PowerPivot - Excel Power Business Intelligence

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 Power Query to build queries to extract, transform and load data; 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 and display KPIs in Excel; create Power View reports within Excel based on your data models; and create and show Power Maps (including making videos of trends over time).