Microsoft Power BI: Data Analysis for Professionals

Intended Organizations
Skill LevelGeneral Workforce
Virtual | Live Trainer4 hours/day, 3 Days
In-Person | Onsite6 hours/day, 3 Days
Smiling professional in a wheelchair holding a phone beside data monitors

Course Overview

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.

Who It's For

  • Business analysts and data analysts who need to connect, transform, and analyze data from multiple sources.
  • Managers and business professionals who use reports and dashboards to support data-driven decisions.
  • Reporting and business intelligence professionals seeking to improve their Power BI skills.
  • Finance, operations, and administrative professionals responsible for analyzing business data and presenting insights.
  • Professionals who want to develop practical skills in data visualization, data modeling, report publishing, and collaboration using Power BI.

Course Agenda

Ten modules · 28 topics
1Analyzing Data & ReportingTopics 1–2
  1. Data Analysis and Visualization for BI
  2. Interact with Reports in Power BI
2Connecting to Data SourcesTopics 3–6
  1. Creating Data Connections
  2. Configure and Manage Data Relationships
  3. Save Files in Microsoft Power BI
  4. Secure and Troubleshoot Connections
3Cleaning, Transforming, & Loading DataTopics 7–10
  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
4Visualizing Data with Power BITopics 11–12
  1. Create Visualizations in Power BI
  2. How to Select Visualization Types
5Enhancing Visuals for Data AnalysisTopics 13–14
  1. Customize Visuals and Pages
  2. Incorporate Tooltips
6Modeling Data with CalculationsTopics 15–17
  1. How to Create Calculated Columns with DAX
  2. Creating Calculated Measures
  3. Using Conditional Columns
7Customizing & Filtering ReportsTopics 18–21
  1. Create Data Hierarchies
  2. Filter Reports
  3. Discover Time-Intelligence Insights
  4. How to Configure Slicers for Interactive Filtering
8Sharing Reports & Creating DashboardsTopics 22–24
  1. Publish and Explore Reports
  2. How to Create Dashboards
  3. Adding Q&A to Dashboards
9Management & CollaborationTopics 25–26
  1. Managing Workspaces and Sharing Content
  2. How to Collaborate with the Power BI Service
10Enhancing Reports & DashboardsTopics 27–28
  1. Optimizing Usability and Performance
  2. Creating Mobile Reports for Power BI

About our Trainers

PTR training instructor headshot
PTR training instructor headshot
PTR training instructor headshot

Our Mission

Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.

Frequently Asked Questions

What is the Microsoft Power BI: Data Analysis for Professionals course about?

This course teaches professionals how to use Microsoft Power BI to connect to data sources, clean and transform data, create visualizations, build interactive reports and dashboards, and share insights. It also covers data modeling, advanced analysis techniques, and collaboration through the Power BI Service.

What is Microsoft Power BI used for?

Microsoft Power BI is a business intelligence platform used to connect to data, analyze information, and present insights through interactive reports and dashboards. It helps professionals understand business performance and communicate findings through data visualizations.

What is self-service business intelligence (BI)?

Self-service BI enables business users and professionals to access, analyze, and visualize data without relying entirely on specialized technical teams. The course introduces data analysis and visualization techniques for self-service BI using Power BI.

Can I connect Power BI to different data sources?

Yes. Power BI supports connections to different data sources, including cloud-based sources. This course covers creating data connections, managing data relationships, saving files, and securing and troubleshooting connections.

What are slicers in Power BI?

Slicers are interactive filtering controls that allow users to narrow the data displayed in reports. They help users explore information based on selected categories, dates, or other available fields. The course covers configuring slicers for interactive filtering.

What is the Power BI Service used for?

The Power BI Service supports publishing, managing, sharing, and collaborating on Power BI content. The course covers managing workspaces, sharing reports and other content, and collaborating through the service.

Discover More Ways to Build Your Skills

Microsoft Power BI: Data Analysis for Professionals

Request a Training Quote

Share your team’s goals, and we’ll recommend the right skills training.