Kickstarter Crowdfunding Data Analysis

An end-to-end data analytics project analyzing Kickstarter crowdfunding data to understand project success patterns, funding behavior, and backer trends.

This project demonstrates data modeling, SQL analytics, and dashboarding using Excel, Power BI, Tableau, and MySQL.

---

Project Objectives

• Convert epoch-based timestamps into natural date formats
• Design a star schema data model for analytics
• Build a reusable calendar (date) dimension
• Standardize multi-currency values into USD
• Perform business-focused SQL analysis
• Create interactive dashboards across multiple BI tools

---

Dataset Overview

The dataset includes the following components:

• Projects (fact table)
• Categories
• Creators
• Locations
• Calendar (derived)

Raw data was provided in Excel format and transformed for analytical use.

---

Data Modeling

A star schema was implemented with the following structure:

Fact Table

• projects

Dimension Tables

• dim_category
• dim_creator
• dim_location
• dim_date

This design improves query performance, simplifies analytics, and supports BI tools.

---

Key Transformations

Epoch to Date Conversion

• Epoch timestamps were converted to natural dates
• Excel used for validation
• MySQL used for analytics and dimensional modeling

Calendar Table

• Derived from project creation dates
• Supports year, month, quarter, and weekday analysis

Currency Standardization

• All monetary values converted to USD
• Static exchange rate applied for consistency

Detailed transformation logic is documented in the 03_transformations folder.

---

Business KPIs Analyzed

• Total projects by outcome, category, and country
• Total amount raised by successful projects
• Total number of backers
• Average duration to project success
• Top successful projects by backers and funding
• Success percentage:
  • Overall
  • By category
  • By time (year/month)
  • By goal range

All KPIs are implemented using SQL and validated in dashboards.

---

Dashboards

The analysis is visualized using multiple tools:

• Excel – Pivot-based dashboard
• Power BI – Interactive executive dashboard
• Tableau – Analytical dashboard for exploration

Dashboard Previews

---

Tools & Technologies

• MySQL
• Excel
• Power BI
• Tableau
• SQL
• GitHub

---

Project Structure

├── 01_data/              → Raw and processed data
├── 02_database/          → Schema, data load, and analytics SQL
├── 03_transformations/   → Transformation documentation
├── 04_dashboards/        → BI dashboards
└── 05_screenshots/       → Dashboard previews

Author

Mayuresh Ahire

This project was built as part of a structured analytics training program and is intended to demonstrate real-world data analysis skills.