Description

Transform raw data into powerful, interactive dashboards with Microsoft Power BI.
In this 6-week course, you’ll learn to connect, model, and visualize data from multiple sources using one of the most in-demand business intelligence tools in the industry. Perfect for analysts, managers, and decision-makers looking to make data-driven moves.

Course Duration: 6 Weeks
Skill Level: Beginner to Intermediate
Prerequisites: Familiarity with Excel or basic data concepts is helpful, but not mandatory

Syllabus Overview

Week 1: Getting Started with Power BI

• Introduction to Business Intelligence

• Installing Power BI Desktop

• Interface overview and navigation

• Importing data from Excel, CSV, and web

Week 2: Data Cleaning & Transformation (Power Query)

• Introduction to Power Query

• Removing errors, nulls, and duplicates

• Splitting/merging columns

• Data types and applied steps

Week 3: Data Modeling

• Creating relationships between tables

• Understanding cardinality and direction

• Creating calculated columns and measures

• Basics of DAX (Data Analysis Expressions)

Week 4: Data Visualization & Reports

• Bar, Line, Map, KPI, Matrix visuals

• Using filters, slicers, and cards

• Formatting visuals for readability

• Drill-downs and tooltips

Week 5: Dashboard Design & Interactivity

• Designing clean, user-friendly layouts

• Building multi-page reports

• Interactivity with bookmarks and buttons

• Publishing and sharing reports via Power BI Service

Week 6: Capstone Project & Best Practices

• End-to-end dashboard from real-world data

• Applying design principles & storytelling

• Performance tips and publishing workflow

• Presentation & feedback session

Assessment & Certification

• Weekly assignments & mini-dashboards

• Final capstone: Build and publish a full Power BI dashboard

• Certificate of Completion issued digitally