Comprehensive Sales Performance Dashboard

Summary

Report submitted for Onyx Data DataDNA ZoomCharts Mini Challenge, January 2025. The report is based on the Merchandise Sales dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI.

Author's description:

The Comprehensive Sales Performance Dashboard file includes three interconnected dashboards, offering a detailed analysis of sales performance, customer behavior, and product trends. Each dashboard provides unique insights to guide decision-making.

The Sales Overview Dashboard delivers a high-level analysis of monthly performance. January experienced slight declines in orders (-6.9%) and quantity sold (-0.6%) compared to December, with minimal revenue impact (-0.1%). Shipping charges also fell slightly (-0.7%). Notable underperforming products (e.g., BFH56, BFH53, BFH55) contributed to 7.78% of total orders. Additionally, customer ratings played a significant role in international shipping, with 33.38% of orders receiving 5-star ratings.

The Customer and Geographic Analysis Dashboard focuses on customer demographics and geographic distribution. It breaks down orders by gender and product category, offering insights into buyer preferences. Top locations by orders and revenues, segmented by age and gender, provide valuable context for identifying key customer segments and regions that drive sales.

The Revenue Trends and Product Performance Dashboard tracks revenue patterns and product performance over time. Monthly revenue trends reveal notable fluctuations, including significant declines in June (-24.62%). Quarterly and yearly breakdowns highlight seasonal patterns, while weekday earning trends and top-performing products provide actionable insights for inventory management and marketing strategies.

Key takeaways across the dashboards include:

• Sales Performance: Stable revenue despite a slight drop in January orders and quantity sold, suggesting room to improve order volume.
• Product Insights: Identifying underperforming products and highly rated items impacting international shipping offers opportunities for strategic adjustments.
• Customer Behavior: Demographic and geographic insights help refine marketing efforts to target key customer segments.
• Revenue Trends: Seasonal fluctuations and product trends provide critical data for optimizing revenue strategies.

This file equips sales managers and strategists with the tools needed to make informed, data-driven decisions and improve overall sales performance.