Setup Menus in Admin Panel

Woodthorpe IT Solutions Ltd


Advanced Microsoft Power Query & Power Pivot (2 days)

If you need to connect to multiple data sources of various types and then analyse the results, then Microsoft Power Query and Power Pivot are the tools of choice.

Power Query and Power Pivot are free add-ins for Microsoft Excel – they significantly extend the functionality of Excel. With these tools you are able to connect to a wide variety of data sources, such as; Excel workbook / worksheet, Access database, SQL, SSAS and more. Once the data source(s) is connected to Power Pivot, users can build simple or more complex data models for analysis purposes. Because Power Query and Power Pivot are built directly into the Excel platform, most users feel comfortable with them from day one as their interfaces both closely align with Excel’s look and feel. 

During this 2 day training course you will learn:

  • About Power Query’s most popular built-in data transformation tools and its relationship with Power Pivot
  • How to connect Power Query to a range of data sources; Excel, CSV & Access
  • How to blend data from multiple sources into a single data stream for analysis
  • How to load data from Power Query directly into Power Pivot
  • How to load data directly into Power Pivot from other sources; Excel, CSV, Access and others
  • How to create a range of ‘measures’ and ‘calculated columns’ to manipulate data in the data model
  • How to use some of the most common DAX functions to extend the power of the Power Pivot data model



© Woodthorpe IT Solutions Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.