To Support me: https://ko-fi.com/kamireddymahendra
Exploratory Data-Analysis-using SQL, Python libraries and MS-Excel to extract insghts with visual reports by preparing dash board.
problems to be solved by the analyst for the business requirements by the client to make profit of vrind store.
- Compare the sales and orders using single chart.
- Which month got the highest sales and orders.
- Who purchased more, men or women in 2022.
- What are different order status in 2022.
- List top 10 states contributing to the sales.
- Relation between age and gender based on number of orders.
- Which channel is contributing to maximum sales.
- Highest selling category.
Proceedings: Step1: As a data analyst i asked many questions regarding the business and what are the problems facing by the business stakeholders and many more.
Step 2: Starts prepared mind map of business accumen by my self as a data analyst to make my work easy.
Step 3: Gathered the data which was provided by the stakeholders.
Step 4: Cleaned the data according to the requirement by understanding the problems from the stakeholders and found that which fields are not useful and if there is any missing values i just removed them to make easy of work.
step 5: Then i started analysing the data and added few new columns wherever is needed, depending on the problems given by the stakeholders to solve them with some calculations and modifications has done in the fields of date to month, age to age group for example if i would say. Then finally data is ready to use by transorming to as required.
Step 6: Then i started preparing visualizations using pivot table, Selected different types of field and columns according to the problems given by the stakesholders. and started making visualizations and from which i started getting solutions for each problems asked by the stakeholder.
Step 7: Finally i prepared the Dashboard of vrinda store to make easy understand by the client to get solutions for their problems by adding slicers to find each and every thing clearly as we can see them in above attached files.
inaights:
-----------------
---> In march month having the highest sales and orders.
----> Women are more likely to purchase as compared to men that we can observed in the report.
----> in Maharstra, Karnatak and Utterpradesh are the top 3 states where the sales are maximum.
-----> Amazon, flipkart and myntra are the three channels are the maximum contributors among all remaining.
-----> Adult age group is the maximum contributing to the sales.
------> As a data analyst i would suggest stakeholders like women are more likely to purchase things related to thier cloths and those are mostly in adult age
from maharastra, karnataka and utterpradesh states in amazon, flipkart and myntra shoping channels so i would suggest keep attract those people to make
more profit in the business vrinda store.