• Power BI desktop?
  • advantages of Power BI over Excel
  • Different versions of Power BI
  • Intro/explanation different modules / building blocks in Power BI

• Data Preparation
  • Get data
  • Profile data
  • Transform data

• Data Modelling
  • Establishing relationships
  • Enriching your data model (measures & calculated columns)
  • Introduction to DAX

• PowerQuery in Power BI
  • Upload PowerPivot data models in Power BI
  • First exercise in excel with power pivot

• PowerView
  • Reporting in Power BI Desktop: intro to the visualization capabilities
  • First exercise in Power BI Desktop
  • Publish report on web portal
  • Students make their own exercises

• Advanced  Topics
  • thorough introduction to DAX and basic functions with it
  • Working with If, Switch, Calculate and Hasonevalue
  • Filter functions: All, AllExcept, Filter, Rankx, TopN and Values         
  • visualization options: treemap, funnel, gauge, cards, slicers,charts, barcharts..
  • using Power BI Maps
  • Report filters: visual level, page level and report level filters
  • Ad hoc filters
  • Drill down functionality
  • exercise in Power BI Desktop using a wide range of functionalities

Elke ondernemer, werknemer binnen een organisatie die met data werkt... die op een efficiëntere manier gegevens willen kunnen analyseren om daaruit de juiste beslissingen te kunnen genereren.