Analyse user activities with Narrator and Activity Schema

You can learn how to go beyond star schema when you want to learn how users interact with your services with activity schema and use Narrator to ask and answer complex questions quickly.

Skill Level
Time to Complete

About this course

There is a world beyond sales and marketing dashboards, a world where you like to look into user activities with your services and their impact on your revenue. So do people churn less when they interact with customer service? Is there a difference in response time make. If you like to answer these questions with a classic BI stack, you will spend a lot of time preparing the data and then make accessible. And that is just question number one; a good product team will have their follow-up questions already prepared in their heads. Ahmed, CEO of Narrator and the inventor of the activity schema saw this all during his time leading the data team at WeWork and now helping companies with Narrator. In this course, we explain the limitations of star-schema, the role of activities, how to model data for activity analytics, formulate questions, and the 12 core temporal joins.

Who is this course for

Product Analyst
You are the product data detective (Mrs. or Mr. Holmes), using your analytical skills to uncover insights from your products. You help businesses make strategic decisions and drive growth by identifying trends and patterns in the data.
Product Manager
As a product manager who works with data, you are like a digital wizard, using your magical powers to predict what our customers need. You spend your days analyzing numbers and making recommendations to improve our products.
Analytics Engineer
You are the ones who bring all our data to life and turn it into valuable insights. The ones who turn data into gold, like a modern-day alchemist.


The choice is yours - you can either immerse yourself and complete the course in one go, or take a more gradual approach by repeating and skipping between lessons at your own pace.


The best way to learn is by taking action, so it's time to get ready to work.
Here are some of the things you'll get out of doing this course:
Learn about star-schema limitations
When to use activity schema as model
How to analyse user activities and their impact on your business
How get started in Narrator
How ask complex business questions in Narrator

Why learn with Deepskydata?

We understand the struggle because we've once been in your shoes. Allow us to share what we know now to help you reach your destination with ease and make your learning journey smoother.
Shortcut to success
Get hands-on shortcuts across the data stack with our how-to videos, saving you time and resources on testing and debugging - where 90% of the work lies.
A new community
Rolling out in early 2023 the new community will bring you together with data practitioners who are on the same track, with the same struggles to share experiences.
We are here for you
This is not a watch and forget platform. We are here to help you. Do you have questions after watching a course - just get in touch with us.


The background of the info card. Likely the portait of a person who is a teacher on the platform.
A colourful small side decoration on an info card.
Timo Dechau
Founder & Data Engineer
The background of the info card. Likely the portait of a person who is a teacher on the platform.
A colourful small side decoration on an info card.
Ahmed Elsamadisi
Founder of, Creator of the Activity Schema