Excel Training

PowerPivot / Excel Power BI (2 days)

£650 + VAT for most venues (£750 + VAT for London)

Excel can do so much more than simple pivot tables!  This two-day course will show you how to:

• create simple, elegant data models in PowerPivot;
• use these data models to create pivot tables based on multiple tables;
• use queries to build queries to extract, transform and load data (this used to be called Power Query, but is now integrated in Excel);
• start to use the DAX language for more in-depth analysis of data;
• analyse time series data ("compare this month's sales with the same period in the previous quarter");
• create hierarchies, and display them in pivot tables;
• create and display KPIs in Excel;
• understand what Power BI Desktop is, and how it is the same in many ways as PowerPivot / Power Query;
• create visualisations in Power BI Desktop (tables, charts and matrices);
• understand how to publish Power BI Desktop reports to the cloud, and pin tiles to dashboards.

Note that you'll need to be using Excel 2016 (or 2013) Professional Plus or Office 365 ProPlus to be able to use the Power BI (Power Business Intelligence) features within Excel.