__STYLES__
The dashboard is available for viewing here.
The dataset for this project consisted of transaction records from 3 "Maven Roasters" franchises. The data was clean but needed to be prepped for analysis. I added:
I created several pivot tables and charts to better understand the data. These were assembled into a dashboard with a few individual KPIs to make the data more easily scannable. The charts and KPIs were tied together on the dashboard with a slicer so that each of 3 franchise owners could dig into the information for their store.
Findings:
Unfortunately this data set didn't include cost information, so the profitability of the products and categories couldn't be considered in this analysis.