Descrizione del corso
This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular model, data modeling, and DAX.
The course is targeted toward business analysts, business intelligence developers, and SQL Professionals.
Programma
Module 1: What is the Tabular Model?
- Analysis Services Installation and Architecture: One Product, Two Models
- Version Changes: SQL Server Analysis Services
- Important Terms
- SQL Server Data Tools for Tabular
Module 2: Working in Tabular
- Projects
- Importing
- Loading Data
- Examining Views
- Deployment
- Understand and utilize projects.
- Understand and utilize importing.
- Understand and utilize loading data.
- Understand and utilize examining views.
- Understand and utilize deployment.
Module 3: Loading Data From Different Sources
- Data Sources
- Data Credentials
- SQL as a Source
- Excel as a Source
- Flat Files as a Source
- Azure as a Source
- SharePoint as a Source
- Sorting During Load
Module 4: DAX and MDX
- Querying with MDX
- Basic DAX Syntax
- Evaluation Context
- Calculate Function
- Time Intelligence
Module 5: Building Data Models
- Importing Related Tables
- Creating Relationships
- Hierarchies
- Direct Query
- KPIs
- Drillthrough
- Perspectives
Module 6: Excel PowerPivot and Tabular
- Working with PowerPivot
- Working with Pivot Tables
- Working with PowerView
