Tag Archives: microsoft bi

Businesses turn to collaborative BI to get things done

There are plenty of advantages to employing business intelligence tools in your business, and it can be even more useful when various members of the company can collaborate on projects. Of the many trends evolving around business intelligence, collaborative BI is growing rapidly as more and more enterprises embrace the team approach to data analysis. As the expression goes, two heads are better than one when it comes to putting data analytics to work for a business, as teamwork can allow good ideas to flourish whether choosing which data to use for a given project and how to interpret the analysis.

Interest in collaborative BI grows
Dresner Advisory Services recently released its third annual Wisdom of Crowds® Collaborative Business Intelligence Market Study, and the results made it clear that collaboration is key when it comes to analyzing data with a BI solution. The survey revealed that this aspect of business analytics was important to more than 60 percent of surveyed businesses around the world, according to Midsize Insider.

“… this year there is a rebound in interest in collaborative BI, placing it above such high-profile topics such as big data and social media,” Howard Dresner, the organizations founder and chief research officer, explained. “In addition, we see a much closer alignment between the tools and capabilities that users want and the features and functions that vendors are incorporating into their offerings.”

Harness benefits of collaborative BI
The ability to combine analytics with social applications and crowd-sourcing opens up a world of possibilities for using data to improve operations and strategies. Working with others on a project involving data can make it easier to interpret the information and determine the best way to use the analytics to make changes to current and future projects and operations.

It helps to have a BI solution that makes collaboration easier, and Panorama has software that can satisfy this needs. Necto 14 takes teamwork to the next level by offering options for collaboration along every step of the process from determining what raw data to use to analyzing that information to organizing it with data visualisation. The software allows multiple people to work simultaneously on the same projects, as they can make notes on various infographics, charts and other data and share instantly with their team.

Company: Ministry of Sport and Tourism of the Republic of Poland

Needs and Requirements:

One of the tasks of the Ministry is to support activities related to sport and tourism through the provision of financial grants. The grant may cover different areas of the office, such as creation of sports stadiums and sports halls, organizing sporting events, etc. Grantsare provided through various funding programs and are carried out by the relevant departments of the Ministry.

Continue reading

Company: Jelly Belly Candy Company

Company Profile

Founded in  1869, Jelly Belly Candy Company is a manufacturer of jelly beans and other  confections. Jelly Belly produces the leading gourmet jelly beans in the world  as well as other treats such as candy corn and Gummi Bears. Jelly Belly  products are sold in 35 countries around the world and in 2003, the company  reported annual sales of more than $140m US.

Continue reading

Company: State of South Carolina

Two years ago, when South Carolina Lt. Gov. Andre Bauer sought state funds to supplement federal dollars for the South Carolina Office of Aging’s meal program, he knew too many of the state’s senior citizens were hungry and unhealthy.

However, to persuade legislators to vote for those funds, he needed proof ‘ or at least persuasive correlations ‘ between meals and improved health for seniors. Bauer, who heads the Office of Aging, turned to the South Carolina Office of Research and Statistics (ORS), part of the state’s Budget and Control Board.

He wanted the office to show that meals for seniors, paid for with federal funds issued to the state through the Older Americans Act, correlated with better health. Using Panorama’s BI Solution business intelligence (BI) software from Panorama as the front end to a Microsoft SQL Server database, ORS was able to establish that correlation. In June 2006, South Carolina’s state legislature appropriated $2.9 million in state funds for the meal program for the calendar year 2007.

That’s one example of relationships ORS is now finding through its BI tools, incorporating identity-protected data from about 20 state agencies, Medicare, Medicaid, hospitals and other organizations.

‘We can tie funding to programs, agencies, the private sector and nonprofits,’ said Pete Bailey, chief of the 45-person health and demographics group at ORS. ‘We can monitor [funding], evaluate the outcomes and tie them back to continued funding. If a program isn’t successful, the legislature can see that, see where the problem is and fix it.’

