Exploring our Sample Dataset
We had yet to find a sample dataset that reflected data found in a B2B SaaS startup. So we made this publicly accessible database to run against our SQL templates.
Our fake startup
Tables in our fake database
users table is populated with ~800 users. All names and emails are fictitious. Any resemblance to actual persons, living or dead is purely coincidental.
teams table is populated with ~160 teams. Again, all teams are fictitious (although we tried to give the names a startup feel). Note: all
users, but not all
teams (i.e. some people use Marker on "single-player mode").
tickets table is populated with ~70 tickets. What this table lacks in size it makes up for in realism. With data in this table you can detect spikes in issues or use Linear Regression to see which sub-metric correlates most strongly with CSAT.
nps_responses table is populated with ~2000 responses. It's perfect for analysis on NPS (and our NPS analysis template is arguably the most straight-forward one on the web).
We plan to add tables for
webhooks (a join table to connect to fake Stripe and Clearbit data).
Accessing this database
In PopSQL, create a new connection and use the credentials below:
|Nickname||Sample Data - Marker|
Tools we found useful in making a fake DB
Spread the wordTweet