Project Explanation: Bollywood Movie Analysis

Project Overview

This project involved analyzing Bollywood movie performance data to enhance profitability by focusing on key factors like genre, release timing, and star power.

The Creation Process

The project began with SQL queries to extract insights from a Bollywood movie database. Data was analyzed using MySQL, and visualizations were created with Power BI to present the findings effectively.

Challenges and Solutions

One of the main challenges was dealing with loss in profit for certain genres, particularly dramas. Additionally, I faced confusion over color schemes for the dashboard. I took breaks and sought guidance from my Twitter friends to resolve these issues.

Key Learnings

This project enhanced my skills in data analysis, SQL querying, and dashboard creation ,, along with insights from community support that improved my problem-solving abilities.

SQL QUERY

Download SQL QUERY PDF

Project Presentation

View my project presentation on Google Slides:

View Presentation

Dashboard

Download Report PDF Back to Portfolio