[go: up one dir, main page]
Scribd
Upload
3 views2 pages

Genesys Data Analysis Assignment

The document outlines a data analysis assignment for a bicycle store, where a data analyst is tasked with extracting and cleaning sales data using SQL. The analyst must gather specific information about orders, customers, products, and sales representatives from multiple tables using JOINS. Additionally, the assignment requires the identification of top-performing sales reps, best-selling products, and sales trends over time.

Uploaded by

obinna okoye
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views2 pages

Genesys Data Analysis Assignment

The document outlines a data analysis assignment for a bicycle store, where a data analyst is tasked with extracting and cleaning sales data using SQL. The analyst must gather specific information about orders, customers, products, and sales representatives from multiple tables using JOINS. Additionally, the assignment requires the identification of top-performing sales reps, best-selling products, and sales trends over time.

Uploaded by

obinna okoye
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

GENESYS DATA ANALYSIS ASSIGNMENT

WEEK 12

Case: You are a data analyst who works for a store that sells bicycles. The company wishes to
glean insights on its sales data, including geographical data and the spending habits of its
customers. You have been given the task of extracting and cleaning the relevant data from the
database so that your teammates can work with it. Due to the size of the data involved, you are
asked to use SQL.

Before you begin: Follow these steps to load the data into MSSQL;
1. Open SQL server, create a new database and name it BikeStores
2. Select the new BikeStores database in the SQL server
3. Open the zip downloaded from the link I provided
4. Open the 'create objects' query file and then execute it in the SQL server for the BikeStores
database
5. Open the 'load data' query file and then execute it in the SQL server for the BikeStores
database

Instructions: The team has requested for the following information;


1. Order ID
2. The customer’s full names
3. City
4. State code
5. Order date
6. Total units ordered
7. Total revenue (quantity * price)
8. The names of the products
9. Their categories
10. Store names
11. Full names of the Sales reps

Hint: The requested data is in several tables, so you will have to use JOINS to obtain them all.

Once you have completed the above, turn it into a table of its own and extract the following
data;
1. The five best performing sales reps
2. The ten most bought products
3. The date that had the most Sales
4. The date that had the least sales
5. The five cities that generated the most orders in ascending order

Once completed, save all the answers, alongside the queries and submit them as usual.
Good Luck!

You might also like