Projects
Business Growth Strategy
This Sales & Profit Dashboard provides a comprehensive view of business performance, highlighting key metrics across sales, profitability, customer contribution, and product categories. The business achieved $1.93 million in total sales and generated $247,961 in profit, demonstrating strong financial performance and operational efficiency. The dashboard also identifies the company's most profitable customers, emphasizing the importance of customer retention and relationship management in sustaining business growth. Customer distribution remained relatively balanced across the years, indicating stable customer acquisition and engagement. Overall, the dashboard serves as a powerful decision-making tool, enabling stakeholders and executives to quickly assess business health, identify growth opportunities, monitor performance trends, and develop strategies that drive profitability and long-term success.
Retail Dashboard
The Coca-Cola Retail Dashboard highlights strong business performance, with $12.02 million in total sales, 24.79 million units sold, and $4.72 million in operating profit. The data shows significant growth in 2023 compared to 2022, reflecting increased consumer demand and effective market expansion strategies. Among the beverage brands, Coca-Cola, Dasani Water, and Sprite emerged as the strongest contributors to sales growth, while key retail partners such as West Soda, BevCo, and FizzyCo played a major role in driving revenue. Quarterly analysis indicates that Q3 recorded the highest sales performance, demonstrating a period of peak demand and profitability. Overall, the dashboard provides valuable insights into sales trends, brand performance, retailer contributions, and profitability, enabling business leaders to make informed decisions that support growth.
HR Data Dashboard
The organization has a strong and youthful talent base, but a 16.3% attrition rate—primarily affecting Administration, Sales, Operations, and early-tenure employees—poses a risk to productivity and growth. Targeted retention, career development, and employee engagement initiatives should be prioritized to reduce turnover and strengthen workforce stability.