Level: Introductory
In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2014 and the Business Intelligence Semantic Model ("BISM").
The Analysis Services 2042 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 2014 and the Business Intelligence Semantic Model ("BISM"). He then overviews 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 ("KPI"). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
You will learn:
- A general understanding of the Business Intelligence Semantic Model ("BISM")
- An overview of the Tabular model
- Examine the creation and management of calculations, measures and Key Performance Indicators