Project Overview
This project aims to analyze and extract key business insights from a bike rental shop's database. As an SQL specialist, the objective is to answer critical business questions that will help the shop owner make data-driven decisions to grow the business.
Project Objectives
The primary business questions addressed in this project include:
How many bikes are available in the shop, categorized by type?
What is the monthly rental revenue trend?
Other relevant data points that will help in understanding inventory, customer behavior, and revenue patterns.
Project Structure
The SQL queries used to retrieve insights from the database are organized by categories, each corresponding to a specific business question. Each script file is designed to:
Retrieve information based on inventory, sales, and revenue data.
Filter, group, and order data to present actionable insights.
Summarize results to provide clear and concise answers to the business questions.
Prerequisites
Database Access: Ensure that the database containing the bike rental shop data is accessible. Connection configurations might be required depending on the setup.
SQL Client: Install a preferred SQL client (e.g., pgAdmin, DBeaver) or use an IDE with SQL support. Here I'm Using PgAdmin4 PostgreSQL managment tool for this project.
Usage
-
Clone the repository to your local machine.
-
Connect to the database with your preferred SQL client.
-
Execute the queries in sequence as per the business questions.