Introduction to Microsoft Power Pivot (1 day)

Microsoft Power Pivot is a must-have tool for anyone who needs to analyse data from multiple sources and of multiple types. Power Pivot is a free add-in for Microsoft Excel* – it allows users to connect to and analyse data from a wide variety of sources, such as; Excel workbook / worksheet, Access database, SQL, SSAS and more. Power Pivot significantly extends the functionality of the standard Excel Pivot table. Once the data source(s) is connected to Power Pivot, users can build simple or more complex data models for analysis purposes. Because Power Pivot is built directly into the Excel platform, most users feel comfortable with it from day one as its interface closely aligns with the Excel look and feel.

During this 1 day training course you will learn:

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.
The difference between Excel and Power Pivot as a data analysis tool.
The basic principles of data modelling.
How to create basic ‘measures’ and ‘calculated columns'.
How to use some of the most common DAX functions to extend the power of the Power Pivot data model.

Chris Bond
March 06,2015 / 0 Comments
We all picked up some new core skills as well as having the the opportunity to ask specific questions relevant to our daily jobs. This has led to some of the team finding more efficient ways to get through their daily workload.
Tony Miles
March 06,2015 / 0 Comments
The main impact of this is that income has been dragged forward some 4 months increasing profits in the first year of purchase many times covering the cost of the software.
Marie Lewis
March 06,2015 / 0 Comments
Ben’s commitment to their learning meant he stayed around to answerquestions and give additional training where it was needed
Layla Young
March 06,2015 / 0 Comments
Never before have I received such consistently positive and up-beat feedback questionnaires, than from the Excel training delivered by Woodthorpe IT; positive comments not only about the content and the format, but the friendly, supportive and tolerant manner in which is was delivered.
Joseph Orwin
March 06,2015 / 0 Comments
Ed went that extra mile and even stayed behind at the end of the course to cover additional items which weren’t included on the original agenda. Highly recommended and a pleasure to work with.
Cheryl Smart
March 06,2015 / 0 Comments
I would recommend Ben to anyone wanting to develop their own customer led software and requiring staff IT training.
Emma Meadowcroft
March 06,2015 / 0 Comments
Ben was very patient and even stayed behind for certain items that weren't on our original tailored agenda.
Lauren Mann
March 06,2015 / 0 Comments
Everyone loved the little tips you included within the training, your friendly manner and the attention you gave each of our group.
David Garnsworthy
March 06,2015 / 0 Comments
Ben also had numerous time saving tips and advice about potential pitfalls. Ben was very conscientious in his approach and at all times was willing and open to provide help with anything the course attendees did not understand.
De Beers
March 06,2015 / 0 Comments
The feedback from the delegates was very positive, they felt the training was relevant, easy to pick up and understand.
Julie Shipley
March 06,2015 / 0 Comments
From the time i emailed you with an enquiry the service has been 'second to none'. I particularly like the way you tailored the training for our individual needs
March 06,2015 / 0 Comments
The feedback from all our employees has been complimentary and I would certainly not hesitate to recommend that any company looking to improve their IT skills employ Woodthorpe IT Solutions.