Motorcycle Sales SQL Project
Motorcycle Sales Dashboard
About this project
This is a summary of a SQL project.
Full Project:
Motorcycle Company Project: Overview
You're working for a company that sells motorcycle parts, and they've asked for some help in analyzing their sales data!
They operate three warehouses in the area, selling both retail and wholesale. They offer a variety of parts and accept credit cards, cash, and bank transfer as payment methods. However, each payment type incurs a different fee.
The board of directors wants to gain a better understanding of wholesale revenue by product line, and how this varies month-to-month and across warehouses. You have been tasked with calculating net revenue for each product line and grouping results by month and warehouse. The results should be filtered so that only "Wholesale" orders are included.
Using the warehouse data provide sale targets for each warehouse and create a dashboard with this data.
They have provided you with access to their database, which contains the following table called sales:
Initial Data Extraction:
The data given contained a wide range of date. In order to focus on key sales and products, the data was filtered, grouped, and sorted.
Improving Sales
In order to improve sales, we must identify our "top" selling and "lowest" selling items. Our plan of attack will be to target these two items in order to increase average sales.
Sales Targets:
Top selling items : Increase by 5%
Lowest selling items : Increase by 10%
Total Average : Increase by 8%
Finding "Lowest" selling items per month and warehouse
For this query, I identify the product that sells the least for each month and warehouse. In order to do this, I created two subqueries. The first, brings the data from the initial project and the second subquery ranks items by their location and month. The final result is filtered in order to show only the "lowest" selling items. Target revenue column was added to show 10% sales target. The results will be used in our Tableau dashboard, so warehouse management can easily share pertinent sales data with their teams.
Visualization created in Tabeau.
Full analysis can be found:
