Get and transform data with Power BI
- Offered byMicrosoft
Get and transform data with Power BI at Microsoft Overview
Duration | 3 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Official Website | Explore Free Course |
Credential | Certificate |
Get and transform data with Power BI at Microsoft Course details
- Get data in Power BI
- Clean, transform, and load data in Power BI
- Start here to learn how to ingest and transform data in Power BI
- 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
- 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
Get and transform data with Power BI at Microsoft Curriculum
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
Exercise - 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
Exercise - Load data in Power BI Desktop
Check your knowledge
Summary