Crash course on how to work effectively with Power BI and Power Pivot
What you'll learn:
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
