Microsoft Power BI: Data Analysis Practitioner

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

Microsoft Power BI was built to connect to a wide range of data sources. It lets users quickly visualize connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those in spreadsheets. In this 2-day course, you will learn to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

Learning Objectives »

  • Analyze data and create reports with Power BI.
  • Connect to data.
  • Clean, transform, and load data.
  • Visualize data with Power BI.
  • Enhance visuals to support data analysis.
  • Customize and filter reports.
  • Sharing reports and creating Power BI dashboards.

Course Agenda

Analyzing Data & Reporting

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

Connecting to Data

  1. How to Create Data Connections
  2. Configure and Manage Relationships
  3. Saving Files in Power BI

Cleaning, Transforming, & Loading Data 

  1. Loading, Cleaning, and Shaping the 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. Creating Visualizations in Power BI
  2. Selecting Visualization Types

Enhancing Visuals for Data Analysis

  1. How to Customize Visuals and Pages
  2. Incorporating Tooltips into Visualizations

Customizing & Filtering Reports

  1. Creating Data Hierarchies
  2. How to Filter Reports
  3. Configure Slicers for Interactive Filtering

Sharing Reports & Creating Dashboards

  1. How to Publish and Explore Reports
  2. Create Dashboards
  3. Adding Q&A to Power BI Dashboards
Young african male programmer writing program code sitting at the workplace with three monitors in the office. Image focused on the screen

Microsoft Power BI: Data Analysis Practitioner

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

Microsoft Power BI was built to connect to a wide range of data sources. It lets users quickly visualize connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those in spreadsheets. In this 2-day course, you will learn to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

Learning Objectives »

  • Analyze data and create reports with Power BI.
  • Connect to data.
  • Clean, transform, and load data.
  • Visualize data with Power BI.
  • Enhance visuals to support data analysis.
  • Customize and filter reports.
  • Sharing reports and creating Power BI dashboards.

Course Agenda

Analyzing Data & Reporting

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

Connecting to Data

  1. How to Create Data Connections
  2. Configure and Manage Relationships
  3. Saving Files in Power BI

Cleaning, Transforming, & Loading Data 

  1. Loading, Cleaning, and Shaping the 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. Creating Visualizations in Power BI
  2. Selecting Visualization Types

Enhancing Visuals for Data Analysis

  1. How to Customize Visuals and Pages
  2. Incorporating Tooltips into Visualizations

Customizing & Filtering Reports

  1. Creating Data Hierarchies
  2. How to Filter Reports
  3. Configure Slicers for Interactive Filtering

Sharing Reports & Creating Dashboards

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