Data Analysis and Power Query

Data Analysis and Power Query


Power Query is a tool used to manipulate data and is commonly used data analysis and business intelligence. Power Query is available in bo Microsoft Excel and Microsoft Power BI. High-quality analysis relies on well organized data that is free from er and that draws data from a single source of truth. Whilst many analys spend hours of time manipulating data, combining data, and performi look ups, Power Query allows all of these steps to be automated with simple, repeatable steps. Power Query is one of the most transformative tools available to any analyst working with data in Excel. Not only will it save analysts hours time, but it will result in reduced manual errors and a better ability to source data from a single source of truth.

The course covers the following key topics:


Importing Data from Text Files

Importing Data from CSV

Import Data from External Excel Workbook

Import Data from Current Excel Workbook

Append Excel Tables in the Same Workbook

Merge Different Tables or Queries

Append Tables from Different Workbooks into One Table

Combine Excel files from a Folder

Get a List of File Names from a Folder

Split Columns

Merge Columns

Filter Data

Sort Data

Replace Values

Fill Down Transpose Data

Group Data

Unpivot Data

Using Locale to Manage Dates

Column Operations

Adding Date and Time Columns

Transform Text with Extract Options

Adding an Index Column



After attending this course attendees should: 

Users of Microsoft Excel who want to manage and report their data more quickly.

Users of Microsoft Excel who want to understand the most popular Excel tool since PivotTables were released.


  • > Established sales people who would like to improve their success rate 
  • > Administrators moving into a more sales- focused role 
  • > Service specialists who need to cross- sell and up-sell to increase company profits 
  • > Any person who interacts with customers and has the potential to influence sales 
  • > Recent graduates entering the business world


Choose your preferred training type/method of delivery below.


We come to you!


Flexible Training: No minimum delegates. Your Date. Your Duration. Face to Face or Online.