Prepare data for analysis with Power BI
Offered By: Microsoft via Microsoft Learn
Course Description
Overview
- 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.
- 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.
- 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.
By the end of this module, you’ll be able to:
By the end of this module, you’ll be able to:
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
Tags
Related Courses
Data Wrangling with MongoDBMongoDB via Udacity Getting and Cleaning Data
Johns Hopkins University via Coursera 软件包在流行病学研究中的应用 Using software apps in epidemiological research
Peking University via Coursera Creating an Analytical Dataset
Udacity Implementing ETL with SQL Server Integration Services
Microsoft via edX