Skip to content

Latest commit

 

History

History
25 lines (17 loc) · 1.24 KB

README.md

File metadata and controls

25 lines (17 loc) · 1.24 KB

SQL for Data Analysis

superstoreDump.sql containes data in the normalized form.

Original Data Set : Superstore Dataset on Tableau

I have to remove some of the rows in order to mantain ACID properties. Dump was taken using PostgreSQL . Mentioned questions are based on analytical purpose from Basics to Advanced level.

PostgreSQL Installation

For Postgres Setup follow the links:

Usage

How to restore .sql dump Restore dump file You can use .sql instead of .backup file as shown in the link.

DB_Schema

SuperStore Data Database schema

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change. Please make sure to update tests as appropriate.