__STYLES__
The goal of this project was to develop an interactive dashboard that enables sales managers to track their team's quarterly performance.
My approach was to calculate the measures and get insights in the following dimensions:
The data consists of a fact table with sales data and three dimensions tables with customer accounts, product and sales team data. Additionally I added a calendar table for the needed measures on the quarterly performances.
Essentially the whole data model revolves around these measures and they are applied to the above mentioned dimensions on a quarterly timeline basis: