This course aims to teach users how to utilize Power BI for advanced data processing and visualization. By the end of the course, learners will be able to build queries, prep data for analysis, create relationships across multiple databases using Power Pivot, use functions to enhance data analysis, build live dashboards, and interactive reports. The course employs a hands-on approach with practical exercises and labs to reinforce learning. The intended audience includes Business Analysts, Data Analysts, and individuals seeking to enhance their data processing and visualization skills using Power BI.
Overview
Syllabus
Start
Introduction
Opening Power Pivot
Importing from Access
Save and Save Often
Importing from Excel
Creating Power Pivot Tables
Creating Relationships
Calculated Columns
Basic Measures
DAX & Derived Measures
CALCULATE
Lab - Creating Measures
Importing Excel Data Model into Power BI
Measures in Power BI
Visualizing Measures
Creating Calendar Tables
Save and Save Often
Sorting by Column
Drilling Down
Lab - Creating Analysis Reports
Publishing to Power BI Online
Creating Dashboards
Sharing Dashboards
Q&A
Conclusion
Taught by
Learnit Training
