Duration:½ day
Standard:Intermediate
Prerequisites:none

This hands-on session demonstrates the use of the Business Intelligence (BI) tools built into recent versions of Excel. Including, Power Query to import data, prepare and transform data for analysis in PowerPivot tables in Excel, making use of and introducing the Data Model. The data is then used to prepare a simple dashboard with 3D Map view.

For true mastery of these tools, we would recommend out Power BI Series, but this will give management and accounting staff new to this area a grasp of the new functionality and power available.