With growing demands and cutthroat competition in the market, a Superstore Giant is seeking knowledge to understand what works best for them. They would like to understand which products, regions, categories, and customer segments they should target or avoid. They demand a Sales and Profit Dashboard which will help them identify areas where sales and profit are declining.
I have used Mysql for data analysis. I have started with adding additional columns which was necessary for our analysis. Then I started my analysis process.
View my full SQL code on my Github for this project here.
Below are my strategic recommendations for the Superstore's sales manager and marketing team, aimed at significantly enhancing both sales and profit margins::
Prioritize Significant Investments in Technology: Acknowledge the consistent track record of technology in delivering the highest sales and profit margins across product categories. Allocate resources accordingly.
Reallocate Investments Away from Bookcases, Supplies, and Tables: Given the consistent negative profit margins in these product categories, consider redirecting investments to more profitable areas.
Maximize Advertising Campaigns from September to December: Given the substantial surge in sales and profits during this period, intensify advertising campaigns to capitalize on this lucrative growth.
Optimize Regional Performance: Recognize that the West region consistently outperforms others in generating profits. Consider offering enhanced incentives to customers in this region. In contrast, address the losses in several states within the South and East regions through a comprehensive investigation and mitigation strategy to prevent further losses.
