CONTEXT:

Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales.He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this. The data was stored in an excel sheet.

SKILLS: Python (Numpy, Pandas), Tableau

OVERVIEW:

Performed exploratory data analysis for the sales of Value INC. using Python. Once that was done I created a dashboard using tableau to show the markup percentage, profits by county, client type, client age and costs. It is also an interactive dashboard, so that the stakeholders can filter to what all they want to summarize.

CONCLUSION:

The company is 15.01% below its average markup percentage of 60%. It would be a good marketing strategy to target "adults", "middle aged" and "solo bussinesses" in the months of January and February to boost revenue. Thus far, most of the company's revenue comes from "seniors" and "big bussiness" clients. The item "465780" and item "470883" are two of the highest revenue generating items.

Link to the Tableau Dashboard: https://public.tableau.com/app/profile/viraj2824/viz/ValueINC_SalesAnalysis/Dashboard1

Link to Python Script: https://github.com/Viraj015/Value-INC-Sales-Analysis