Excel BI Training: Power Query & Power Tools Course

Excel BI Training: Power Query & Power Tools Course

4.78
18 reviews
microsoft-partner
feefo award

Master Excel’s suite of business intelligence tools (Power Query, Power Pivot, Power Maps etc) on this 2-day Excel training course.

This is a hands-on course that includes lots of time to experiment with what you are being taught and ask questions.

By the time you finish, you’ll be a confident Excel Power Query and Power Pivot user.

✔ A complete Excel Power Tools course that covers all Excel BI functions.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ Ongoing support and help with issues you have after the course.

What to expect from our Excel Power Tools course, available at our London centre near Liverpool Street

What Will I Learn?

By the end of this course you will be confidently using Excel’s business intelligence Power Tools to analyse data.

You’ll be very comfortable using Microsoft Excel to:

  • Create a Power Pivot model by importing data from various sources
  • Understand and manage data relationships
  • Create and edit hierarchies
  • Insert calculated columns using Data Analysis Expression (DAX) formulas
  • Insert, modify, and format PivotTables and PivotCharts
  • Create and edit Measures (DAX aggregate functions)
  • Create report dashboards using slicers, timelines and KPIs
  • Use Power View, Power Maps and Power Query tools

Course Details

Download full course details Download full course details

This session covers the core BI concepts, and gets your data into Power Query ready to work with.

  • Understanding what Business Intelligence is
  • How Power Query, Power Pivot & Power BI Desktop fit together
  • Understanding what a query is and how ETL works in practice
  • Importing data from CSV, text and Excel files so it lands cleanly
  • Creating and editing a simple query to see how Power Query works

Raw data never comes in ready to use.

  • Learn how to clean and reshape it – and build queries that always hold up.
  • What is BI – the main concepts
  • What is Power Query, Power Pivot & Power BI Desktop
  • Importing from CSV, text and Excel files
  • Working with other data sources
  • Metadata and file content queries
  • Different data analysis techniques

Power Query gets your data clean – Power Pivot is where you start to analyse it.

  • Understanding what Power Pivot is and how it works
  • Seeing how PivotTables built from a data model are different
  • Bringing Excel tables and data ranged into Power Pivot
  • Identifying key fields and using them to create reliable relationships
  • Setting up hierarchies in your data model so it reflects your data

This session covers how to add calculation that answer real business questions.

Then we show how to present those answers clearly – in Excel and Power BI.

  • Understanding the two types of calculation in Power Pivot
  • Creating calculated columns to add row-level data
  • Setting up a date table to use time intelligence functions
  • Applying dashboard and report principles
  • Creating and formatting Power Pivot charts

Online Training Requirements

To attend this Excel course online, you will need:

✔ MS Excel on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.