Power BI & Power Pivot: Introduction
Requirements
- Microsoft Power BI Desktop (free download)
- Microsoft Excel
- Windows (currently not available for Mac)
Description
________
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
Who this course is for:
- Anybody curious about Power BI and Power Pivot
Course content
- 04:53Working with tables
- 08:08Combining data the old way
- 08:27Creating a relationship in Power Pivot
- 04:43Connecting a pivot table to the data model
Instructor
Data Science Professional with 10 years of experience providing training and support in the field of Business Intelligence. Consulted on 100+ projects related to Power BI and Tableau across many different sectors for small companies to multinationals. Passionate about learning and development and knowledge sharing. I have trained over 2000+ people through on site trainings plus many more through online courses.