Perform Sale data visualization with raw data set using excel for obtaining different questions related to it and help business to grow and see thier daily sales. Also done data cleaning in raw data to remove duplicate/null values.
1.Created a pivot Chart to see in what order date the particular sale amount has been done
and created a combo chart to show the graph.
Compare the sales amount, no.of items & their actual price with every date in a single chart?
2.Created a pivot table to see in which region the particular product has been sold
and created a pie-chart to show the graph.
In which year and date the business got the highest sale and by what number of units?
3.Created a pivot table to see which employee sold the maximum number of appliances
and belongs to which manager.
4.Lastly created dashboard using all the data using slicer functions to see in which particular date,
With how much unit price and at what sale amount
5.Talking about the insights we can see different types of questions to help stakeholders take better decisions.
