This is a Data Analyst project whose files are all tailored to solving the business request with the scenario below:
Idris, Sales Manager: Hi Habeeb! I hope you are doing well. We need to improve our internet sales reports and want to move from static reports to visual dashboards. Essentially, we want to focus on how much we have sold of what products to which clients and how it has been over time. Seeing as each sales person works on different products and customers it would be beneficial to be able to filter them also. We measure our numbers against budget so I added that in a spreadsheet so we can compare our values against performance. The budget is for 2022 and we usually look 2 years back in time when do analysis of sales. Let me know if you need anything else!
Regards, Idris
For this project, I downloaded the database on Advebture Works, made use of SQL for data cleaning and aggregation and exported the file to PowerBI for visualization.
Read full story at https://link.medium.com/P2RiuqQl4vb