Prepare data for analysis with Power BI

  • Learning Path
  • 3 Modules

At a glance

You'll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You'll also learn to profile, clean, and load data into Power BI before you model your data.

This learning path can help you prepare for the Microsoft Certified: Data Analyst Associate certification.

Prerequisites

None

Modules in this learning path

Get data in Power BI

Connect to data sources including Excel, relational databases, and NoSQL stores in Power BI. Learn techniques to optimize performance and resolve common import errors.

Clean, transform, and load data in Power BI

Use Power Query to clean and prepare data for analysis. Learn to simplify models, change data types, rename objects, pivot data, and profile columns to identify valuable data for deeper analytics.

Choose a Power BI model framework

Describe model frameworks, their benefits and limitations, and features to help optimize your Power BI data models.

Start