With growing demands and cut$-$throat competition in the market, a Woolworths US

Stores is seeking your knowledge in understanding what works best for them. They

would like to understand which products, regions, categories, and customer segments

they should target or avoid.

Source : $($Maodza$,2023)$

Using the Whoolworths US Store Data Set provided $($Under Week $1$ Resources$)$ use

excel to create graphs $($dashboard$)$ that shows the following focus areas that would

help Woolworths to improve their business. For each of the below provide a

description of the visualization.

$1.$ Sales Analysis

How have sales and profit trends evolved over time $($monthly$,$ yearly$)?$

Which periods experienced high or low sales and profit?

Is there an overall growth or decline in sales and profit?

What is the geographical distribution of sales and profit?

What are the profit margin and loss $(\%)$ by the state?

Which region generates the most sales?

$2.$ Product Analysis:

$(35$ Marks$)$

What is the distribution of sales by product category and sub$-$category?

Which category of products generates the highest revenue and profit?

What are the top$-$selling or most profitable products in the superstore?

$3.$ Customer & Order Analysis

$(35$ Marks $)$

Which customer segment generates the highest sales and profit?

Which customers have made the most purchases in terms of the number of

orders and total sales?

What are the patterns, frequency, and volume of orders?

What is the average order value?

What is the average shipping time for each ship mode?

What are the discount rates by category and sub$-$category?

What is the impact of discounts on sales?

How are discounts distributed $($by percentage or range$)?$