Global Store Sales Analysis Dashbaord

Overview

This Sales dashboard offers a detailed analysis of a Global Super Store Sales, emphasizing critical elements such as sales trends, product performance, key customer insights. It displays crucial metrics like YTD Sales, YTD Profit, CAGR, YoY Growth, Top and Bottom Performing Products sub-category . Additionally, the dashboard highlights revenue patterns categorized by region, market, customer, states.

The objective of the dashboard is to furnish the store with valuable insights and information drawn from the sales data. The dashboard aims to assist the business in the following ways:

• Identification of Sales Trends: The dashboard enables the store to monitor the evolution of sales patterns over time, examining them based on State, Sub-Category, and product. This insight aids in discerning high-performing areas and areas that may require enhancements. • Optimizing product performance: By highlighting the top-performing sub-category, the dashboard enables businesses to focus their efforts on those sub-categories that generate the most revenue. This information can guide decisions related to inventory management, marketing campaigns, and product development. • Focusing on Key Customers: Utilizing the dashboard to pinpoint top customers assists businesses in acknowledging their most valuable clientele. This understanding can be leveraged to offer personalized incentives, elevate customer satisfaction, and cultivate enduring relationships, ultimately fostering customer loyalty and retention. • Evaluating performance against previous years: The capability to compare the current year's performance against the preceding year offers businesses a benchmark for gauging their advancement. This comparative analysis aids in pinpointing areas for improvement, comprehending growth rates, and establishing achievable goals.

In general, the dashboard enables the store to base their decisions on data, refine strategies, and enhance overall performance in aspects like sales, customer satisfaction, and profitability.

Problem:

• What are the YTD Sales and Profit for the year 2015? • What is the Sales Growth? • Which are the Most and least Profit Generating Sub-Category? • Who is the most valuable customer for the store?

Findings:

• YTD sales for the Year 2015 is $4.3M and YTD profit for the year is $504.17K. • YoY Sales growth is 26% for the current year and Compound Annual Growth Rate (CAGR) is 23.92%. • Most profit generating sub-category is Copiers (Profit:$260K) and Least profit generating sub-category is Tables (Loss:$64K). • Tom Ashbrook is the most Revenue earning customer over the years (accounting for $41K revenue).

Summary:

• While the overall sales performance has been good for the year 2015 (26% YoY), if we compare to the year-over-year sales growth of 2014 (27%), sales growth have been decreased by 1 percentage points. • Close inspection is required to find out the reason behind the poor performance of some sub-category (such as Tables).