/Power BI - Beginner

Course Curriculum

Section 1 · Module 1: Introduction to Business Intelligence & Power BI

○ What is Business Intelligence (BI)? ○ Overview of Power BI and its components (Power BI Desktop, Service, Mobile) ○ Installing and setting up Power BI Desktop

Section 2 · Module 2: Connecting & Transforming Data (Power Query)

○ Importing data from Excel, CSV, SQL, and cloud services ○ Data transformation basics: filtering, cleaning, merging, and appending data ○ Introduction to Power Query Editor

Section 3 · Module 3: Data Modeling & Relationships

○ Understanding tables, fields, and relationships ○ Creating relationships between tables ▶ Using the Star Schema for better performance

Section 4 · Module 4: Data Visualization Basics

○ Creating bar charts, line graphs, pie charts, and maps ○ Formatting visuals for better readability ○ Adding slicers, filters, and drill-through options

Section 5 · Module 5: Introduction to DAX (Data Analysis Expressions)

○ What is DAX? ○ Basic DAX functions: SUM, AVERAGE, COUNT ○ Creating calculated columns and measures

Module 3: Data Modeling & Relationships

Using the Star Schema for better performance

← Previous Continue →