M03: Cleaning,

Transforming, and
Loading Data

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
 Shaping the Data

Module
Agenda Profiling the Data

Enhance the Data Structure

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Learning Objectives

You will learn the following concepts:

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Lesson 1: Shaping the Data

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Learning Objectives

• Benefits of clean data

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Identify column headers and names
Use Power Query Editor to clean up and shape data.

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Shaping Table Structure
Shape the data to meet reporting needs.

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Unpivot and Pivot columns
Transfer data from rows to columns, and columns to rows.

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Lesson 2: Profiling the Data

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Profiling Data and Examining Structures
Data profiling is understanding the state and
structure of the data you are working with.

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Lesson 3: Enhance the Data Structure

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Apply user-friendly value replacements
Make information user-friendly.

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Evaluate and Change Column Data Types

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Combine Multiple Tables into a Single Table

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
Module Overview

We covered the following concepts:

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.
References
PL-300 Clean, transform, and load data in Power BI
https://docs.microsoft.com/en-us/learn/modules/clean-data-power-
bi/

https://forms.office.com/r/w9cyHaVgz6

© CopyrightPower
Microsoft
BI Bootcamp
Corporation.
- FallAll2022
rights reserved.