Project Date : Jan 2022
Walmart Sales Analysis
Uncovering regional performance & profitability trends
This dashboard analyzes Walmart’s sales data to identify which states, product categories, and time periods yield the highest profits.
By exploring patterns in average sales, discounts, and quarterly performance, this analysis helps pinpoint where Walmart should focus to maximize revenue and optimize operations.
The Report will help to gain insights into Walmart's product sales and profitability trends and identify areas of growth and potential opportunities for improvement.
full dashboard LINK( https://github.com/ilaki-prog/Tableau-dashboard)
Based on the given data, Walmart's average sales are $1775.88, which indicates a decent sales performance. The average profit earned per sale is $181.18, suggesting that the company is generating a healthy margin. However, Walmart's average discount is relatively low at $0.05, which could mean that the company is not focusing on aggressive pricing strategies to boost sales. Overall, the data suggests that Walmart is performing well in terms of sales and profitability, but there may be room for improvement in terms of pricing strategies.
The given data, copiers and fax machines have the highest average profit of $1924, indicating that this product category is a significant contributor to the company's overall profitability. Appliances and office machines are the next highest-profit categories, with average profits of $244 and $913, respectively.
Chairs and chairmates have an average profit of $388, which is also relatively high. However, bookcases have negative average profit at -$178, indicating that the company may need to reconsider its pricing and marketing strategies for this category.
Other categories such as telephones, tables, and binders and binders also have relatively high average profits, suggesting that these product categories are performing well. However, categories such as scissors and rulers, storage and organization, and pens and art supplies have low average profits, indicating that the company may need to focus on increasing sales or reducing costs in these areas to improve profitability.
Overall, the data suggests that Walmart should focus on maximizing profits from high-performing categories, such as copiers and fax machines, and appliances, while considering improving or re-evaluating pricing and marketing strategies for categories with lower profitability, such as bookcases and scissors and rulers.
According to the given data, South Dakota has the highest average profit of $706, indicating that this state is a top performer in terms of profitability. Louisiana follows closely with an average profit of $436, while New Mexico comes in third with $289.
Oregon and Washington have average profits of $269 and $175, respectively, which suggest that they are performing relatively well. Florida and South Carolina have average profits of $174 and $184, respectively, which are lower than the national average but still above the lowest-performing state.
Montana has the lowest average profit, suggesting that this state may need more attention from the company in terms of marketing, pricing, or supply chain strategies. Overall, the data suggests that Walmart should focus on maximizing profitability in the highest-performing states and consider implementing strategies to improve profits in lower-performing states.
The above chart represents the regional wise quarterly average profits. for the following years of 2012, 2013, 2014, 2015 respectviley.
south has performed well for the following 4 years. then followed by central region, and then east, lastly west.