# 🚀 SpaceX Launch Analysis — End-to-End Data Project

This project delivers a complete **data analytics pipeline** for analyzing SpaceX rocket launches, from **data extraction** to **insightful Power BI dashboards**.

## 📌 Project Overview
- **Data Source:** SpaceX API (real-time data)
- **Processing:** Python scripts for data fetching, cleaning, and MySQL storage
- **Analysis:** SQL queries to derive key metrics and trends
- **Visualization:** Interactive Power BI dashboards with KPIs & charts

## 📊 Key KPIs
| KPI                  | Value |
|----------------------|-------|
| Total Launches       | 205   |
| Successful Launches  | 181   |
| Success Rate         | 88%   |
| Payload Count        | 192   |
| Failures             | 24    |

## 💡 Insights
- SpaceX has maintained an **88% success rate** across all launches.
- Certain rockets dominate **heavy payload missions**.
- **Launch failures** have decreased over recent years.

## 🛠 Tech Stack
- **Python** — Data extraction, cleaning
- **MySQL** — Structured storage & querying
- **Power BI** — Data visualization & dashboarding
- **SQL** — Analytical queries

## 📂 Project Structure

Let's Connect:-
LinkedIn:https://www.linkedin.com/in/tanmay-sharma-800599373/
Github: https://github.com/Tanu272004/SpaceX_Rocket_Analysis.git
PowerBI: https://app.powerbi.com/groups/me/reports/9bd747a8-5091-436e-9f9c-35e3d8d2b4a9/7968b2441b0c582b4013?experience=power-bi