Hi, I'm JEROME GAMELI KOFI DAVOR.
This portfolio is a showcase of my expertise in data analysis, business intelligence, and data-driven decision-making. Here, you’ll find a collection of projects that reflect my ability to extract insights, visualize data, and optimize business processes using tools like SQL, Power BI, Python, and Excel.
Each project demonstrates how I approach real-world business challenges through data cleaning, analysis, and storytelling. I invite you to explore my work and if you have any questions or collaboration ideas, feel free to reach out.
Thanks for visiting - I'm glad you're here!
This project focuses on reducing customer churn in the telecom industry by combining data engineering, business intelligence, and machine learning to deliver a full-scale, data-driven solution. It integrates a robust ETL pipeline in SQL Server, insightful Power BI dashboards, and a predictive Random Forest model to identify at-risk customers and uncover churn patterns. By transforming complex data into clear, actionable insights, the project empowers stakeholders to make smarter decisions and implement targeted retention strategies. Its innovative approach not only enhances customer loyalty but also holds the potential to significantly boost revenue and operational efficiency.
Innova Manufacturing Ltd, a manufacturing company, faced significant challenges in managing supplier quality and performance due to a lack of a centralized procurement system. Without a structured approach to assessing supplier reliability, the company struggled with inconsistent vendor performance, defective materials, and production downtime. Recognizing the need for a data-driven solution, the production management team consolidated supplier and defect-related data across multiple plants. The objective of this project was to analyze supplier quality, identify the key contributors to material defects and downtime, and provide actionable insights to optimize supply chain decisions and improve overall manufacturing efficiency.
The Product Sales and Performance Analysis project aimed to provide actionable insights into sales trends, revenue performance, and sales effectiveness within the product marketing and sales industry. By leveraging Power BI dashboards, the analysis evaluated total revenue, budget alignment, product group performance, sales channels, and salesperson rankings, offering data-driven recommendations to optimize business strategies. This project underscores the power of data-driven insights in shaping marketing and sales strategies, helping businesses maximize revenue potential and enhance overall performance.