This two-day instructor-led is course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
Objectives
Understand Analysis Services Installation and Architecture: One Product, Two Models.
Understand version changes: SQL Server Analysis Services.
Understand important terms.
Understand and utilize SQL Server Data Tools for Tabular.
Understand and utilize projects.
Understand and utilize importing and many more.
Audience
The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.
Topics
Course overview
What is the Tabular Model
Working in Tabular
Understanding loading data from different sources
User DAX and MDX
Building data models
Excel powerpivot and tabular
Other Trainings
SQL Server
27 Training Set
