Introduction

In this course you'll learn how to build Dynamic Excel Dashboards for data analytics quickly and easily using Power Query and Pivot Tables no VBA required. Power Query can be used to replace complex VBA scripts and enables your Dynamic Excel Dashboards to automatically refresh. You'll learn how you can get and transform data using power query and how power query can be used to prepare and aggregate your data for use with the new Excel 2016 data visualizations. We'll look at how Excel data visualizations compare with tools such as Power BI. The course will also cover driver based models using what if analysis. When building driver based models we need to evaluate if calculation should be placed within power query or within Excel Formulas. Power Query is a free add in for Excel 2010 and Excel 2013. Power Query has been renamed to Get and Transform in Excel 2016 and is now built in.