Preparing Your Data for Power BI – MS55163

ONZE LESMETHODE: ACTIVE LEARNING

Bij Active Learning word je gecoacht bij het ontwikkelen van vaardigheden die voor jou persoonlijk cruciaal zijn. De methode sluit goed aan bij hoe mensen leren, en houdt rekening met wat jij al weet en kunt. Als je erover nadenkt, is het zo logisch als wat. Lees hier alles over Active Learning

OMSCHRIJVING TRAINING PREPARING YOUR DATA FOR POWER BI

Deze training is bedoeld om je kennis te laten maken met SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling en DAX.

Na afronding van deze training kun je:

  • Analysis Services Installatie en architectuur begrijpen: één product, twee modellen.
  • Wijzigingen in versies begrijpen: SQL Server Analysis Services.
  • SQL Server Data Tools voor Tabular begrijpen en gebruiken.
  • Projecten begrijpen en gebruiken.
  • Importeren en laadgegevens begrijpen en gebruiken.
  • Onderzoek visies begrijpen en gebruiken.
  • Inzet begrijpen en gebruiken.
  • Gegevensbronnen en gegevensreferenties begrijpen en gebruiken.
  • Azure enSharePoint, Flat Files en SQL en Excel als een bron begrijpen en gebruiken.
  • Sorting during load begrijpen en gebruiken.
  • Query’s met MDX, KPI’s, Drillthrough, PowerPivot, Pivot Tables en Power View begrijpen.
  • DAX-syntaxis en begrijpen en gebruiken.
  • DAX-gegevenstypes en overbelasting van de operator begrijpen en gebruiken.
  • Berekende kolommen en evaluatiecontexten begrijpen.
  • Datumberekeningen, invoer gerelateerde tabellen, relaties, hiërarchieën begrijpen en gebruiken.
  • Perspectieven onderscheiden.

Voorkennis

Voor het volgen van deze training dien je te beschikken over:

  • Werkervaring met Windows desktops of servers.
  • Werkervaring met een Windows-domeinomgeving.
  • Ervaring met het beheer van SQL Servers.
  • Fundamentele ervaring met PowerShell.

VOOR WIE IS DE TRAINING PREPARING YOUR DATA FOR POWER BI GESCHIKT?

De training is bedoeld voor bedrijfsanalisten, business intelligence developers en SQL-professionals.

ONDERDELEN VAN DE TRAINING PREPARING YOUR DATA FOR POWER BI?

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing

Lab 1: Course Overview

After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

Module 2: What is the Tabular Model?

SQL Server Analysis Services (SSAS) provides two different approaches for data modeling: multidimensional and tabular. While there is substantial overlap between them, there are also significant differences. In this module, we discuss feature comparisons and explain each approach, then we’ll dive deeper into the tabular model as that is the focus for this course.

Lessons

  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular

Lab 1: What is the Tabular Model?

  • SQL Server Data Tools for Tabular

After completing this module, 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.

Module 3: Working in Tabular

In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.

Lessons

  • Projects
  • Importing
  • Loading Data
  • Examining Views
  • Deployment

Lab 1: Working in Tabular

  • Creating a Tabular Project

Module 4: Working in Tabular

After completing this module, students will be able to:

  • Understand and utilize projects.
  • Understand and utilize importing.
  • Understand and utilize loading data.
  • Understand and utilize examining views.
  • Understand and utilize deployment.

Module 5: Understanding Loading Data From Different Sources

In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.

Lessons

  • 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

Lab 1: Understanding Loading Data From Different Sources

After completing this module, students will be able to:

  • 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.

Module 6: Using DAX and MDX

In this module, we will discuss two different languages; DAX and MDX. We will briefly explore MDX and its use with a tabular model, then we’ll cover DAX and walk-through how to use this powerful language.

Lessons

  • Querying with MDX
  • Basic DAX Syntax
  • Evaluation Context
  • Calculate Function
  • Time Intelligence

Lab 1: Using DAX and MDX

  • DAX Syntax
  • DAX Data Types and Operator Overloading
  • DAX Operators
  • DAX Values
  • Measures
  • Calculated Columns
  • Evaluation Contexts
  • Date Calculations

After completing this module, students will be able to:

  • 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.

Module 7: Building Data Models

In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.

Lessons

  • Importing Related Tables
  • Creating Relationships
  • Hierarchies
  • Direct Query
  • KPIs
  • Drillthrough
  • Perspectives

Lab 1: Building Data Models

  • Creating Relationships
  • Hierarchies

Lessons

  • 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.

Module 8: Excel PowerPivot and Tabular

In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.

Lessons

  • Working with PowerPivot
  • Working with Pivot Tables
  • Working with PowerView

Lab 1: Excel PowerPivot and Tabular

  • Importing Data
  • Importing Large Datasets
  • Importing Data with a Query
  • Creating Relationships
  • Creating a Cascading Relationship
  • Power View

After completing this module, students will be able to:

  • Understand and utilize PowerPivot.
  • Understand and utilze Pivot Tables.
  • Understand and utilize Power View.
in samenwerking met

PRAKTISCHE INFORMATIE

MAESTRO PRIJS

€ 995,-

PARTNER PRIJS

€945,-

CURSUS

Active Learning

AANTAL DAGEN

2 dagen (flexibel in te plannen)

Datum optie 1 15-03-2021 t/m 19-03-2021 Locatie: Vianen, virtueel Datum optie 2 12-04-2021 t/m 16-04-2021 Locatie: Vianen, virtueel Datum optie 3 19-04-2021 t/m 23-04-2021 Locatie: Eindhoven, Rotterdam, virtueel Datum optie 4 03-05-2021 t/m 07-05-2021 Locatie: Vianen, Rotterdam, virtueel Datum optie 5 24-05-2021 t/m 28-05-2021 Locatie: Rotterdam, virtueel Datum optie 6 07-06-2021 t/m 11-06-2021 Locatie: Vianen, virtueel

DIRECT AANMELDEN

Aanmelden voor Preparing Your Data for Power BI – MS55163

VOORWAARDEN

  • Partners van de Maestro Academy: Specialisten aangesloten bij Het Finance Gilde, DataConnected of HeadFirst(Premium overeenkomst);
  • De betaling dient vóór aanvang van de eerste trainingsdag volledig te zijn voldaan;

Alle bovengenoemde prijzen zijn exclusief BTW;