Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Prepare data for analysis with Power BI

Microsoft via Microsoft Learn

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
  • Module 1: You will learn how to retrieve data from a wide variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You will also learn how to improve performance while retrieving data.
  • By the end of this module, you’ll be able to: 

    • Identify and connect to a data source
    • Get data from a relational database, like Microsoft SQL Server
    • Get data from a file, like Microsoft Excel
    • Get data from applications
    • Get data from Azure Analysis Services
    • Select a storage mode
    • Fix performance issues
    • Resolve data import errors
  • Module 2: Power Query has an incredible amount of features that are dedicated to helping you clean and prepare your data for analysis. You will learn how to simplify a complicated model, change data types, rename objects, and pivot data. You will also learn how to profile columns so that you know which columns have the valuable data that you’re seeking for deeper analytics.
  • By the end of this module, you’ll be able to:

    • Resolve inconsistencies, unexpected or null values, and data quality issues.
    • Apply user-friendly value replacements.
    • Profile data so you can learn more about a specific column before using it.
    • Evaluate and transform column data types.
    • Apply data shape transformations to table structures.
    • Combine queries.
    • Apply user-friendly naming conventions to columns and queries.
    • Edit M code in the Advanced Editor.

Syllabus

  • Module 1: Get data in Power BI
    • Introduction
    • Get data from files
    • Get data from relational data sources
    • Get data from a NoSQL database
    • Get data from online services
    • Select a storage mode
    • Get data from Azure Analysis Services
    • Fix performance issues
    • Resolve data import errors
    • Lab - Prepare data in Power BI Desktop
    • Check your knowledge
    • Summary
  • Module 2: Clean, transform, and load data in Power BI
    • Introduction
    • Shape the initial data
    • Simplify the data structure
    • Evaluate and change column data types
    • Combine multiple tables into a single table
    • Profile data in Power BI
    • Use Advanced Editor to modify M code
    • Lab - Load data in Power BI Desktop
    • Check your knowledge
    • Summary

Reviews

Start your review of Prepare data for analysis with Power BI

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.