Sales Performance Dashboard Development

Key Deliverables:

COGS Dashboard:

Analyzed the cost structure with KPIs such as total COGS, income, gross margin, and quantity sold. Used detailed charts to break down COGS by month, gender, payment method, product line, branch, and time of day to identify cost trends and inefficiencies.

Revenue Dashboard:

Created a dynamic tree diagram to drill down into total revenue, segmented by branch, gender, payment method, and product line, allowing for granular insights into revenue drivers.

Profit Dashboard:

Developed a profit analysis dashboard with tree visualizations showing profit margins by store, gender, membership type, and product line, enabling decision-makers to optimize profitability strategies.

Business Impact:

This project empowered the company to make data-driven decisions by providing actionable insights into sales, cost structure, and profitability. It allowed for better understanding of performance across multiple dimensions, facilitating strategic adjustments for growth.