ORS’ goal is to use its BI tools to help state agencies and organizations fulfill their missions.   Although it took several years of negotiating with the entities that own the data to get it and then more time to build the databases, ORS is starting to show what it can do with the decision-support tools.   Ultimately, the BI capabilities could add accountability to the political process by measuring the results of policy decisions.   ‘Business intelligence has been widely used in private-sector industries for years,’ said Nigel Pendse, an independent BI analyst, author of the annual Business Intelligence Survey and lead analyst for the Web-only OLAP Report on online analytical processing at www.olapreport.com.   ‘It’s for fast-moving industries to track products and competition, profit and customer profitability,’ he said. ‘Governments are less likely to use these types of products.’   From the ground up   BI software includes the underlying database software or server and the front end, which ‘queries the [database] and represents the results of the queries in different formats,’ Pendse said. Microsoft, SAP, IBM and Oracle are the leaders in the BI field, but ‘the big [companies] do a bad job,’ he said. ‘Most of the surviving small companies do a good job.’   Large companies’ BI products are combinations of different products, Pendse said.   ‘Panorama is better than the others because it has built-from-the-ground-up technology,’ he said. ‘It doesn’t have the integration challenge.   It hasn’t been stitched together from different sources.’

Panorama’s BI Solution, with its dashboard, reporting and analytical capabilities, was selected by ORS because, at the time, it was the only BI tool that could exploit the full power of the online analytical processing and data-mining capabilities of SQL Server. Panorama developed the SQL Server software and sold it to Microsoft in 1996.   ‘After selling the old technology to Microsoft, Panorama built the front end,’ Pendse said. ‘All was happy for 10 years.’   When ORS chose SQL Server, Panorama’s BI Solution was the de facto front-end BI module to extract information from the database.   In the past two years, Microsoft acquired ProClarity, another BI front end, which it is incorporating into SQL Server. ‘Now Microsoft is less likely to feed business to Panorama,’ Pendse said. Consequently, the company is broadening its base of business.   Some experts might not necessarily need a tool like Panorama’s BI Solution to query a database and understand the results. But for employees at ORS, the tool makes accessing and using databases much easier.   Five or six years ago, before the office started using BI tools, ‘statisticians had to manually aggregate all the data,’ Bailey said. ‘Now you just press a button. You can do an analysis in a day, whereas before it would have taken months.’   Building cubes   Since acquiring its BI tools, ORS has built multiple databases, also known as data cubes. Each cube represents data drawn from local, state and federal sources.   The so-called seniors’ cube was the source of the correlation between the seniors’ meals program and their improved health. The metric for improved health was a reduction in the number of emergency room visits and hospitalizations of seniors who received meals. These correlations, plus ORS’ ability to measure state spending outcomes, were instrumental in obtaining state funds for the meals program.   In 2007, those funds paid for 5,476 meals and other home- and community-based services for seniors. The resulting data is just now starting to trickle in to ORS for analysis.

‘Working with the seniors’ cube, we want to show [that] an investment of less than $1,000 a year in home- and community-based services helps an individual maintain independence and dignity in his or her home ‘ preventing or delaying the expense of a $40,000 a year nursing home bed or a $24,000 average Medicare inpatient hospital discharge,’ Bauer said in a statement.

CommuniCare, a nonprofit based in Columbia, S.C., also has benefited from ORS’ BI capabilities. CommuniCare’s mission is to provide prescription medications for the state’s uninsured workers. It operates solely from donated funds.

Last year, the nonprofit spent $34 million to distribute 142,000 prescriptions to more than 14,000 clients. Chief Executive Officer Ken Trogdon said he assumed the organization was helping its clients, but he turned to ORS for some hard numbers.   CommuniCare provided ORS with identity-protected data covering the time from a client’s enrollment with the organization until 18 months afterward. ORS combined this with hospitalization and emergency room utilization metrics extending from a year before an individual signed up for the program until 18 months afterward.

