Smartfuture formation Preparing your Data for Power BI
  • Smartfuture formation Preparing your Data for Power BI

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