Exploratory Data Analysis with IMDB database

SQL queries performed on a IMDB database containing scaled down data(Year 2017-2019) of the movies to explore the details of the database to analyse and gain insights. All Sql scripts were created and tested on SSMS 2016.

Setup IMDB Database

1. Run the Sql script SetupImdbDatabase.sql to create the database and the tables.
2. Insert data in each table using the scripts named as 'InsertValues....'.sql.

Queries for Exploratory Data Analysis

1. Open the sql script BasicEDAQueries.sql to execute the queries.
2. The above script contains analytical insights and the query results in comments.
3. Run or Execute individual query to find the results.

4. The summary and recommendations after the exploratory analysis is detailed in Summary.docx