Power BI
IT
This 20-hour program builds end-to-end Power BI competency — from connecting and modeling data to writing DAX, designing compelling reports, and publishing governed dashboards to the Power BI Service. The course blends c…
Program Overview
This 20-hour program builds end-to-end Power BI competency — from connecting and modeling data to writing DAX, designing compelling reports, and publishing governed dashboards to the Power BI Service. The course blends conceptual grounding in business intelligence with hands-on, project-based practice.
Target Audience
Business analysts, data analysts, reporting teams, and managers who need to build or consume interactive BI dashboards.
Prerequisites
Basic Excel knowledge is helpful. No prior BI tool or programming experience required.
Learning Objectives
By the end of this module, participants will be able to:
- Connect, clean, and model data from multiple sources in Power BI
- Write DAX measures for aggregation and time intelligence
- Design clear, interactive, and visually effective reports
- Apply AI-powered visuals to surface deeper insights
- Publish, secure, and govern dashboards in the Power BI Service
Detailed Syllabus
Unit 1: BI Foundations & Data Connectivity (3 hrs)
- Business intelligence concepts and the Power BI ecosystem
- Power BI Desktop interface and workflow
- Connecting to files, databases, and cloud sources
Unit 2: Data Transformation & Modeling (3 hrs)
- Power Query for data shaping and cleaning
- Relationships, star schema, and data modeling best practices
Unit 3: DAX (3 hrs)
- DAX fundamentals: calculated columns vs. measures
- Aggregation and logical DAX functions
- Time intelligence functions (YTD, QTD, prior period comparisons)
Unit 4: Visualization & AI Features (4 hrs)
- Core visualizations and formatting
- Custom and advanced visuals
- AI visuals: Key Influencers, Decomposition Tree, Q&A
Unit 5: Reports, Dashboards & Interactivity (3 hrs)
- Report design and UX best practices
- Bookmarks, drill-through, and interactive navigation
Unit 6: Publishing, Governance & Optimization (3 hrs)
- Row-level security and data governance
- Publishing, workspaces, and apps in Power BI Service
- Performance optimization best practices
Unit 7: Capstone Project (1 hr)
- End-to-end BI project build and presentation
Hour-Wise Breakdown (20 Hours)
Hour | Topic | Content Covered | Hands-On Activity |
|---|---|---|---|
1 | BI Foundations | BI concepts & the Power BI ecosystem | Map out a BI reporting workflow for a sample business |
2 | BI Foundations | Power BI Desktop interface tour | Explore panes, ribbons, and views |
3 | Data Connectivity | Connecting to Excel, CSV, SQL, and cloud sources | Connect Power BI to three different data sources |
4 | Data Transformation | Power Query: shaping & cleaning data | Clean and reshape a raw sales dataset |
5 | Data Modeling | Relationships & star schema design | Build a star schema model from fact/dimension tables |
6 | Data Modeling | Modeling best practices & data categories | Optimize an existing data model |
7 | DAX | Introduction to DAX: columns vs. measures | Create 5 calculated columns and measures |
8 | DAX | Aggregation & logical DAX functions | Build SUMX, CALCULATE, and FILTER-based measures |
9 | DAX | Time intelligence functions | Build YTD, QTD, and YoY growth measures |
10 | Visualization | Core chart types & formatting | Build a set of core visuals for a sales report |
11 | Visualization | Advanced & custom visuals | Add a custom visual from AppSource |
12 | AI Features | Key Influencers & Decomposition Tree | Analyze churn drivers using Key Influencers |
13 | AI Features | Natural-language Q&A visual | Set up and test a Q&A visual on a dataset |
14 | Report Design | Report design & UX best practices | Redesign a cluttered report following UX principles |
15 | Interactivity | Bookmarks, drill-through, navigation | Build a bookmark-driven navigation menu |
16 | Governance | Row-level security & data governance | Implement RLS for two user roles |
17 | Publishing | Publishing, workspaces & apps | Publish a report and create a workspace app |
18 | Optimization | Performance optimization best practices | Optimize a slow-loading report |
19 | Capstone Project | Applied project work session | Build an end-to-end BI report for a business case |
20 | Capstone Project | Project presentation & wrap-up | Present the BI dashboard and receive feedback |
Practical Exercises
- Building a star-schema data model from raw fact/dimension tables
- Writing DAX measures for YTD, QTD, and YoY comparisons
- Designing an interactive sales dashboard with drill-through and bookmarks
- Configuring row-level security for multiple user roles
- Using Key Influencers and Decomposition Tree to explain business drivers
Real-World Projects
- Capstone: End-to-end sales & operations BI dashboard including data modeling, DAX measures, AI visuals, RLS, and Power BI Service publishing.
- Mini-project: Executive KPI scorecard with drill-through detail pages.
Assessment Plan
Component | Weight | Description |
|---|---|---|
Formative quizzes (end of each unit) | 20% | Short quizzes on modeling, DAX, and visuals |
Practical exercises | 30% | Hands-on tasks completed during each session |
Capstone project | 40% | End-to-end BI dashboard build and presentation |
Participation & engagement | 10% | In-class contribution and peer feedback |
Tools Required
- Power BI Desktop (latest version, free)
- Power BI Service account (free or Pro trial)
- Sample datasets (provided): sales, finance, and HR data
- Windows laptop (Power BI Desktop is Windows-only) with internet access
Expected Outcomes
- Build complete data models from raw, multi-source data
- Write effective DAX measures for common business calculations
- Design professional, interactive Power BI reports
- Apply AI visuals to accelerate insight discovery
- Publish and govern dashboards securely in an organization
Full curriculum is for enrolled learners
Enrol to unlock the detailed syllabus, hour-wise breakdown and assessment plan.