Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
12 Hour(s) 47 Minute(s)
Language
English
Taught by
Manpreet Singh Ragi
Rating
Course Overview
Learn Power BI by Building Real-World Dashboards – From Data Prep to DAX and Visualization
Unlock the power of data with "Mastering Power BI: Transforming Data into Insights" — a comprehensive, hands-on course designed to take you from foundational knowledge to advanced proficiency in Microsoft Power BI.
Whether you're a business analyst, data professional, or aspiring BI developer, this course provides the skills and confidence you need to transform raw data into actionable insights.
Starting with Power Query, you’ll learn how to import, clean, and shape data, building efficient preparation workflows. Along the way you will learn about the different storage modes available and be able to contrast between them. You will also explore aggregations in Power BI and learn how to use these to overcome performance challenges.
A special emphasis is placed on Dimensional Modeling — a technique used to structure data into fact and dimension tables for efficient querying and user-friendly analytics. You'll explore star and snowflake schemas, learn how to identify facts and dimensions and implement these models in Power BI to support self-service analysis and accurate performance measurement.
The course then progresses into DAX (Data Analysis Expressions) — the formula language of Power BI. You’ll learn how to write DAX to perform dynamic calculations, create time intelligence metrics, understand evaluation context and drive interactivity in your reports.
Throughout the course, theory is balanced with practical, real-world tasks that reinforce learning. You will solve common business problems, and complete a guided project that simulates actual reporting challenges.
By the end, you’ll have a deep understanding of the end-to-end BI workflow.
No prior experience in Power BI is required, but familiarity with Excel or basic data concepts is helpful.
This course will also help you build the knowledge and skills needed to pass the PL-300 certification.
Course Content
- 17 section(s)
- 169 lecture(s)
- Section 1 Introduction
- Section 2 Download & Install Microsoft Power BI Desktop
- Section 3 ETL - Import Mode
- Section 4 ETL - Direct Query
- Section 5 Dimensional Modelling
- Section 6 Visualizations
- Section 7 Data Types & Measure Context
- Section 8 Implicit & Explicit Measures
- Section 9 Creating Measures Table
- Section 10 Calculated Columns & Measures
- Section 11 Scalar Functions
- Section 12 Table Functions
- Section 13 Other DAX Functions
- Section 14 CALCULATE & Evaluation Context
- Section 15 Condition Logic & Relationship Functions
- Section 16 Time Intelligence
- Section 17 Storytelling
What You’ll Learn
- Navigate and utilize the Power BI interface to connect to data sources, build reports within the Power BI ecosystem., Describe the different storage modes available in Power BI and understand the strengths and weaknesses of each mode., Learn how to use Power Query and the M language to cleans and transform your data, Describe the process and importance of data modelling using industry recognized approaches, Establish relationships between tables and understand the implications of cardinality, filter propagation, and model performance., Write DAX formulas to create calculated columns and measures, apply logic, perform aggregations, and implement advanced time intelligence functions., Apply BI skills to real-world business scenarios through guided projects that simulate common use cases like sales tracking, performance analysis., Build knowledge & skills needed to pass the PL-300 Exam
Skills covered in this course
Reviews
-
BBani K
The course is a must for anyone wanting strong foundations of Power BI and some advanced concepts. I was able to follow the structured examples and gain confidence on them. great content and would recommend to anyone!!
