Power Query

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

Course description

Level:   Advanced 
Duration:   1 day

Power Query or ‘Get and Transform

Introduction 

  • What is Power Query 
  • Interface 

Data Sources 

  • From Web 
  • From Excel File 
  • From Current Workbook 
  • From CSV or Text File 
  • From Folder 

Multiple Sources 

  • Multiple Excel Tables or Named Ranges 
  • Appending Queries 
  • Merging Queries 

Transforming and cleaning data 

  • Editing Queries 
  • Data Types 
  • Columns – Move, Remove, Rename & Duplicate 
  • Splitting Columns and Extracting Text 
  • Merging Columns 
  • Filtering Rows 
  • Remove Duplicates & Errors 
  • Sorting 
  • Replace & Fill 
  • Transforming Text & Numbers 
  • Transforming Dates 
  • Adding Custom & Index Columns 
  • Adding Custom Calculated Columns 
  • Adding Custom Date & Time Columns 
  • Grouping 
  • Unpivot 
  • Transpose 
  • Duplicating & Referencing Another Query 
  • Add Column From Examples 
  • Reuse and Share Queries 

Data Destination 

  • Loading to the Workbook Options 
  • Loading to the Data Model or Power Pivot 
  • Load Settings & Automatic Refresh 

M Language 

  • Introduction to M 
  • Where to Edit and Write M 
  • Using a Function to add a Custom Column 
  • Reading M 
  • Writing M 
  • Type System 
  • Splitting Text 
  • Conditional Columns 

Parameter Tables & Functions 

  • Parameter Tables for Filtering
  • Dynamic Folder Paths
  • Dynamic File Paths 
  • Manage Parameters 
  • Variables 

 

Klein

Instructor

Duis egestas aliquet maecenas erat eros, fringilla et leo eget, viverpretium. Quisque sed augue tincidunt, posuere dui tempor, dapibus nisi. Donec vel lectus sapien. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Ready to get started?

Get in touch, or create an account

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!