ORS’ analysis showed that diabetics who received medications from CommuniCare reduced their visits to emergency rooms by 27 percent and in-patient hospitalizations by 15 percent during the 30-month period.

Clients with hypertension who received the necessary medications reduced emergency room use by 33 percent and inpatient hospitalizations by 20 percent.   Individuals who received prescription psychotropic drugs from the nonprofit reduced emergency room visits by 24 percent and hospitalizations by 31 percent.   ‘Before, we knew we were doing something good, but it was just warm and fuzzy,’ Trogdon said. ‘When you can quantify the numbers, it justifies our existence and shows the impact we’re having. If we can show what we’re doing in a state like ours that suffers greatly from poverty, then there is a good chance the program can grow nationwide.’   The latest addition to ORS’ analysis capabilities is a geographic information system that allows results to be mapped according to county, ZIP code and congressional district. ‘With the mapping system, we can show these issues to every House member, senator and congressman and the people they represent,’ Bailey said.   ‘When a politician wants to be re-elected, he can show how things have changed while [he was] in office,’ he said. ‘If there haven’t been sufficient improvements, he and agencies can work together. Politicians haven’t previously had specifics of these problems for the people they represent.’   Bailey didn’t say it, but the ability to measure outcomes also means that politicians can be held accountable for their actions, and political programs and initiatives can be objectively evaluated.

THE CONCEPT OF a cube of data is central to business intelligence software, but these cubes aren’t the common 3-D blocks that might come to mind. Instead, a BI cube can have multiple dimensions in which each is an element of a data category.   Data elements might be durations in minutes, hours or months. Or they might be the number of visits a person makes to a hospital.   ‘Cubes typically have between five and 10 dimensions,’ said Nigel Pendse, an independent BI analyst, author of the annual Business Intelligence Survey and lead analyst for the Web-only OLAP Report.

‘The software can do more, but people have trouble understanding it,’ he said.   Data dimensions can be linked or cross-tabbed to find correlations or relationships, just as a Microsoft Excel user finds a cell that links one unique row and one unique column. In fact, Excel is the most commonly used BI software tool.   Because of the sheer quantity of data it manages from local, state and federal sources, the South Carolina Office of Research and Statistics, part of the state’s Budget and Control Board, uses Microsoft SQL Server to create its 20 data cubes, and more are being developed.

The office uses Panorama’s Panorama’s BI Solution to query the data cubes for information that will help client agencies do their jobs better.   ‘The beauty of the software is that you can define the relational database and how the data are related, define the data, and the computer does all the work for you,’ said Pete Bailey, chief of health and demographics at ORS.

Company: Mobiltel

Company Overview

With 3.3 million customers Bulgarian Mobiltel  is the biggest telecommunications network in Bulgaria and one of the most  successful mobile operators in Europe. The penetration rate for mobile  communications in Bulgaria is 62.4 percent and rising, where Mobiltel’s  installed base is more than 60 percent and the revenues in 2004 were €486.3  million.

Continue reading

Company: Israeli Police

Customer Size: 2,500 employees

Organization Profile

The Israel Police strives to enforce the law in the spirit of the basic values set forth in the Proclamation of Independence, with the aim of ensuring the security of both individuals and society as a whole and enhancing quality of life in the State of Israel.

Continue reading

Company: Advocate Health Care

Leading Health Care Provider Utilizes Robust BI Solution to Manage Key Performance Indicators and Enhanced Drilled Down Data

Company Overview

Advocate Health  Care, one of the nation’s top 10 health care provider, based on clinical  performance, is the largest health system in Illinois and one of the largest  health care providers in the Midwest. Advocate operates more than 250 sites of  care, including ten acute care hospitals, two integrated children’s hospitals,  five Level I trauma centers (the state’s highest designation in trauma care),  two Level II trauma centers, one of the area’s largest home health care  companies and one of the region’s largest medical groups. Advocate Health Care  trains more primary care physicians and residents at its three major teaching  hospitals than any other health system in the state. Continue reading