This project uses SQL to analyze the dataset of a Pizza Store. The goal of the project is to answer a set of questions about the store's business performance and help in it's growth by making better decisions.
To run this project on your machine you need to install any SQL supported DBMS then follow the steps below:
- Create a database.
- Create tables using the schema diagram provided below.
- Import csv files provided in the dataset folder.
Note: If you are using PostgreSQL then restore the backup file of the database and save yourself some time.
- Postgre SQL
- PgAdmin4
This dataset was downloaded from Maven Analytics click here to download.
You can use this dataset to build your own project and practise your SQL skills.
The project was successful in answering the set of questions about the store's business performance. The results of the project can be used by the store to make decisions about its marketing and product offerings.