Electronic Product Sales Analysis in US

Data Cleaning played an important role in this dataset. The data types , dates format needed to be changed, some columns needed splitting into required columns .

Further I have used Excel and Power BI to gain in depth insights and present the dashboard.

I had to typically find out solutions to the below mentioned questions as my objectives

Q: What was the best Year for sales? How much was earned that Year? Q: What was the best month for sales? How much was earned that month? Q: What City had the highest number of sales? Q: What time should we display advertisement to maximize likelihood of customer’s buying product? Q: What products are most often sold together? Q: What product sold the most? Why do you think it sold the most?