Power BI Curriculum (30 Hours)

Module 1: Introduction to Power BI (2 hours)

  • Topics Covered:
    • Overview of Power BI
    • Power BI Components: Power BI Desktop, Service, and Mobile
    • Installing Power BI Desktop
    • Power BI Interface and Navigation

Module 2: Connecting to Data (3 hours)

  • Topics Covered:
    • Data Sources Supported by Power BI
    • Connecting to Different Data Sources
    • Data Preparation and Cleaning
    • Data Types and Roles in Power BI

Module 3: Data Transformation with Power Query (4 hours)

  • Topics Covered:
    • Introduction to Power Query Editor
    • Data Cleaning and Shaping Techniques
    • Merging and Appending Queries
    • Using Advanced Editor and M Language

Module 4: Building Basic Visualizations (3 hours)

  • Topics Covered:
    • Creating Basic Charts: Bar, Line, Pie, and Column Charts
    • Formatting and Customizing Visualizations
    • Using Slicers and Filters
    • Creating Tables and Matrices

Module 5: Advanced Visualizations (4 hours)

  • Topics Covered:
    • Creating Advanced Chart Types: Waterfall, Funnel, and Gauge Charts
    • Using Maps and Geographic Visualizations
    • Creating Custom Visuals
    • Implementing R and Python Visuals

Module 6: Data Modeling and DAX (4 hours)

  • Topics Covered:
    • Introduction to Data Modeling
    • Creating Relationships Between Tables
    • Introduction to DAX (Data Analysis Expressions)
    • Writing Basic and Advanced DAX Measures and Calculations

Module 7: Creating Interactive Reports (3 hours)

  • Topics Covered:
    • Designing Interactive Reports
    • Using Bookmarks and Buttons for Navigation
    • Implementing Drillthrough and Tooltips
    • Creating and Customizing Report Themes

Module 8: Power BI Service (3 hours)

  • Topics Covered:
    • Publishing Reports to Power BI Service
    • Creating and Managing Dashboards
    • Sharing and Collaborating in Power BI
    • Scheduling Data Refreshes

Module 9: Power BI Mobile and Power BI Embedded (2 hours)

  • Topics Covered:
    • Introduction to Power BI Mobile
    • Designing Reports for Mobile Devices
    • Overview of Power BI Embedded
    • Integrating Power BI into Custom Applications

Module 10: Advanced Analytics and AI (4 hours)

  • Topics Covered:
    • Using AI Visuals: Key Influencers, Decomposition Tree, and Q&A
    • Implementing Machine Learning Models
    • Using Cognitive Services in Power BI
    • Performing Advanced Analytics with R and Python

Capstone Project 1: Sales Performance Dashboard (3 hours)

  • Objective:
    • Create a comprehensive sales performance dashboard using Power BI.
    • Connect to multiple data sources and perform data transformation.
    • Implement advanced visualizations and interactive elements.
  • Skills Applied:
    • Data Connection and Transformation
    • Advanced Visualizations
    • Report Design
    • Data Modeling

Capstone Project 2: Customer Segmentation Analysis (3 hours)

  • Objective:
    • Develop a customer segmentation analysis using Power BI.
    • Use clustering techniques and advanced DAX calculations.
    • Create an interactive report to present findings.
  • Skills Applied:
    • Advanced Analytics
    • DAX Calculations
    • Data Visualization
    • Report Interactivity