Challenge
A dashboard was required that would optimally and quickly synthesize the main indicators that were reviewed in the weekly meeting with the sales team and their manager.
Solution
The main data sources were reviewed, a data extraction and mining process was carried out. With which it was possible to synthesize the most relevant indicators for the manager.
Result
With the available information, relevant KPIs and measures that can help evaluate and meet monthly goals were suggested to the manager.
The web sales report was divided into two parts, the first to show the current status and the second, to individually evaluate the KPIs of the sales team.
For reasons of company confidentiality, the data, brand and logos of this dashboard were modified, only used for information purposes.
Technology used to build the dashboard: Pandas & Numpy Python Librarys & Google Looker Studio
Interactive dashboard: https://lookerstudio.google.com/s/j0eEMyt253E