From a normal pivot table to Power Pivot
  • Working with tables
  • Combining data the old way
  • Creating a relationship in Power Pivot
  • Connecting a pivot table to the data model
Building a data model in Power Pivot
  • Importing data into Power Pivot
  • Data modeling and relationships
  • Creating a pivot table connected a data model
Creating a dashboard using Power BI
  • Introduction to Power BI
  • Importing data into Power BI
  • Creating relationships
  • Creating a date table
  • Visualisations - tables
  • Visualisations - area charts
  • Visualisations - slicers
  • Visualisations - bar charts
  • Visualisations - maps
  • Visualisations - cards
  • Finalising the Power BI report page