Automated Nick’s Cookie Sales Analysis Dashboard
Table of contents
Business Problem
Nick has an online cookie shop which recently has grown to attract customers from different countries. All the customer, and sales data is available in the database.
To remain competitive in a fast-phased industry of cookie sale Nick wanted to:
- Enhance efficiency by understanding customer preferences and experience
- Identify the profitable cookies
- Track the daily units sold in an automated manner
While the problem requires deep analytical mind to lead to timely and insightful financial reporting of financial metrics, the solution ought to be cost effective. The goal is to automate the profit dashboard with accurate data, meaningful analysis and interactive charts which leads to business improvement, operational efficiency and cost reduction.
Approach
As a self-starter, I independently understood the problem statement, identified data sources, plan project scope, and design the analysis process. I came up with the appropriate tools to achieve the business objective. Experience in SQL for data extraction from the database then creation of ETL pipelines to analytics software was the most cost-effective approach. The utilization of automated Excel dashboards helped in developing scalable and efficient processes to support operations. The problem required advanced skills in excel with advanced problem solving, modelling and reporting skills. The final solution could help to derive insights for organizational profitability.
Solution
The final product was a commercially successful automated Excel dashboard which answered multiple business questions in an economical manner. The solution delivered real value for the identified market segment because Nicholas could identify the best markets to concentrate on and the best customers to give discounts on purchase. Additionally, he could refine customer value proposition and competitive positioning for his cookies. The developed solution helped the company to become more profitable by reduced costs, increased revenues and improved organizational efficiency. You can Interact with the Solution through this Link.