I guess your organization’s problem is that different teams have their preferred BI/analytics/data exploration tools. While Periscope may serve other departments’ purposes, it may not satisfy your PMs who are more tech-savvy and would want to dig deeper into the data instead of looking at just the aggregated report.
We are also a product company, and the most important things for us are:
- The PMs have access to the correct data from a common source of truth (instead of using their dedicated tool and explore unverified data)
- The PMs have a convenient means to explore that data by themselves (instead of having to rely on the data analytics team all the time).
In may cases, if you enforce (1) your PMs won’t be happy because they cannot freely explore data by themselves. If you let them do (2) then you face data accuracy issues.
To solve those problems we use Holistics on top of BigQuery and Postgres for all internal reports and data self-service. (Imagine it as dbt + a nice GUI + data exploration layer for business users)
Holistics has a really useful data modeling layer and a data exploration layer built right on top of it. We can create some models as building blocks and combine them in different ways to serve different needs.
For example, we aggregate traffic to (session - page) level, (session) level, (page) level, (visitor) level… and mix them to create datasets for different purposes like:
- Sales funnel analysis dataset = session model + session-page model + demo booking model
- User path = session model + session-page model + page model + visitor model
Same thing with user behavior on our products. We build models for major features, and either throw them together into a master dataset, or break them into feature groups so the PMs have an easier time getting their relevant data.
It’s important that we model our data carefully and expose only relevant dimensions and measures. The amount of data you got from Snowplow is enormous in terms of volume and dimensions, so we have to balance between flexibility in exploration and performance.