In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement Tabular PowerPivot Models to support Business Intelligence (BI) solutions. You will learn about the Microsoft SQL Server Visual Studio development environment (SQL Server 2012/2014 Data Tools) for design, creation and deployment of SQL Server BISM (Business Intelligence Semantic Model) Tabular Mode projects, and SQL Server Management Studio for the management of Tabular Models.
Delegates will be introduced to the concepts of Transactional Relational Databases, Data Warehouse Relational Databases, other sources of data, and Tabular (PowerPivot) Models fundamentals, becoming familiar with terminology such as Tables, Data Sources, Relationships, Hierarchies, Calculations & Measures. The course will take delegates through building a Tabular Model in its simplest form through to extending the features within the model by implementing DAX calculations and measures, and Key Performance Indicators (KPIs). The main emphasis of the course is on the design and creation of Tabular Models, but basic administration and security of models are also covered.
An introduction to the DAX language will provide an insight into extending data models by adding simple aggregate type measures and calculations to the model through to complex Time-Intelligence based measures, such as parallel period calculations, year to date, month to date, etc. This course also covers the interrogation of Tabular Models from Microsoft Excel 2010/2013 through Pivot Tables and Charts, and the use of Tabular Models as data sources for SQL Server Reporting Services (SSRS).
This course is suitable for delegates working with SQL Server 2012 and SQL Server 2014.
There are no specific pre-requisites for this course, but delegates attending this course would benefit from having some basic Excel skills, and where data is to be drawn from relational databases some SQL querying experience would be advantageous.