Introduction to Microsoft Power Query (1 day)

Microsoft Power Query is a must-have tool for anyone who works with data as part of their job function. Power Query is a free add-in for Microsoft Excel* – it allows users to connect to a wide variety of data sources, such as; Excel workbook / worksheet, Access database, SQL, SSAS and many more. Having connected to the data source(s), Power Query allows users to manipulate, standardise and blend data for ease of analysis in other applications such as MS Excel, MS Power BI and MS SSAS and others.

During this 1 day training course you will learn:

About Power Query’s most popular built-in data transformation tools.
How to connect Power Query to a range of data sources; Excel, CSV & Access.
How to re-shape report data into rows and columns in preparation for analysis.
How to blend data from multiple sources into a single data stream.
How to refresh data when connecting to differing data sources.

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.