Power BI & Power Pivot: Introduction

Crash course on how to work effectively with Power BI and Power Pivot

What you'll learn:

• Take your reporting to the next level with Power BI in just 2 hours
• Transition from normal pivot tables to Power Pivot reports in Excel
• Understand how Power BI and Power Pivot function as the next step in self-service BI
• Fundamental concepts like data modeling, building interactive visualisations and simple calculations
• Hands-on case examples that get you up and running
• Learn from a professional BI developer

________

From a normal pivot table to Power Pivot

• Working with tables

• Combining data the old way

• Creating relationships 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 to a data model

Creating a dashboard using Power Pivot

• Importing data

• Data modeling

• Report structure

• Report filters

Building a report in Power BI

• Introduction to Power BI

• Loading data into Power BI

• Creating relationships

• Creating a date table

• Visualizations- Area charts

• Visualizations- Bar charts

• Visualizations- Maps

• Visualizations- Cards