TMall Order Analysis & Market Strategy Dashboards
This project delivers a comprehensive analysis of TMall order data, aiming to uncover sales performance trends, refund patterns, and regional market behavior. The interactive Tableau dashboard supports strategic decision-making by visualizing order dynamics over time, geography, and customer outcomes.
Description
Time-Based Sales Trends & Regional Market Performance
-
Daily & Hourly Order Volume: Line charts display fluctuations in total and paid orders across both days and hours. Peaks are clearly observed near the end of the month and during midday hours, suggesting key promotional or behavioral patterns.
-
Order Patterns Over Time: Helps identify optimal campaign timing and customer engagement periods.
-
Geographical Sales Distribution:
-
Guangdong, Jiangsu, and Zhejiang dominate in both total and paid orders.
-
Overlaid trends help visualize transaction consistency across provinces.
-
Order Breakdown & Refund Insights
-
Order Summary KPIs: Displays total, paid, successful, and refunded order counts, providing a snapshot of the transaction lifecycle.
-
Refund Segmentation:
-
Visual scatterplots compare paid orders against partial and full refund rates.
-
Orders are segmented into strategic quadrants (e.g., "High Deal, High Refund") to highlight risk or opportunity areas.
-
-
Regional Refund Analysis:
-
Bar charts show which regions have higher rates of partial or full refunds, with Shandong and Shanghai leading in full refunds, while Zhejiang and Shanghai lead in partials.
-
Useful for evaluating regional product satisfaction or logistics issues.
-
Tools & Techniques
-
Tableau for dashboard design and interaction
-
Multi-metric scatterplots for segmentation analysis
-
Time-series visualizations for behavioral trend detection
-
Bar charts and geolocation analytics for regional comparisons