This project is a comprehensive SQL-based analysis of the IMDB movie dataset. It explores movie trends, genres, directors, production houses, and actors based on various metrics like ratings, duration, and votes.
The analysis addresses 29 SQL questions, each solved using three different methods:
- Standard SQL (SELECT-FROM-WHERE)
- SQL with JOINS
- SQL with Subqueries/CTEs
The project was developed as part of an academic assignment at CDAC Mumbai by Team 9 – Code Alchemist under the Diploma in Big Data Analytics (DBDA) program.
| Name | Role |
|---|---|
| Rishabh Tripathi | Member |
| Ruchika Mhetre | Member |
| Rudrang Darade | Technical Lead |
| Rushikesh Chavhan | Member |
| Sadik Jamadar | Member |
| Sahil Karande | Technical Class Representative |
| Sakshi Khandagale | Communication Lead |
- Analyze the IMDB dataset to extract key business insights
- Perform structured query analysis using multiple SQL approaches
- Identify genre trends, high-performing actors/directors, and language patterns
- Make actionable recommendations for future productions
imdb-data-analysis/ │ ├── database/ │ ├── create_tables.sql # SQL to create IMDB database schema │ ├── insert_data.sql # Sample data insert commands │ └── erd.png # Entity-Relationship Diagram │ ├── queries/ │ ├── query01_three_methods.sql │ ├── query02_three_methods.sql │ └── ... # All 29 queries solved by 3 methods each │ | ├── Executive Summary - Team 9.pdf # Final compiled report └── README.md # This file
- 🎭 Drama is the most dominant genre (4285 movies); 1078 produced in 2019 alone.
- 📅 2017 saw the highest number of movie releases; March was the busiest month.
- ⏱️ Action movies had the longest average durations (112.88 mins); Horror had the shortest.
- 🎬 Top production houses by hit count: Dream Warrior Pictures, National Theatre Live.
- 🎥 Best directors in popular genres: James Mangold, Joe Russo, Anthony Russo.
- 👑 Highest-rated Indian actor: Vijay Sethupathi (Avg Rating: 8.42).
- 👸 Highest-rated Indian actress: Taapsee Pannu (Avg Rating: 7.74).
- 🌐 Multilingual hit leaders: Star Cinema and Twentieth Century Fox.
- 💥 Studios with most votes: Marvel Studios, Twentieth Century Fox, Warner Bros.
- 🎯 RSVP Movies should focus on the Drama genre in future productions.
- 🌍 Release the movie in English for broader international appeal.
- SQL (MySQL / PostgreSQL)
- Relational Database Design
- ER Diagrams
- Python (Pandas, Seaborn - optional for visuals)
- Markdown & Git/GitHub
This analysis was performed as part of the academic curriculum at CDAC Mumbai under the Diploma in Big Data Analytics (DBDA) program. It was a team project executed by Team 9 – Code Alchemist as part of the database module’s major assignment.
- LinkedIn - Sahil Karande https://www.linkedin.com/in/sahil-karande-a77aa7207/
- GitHub - Sahil Karande
📁 Feel free to explore the repository to see SQL queries, visual insights, and our complete analytical process.