Shark Tank India Data Analysis

Shark Tank India Data Analysis Project

Goal: The goal of this project was to analyze the data from Shark Tank India using SQL to gain insights into investment trends, pitch success rates, gender ratios, and other key metrics. The analysis aims to provide a comprehensive understanding of the show's dynamics and the factors influencing investment decisions.

Insights:

• Total Episodes: Determined the total number of episodes and unique episodes aired.
• Total Pitches: Counted the total number of unique pitches made.
• Pitches Converted: Calculated the conversion rate of pitches into investments.
• Gender Analysis: Analyzed the total number of male and female participants and the gender ratio.
• Total Investment Amount: Summed up the total amount invested by the sharks.
• Average Equity Taken: Computed the average equity taken in deals where equity was involved.
• Highest Deals: Identified the highest deal amounts and the highest equity taken in any deal.
• Female Participation: Counted the number of startups with at least one female participant.
• Converted Pitches with Women: Analyzed pitches that were converted into deals and had at least one female participant.
• Team Analysis: Calculated the average number of team members per startup.
• Amount Invested Per Deal: Computed the average amount invested per successful deal.
• Demographics: Analyzed the average age, location, and sector distribution of contestants.
• Partner Deals: Counted the number of deals involving specific partners.
• Shark-Specific Analysis: Analyzed investments, average equity taken, and deal counts for individual sharks.

Discovering and Presenting Insights:

• Data Collection and Organization: Gathered Shark Tank India data, including details on pitches, investments, participants, and deals.
• Data Wrangling: Cleaned and organized data to ensure accuracy and completeness.
• SQL Queries: Used SQL queries to extract, analyze, and visualize data insights.
• Detailed Analysis: Conducted specific analyses on various aspects such as gender participation, deal conversion rates, and investment amounts.
• Shark Analysis: Focused on individual sharks to understand their investment behavior and trends.

This project provides a detailed analysis of Shark Tank India, highlighting key metrics and insights using SQL. The analysis supports better understanding and decision-making for future investments and participant evaluations.