This course will introduce delegates to Microsoft’s ever evolving Business Intelligence products. Delegates will learn about PowerPivot which was first introduced in Office 2010 for developing business intelligence models based on multiple data sources. Delegates will also explore Power Query, a tool that is used to transform data and is often used with PowerPivot. This is followed by a module on Power View, a very easy to use dashboarding tool that allows self-service business intelligence. Finally, delegates will learn to use Microsoft’s stand-alone Power BI application which allows users to import data and create dynamic dashboards and visual reports in seconds.
* Delegates must have access to Excel 2010 and 2013 for PowerPivot, 2013 or 2016 for Power View and Power Query, and will need to have downloaded Power BI to their desktops.
This course is suitable to intermediate to advanced users of Excel that are looking to utilise the Microsoft business intelligence products and keep their Excel skills up to date. The content is an ideal introduction for individuals that spend time analysing and reporting on data using Excel.