Business Intelligence Part 1: Power Query

Course summary
1 day
Next available date: Enquire for more information - Worldwide
Corporate Training for Teams

Course description

Business Intelligence Part 1: Power Query

Power Query (Excel 2010 and Excel 2013) / Get & Transform (Excel 2016) can help you extract, load and transform data automatically, giving you more time to spend analysing and less time preparing reports.

This course shows you how you can design rich and interactive data preparatory tools that take seconds to run, yet look like they have spent weeks in development.

Suitability - Who should attend?

This course is for the Analyst, Manager and Trusted Advisor.

Training Course Content

The Excel feature Power Pivot allows you to manage database-like computational power on your desktop. This is the first of a series of three courses bringing self-service business intelligence to your personal computer.

This course shows you how to create more powerful PivotTable reports, summarise multi-dimensional PivotTables and dissect data to produce detailed information for business reporting and forecasting purposes. Power Pivot takes PivotTables to the next level, allowing you to link data like never before from the comfort of a humble Excel spreadsheet.

Learning outcomes:

  • Confidence in current Excel techniques: SUMIF, SUMIFS, SUMPRODUCT, Tables and PivotTables, and on Key DAX functions:
  • Ability to construct efficient databases for Power Pivot analysis.
  • Confidence in using unlinked tables for sophisticated analysis.

Why choose ICAEW

Training needs consultation service 

 4.8/5 average delegate feedback score

Experienced finance professionals and
highly engaging trainers


ICAEW Member £528 + VAT Non-Member £660+ VAT Community/Faculty Member £462 + VAT

About provider

ICAEW Academy of Professional Development

As a world leader of the accountancy and finance profession, ICAEW’s Academy reflects our commitment to high quality learning and leadership development solutions for all career stages, across a wide range of sectors in practice and business. The extensive portfolio...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Business Intelligence Part 1: Power Query.

  Contact the provider

  Get more information

  Register your interest

Contact info


Chartered Accountants’ Hall
Moorgate Place
EC2R 6EA London

Request information

Find out more about this Business Intelligence Part 1: Power Query course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here