Data Visualization using Power BI

🧱 Course Modules & Lessons:

🔹 Module 1: Introduction to Power BI

• What is Power BI and why use it?

• Key components: Power BI Desktop, Service, Mobile

• Installing Power BI Desktop

• Power BI vs Tableau vs Excel

• Exploring the Power BI interface

🔹 Module 2: Connecting to and Transforming Data

• Importing data from Excel, CSV, Web, SQL Server

• Introduction to Power Query Editor

• Cleaning and transforming data (remove nulls, change types, split columns)

• Merging and appending queries

• Basic data modeling principles

🔹 Module 3: Data Modeling and DAX

• What is a data model?

• Creating relationships between tables

• Star schema vs snowflake schema

• Introduction to DAX (Data Analysis Expressions)

• Common DAX functions: CALCULATE, SUMX, FILTER, etc.

• Creating calculated columns and measures

🔹 Module 4: Visualizing Data

• Understanding visual types and when to use them

• Bar, line, pie, waterfall, combo, gauge, KPI

• Creating slicers and filters

• Conditional formatting and tooltips

• Sorting, formatting, and customizing visuals

🔹 Module 5: Building Interactive Dashboards

• Designing dashboard layouts and themes

• Linking multiple pages and visuals

• Using bookmarks, buttons, and drill-through pages

• Performance tips: optimizing visuals and DAX

• Sharing and publishing dashboards to Power BI Service

• Embedding dashboards (e.g., in websites or SharePoint)

🔹 Module 6: Final Project: Create a Full Power BI Dashboard

• Choose from: Sales Dashboard, HR Analytics, Financial Performance, or Marketing ROI

• Clean and model the data

• Apply visualizations, filters, and interactivity

• Submit final .pbix file and recorded walkthrough (optional)