Introduction to Power Query
13th November 2014 - 1 day course
Who is it for?
This course is aimed at Excel users and BI professionals who want to learn how to use Power Query to load data into Excel and use it with Power Pivot and the rest of the Power BI stack
What you will learn
The following topics will be covered on the course:
- Understanding where Power Query fits in with the rest of the Power BI stack
- Extracting data with Power Query: relational databases, text files, OData feeds and more
- Creating Power Query transformations in the user interface
- Loading data to Excel tables and the Excel Data Model/Power Pivot
- Writing expressions and queries in M
- Working with multiple queries and data sources, and understanding data privacy settings
- Sharing queries via the Power BI Data Catalog
The course will include practical exercises, and for attendees to take part they must bring a laptop with Excel 2013 and Power Query installed.
This course will teach you how you can use Power Query to load data into Excel when building a self-service BI solution, and what advantages it offers over traditional methods of data loading.Cost: £249 (until August 31 2014), £299 (from September 1st 2014) +VAT
Chris Webb is the owner of Crossjoin Consulting, and is a consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", and blogs at http://blog.crossjoin.co.uk/
116-120 Goswell Road
Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.
In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.
Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.