Overview
This comprehensive Regular Power BI program takes you from beginner to job-ready analyst. You will learn to connect data, transform it with Power Query, build a star schema, write DAX measures, and publish dashboards your stakeholders will actually use.
Includes assignments, downloadable resources, and doubt-solving support aligned with real business scenarios.
What you'll learn
- Connect to Excel, SQL, and web data sources
- Clean and shape data with Power Query (M)
- Build star-schema data models
- Write core DAX measures (SUM, CALCULATE, DIVIDE, time intelligence)
- Design interactive dashboards with slicers and drill-through
- Publish to Power BI Service and manage workspaces
- Apply row-level security basics
Requirements
- Windows PC (Power BI Desktop is Windows-only)
- Microsoft Excel basics (formulas, tables)
- No prior BI experience required
Who this course is for
- Aspiring data analysts and business analysts
- Excel power users moving to Power BI
- IT professionals supporting analytics teams
- Students preparing for analytics interviews
Course Content
13 Lectures 3:30:40
Watch a free preview
Outline only — full videos and downloads unlock after purchase. Lessons marked Preview are free samples.
-
Course overview & install Power BI Desktop Free preview
12:30
-
Power BI ecosystem: Desktop, Service, Mobile Locked
8:45
-
Import your first dataset Locked
15:20
-
Build a simple report in 20 minutes Locked
20:10
-
Power Query editor: merge, append, pivot Locked
22:00
-
Data types, profiling, and quality checks Locked
14:15
-
Star schema: facts, dimensions, relationships Locked
18:40
-
Active vs inactive relationships Locked
11:05
-
Calculated columns vs measures Locked
16:30
-
CALCULATE and filter context Locked
19:50
-
Time intelligence: YTD, MTD, same period last year Locked
21:10
-
Dashboard design: layout, colors, accessibility Locked
17:25
-
Publish to Power BI Service & sharing Locked
13:00