Power BI User Specialist (Academy) (conducted in English)

Kursusmål
Deltagere
Kursusmateriale
Kursus indhold Data modelling and querying data - 2 days
In this module you learn how to query relational databases using T-SQL. You learn about different database designs and you learn how to query data from multiple tables, and you learn how to filter data and use aggregate functions.

The following will be covered:

  • Introduction to relational databases and designs
  • Simple queries with T-SQL
  • Filtering data
  • Querying multiple tables
  • Calculated columns
  • Aggregate functions

Power BI - 3 days
In this module you learn how to use applications and services in Power BI. You learn how to create and design data models using the Star Schema Model for efficient data analysis. You will learn to create reports and analyze data with Power BI Desktop. You learn how to prepare and transform data from different data sources with Power Query and you learn how to publish your reports to the Power BI Cloud Service and use these for dashboards ...

Vis mere

... that you can share in your organization for valuable insights and decisions.

The following will be covered:

  • Creating data models with Power BI Desktop
  • Introduction to the Star Schema Model
  • Transforming and cleaning data with Power Query
  • Creating calculated columns and measures using DAX
  • Designing reports and formatting visuals
  • Reports with drill through and bookmarks
  • Publishing reports to the Power BI Cloud Service
  • Refreshing data in the Power BI Cloud Service
  • Creating and sharing dashboards
  • Access to reports and dashboards in Power BI Cloud Service

Advanced DAX - 2 days
In this module you learn how to use DAX for advanced calculations and data models. You will learn the concept of evaluation context and you will learn the difference between row -and filter context and you will learn how to use context transition. You will learn how to use numerous DAX functions to work with tables and time intelligence.

The following will be covered:
  • Evaluation context
  • The function CALCULATE
  • Filter functions
  • DAX and variables
  • Calculated tables
  • DAX and relationships
  • Time intelligence functions
  • DAX queries
Du kan finde alle informationer om dette kursus ved at gå ind på http://www.4d.dk/Kurser/Business_Intelligence/Power_BI/Ikke_angivet/1077788

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.

Power BI User Specialist (Academy) (conducted in English)

Forhandler
4D konsulenterne
Normalpris
20.449,00 kr
Udsalgspris
20.449,00 kr
Normalpris
Udsolgt
Pris pr. stk.
pr. 
Eksklusiv moms.

Efter aftale / Kontakt for pris

Hvis du har valgt Efter aftale, kan du udfylde formularen nedenfor og så vender vi tilbage til dig og aftaler nærmere.

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.