Microsoft Power BI: Data Analysis Professional

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

This course is designed for professionals responsible for connecting to cloud-based data sources and shaping and combining data for analysis. In this 3-day course, you will learn the same skillset for creating compelling and interactive worksheets, dashboards, and stories, as well as 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.
  • Add and customize visual elements.
  • Model data with calculations.
  • Customize and filter visualizations.
  • Use advanced analysis techniques.
  • Share reports and create dashboards.
  • Manage and collaborate in the Power BI Service.
  • Enhance reports and dashboards.

Course Agenda

Analyzing Data & Reporting

  1. Data Analysis and Visualization for BI
  2. Interact with Reports in Power BI

Connecting to Data Sources

  1. Creating Data Connections
  2. Configure and Manage Data Relationships
  3. Save Files in Microsoft Power BI
  4. Secure and Troubleshoot Connections

Cleaning, Transforming, & Loading Data

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

Visualizing Data with Power BI

  1. Create Visualizations in Power BI
  2. How to Select Visualization Types

Enhancing Visuals for Data Analysis

  1. Customize Visuals and Pages
  2. Incorporate Tooltips

Modeling Data with Calculations

  1. How to Create Calculated Columns with DAX
  2. Creating Calculated Measures
  3. Using Conditional Columns

Customizing & Filtering Reports

  1. Create Data Hierarchies
  2. Filter Reports
  3. Discover Time-Intelligence Insights
  4. How to Configure Slicers for Interactive Filtering

Sharing Reports & Creating Dashboards

  1. Publish and Explore Reports
  2. How to Create Dashboards
  3. Adding Q&A to Dashboards

Management & Collaboration

  1. Managing Workspaces and Sharing Content
  2. How to Collaborate with the Power BI Service

Enhancing Reports & Dashboards

  1. Optimizing Usability and Performance
  2. Creating Mobile Reports for Power BI
Portrait of young and cheerful male businessman in a wheelchair holding his smartphone and smiling while sitting at his workplace in modern office. Handicapped worker. Trading online. Stock market - leadership strategies for wellness

Microsoft Power BI: Data Analysis Professional

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

This course is designed for professionals responsible for connecting to cloud-based data sources and shaping and combining data for analysis. In this 3-day course, you will learn the same skillset for creating compelling and interactive worksheets, dashboards, and stories, as well as 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.
  • Add and customize visual elements.
  • Model data with calculations.
  • Customize and filter visualizations.
  • Use advanced analysis techniques.
  • Share reports and create dashboards.
  • Manage and collaborate in the Power BI Service.
  • Enhance reports and dashboards.

Course Agenda

Analyzing Data & Reporting

  1. Data Analysis and Visualization for BI
  2. Interact with Reports in Power BI

Connecting to Data Sources

  1. Creating Data Connections
  2. Configure and Manage Data Relationships
  3. Save Files in Microsoft Power BI
  4. Secure and Troubleshoot Connections

Cleaning, Transforming, & Loading Data

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

Visualizing Data with Power BI

  1. Create Visualizations in Power BI
  2. How to Select Visualization Types

Enhancing Visuals for Data Analysis

  1. Customize Visuals and Pages
  2. Incorporate Tooltips

Modeling Data with Calculations

  1. How to Create Calculated Columns with DAX
  2. Creating Calculated Measures
  3. Using Conditional Columns

Customizing & Filtering Reports

  1. Create Data Hierarchies
  2. Filter Reports
  3. Discover Time-Intelligence Insights
  4. How to Configure Slicers for Interactive Filtering

Sharing Reports & Creating Dashboards

  1. Publish and Explore Reports
  2. How to Create Dashboards
  3. Adding Q&A to Dashboards

Management & Collaboration

  1. Managing Workspaces and Sharing Content
  2. How to Collaborate with the Power BI Service

Enhancing Reports & Dashboards

  1. Optimizing Usability and Performance
  2. Creating Mobile Reports for Power BI