Introduction to using DAX & Power Pivot (2 days)

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. At the heart of Power Pivot is a functional language called DAX (Data Analysis Expression). DAX allows users to create basic and more complex expressions that manipulate the data held within the data model. The DAX syntax closely aligns with Excel’s functional language so Excel users normally find the transition to DAX less daunting.

During this 2 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, filter and row context
How to create basic ‘measures’ and ‘calculated columns’ and use these 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

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.