Pinturas AYA - Consulting Project
Increased sales by 23%.
Segmented clients based on their value and built several B.I. tools that enabled the company to increase sales by 23% and improve customer satisfaction.
Performed an EDA, cleaned the data, segmented customers based on an RFM analysis, built two interactive dashboards and a series of Machine Learning models to forecast sales and product demand. All followed by a clear strategy and a a number of recommendations.
Results
23%
Increased Sales
2
High Executives Trained on B.I. Tools
3X
More sales to Loyalist Client Segment
Goals
While the goal is constantly keep growing, a major panamanian-venezuelan paint company was looking to take advantage of their data to increase sales and customer satisfaction by personalizing their offer and communications. The company was ready to invest significantly on a data strategy, BI and technological solutions to maintain their competitive advantage in the market.
This Data Science and Business Intelligence project for Pinturas AYA Panama has 3 main objectives.
First, performed an analysis of the data (EDA and RFM) of AYA Painting orders in 2021 and identify the bottleneck in the sales process, to have a better understanding of the dataset, find insights, identify business opportunities, segment customers based on their added value, increase the quality of the data when processing them, and more. Second, to develop an Interactive Dashboard of AYA Painting orders in Panama and Venezuela with key information that allows management to make better informed decisions on a day-to-day basis. Finally, I propose a series of technical recommendations to be taken into account by management for future implementation and delivered a Machine Learning model to help the company forecast sales and demand.
Dashboard for Panamanian Orders in 2021
Dashboard for Panamanian Orders in 2021, with 1 filter:
Deliverables
Consulting Reports. Composed by a:
- EDA and RFM analysis
- Instructions for using the dashboards
- Predictive models to forecast demand and sales to
- Recommendations to achieve goals based on our findings.
2
Interactive Dashboards in Tableau
2