Level: Introductory

William E. Pearson III

Business Intelligence Architect and Founder

Island Technologies Inc.®

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM"). He'll provide an overview of the Tabular model, beginning with the creation of a project with SQL Server Data Tools (SSDT), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (KPIs). Finally, he'll give you insight into creating and maintaining of perspectives and hierarchies, as well as other considerations involved in working with Tabular.

You will learn:

• About Microsoft Business Intelligence 2012 and gain a general understanding of the Business Intelligence Semantic Model ("BISM")
• About the Tabular model, discussing design goals and features, and observe the creation of a new Tabular model project in SQL Server Data Tools (SSDT), the import of data into the model, and the creation and management of relationships between tables in the model
• Examine the creation and management of calculations, measures and Key Performance Indicators (KPIs) to assist consumers in the reporting and analysis of data, and gain insight to creating and managing perspectives and hierarchies to provide business and application contextual "viewpoints" for user-friendly data browsing