Sales and Reviews Tracker

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:

I created the Sales and Reviews Tracker, an analytical solution designed to provide a clear and comprehensive view of business performance. The report is divided into three pages, each serving a specific purpose:

1. Sales Analysis
   The first page focuses on analyzing sales by product, category, and individual items. It provides detailed insights into buyer demographics, segmented by gender, age, and whether purchases were domestic or international. Key metrics are highlighted through summary cards, showing total sales and performance for the last 30, 60, 90, and 120 days based on selected variables.
2. Category Performance
   The second page tracks the performance of the three main product categories: Clothing, Ornaments, and Other. It includes a dynamic table displaying the last five sales dates or an option to view all available sales data, allowing users to dive deeper into trends and patterns.
3. Customer Sentiment and Ratings
   The third page focuses on analyzing customer feedback, sentiment, and product ratings from reviews. This section offers insights into customer satisfaction and how reviews impact overall sales performance.

The Sales and Reviews Tracker provides a user-friendly and data-driven approach to understanding sales trends, evaluating product performance, and improving customer satisfaction.