Power BI Data Analysis – Complete Course Outline
Module 1: Introduction to Business Intelligence & Power BI
Topics
• What is Business Intelligence (BI)?
• Data Analytics vs Business Intelligence
• Components of Microsoft Power BI
• Installing Power BI Desktop
• Power BI Service and Mobile App
• Power BI Workflow
• Power BI Interface Overview
• Creating Your First Report
Labs
• Install Power BI Desktop
• Import a sample Excel file
• Create a simple bar chart
Module 2: Data Sources & Data Import
Topics
• Connecting to Excel
• CSV/Text Files
• SQL Server
• Microsoft Access
• Web Data
• Folder Data
• SharePoint
• PDF Data
• Data Refresh
Labs
• Import data from Excel and CSV
• Combine multiple CSV files
Module 3: Power Query Editor (Data Cleaning & Transformation)
Topics
• Power Query Interface
• Data Types
• Rename Columns
• Remove Columns
• Remove Duplicates
• Replace Values
• Split Columns
• Merge Columns
• Fill Up & Fill Down
• Pivot and Unpivot
• Conditional Columns
• Group By
• Merge Queries
• Append Queries
• Date Transformations
• Text Transformations
• Number Transformations
Labs
• Clean messy sales data
• Remove blanks and duplicates
• Create calculated columns
Module 4: Data Modeling
Topics
• Tables
• Relationships
• One-to-One
• One-to-Many
• Many-to-Many
• Star Schema
• Snowflake Schema
• Active & Inactive Relationships
• Cardinality
• Cross Filter Direction