Overview:

Pivot Tables have been a feature of Excel for many years, now we'll show you how to use PowerPivot to simplify the process of getting the data into the "right shape" to pivot, as well as harnessing the power of DAX to gain deeper insights into you data.

If you spend a lot of time manipulating data in Excel in order to build a Pivot Table, including things like Lookup functions to mash data together, performance calculations, or time dependent calculations, then PowerPivot and DAX measures can help streamline the process. Simple reusable measures in Power Pivot can help gain extra insights into your data, which you can then output to a familiar Pivot Table report or dashboard.

Join Chris Harvey will guide you through an in-depth and hands-on session on how to best make use of your data. 

Agenda

  • What is Power Pivot and how can I get it?
  • Connect to multiple data sources and create relationships using the Model
  • Create refreshable connections to external data
  • Create a Pivot Table using data in the Model
  • Analyse data in the Pivot Table using DAX measures
  • Add a KPI (RAG report) to a Pivot Table

Target audience

Anyone currently using Pivot Tables to create reports in Excel and want to take advantage of the additional functionality available in PowerPivot. 

The speaker

Chris Harvey, QA’s Senior Learning Technical Specialist, is specialised in Office 365 adoption projects and supporting organisations with there digital transformation programme.

OneQA_Microsoft_Gold_Partner_Vert

Please enter details below to access the webinar recording.