Description

[Marina-ai-hub]

The business request for this data analysisi project was a sales report for sales managers. Throughout the project were fulfilled the following requests.

1. To get a dashboard overview of Internet sales. For better following which customers and products sells best.
   Was created: Power BI dashboard which updates data once a day.
2. To get a detailed overview of Internet sales per customers. For following up which customers buy the most and who can we sell more to.
   Was created: Power BI dashboard which uallows to filter data for each customer.
3. To get a detailed overview of Internet sales per Products. For following up Products that sells the most.
   Was created: Power BI dashboard which uallows to filter data for each Product.
4. To get a dashboard overview of Internet sales. For following sales over time against budget.
   Was created: Power BI dashboard whish graphs and value comparing against budget.

To create th necessary data model for doing analysisi and fulfilling the business needs the following tables were extracted using SQL.
One data sourse (sales budgets) were provided in Excel format and were connected in the data model in a later step of the process.

Business Demand Overview.docx