Power BI & Power Pivot: Introduction
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
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
Instructor
- 4.4 Instructor Rating
- 391 Reviews
- 7,741 Students
- 2 Courses
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.