Extract, Transform and Load Data in Power BI
Instructor: Microsoft
Beginner Level • 4 hours to complete • Flexible Schedule
What You'll Learn
- How to set up a data source and explain and configure storage modes in Power BI.
- How to prepare for data modeling by cleaning and transforming data.
- How to use profiling tools to identify data anomalies.
- How to reference queries and dataflows and use the Advanced Editor to modify code.
Skills You'll Gain
Data Cleansing
Data Validation
Data Integration
Data Storage
Extract, Transform, Load
Data Transformation
Data Quality
Power BI
Business Intelligence
Data Storage Technologies
Data analysis
Shareable Certificate
Earn a shareable certificate to add to your LinkedIn profile
Outcomes
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate from Microsoft
There are 4 modules in this course
In this module, you'll set up data sources and explore the different data source capabilities in Power BI.
In this module, you'll practice cleaning and transforming data to prepare for data modeling in later courses.
In this module, you'll gain an understanding of the load portion of the ETL process and practice data profiling and advanced queries.
In this module, you'll be assessed on the key skills covered in the course.