Crowdfunding Dashboard

High Level Design

Overview

For any crowdsourced-based business, tracking campaign market trends over time and uncovering drivers of success is essential for long-term revenue security. Insights are used to shift resources towards promising markets and empower customers with valuable information.

Goals

Increase revenue by optimizing resource allocation and empowering customer base.

Objectives

  • Understand high level drivers of revenue and trends
  • Increase revenue by focusing on growing market categories and shifting resources away from dwindling markets
  • Increase revenue by identifying drivers of success (irrespective of market) and empowering users with that information

KPIs Architecture

Objectives KPIs Measures Data Source
Understand high level drivers of revenue and trends $ Pledged

this year and annual growth

sum( usd pledged) Fact_Campaigns_2018
#Campaigns

this year and annual grown

count(campaign id) Fact_Campaigns_2018
# Contributors

this year and annual growth

count(backers) Fact_Campaigns_2018
Success Rate

this year and annual growth

count(success flag) / count(campaign id) Fact_Campaigns_2018
Average Campaign Length

this year and annual growth

avg(campaign days) Fact_Campaigns_2018
Identify pledged vs goal by category $ pledged w/ goal by category Fact_Campaigns_2018
Analyze pledge $ distribution by category box plot of revenue by category Fact_Campaigns_2018
Increase revenue by focusing on growing markets and shifting resources away from dwindling markets Identify pledged $ trends and forecast future revenue monthly $ over time w/ logarithmic forecast Fact_Campaigns_2018
Analyze revenue by category over time annual $ by category over time Fact_Campaigns_2018
Increase revenue by identifying drivers of success (irrespective of market) and empowering users with that information Analyze correlation between success rate and category scatter plot – success rate, category Fact_Campaigns_2018
Analyze correlation between success rate and launch month scatter plot – success rate, launch month Fact_Campaigns_2018
Analyze correlation between success rate and deadline month scatter plot – success rate, deadline month Fact_Campaigns_2018
Analyze correlation between success rate and country scatter plot – success rate, country Fact_Campaigns_2018

 

Entities Relationship Diagram

Crowdfunding dashboard

Entities Relationship Diagram

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation