DATA SET : This project contains data in 3 Excel sheets namely
- Orders
- People
- Returns
OBJECTIVE :
- To find meaningfull insights from data and create an interactive dashboard for the same.
QUESTIONS :
- Relation between the data tables and colums.
- Profits depending upon different conditions like country, region and segment etc.
- Analyse sales data like most sold products, products least sold.
- Analyse market ratio depending on sales.
- Analyse delivery services, discount, market distribution etc.
Process :
- Verify data for any missing values, null values and anomalies, and sort out the same.
- Made sure data is consistent and clean with respect to data type, data format and values used.
- Created new columns for better analysis.
- Merge all maps, card, pie charts and graphs into one dashboard and apply slicer to make dashboard interactive and dynamic.