Building A Reporting Solution Using Power Query

Power Query is a desktop ETL tool, right? Well, yes - but it's a lot more than that. In fact you can use Power Query to build an impressive Excel-based reporting solution without going near Power Pivot, and in some cases this approach can be better than using Power Pivot. In this session you'll learn how to:

• Connect to multiple data sources and combine data from them in Power Query
• Create parameterised queries in Power Query, and pass parameters to them from your Excel worksheet
• Build a Reporting Services-like user interface for your reports in Excel
• Ensure that your reports work in Excel Services as well as on the desktop
• Make sure that you get the best possible performance in Power Query using query folding
• Learn when to load data to the Excel Data Model/Power Pivot, and when not to