Database creation and manipulation using SQL
For this project, I imported a Dataset from Kaggle about Bike Sales. I created tables to import the content from the bike sales dataset in PgAdmin and created an ERD analysis. I then conducted various select statement analyses to gain insights into the staff and customers of Bike Sales.
Creation
I chose this dataset due to the great amount of data, and the great amount of rows. I was interetsed in finding out the relationship between the various tables. I began by visualising on paper the relationships between the data. Then I created the tables and made a visualization of the ERD analysis. Below I have the ERD analysis created in PgAdmin.
Analyses
I decided to find out more about the relationships between the amount of orders and customers. I conducted Select statements to identify the relationship between sales and store locations. I used joins and analysed the staff, displaying the top employees in each store, and made reccommendations about this. I also analysed the distribution of the store.
