Excel 2010 Dashboard

This dashboard was created to see if price changes for items had any impact on their consumption. It shows the change in item per cap so it can be compared to the change in price to see if there was an impact in revenue. The 2 charts on the right remain static so the drilldowns can be compared to overall performance to determine if there is an outlier when exploring the data. The slicers allow the user to drill down to as much detail as they wish to explore.

The data was gathered directly from the point of sale system SQL database. Using Advanced VBA, the data is processed into pivot tables and charts that will update automatically as the desidred slicers are applied. There is also an option for the user to refresh the data if newer information is required.

As this was created in Excel 2010 and the organization had yet to adopt Power Query, using that tool was not available and the manual method via VBA was developed.