Microsoft Power BI Comprehensive Course

Overview

• Instructor: Trish Connor Kato
• Modules: 13 covering basics to advanced features

Module 1: Introduction to Data Analytics and Power BI Licensing

• Key Topics:
  • Data analytics overview
  • Roles in data analytics
  • Power BI roles and responsibilities
  • Licensing options for Power BI

Module 2: Getting Started with Power BI Desktop

• Hands-On: Identify and retrieve data from various sources
• Topics:
  • Data connectivity and storage options
  • Importing vs connecting to data
• Practicals:
  • Sample datasets: Excel, Access, web data
  • Save and export datasets

Module 3: Data Cleaning and Transformation

• Focus: Profiling and preparing data for modeling
• Data Preparation:
  • Identify data anomalies
  • Data cleaning techniques
• Tools:
  • Power Query Editor for data transformation
  • Custom column creation

Module 4: Designing and Developing Data Models

• Important Concepts: Performance and scalability
• Topics:
  • Data model relationships, security, performance
  • Introduction to DAX (Data Analysis Expressions)
• Exercises:
  • Create measures, calculated columns/tables
  • Optimize data models for performance

Module 5: DAX and Model Calculations

• Focus: Using DAX for various calculations
• Key Topics:
  • Aggregations and functions
  • Measures, calculated columns, calculated tables
  • Time intelligence functions

Module 6: Optimizing Model Performance

• Topics:
  • Best practices for data modeling
  • Direct Query vs import
  • Variables and DAX
• Tools:
  • Power BI performance optimization techniques

Module 7: Advanced Reporting Techniques

• Focus: Report designing and building
• Key Topics:
  • Selecting visuals, page layout design
  • Accessibility features in reports
• Hands-On:
  • Different report visualizations in Power BI
  • Synched slicers, drill-through reports
  • Creating and utilizing bookmarks

Module 8: Creating Dashboards and Real-Time Reporting

• Key Topics:
  • Pinning visualizations to dashboards
  • Real-time dashboard setup
  • Enhancing dashboards with multimedia
• Exercises:
  • Use Microsoft Forms, Power Automate
  • Create and manage dashboard tile alerts

Module 9: Paginated Reports

• Tool: Power BI Report Builder
• Topics:
  • Multi-page reports for printing/exporting
  • Configuring and publishing paginated reports

Module 10: Advanced Analytics

• Key Topics:
  • AI visuals, animated visuals
  • Forecasting, analyzing data patterns
• Tools:
  • Using Key Influencers, Decomposition Tree visuals

Module 11: Sharing and Managing Assets

• Key Topics:
  • Workspace management
  • Sharing and distributing dashboards/reports
  • Assigning roles and access permissions

Module 12: Managing Datasets

• Focus: Data refresh and parameters
• Hands-On:
  • Creating and managing parameters
  • Scheduling dataset refresh

Module 13: Security

• Focus: Row-Level Security (RLS)
• Topics:
  • Implement/Configure RLS in Power BI
  • Secure data access within organizations