Clean, transform, and load data in Power BI

Course Description (Long)

Power Query offers a multitude of features dedicated to assisting users in cleaning and preparing data for analysis. This module guides learners through simplifying complex models, altering data types, renaming objects, and pivoting data. Additionally, it delves into profiling columns to identify which contain valuable data essential for deeper analytics. By the end of this module, participants will be adept at resolving inconsistencies, handling unexpected or null values, and addressing data quality issues. They will also be equipped to apply user-friendly value replacements, evaluate and transform column data types, and combine queries effectively. Furthermore, the module emphasizes the importance of applying intuitive naming conventions to columns and queries, as well as editing M code in the Advanced Editor.

Course Format

Online learning

Course Length

Approximately 2 hours

Course Accreditation

No accreditation

Cost

Free

Access

General access

Skills Covered

- Resolve data inconsistencies and quality issues
- Apply value replacements
- Profile data columns
- Evaluate and transform column data types
- Perform data shape transformations
- Combine queries
- Implement naming conventions for columns and queries
- Edit M code using the Advanced Editor

Mapped to NCF

• SA24.1 Beginner: Proficient in Power BI basics, including connecting to data sources and creating simple visualisations.

• SA24.2 Beginner: Understand the importance of clean data by using tools like Power Query to transform and prepare datasets effectively.