Kickstarter is a crowdfunding platform that helps creators secure funding for their projects through contributions from backers. It emphasizes creative fields such as art, technology, design, and entertainment.
1. Provide strategic recommendations to Kickstarter stakeholders to enhance campaign success rates.
2. Identify key factors that attract backers and boost engagement.
3. Highlight growth opportunities to strengthen Kickstarter’s platform performance.
- ID: A unique identifier for each project. This serves as the primary key for data reference.
- name: The title of the project. This gives insights into how projects are marketed and named.
- category: The specific niche or subcategory of the project (e.g., “Tabletop Games” or “Documentary”).
- main_category: The broader category under which the project falls (e.g., “Games” or “Film & Video”).
- currency: The type of currency used for the project funding (e.g., USD, GBP, EUR).
- deadline: The date when the campaign ended or was due to end.
- goal: The funding goal set by the project creator (in the project’s respective currency).
- launched: The date and time when the campaign was launched, indicating the start of the crowdfunding period.
- pledged: The total amount of money pledged by backers at the end of the campaign (in the project’s respective currency).
- usd_pledged: This column represents the amount of money pledged for a project, converted to US dollars by Kickstarter's internal currency conversion system.
- usd_goal_real: The total amount of money pledged by backers at the end of the campaign (in USD)
- usd_pledged_real: This column represents the pledged amount, converted to US dollars using exchange rates provided by an external service, Fixer.io API.
- state: The final status of the project, which can be:
- successful: Fully funded or surpassed the goal.
- failed: Did not meet the funding goal.
- canceled: Campaign ended prematurely by the creator.
- backers: The total number of individuals who pledged money to support the project.
- country: The country of the project creator, indicating where the campaign originated.
- Understanding the characteristics of successful campaigns.
- Exploring category and country-specific performance.
- Analyzing seasonal trends in project launches and success.
- Evaluating the impact of funding goals, backers, and project timelines on success rates.
- Identifying underperforming categories or regions that may need additional support.
Platform: MySQL Workbench 8.0 and PowerBI (for visualization)
Presentation & Documentation: MS PowerPoint Presentation and Google Doc
1. Which are the high and low-performing categories?
2. Which categories have significant pledged amounts and a high number of backers?
3. Analyse & identify the relationship between the backers and the categories.
4. Which countries have the highest number of successful projects?
5. How can we identify the categories that exceed their project goals and determine the average pledged amount by backers?
6. How can the optimal project duration and months with high success rates be identified?
7. How can analyzing category trends over the years, based on success, failure, and cancellation rates, help identify top-performing categories and those with untapped potential?
If you have any feedback, please reach out to [email protected] or connect with me on linkedIn
Hello, My name is Tuhin Basu.
I am a Data Analyst in training.