Power BI Developer Diploma
0% Completed
Lecture 1: Introduction to Power BI
Start with a full understanding of Power BI’s ecosystem, components, and how developers plan, build, and deploy complete BI solutions.
Introduction To power Bi
Video - 00:20:00 mins
Power BI User Interface & BI Life cycle
Video - 00:30:54 mins
Power BI Connectivity Modes
Video - 00:49:50 mins
Extracting Data from diff sources (Files)
Video - 00:23:47 mins
Assignment (1): Load Data into Power BI
Reading
✅ Solution Assignment (1): Load Data into Power BI
Video - 00:2:42 mins
Quiz 1
Quiz
Lecture 2: Connecting & Transforming Data with Power Query
Learn to connect to different data sources, clean messy data, and automate transformations using Power Query and M language for scalable workflows.
Extracting Data from diff sources (Folders)
Video - 00:28:28 mins
🧩 Assignment: Extracting Data from diff sources (Folders)
Reading
✅ Solution Assignment: Extracting Data from diff sources (Folders)
Video - 00:1:20 mins
Extracting Data from diff sources (Databases, Web and APIS)
Video - 00:15:34 mins
🧩 Assignment:Connecting to Advanced Data Sources (SQL, Web, APIs)
Reading
✅ Solution Extracting Data from diff sources (Databases, Web and APIS)
Video - 00:00:58 mins
Evaluating & Understanding Your Dataset
Video - 00:34:5 mins
Cleaning, Shaping & Transforming Data in Power Query
Video - 1:9:56 mins
🧩 Assignment: Advanced Data Transformation
Reading
✅ Solution Assignment: Advanced Data Transformation
Video - 00:7:13 mins
Quiz 2
Quiz
Lecture 3: Building a Strong Data Model
Master relationships, cardinality, and star schema design. Build optimized data models that ensure accurate reporting and high performance.
M code, Custom columns, and debugging Power Query Errors
Video - 00:33:54 mins
🧩 Assignment::M code
Reading
✅ Solution Assignment::M code
Video - 00:3:41 mins
Dimensional Modeling, Schemas, and Data Relationships
Video - 1:18:39 mins
🧩 Assignment: Build Your Own Data Model
Reading
✅ Solution Assignment: Build Your Own Data Model
Video - 00:3:52 mins
Quiz 3
Quiz
Lecture 4: DAX for Dynamic Analysis
Develop powerful calculated measures and KPIs with DAX. Learn core and advanced functions to unlock interactive and insightful dashboards.
Dax, Implicit and Quick Measures
Video - 1:2:56 mins
🧩 Assignment Basic DAX and Quick Measures
Reading
✅ Solution Assignment Basic DAX and Quick Measures
Video - 00:2:39 mins
Explicit Dax
Video - 00:57:34 mins
🧩 Assignment 2 Advanced DAX
Reading
✅ Solution Assignment 2 Advanced DAX
Video - 00:6:11 mins
Quiz 4
Quiz
Lecture 5: Data Visualization Fundamentals
Understand data storytelling and visualization principles — how to choose the right charts, apply color psychology, and present insights effectively.
Data storytelling fundamentals and Types of analytical applications
Video - 00:39:5 mins
Setting up report layout
Video - 00:11:4 mins
Bar charts variations
Video - 00:40:43 mins
Line Chart
Video - 00:7:11 mins
Pie Charts, Data groups, Students Q&A
Video - 00:33:43 mins
Quiz 5
Quiz
🎓 Project 1: Tea Sales Insights Dashboard
Assignment
Lecture 6: Dashboard Design & Layout
Take your dashboards to the next level by learning professional layout structures, layering visuals, consistent branding, and responsive design best practices.
Scatter plot, Waterfall and other advanced visuals
Video - 00:27:45 mins
Tables, Matrix and Drill downs
Video - 00:11:24 mins
Design a professional scorecard
Video - 00:10:55 mins
AI in Power BI
Video - 00:45:45 mins
Conditional Formatting
Video - 00:45:45 mins
Quiz 6
Quiz
🎓 Project 2: HR Analytics Dashboard
Assignment
Lecture 7: UX Design & Interactivity (Buttons, Filters & Navigation)
Bring dashboards to life! Learn how to use buttons, slicers, bookmarks, tooltips, and navigation menus to create a seamless and interactive user experience in Power BI.
Graduation project Sales Reporting & Analysis Project Guide
Advanced Session: Real-World Deployment & Security
Deploy your project professionally — learn how to publish reports, manage workspaces, apply Row-Level Security (RLS), and share dashboards safely with teams or clients.
This session introduces Bookmarks, one of Power BI’s most powerful storytelling tools. You’ll learn how to capture specific views or states of your report — like selected visuals, applied filters, or hidden elements — and toggle between them seamlessly.
We’ll also build practical examples, such as switching between summary and detailed views, before/after comparisons, or creating a tab-like navigation system using buttons and bookmarks together.
💡 Trick to Remember:
Bookmarks = Snapshots of your story.
Each bookmark saves a moment in your report — use them to switch perspectives without losing context.
Bookmark what matters. Hide what distracts.
📘 Resources
Create report bookmarks in Power BI – Power BI | Microsoft Learn