01 / The brief

The question

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

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.

Results & observations

  • 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.

Challenges

  • 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

Approach

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

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.

Explore the report

Select a screenshot for a larger view.