This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
Audience profile:
The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.
At course completion
After completing this course, students will be able to:
- 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.
- Understand and utilize loading data.
- Understand and utilize examining views.
- Understand and utilize deployment.
- Understand and utilize data sources.
- Understand and utilize data credentials.
- Understand and utilize SQL as a source.
- Understand and utilize Excel as a source.
- Understand and utilize Flat Files as a source.
- Understand and utilize Azure as a source.
- Understand and utilize SharePoint as a source.
- Understand and utilize sorting during load.
- Understand querying with MDX.
- Understand and utilize DAX syntax.
- Understand and utilize DAX data types and operator overloading.
- Understand and utilize DAX operators.
- Understand and utilize DAX values.
- Understand and utilize measures.
- Understand and utilize calculated columns.
- Understand evaluation contexts.
- Understand and utilize date calculations.
- Understand and utilize importing related tables.
- Understand and utilize creating relationships.
- Understand and utilize hierarchies.
- Understand Direct Query.
- Understand and utilize KPIs.
- Understand drillthrough.
- Understand perspectives.
- Understand and utilize PowerPivot.
- Understand and utilize Pivot Tables.
- Understand and utilize Power View.
Pretul include:
Suportul de curs in format electronic si diploma interna ProManagement.