How Narrator Works

Narrator works alongside your existing data system.

Narrator allows your data team to drastically accelerate ad hoc requests by defining business concepts once and allowing your stakeholders to make datasets themselves.

The Current Approach

All insights begin with a “simple” data question

When data questions are asked, they come in a natural, human format, and seem straightforward:

Product Manager

ASKS A QUESTION...

How many people who called us, signed a contract?

ANALYST

...RETURNS AN ANSWER.

275 people who called us between Jan 1, 2019, and Jan 15, 2019, converted to signed a contract.

But for analysts, the process is slow, tedious, and error-prone:

1. Product Manager asks data question

2. Analyst translates the question into the proper format

3. Analyst researches relevant tables and their dependencies

4. Analyst writes a data query

5. Analyst validates the data output

How many people who called us, signed a contract?

Product Manager

How many new unique customers who called us (via Zendesk) for the first time ever during Jan 1 and Jan 15 signed a contract?

2. Analyst translates the question into the proper format

1. Product Manager asks data question

4. Analyst writes a data query

3. Analyst researches relevant tables and their dependencies

5. Analyst validates the data output

Analyst

275 new unique customers who called us (via Zendesk) during Jan 1 and Jan 15 for the first time signed a contract (via Salesforce).

Narrator allows your data team to solve this problem by reframing data modeling to be from the point of view of the Stakeholder:

1. Product Manager asks data question

How many people who called us, signed a contract?

Product Manager

2. Product Manager assembles the question using relevant business concepts

3. Narrator returns an answer

275 new unique customers who called us (via Zendesk) during Jan 1 and Jan 15 for the first time signed a contract (via Salesforce).

Product Manager

1. Product Manager asks data question.

2. Product Manager assembles the question using relevant business concepts.

3. An answer is returned.

Stakeholders can answer questions on their own using trusted data that is validated and maintained by your data team.

Our Approach

Step 1. Data Modeling

Your core business concepts and customers activities are defined up front, and written in simple SQL on top of your warehouse.

This removes the need for analysts and data engineers to manage the relationships and dependencies of thousands of tables because there’s only one:

SELECT 
  u.email                  as customer, 
  ‘subscription_upgraded’  as activity,
  s.id                     as activity_id,
  s.upgraded_at            as  timestamp
FROM subscriptions AS s
JOIN users AS u
  ON s.user_id = u.id
WHERE s.status = ‘upgraded’

via Internal db

Upgraded Subscription

Page View

Call Support

Opened Marketing Email

Signed a Contract

Logged In

Define All Activities in 1 Week

Step 2. Assembling Datasets

The data modeling completed in step one allows anyone to use Narrator’s powerful tools to combine these concepts to build any dataset, over and over again.

people

who

Submitted Lead

and

Signed Contract

Data consumers can now ask data questions in a way that mirrors how they already understand the business:

1. Start with a data question:

How many

people

who

visited the website converted to a lead?

2. Rephrase it in terms of customer and business concept:

Count of

people

who

Called Us

then

Signed Contract

Within 7 Days

3. Assemble concepts to build a dataset:

Benefits

Simpler
definitions

Easy to write SQL (average of 14 lines vs. 1000).

Less mess,
fewer arguments

No redundancy—each concept is clearly defined only once, and new activities don’t need to be created often.

No more
adhoc requests

Everyone can answer their own questions and assemble datasets in 5 minutes.

Try Narrator with your data

Your team could be using Narrator in as little as 2 hours. Setup is free and easy.