Business intelligence has become much more mainstream than ever before in recent years. This is happening perhaps because it represents one of the last mountains left to climb in classic information technology.

The idea behind business intelligence is that organizations have the ability to gather huge amounts of information about their operations that when viewed in detail are often meaningless—the classic problem of not being able to see the forest for the trees. If you can collate that data and browse it in an ordered way, insights are there to be found in any business.

By employing the tools and practices of business intelligence, a retailer might discover that their sales of clocks increase shortly after a drought, or that unfinished furniture is more in demand in stores closest to the coast during summer months. There might be reasons behind the things that are discovered, but the real value in the data is the ability to exploit it and maximize positives or minimize negatives based on the nature of the insight.

Business intelligence is a great example of the adage “knowledge is power” put into practice. When I first heard it in conversation, business intelligence was the term used to describe the business-shaping data that could be gleaned by leveraging a data warehouse, as that was the primary tool for this kind of introspection back in those days. Data warehousing is about gathering all information about every aspect of a corporation’s operations into a single place and aggregating it across many dimensions.

This requires a special capability in the database server that Microsoft has supplied with its Analysis Services. This kind of data processing differs from most line-of-business systems. We refer to typical business systems as Online Transaction Processing (OLTP), but Analysis Services supports Online Analytical Processing (OLAP). OLTP uses database tables and lets the user read and write data as part of running the business. OLAP is the after-action review that figures out what is driving or holding back the business.

Rather than classic relational tables, Microsoft SQL Server Analysis Services provides the ability to shape this data into multi-dimensional cubes. To wrangle these cubes, Microsoft SQL Server Analysis Services leverages a special form of SQL syntax known as Multi-Dimensional Expressions, or MDX for short. MDX provides a language capable of navigating the OLAP database cubes.

For a number of years, OLAP was the only path to understanding what is going on under the covers of the business. This is still the case, but the information becomes more accessible once it is collected into one place. Correlations and buried synergies hide well among the data, and without end-user tools up to the task, the insights can only be searched for by the keepers of the data. This middleman has been the standard for a long time and has obvious inefficiencies that are in need of repair. Ultimately, the multi-dimensional cubes of OLAP will yield the data, but not present it in a way that is easy to consume or recognize. Excel exports were the order of the day for years.

The good news is that this situation is really the part of the landscape that has been changing drastically in recent times. Interfaces that really make the data and trends understandable with tracking across time and other dimensions have emerged with recent product acquisitions and their integration into the Microsoft business intelligence bag of tricks. Perhaps the most major development in this area is that Microsoft SharePoint Server has become a major vehicle for enabling consumption of business intelligence data.

#!
How we got here
This process of evolution toward more direct access to the data has been in motion for years. Microsoft has been continually adding to the capabilities and arsenal for business intelligence with its offerings. In 2006, Microsoft announced the introduction of PerformancePoint Server 2007, which added scorecards and planning functionality to the tool set. When Microsoft originally announced this first version of PerformancePoint Server, it called it “BI for everyone.” Microsoft recognized that the barriers were starting to come down and access to these tools was democratizing one of the last bastions of proprietary knowledge. That is what it is all about in this round, bringing the ability to delve into the guts of the business through the data to anyone.

Each business is somewhat unique, but there are always commonalities. By providing scorecards, you can measure what matters for your particular business. Before the introduction of PerformancePoint Server, the construction of a scorecard was a major effort that really required a custom development effort to get right. The same goes for dashboards. A dashboard enables users to explore the data from within a browser to find their own answers by filtering and drilling down.

About Patrick Hynds