Analyzing Kickstarter Projects

  • Guided Project
  • 0.5 hours
  • Beginner
  • SQL

Practice SQL skills to analyze Kickstarter data and identify factors influencing campaign success.

Start this project

Overview

In this project, you'll take on the role of a data analyst at a startup considering launching a Kickstarter campaign to test product viability. Using SQL, you'll analyze a database of Kickstarter projects to identify factors that influence the success or failure of campaigns. This hands-on project allows you to apply fundamental SQL skills like querying, filtering, sorting, and conditional logic to derive insights from real-world data. You'll uncover trends in project categories, funding goals, and backer engagement to guide your team's campaign strategy. Objective: Analyze Kickstarter data using SQL to identify key factors contributing to campaign success and inform product launch decisions.

What You'll Learn

  • ✓ Explain the context of the problem
  • ✓ Query the dataset
  • ✓ Filter the dataset
  • ✓ Sort the dataset

Before You Start

  • ✓ Extracting data from database tables using SELECT queries
  • ✓ Filtering data using WHERE clauses with operators
  • ✓ Sorting query results using ORDER BY
  • ✓ Transforming data using SQL functions

Project Steps

8 steps

  1. 1 Retrieving Column Data Types
  2. 2 Initial Selection of Rows and Columns
  3. 3 Filtering by Category
  4. 4 Filtering by Quantity
  5. 5 Ordering Results
  6. 6 Applying Conditional Logic
  7. 7 Your Turn
  8. 8 Next Steps
Start this project

Join 1M+ data learners on Dataquest.

  1. 1

    Create a free account

  2. 2

    Choose a learning path

  3. 3

    Complete exercises and projects

  4. 4

    Advance your career

Start learning today

Sign Up For Dataquest Continue Learning