Data-Driven Jobs-to-be-Done: How a Star Schema Can Help You Succeed

Unlock the potential of your Jobs-to-be-Done catalog with a star schema model that empowers you to make informed decisions based on real data

Some of you may be wondering how all of the data that we collect during our qualitative research gets used. I’d like to use an analogy to help understand. If you’ve done any work in data analysis, you’ve probably heard of a Star Schema. This looks like a spoke and wheel set up, where the hub is a FACT table, and the spokes are DIMENSION data.

This is more applicable to the actual data model that comes out of a Jobs-to-be-Done survey. However, it’s also a good way of thinking about what you will find in the Jobs-to-be-Done catalogs I share.

Think of the FACT TABLE as the Core Job Success Metrics. And think of Situations, Contexts, Use Cases, etc. as DIMENSIONS. We’re rating the needs in the Core Job but we’re using the other data to slice and dice them to see what changes given the various dimensions or combinations of dimensions.

There will a…