Exploratory Data Analysis - Retail

 

Task : 

• Performing Exploratory Data Analysis on a Retail Company's 'Sample Superstore' dataset.

• The tool used is Tableau.

• Creating different visualizations to analyze the dataset, its trends and statistics and further creating Dashboard to showcase and compare the sales and profit depending on various different aspects.

• Using this insights from the data, creating a Storyboard to showcase the areas for improvement in order to increase the company's Sales and Profit.

Tableau Workbook Link : 

The tableau workbook is uploaded on Tableau Public and below is the link to view the same.

https://public.tableau.com/app/profile/mohit.pundir/viz/SuperStore_16313465526460/Dashboard1

Tableau Dashboard/Storyboard Image : 

Dashboard - Storyboard Video :

Sharing a glimpse of my dashboard / storyboard through a small video to showcase some of the insights drawn from analyzing this dataset.

Insights / Conclusion :

• In terms of Sales, Technology tops the Category list where Phones bags the top position.
• Maximum profit is from Technology Category.
• Despite having good number of Sales, Profit from Furniture is less.
• Ship mode by Standard Class gives more Profit than other modes so we should focus more on Standard Class.
• Central Region Sales is more than South region but the profit from South Region is more than Central Region 
• Maximum Sales and profit is from the West Region.
• Along with profit, losses are also there which we need to address. Losses incurred from 10 States - OREGON, COLORADO, ARIZONA, TEXAS, TENNESSEE, ILLINOIS, OHIO, PENNSYLVANIA, NORTH CAROLINA, FLORIDA.
• Number of products bought are for Consumers.
• Total sales = 2297201
• Total Discount = 1561
• Total Profit = 286397