Excel - Discover Power Query and dynamically connect your data - Training Courses | Afi U.

New

Excel - Discover Power Query and dynamically connect your data

Get to know better Microsoft Excel and Power BI data models with the M fornula language reference.

Upcoming sessions

Show all sessionsarrow icon
Guaranteed to run
  • Duration: 1 day
  • Regular price: $360
  • Preferential price: $306tip icon

Course outline

Duration : 1 day

© AFI par Edgenda inc.

This training course is aimed at data analysis professionals and BI experts who want to deepen their knowledge of Microsoft Excel and Power BI data models using the M language to connect different data sources, transform data and optimize data models within their organization.

Audience

Professionals, data engineers and data analysts wishing to import, transform and load data in the Power Query editor

Objectives

  • Master the skills needed to clean, filter, sort, aggregate, merge and transform data
  • Create a Date table
  • Master the best practices

Teaching method

Lectures - demonstrations - guided and individual exercises

Contents

Chapter 1 - Introduction to Power Query
  • What is Power Query
  • Why use it
  • Understanding the Power Query editor
Chapter 2 - Querying data sources
  • Understanding data access functions
  • Data loading options
  • Discover the impact on data refreshing
Chapter 3 - Transforming master data
  • Transforming basic data
  • Transforming text columns
  • Transform number columns
  • Transforming date columns
  • Using duration functions
  • Learn to use error functions
Chapter 4 - Using advanced queries
  • Pivoting and depivoting columns
  • Simplify and standardize names
  • Adjust column types
  • Combine several tables into one
  • Using the advanced editor M
Chapter 5 - Creating a date table
  • Create a date list
  • Transform list into table
  • Change data type
  • Add columns Year, Month, Day, ...
  • Add a conditional column
  • Update a date
Chapter 6 - Apply good practices
  • Reviewing the best practices in Power Query

Related courses

Power BI - Discover Power Query and dynamically connect your data | AFI Expertise