Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, tutorials, and more.

Chapter 13. Business Intelligence Semantic Model (BISM)

In the previous chapter, we reviewed the Microsoft business
intelligence offering as it existed before the release of SQL Server 2012.
Microsoft was seen by Gartner as a dominant player in the BI space with
significant enterprise adoption of Analysis Services due to a low cost and
minimal barrier to entry given the large installed base of SQL Server. With
the release of SQL Server 2008 R2, Microsoft shipped add-ins to Excel and
SharePoint that brought a new simplified model for end user and community
business intelligence named PowerPivot. PowerPivot leveraged a new in-memory
storage model that allowed end users to manipulate millions of rows of data
within Excel and SharePoint. Both of these offerings were well received, but
left Microsoft with a fractured product offering; one product for BI
professionals and another for self-service. With the release of SQL Server
2012, Microsoft unifies the platform with the Business
Intelligence Semantic Model, or BISM.

Why Business Intelligence Semantic Model?

BISM is the next generation of Analysis Services. BISM extends analysis services and opens up development to a new generation users. Today’s power users are more familiar with relational data structures then traditional star schema structures that are used for traditional OLAP databases. BISM brings the familiar relational data model to the BI platform and unifies it with the multidimensional model. This added flexibility within Analysis ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.