To be able to import, tidy up, transform data and output a workable clean dataset for analysing.
On completion of this course, attendees will be able to state what Power Query is, identify where in the data analysis process Power Query sits, import data from various sources, restructure and transform data ready for output, load data to a Table Query, create a Connection only and add to the Data Model
Attendees should be proficient in writing formulae and Excel functions.
Training can be delivered at your offices in either of the following ways:
Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.
Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.
Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.
All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.
Short on time, but still want to boost staff performance?
Book a Sprint Session!
Each Sprint Session follows a 90-minute format for ultra-focused team learning.
Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.