Data Analysis and Power Query

COURSE OVERVIEW

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, Data Analysis and 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

…AND MUCH MORE!

OUTCOMES

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.

WHO SHOULD ATTEND

• > 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