Skip to main content

SALES DASHBOARD TABLEAU

In this project, the objective is to analyze from the dataset sample of Sales #RWFD
Sales Dashboard

##TABLEAU DASHBOARD

CONCLUSIONS

1. Overall Sales Performance (2023)

  • Total Sales: $733K, which is a 20.36% increase compared to the previous year (PY).

  • Total Profit: $93K, a 14.24% growth vs. PY, indicating improved profitability but at a slower pace than sales growth.

  • Total Quantity Sold: 12K units, a significant 26.83% increase vs. PY, suggesting strong demand.

  • Sales and profit trends show consistent growth throughout the year, with noticeable peaks in certain months.

  • Profitability aligns with sales trends but dips in some months, which might indicate increased costs or lower margins during those periods.

3. Sales & Profit by Subcategory

  • High-performing categories: Phones, Chairs, and Binders are top contributors in both sales and profit.

  • Underperforming categories: Accessories and Tables show losses (highlighted in red), which could indicate high costs, pricing issues, or low demand.

  • Certain subcategories, such as Machines and Appliances, show moderate but consistent profit margins.

  • Weekly sales fluctuate around an average of $14K, with significant spikes likely during promotions or high-demand periods.

  • Weekly profit averages around $2K, with occasional dips into losses, indicating some inefficiencies or high expenses during certain weeks.

5. Opportunities for Improvement

  • Address underperforming subcategories (e.g., Accessories and Tables) by optimizing costs, reviewing pricing strategies, or focusing on higher-demand items.

  • Analyze weeks with significant profit dips to identify inefficiencies or cost-related issues.

6. Strengths

  • Strong year-over-year growth in sales and quantity sold highlights effective marketing and sales strategies.

  • Top-performing subcategories are driving profitability and can be further leveraged for growth.