Prepare data for analysis
- Offered byMicrosoft
Prepare data for analysis at Microsoft Overview
Prepare data for analysis
at Microsoft
Duration | 4 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Prepare data for analysis at Microsoft Course details
Prepare data for analysis
at Microsoft
Skills you will learn
What are the course deliverables?
- 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.
More about this course
- You will explore Power Query as you learn to extract data from different data sources and choose a storage mode and connectivity type. You will learn to profile, clean, and load data into Power BI in preparation for modeling your data
- This learning path can help you prepare for the Microsoft Certified: Data Analyst Associate certification.
Prepare data for analysis at Microsoft Curriculum
Prepare data for analysis
at Microsoft
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
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
Other courses offered by Microsoft
View Other 1171 Courses
Prepare data for analysis
at Microsoft
Student Forum
Anything you would want to ask experts?