Categories: Data Analytics / Practice Datasets
Tags:

Investment Pitch and Deals Dataset – EDA Power BI

Here are some powerful KPI ideas for your Power BI dashboard on this dataset:

📊 General Show Performance KPIs

  1. Total Pitches: Count of all pitches across seasons.
  2. Deals Closed Rate (%): (Number of Deals Closed / Total Pitches) * 100
  3. Average Valuation Requested: Mean of Valuation Requested per season.
  4. Total Investment Amount by Sharks: Sum of Total Deal Amount.
  5. Average Investment Per Deal: Total Investment / Number of Deals
  6. Highest Valuation Deal: Max Deal Valuation.

You can get the Dataset for Educational Practice Here : https://www.kaggle.com/datasets/thirumani/shark-tank-us-dataset

🦈 Shark-Specific KPIs

  1. Most Active Shark: Shark with the highest number of deals.
  2. Highest Investment Shark: Shark who invested the most money.
  3. Average Equity Taken by Sharks: Mean of Equity Per Shark across deals.
  4. Number of Deals by Each Shark: Count of deals each shark participated in.

🔍 Entrepreneur & Business Analysis

  1. Success Rate by Industry: (Deals Closed in Industry / Total Pitches in Industry) * 100
  2. Most Popular Industry: Industry with the most pitches.
  3. Average Age of Entrepreneurs: Mean of Pitchers Average Age.
  4. Pitcher Gender Distribution: Percentage of male vs. female entrepreneurs.
  5. Cities/States with Most Pitches: Locations with the highest number of pitches.

🎥 Audience & Season Performance

  1. Most Viewed Episode: Max US Viewership.
  2. Average Viewership Per Season: Mean of US Viewership grouped by season.
  3. Seasons with Most Investment: Total deal amount per season.
  4. Seasonal Deal Trends: Deals closed per season over time.

🔄 Investment Types & Deal Structures

  1. Equity vs. Royalty Deals: Count of equity-only vs. royalty-based deals.
  2. Loan-Based Deals: Number of deals that included a loan.
  3. Deals with Conditions: Count of deals that had special conditions.
  4. Highest ROI Deal: (Deal Valuation - Total Investment) / Total Investment * 100

To calculate Average Investment Per Deal in Power BI using DAX, follow these steps:

🔎 Identify the Required Columns:

  • Total Investment Amount: Total Deal Amount
  • Number of Deals: Count of Got Deal where value is Yes

📌 DAX Formula for Average Investment Per Deal

Average Investment Per Deal =

VAR TotalInvestment = SUM(table[Total Deal Amount])

VAR DealsCount = CALCULATE(

    COUNT(table[Got Deal]),

    table[Got Deal] = 1

)

RETURN

IF(DealsCount > 0, TotalInvestment / DealsCount, BLANK())

🔹 Explanation:

  1. TotalInvestment: Sums up the Total Deal Amount column.
  2. DealsCount: Counts the number of rows where Got Deal = “Yes”.
  3. RETURN: Divides total investment by deal count.
  4. IF(DealsCount > 0, …, BLANK()): Prevents division by zero errors.