Transforming data

Introduction to Power BI

Iason Prassides

Curriculum Manager, DataCamp

Transforming data

  • Dataset may contain:
    • Columns you don't need
    • Inconvenient and inconsistent formatting
    • Extra characters
    • Blank rows
  • Cleaning data
Introduction to Power BI

Loading data

power_query.png

Introduction to Power BI

Loading data

power_query_load.png

Introduction to Power BI

Loading data

power_query_transform.png

Introduction to Power BI

Power Query Editor

power_query_editor.png

Introduction to Power BI

Don't forget to Close & Apply

close&apply.png

Introduction to Power BI

Let's practice!

Introduction to Power BI

Preparing Video For Download...