Introduction to Data Analysis with Power BI - From Basics to Advanced

Learn essential data analysis and visualization skills in this comprehensive tutorial designed for Business Analysts and Data Analysts working with Microsoft's Power BI platform. Master the fundamentals across three progressive sections: begin with exploring the interface, connecting to data sources, and performing data transformations; advance to creating interactive visualizations including bar charts, line graphs, and pie charts with timeline filters and bookmarks; and culminate with advanced analytics using DAX functions like SUM, SUMX, Calculate, and Filter. Gain hands-on experience transforming raw data into actionable insights through live dashboards and interactive reports, while learning to effectively organize, analyze, and visualize large datasets. Access provided exercise files and manuals to practice implementing various data analysis techniques, from basic data modeling to publishing finalized reports to the Power BI service.

Syllabus

Start
Introduction
Power Bi Interface
Connecting to Data Sources
Power Query Interface
Using Power Query
Data Modeling
Beginner Conclusion
Intermediate Introduction
Quick Recap of Beginner
Intro to Data Visualization
Bar Chart Visualization
Line Graph
Pie Chart
Slicers Timeline Filters
Bookmarks
Intermediate Conclusion
Advanced Introduction
Introduction to DAX
SUM Function
SUMX Function
Average Function
Calculate Function
Filter Function
Related Function
If Function
Date Add Function
Publish to Service
Conclusion