Here’s an overview of the North America Retail Supply Chain & Sales Analysis Dashboard based on the image you provided:
Dataset Link: https://community.tableau.com/s/question/0D58b0000CFiCI1CQN/where-is-most-current-super-store-dataset-using-tableau-public
DAX Codes are here: https://colorstech.net/data-analytics/north-america-retail-supply-chain-sales-analysis-dax-codes-used-in-the-project/
🔹 Overall Metrics (Top Row)
- Sales
- Current Year (CY): 745.57K
- Previous Year (PY): 613.93K
- YoY Growth: 🟢 21.44%
- Profit
- CY Profit: 95.93K
- PY Profit: 82.67K
- YoY Growth: 🟢 16.04%
- Orders
- CY Orders: 1723
- PY Orders: 1340
- YoY Growth: 🟢 28.58%
- Returns
- CY Returned Orders: 105
- PY Returned Orders: 77
- YoY Growth: 🟢 36.36%
📈 Sales & Profit Trend (Year-wise)
- Visualized for the years 2022, 2023, and 2024.
- Both Sales and Profit show a consistent upward trend year-over-year.
🌍 Region-wise Business Overview
| Region | Total Sales | Orders | Total Profit |
|---|---|---|---|
| West | 739,813.61 | 1635 | 110,798.82 |
| East | 691,828.17 | 1475 | 94,883.26 |
| Central | 503,170.67 | 1179 | 39,865.31 |
| South | 391,721.91 | 822 | 46,749.43 |
| Total | 2,326,534.35 | 5111 | 292,296.81 |
🥧 Segment Contribution to Sales
- Corporate: 1.17M (📊 50.32%)
- Consumer: 0.72M (30.77%)
- Home Office: 0.44M (18.92%)
🧾 Sum of Sales by Category
| Category | Sales | Share |
|---|---|---|
| Technology | 0.84M | 20.23% |
| Furniture | 0.75M | 9.12% |
| Office Supplies | 0.73M | 36.20% |
🗺️ Sales by Country/Region (Map View)
- Map visualization highlights sales distribution across Canada and the United States, with the U.S. contributing more significantly (darker shade of blue).
🧭 Filter Toggle
- Country selector: Canada / United States toggle available for comparative analysis.