Microsoft Power BI: Data Analysis Practitioner & Professional Series

Formats  Live Virtual: 4 hrs./day, 3 Days  |  In-Person: 6 hrs./day, 3 Days

This series is designed for professionals responsible for connecting to cloud-based data sources and shaping and combining data for analysis. The Data Analysis Practitioner and Professional Series combines the Practitioner and Professional Courses for a power-packed 3-day series. You will learn to create compelling and interactive worksheets, dashboards, and stories. You will also apply advanced analysis techniques, enhanced reporting, and publishing.

Learning Objectives »

  • Analyze data with self-service BI.
  • Connect to data sources.
  • Perform data cleaning, profiling, and shaping.
  • Visualize data with Power BI.
  • Enhance data analysis with customized visual elements.
  • Model data with calculations.
  • Create interactive visualizations.

Course Agenda

Data Analysis Practitioner

Analyzing Data with Self-Service BI

  1. Data Analysis and Visualization for BI
  2. Self-Service BI with Microsoft Power BI

Connecting to Data Sources

  1. Create Data Connections
  2. Manage Data Relationships
  3. Save Files in Power BI

Data Cleaning, Profiling, and Shaping

  1. Clean, Transform, and Load Data
  2. Profile Data with the Query Editor
  3. Shape Data with the Query Editor
  4. Combine and Manage Data Rows

Visualizing Data with Power BI

  1. Create Visualizations in Power BI
  2. Chart Data in Power BI

Enhancing Data Analysis

  1. Customize Visuals and Pages
  2. Incorporate Tooltips

Modeling Data with Calculations

  1. Use Data Analysis Expressions (DAX)
  2. Calculated Measures and Columns

Creating Interactive Visualizations

  1. Create and Manage Data Hierarchies
  2. Filter and Slice Reports
  3. Create Dashboards

Data Analysis Professional

Using Advanced Analysis Techniques

  1. Tables, Variables, and Parameters
  2. Visuals with Statistical Analysis
  3. Perform Advanced Analysis

Enhancing Reports and Dashboards

  1. How to Enhance Reports
  2. How to Enhance Dashboards

Enhancing Reports and Dashboards

  1. Publish Reports
  2. Create and Manage Workspaces
  3. Share Reports and Dashboards

Extending Power BI

  1. Use Power BI Mobile
  2. Extend Access with the Power BI API
Microsoft Power BI logo featuring a yellow bar chart icon alongside the platform's name, representing its business analytics services.

Microsoft Power BI: Data Analysis Practitioner & Professional Series

Formats  Live Virtual: 4 hrs./day, 3 Days  |  In-Person: 6 hrs./day, 3 Days

This series is designed for professionals responsible for connecting to cloud-based data sources and shaping and combining data for analysis. The Data Analysis Practitioner and Professional Series combines the Practitioner and Professional Courses for a power-packed 3-day series. You will learn to create compelling and interactive worksheets, dashboards, and stories. You will also apply advanced analysis techniques, enhanced reporting, and publishing.

Learning Objectives »

  • Analyze data with self-service BI.
  • Connect to data sources.
  • Perform data cleaning, profiling, and shaping.
  • Visualize data with Power BI.
  • Enhance data analysis with customized visual elements.
  • Model data with calculations.
  • Create interactive visualizations.

Course Agenda

Data Analysis Practitioner

Analyzing Data with Self-Service BI

  1. Data Analysis and Visualization for BI
  2. Self-Service BI with Microsoft Power BI

Connecting to Data Sources

  1. Create Data Connections
  2. Manage Data Relationships
  3. Save Files in Power BI

Data Cleaning, Profiling, and Shaping

  1. Clean, Transform, and Load Data
  2. Profile Data with the Query Editor
  3. Shape Data with the Query Editor
  4. Combine and Manage Data Rows

Visualizing Data with Power BI

  1. Create Visualizations in Power BI
  2. Chart Data in Power BI

Enhancing Data Analysis

  1. Customize Visuals and Pages
  2. Incorporate Tooltips

Modeling Data with Calculations

  1. Use Data Analysis Expressions (DAX)
  2. Calculated Measures and Columns

Creating Interactive Visualizations

  1. Create and Manage Data Hierarchies
  2. Filter and Slice Reports
  3. Create Dashboards

Data Analysis Professional

Using Advanced Analysis Techniques

  1. Tables, Variables, and Parameters
  2. Visuals with Statistical Analysis
  3. Perform Advanced Analysis

Enhancing Reports and Dashboards

  1. How to Enhance Reports
  2. How to Enhance Dashboards

Enhancing Reports and Dashboards

  1. Publish Reports
  2. Create and Manage Workspaces
  3. Share Reports and Dashboards

Extending Power BI

  1. Use Power BI Mobile
  2. Extend Access with the Power BI API