Utilising the
Solution
Seven Miles’ Sales operation was structured as such that they would act as a bulk grinder/processor of high-quality raw coffee. Hence their sales teams consisted of multiple focus-based orientations on customer type and size. However, the organization found it challenging to keep track of budget vs actual sales and how targets were maintained across these multiple teams. Not only were they unable to efficiently and effectively extract the data but they failed to meaningfully visualize it.
POTENZA was integral in creating a dedicated Sales Data Warehouse where logical structuring of sales-related data (actual vs budget data) was effectively done. In addition, bringing these sets of data on top of matured platforms increased the sheer speed of data extraction significantly.
Model Citizen contributed by utilizing the data present in the newly constructed sales data warehouse and visualizing it through Microsoft’s Power Bi Dashboards to provide deep drilled down insights to the relevant business users
Through this innovation, in decisioning insights, we were able to provide sales-related insights to the organization. For example, they were able to clearly see and seamlessly monitor simple KPI’s such as how many Kilos of coffee each team is selling vs how much each sales department should be selling in accordance with the ratio defined by Seven Miles Coffee.




Now the team is looking at the next phase of Data optimization and visualization by focusing on manufacturing and inventory-based data sets as well as looking at creating warehouses specific to them. Certain aspects of financial data would be touched upon in phase 2 as well.