Skip to content

A SQL repo for understanding analytics from basics to advanced with the help of Super Store datasets. It contains SQL dump of Super Store Dataset provided by Tableau and various questions.

Notifications You must be signed in to change notification settings

LMSharma/Analytics-SuperStore-SQL

Repository files navigation

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.

About

A SQL repo for understanding analytics from basics to advanced with the help of Super Store datasets. It contains SQL dump of Super Store Dataset provided by Tableau and various questions.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published