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.