Slides and Materials for PASS BA 2016 Conference

Posted by on May 16, 2016 in Power BI, Power Query, Presentations | One Comment


I have to first and foremost thanks to all attendees to my session at PASS Business Analytics 2016 conference, It was pleasure to have you all. Some of you mentioned that you are already using some contents from my blog which is great, and I’m humbled to hear this. I’ll definitly do more effort to put contents more regularly on my blog.

Session Title: Data Preparation is the Keystone

Session Description

Prepare to be amazed with what you can achieve using Power Query in this demo-heavy session. Power Query is the data extraction, transformation, and mash up tool. It can be accessed through Excel or from Power BI Desktop. There are numerous data transformation features that can be used to solve real-world data preparation challenges.

We will use customer case studies to go through scenarios of preparing data for modelling, and visualization. You will learn how to use features of Power Query such as generators, custom functions, and lots of built-in functions to solve those scenarios. You will also learn some data preparation techniques through Excel itself.

Slides to download


Codes and Examples

I’ve showed you some examples of using Power Query, and here I have explained them all one-by-one through walkthrough, so read below posts to learn exactly how to build those;



Don’t hesitate to ask me any question here. I’ll be more than happy to answer.

Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *