Preparing Your Data for Power BI

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.

Category:

Description

Début :

08 Juin 2021

Fin :

09 Juin 2021

À propos de cette formation

Pour quel public ?
The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.
Prérequis
• A working knowledge of SQL Server
Moyens pédagogiques
Méthodes pédagogiques interactives et personnalisées (la problématique de chaque participant est vue en détails par le formateur en amont de la formation). 
Objectifs
• 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.

Le Programme : 02 Modules

Module 1: Course Overview

Module 2: What is the Tabular Model?

Nous contacter

Nos partenaires

Nos accréditations