Interactive Dashboard and Data Analysis for Startup Growth Dataset

I worked on a complete data analysis project using a startup investment dataset that included the following columns: Industry, Funding Rounds, Investment Amount (USD), Valuation (USD), Number of Investors, Country, Year Founded, and Growth Rate (%).

Here’s what I did step by step:

Cleaned and prepared the dataset using Power Query:

- Removed duplicates

- Handled missing values

- Added a new calculated column for returned rate

Performed exploratory data analysis (EDA) using Excel:

- Calculated key metrics such as total investment, average valuation, and average growth rate

- Grouped data by industry, country, and year

Created a professional and interactive dashboard using Pivot Tables and Charts to visualize:

- Average Investment by Industry

- Average Valuation per Funding Round

- Average Growth Rate by Country

- Total Valuation by Industry

- Growth Rate by Industry

- Top 5 Years by Number of Investors

The dashboard is clean, dynamic, and user-friendly – allowing filters by industry and country.

This project showcases my ability to:

- Handle real-world business data

- Use Excel (Power Query + Pivot Table) for analysis and reporting

- Deliver clear, visual insights for better decision-making