Back to Projects
Case Study
Data Analysis and Visualization

Shark Tank Data Analysis Dashboard

A Power BI dashboard that helps understand Shark Tank deals, startups, investors, industries, seasons, and investment trends.
Live Production AppDiscuss Project
Shark Tank Data Analysis Dashboard cover image

Key Metrics Analyzed

Total Seasons14
Total Pitchers1,274
Deal Ratio60.05%
Total Deal Amount$226.49M
Average Valuation Requested14%
Average Amount Asked$284.14K
Mark Cuban Investment$59.42M
Lori Greiner Investment$43.24M

Overview & Objectives

This project analyzes Shark Tank data using Power BI. It helps users understand total seasons, total pitchers, deal ratio, total deal amount, average valuation requested, average amount asked, startup industries, deal outcomes, pitcher gender distribution, startup locations, and individual shark investment behavior. The dashboard includes multiple report pages. The overview page focuses on season-level performance, deal ratios, industries, startups, states, pitchers, and deals made. The investor profile pages compare shark investment behavior for Barbara Corcoran, Daymond John, Kevin O Leary, Lori Greiner, Mark Cuban, and Robert Herjavec across seasons and industries.

Project Goal

Build a clear Power BI dashboard that helps users explore Shark Tank performance, compare investors, identify top industries, and understand startup deal patterns.

The Business Problem

Shark Tank data contains many connected details such as seasons, episodes, industries, startups, pitchers, deal amounts, valuations, investor names, states, and deal outcomes. It can be difficult to understand investment patterns and shark performance without one clear interactive dashboard.
Methodology

My Approach

  • 1I cleaned and prepared the Shark Tank dataset.
  • 2I created Power BI measures for total seasons, total pitchers, deal ratio, total deal amount, average valuation requested, average amount asked, and investment totals.
  • 3I designed dashboard pages for overview analysis and individual shark profile analysis.
  • 4I added visual comparisons by season, year, industry, state, startup, pitcher type, deal status, and shark investor.
Implementation

Roadmap Execution

Data Preparation

Cleaned and prepared the Shark Tank dataset for analysis.

Data Modeling

Created the Power BI data model for seasons, years, startups, industries, states, investors, pitchers, and deal outcomes.

DAX Development

Built measures for total seasons, total pitchers, deal ratio, total deal amount, average valuation, average amount asked, and shark investment totals.

Overview Dashboard

Designed the main analysis page with KPIs, industries, states, pitcher distribution, top startups, deal ratio, and deals made.

Investor Profile Analysis

Created shark profile pages showing total investment, average investment, maximum investment, equity trends, seasonal investment, and industry investment.

Final Formatting

Formatted KPI cards, bar charts, maps, line charts, donut charts, and investor panels for clear startup investment reporting.

Key Features

Shark Tank KPI overview
Top 10 industries by total deal amount
Total startups by states
Pitcher gender distribution
Deal ratio by season
Top 10 startups by deal amount
Deals made analysis
Season and year filters
Individual shark investment profiles
Investment equity by season
Investment amount by season
Investment amount by industry
Investor comparison across industries
Startup performance analysis

Business Impact

Helps compare Shark Tank investors in one place
Makes startup deal trends easier to understand
Shows which industries receive the highest investment
Supports faster exploration of season and investor performance
Reduces manual analysis work by using one interactive Power BI dashboard

Challenges Overcome

  • Combining seasons, startups, investors, industries, states, deal outcomes, and financial fields into one dashboard
  • Making shark investment behavior easy to compare
  • Showing deal ratio and deal amount trends clearly
  • Comparing individual shark profiles across seasons and industries
  • Designing simple visuals for startup and investor analysis
Outcomes

Final Outcomes & Learnings

  • The final dashboard gives a clear view of Shark Tank deal trends, top industries, startup performance, investor behavior, pitcher distribution, and investment patterns.
  • Users can quickly compare sharks, identify high-value industries, analyze deal ratios by season, and understand how investment behavior changes over time.

Project Gallery & Screenshots

Power BI Shark Tank dashboard showing total seasons, pitchers, deal ratio, deal amount, industries, states, pitchers, top startups, and deals made
Power BI Shark Tank dashboard showing Barbara Corcoran and Daymond John investment profiles by season and industry
Power BI Shark Tank dashboard showing Kevin O Leary and Lori Greiner investment profiles by season and industry
Power BI Shark Tank dashboard showing Mark Cuban and Robert Herjavec investment profiles by season and industry

Technologies Used

Power BIPower QueryDAXExcelData ModelingData Visualization

Data Sources

Shark Tank datasetStartup pitch dataInvestment dataInvestor dataIndustry dataSeason and episode dataStartup location dataDeal outcome data

Need similar outcomes in your business?

Let's scope your metrics and construct dashboards tailored to your parameters.

Discuss Similar Projects