← All courses
FREN
Slide from a module of the Power BI course

Power BI

From data import to deployment: Power Query, modelling, DAX and the Service.

22
modules
≈ 28 h
of training
€500
the full course, incl. VAT
Start for free

Access: an e-mail address is enough, you receive a sign-in code. Free modules need no bank card.

What you will be able to do

  • Import, clean, type, combine and unpivot data in Power Query
  • Build a first model, simple measures and a readable page of visuals
  • Publish and share a report in the Power BI Service, with its refresh
  • Make queries dynamic: parameters, custom functions, reconciliations
  • Master the star schema, CALCULATE, filter context and date calculations
  • Go further with DAX, M, modelling, performance, row-level security and governance

Who it is for

Analysts, controllers and finance teams who prepare data and produce Power BI reports, from import to deployment.

Prerequisites

No prerequisites for the foundation modules; the advanced modules assume the earlier ones.

Included

  • Video with chapters
  • PDF slides
  • Marked quiz
  • Verifiable certificate

Programme

Fundamentals

  1. 00Introduction: Power BI, understanding the platform45 min20-question quizFree
  2. 01Importing the data2 hr20-question quizFree
  3. 02Cleaning the data1 hr 4020-question quiz€50 incl. VAT
  4. 03Setting column types1 hr 1520-question quiz€50 incl. VAT
  5. 04Combining tables1 hr 1520-question quiz€50 incl. VAT
  6. 05Unpivoting a table1 hr 1520-question quiz€50 incl. VAT
  7. 06Merge and first model1 hr 1520-question quiz€50 incl. VAT
  8. 07Simple measures1 hr 1520-question quiz€50 incl. VAT
  9. 08Creating visuals1 hr 1520-question quiz€50 incl. VAT
  10. 09Publishing and sharing1 hr 1520-question quiz€50 incl. VAT

Intermediate

  1. 10Parameters and dynamic sources1 hr 1520-question quiz€50 incl. VAT
  2. 11Custom functions1 hr 1520-question quiz€50 incl. VAT
  3. 12Grouping and reconciling1 hr 1520-question quiz€50 incl. VAT
  4. 13Star schema and date table1 hr 1520-question quiz€50 incl. VAT
  5. 14CALCULATE and filter context1 hr 1520-question quiz€50 incl. VAT
  6. 15Date calculations1 hr 1520-question quiz€50 incl. VAT

Advanced

  1. 16Advanced DAX1 hr 1520-question quiz€50 incl. VAT
  2. 17Advanced M language1 hr 1520-question quiz€50 incl. VAT
  3. 18Advanced modelling1 hr 1520-question quiz€50 incl. VAT
  4. 19Optimising performance1 hr 1520-question quiz€50 incl. VAT
  5. 20Row-level security1 hr 1520-question quiz€50 incl. VAT
  6. 21Governance and deployment1 hr 1520-question quiz€50 incl. VAT
Start for free

Training a team? Access for several employees, on quotation. admin@axent-consulting.com