This project is about an overview of dashboard of internet sales which also have a detailed overview of internet sales per customer and per product.
The data was uploaded to MYSQL and DML(data manipulation) queries was used to sort out the required data which was saved as an excel file and Power BI was used for data visualization.
The business request for this data analyst project was an executive sales report for sales managers. Based on the request that was made from the business we following user stories were defined to fulfill delivery and ensure that acceptance criteria’s were maintained throughout the project.
To create the necessary data model for doing analysis and fulfilling the business needs defined in the user stories the following tables were extracted using SQL. One data source (sales budgets) were provided in Excel format and were connected in the data model in a later step of the process. Below are the SQL statements for cleansing and transforming necessary data.
The finished sales management dashboard with one page with works as a dashboard and overview, with two other pages focused on combining tables for necessary details and visualizations to show sales over time, per customers and per products.