Microsoft Power BI: Data Analysis Practitioner

Description

In this course, you will analyze data with Microsoft Power BI. You will:

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

Lesson 1: Analyzing Data with Self-Service BI

Topic A: Data Analysis and Visualization for Business Intelligence

Topic B: Self-Service BI with Microsoft Power BI

Lesson 2: Connecting to Data Sources

Topic A: Create Data Connections

Topic B: Configure and Manage Data Relationships

Topic C: Save Files in Power BI

Lesson 3: Performing Data Cleaning, Profiling, and Shaping

Topic A: Clean, Transform, and Load Data with the Query Editor

Topic B: Profile Data with the Query Editor

Topic C: Shape Data with the Query Editor

Topic D: Combine and Manage Data Rows

Lesson 4: Visualizing Data with Power BI

Topic A: Create Visualizations in Power BI

Topic B: Chart Data in Power BI

Lesson 5: Enhancing Data Analysis

Topic A: Customize Visuals and Pages

Topic B: Incorporate Tooltips

Lesson 6: Modeling Data with Calculations

Topic A: Create Calculations with Data Analysis Expressions (DAX)

Topic B: Create Calculated Measures and Conditional Columns

Lesson 7: Creating Interactive Visualizations

Topic A: Create and Manage Data Hierarchies

Topic B: Filter and Slice Reports

Topic C: Create Dashboards

Similar courses

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course is best for students with high PC skills and are experienced/comfortable with technology - if that isn't you, our one or two day Power BI classes might be a better fit for you.

More Information

This is a great class for an overview of Power BI/if Power BI isn't a central part of your job role.

More Information

Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes).

More Information

Understanding DAX is critical for Power BI users. It is required that you are familiar with Power BI and (if attending virtually) that you have Power BI on the PC to be used for this training event in order to take this class

More Information

This is a great class for an overview of Power BI/if Power BI isn't a central part of your job role.

More Information

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course is best for students with high PC skills and are experienced/comfortable with technology - if that isn't you, our one or two day Power BI classes might be a better fit for you.

More Information

Understanding DAX is critical for Power BI users. It is required that you are familiar with Power BI and (if attending virtually) that you have Power BI on the PC to be used for this training event in order to take this class.

More Information