Woodthorpe IT Solutions Ltd

powerpivot_01

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

 


 

North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

×
IFA Practice Manager

No flash installed

×
Production Scheduling Tool

No flash installed

×
Format As Table Part 1

No flash installed

×
Format as a table part 2

No flash installed

×
Subtotalling a list

No flash installed

×
Sorting basics

No flash installed

×
Cell Styles

No flash installed

×
Remove Duplicates In List

No flash installed

×