How Holistics uses Snowplow data to optimize their data modeling and self-service BI platform
Self-serve data is the holy grail for many organizations. But achieving it is challenging. Making data readily available for teams and individuals to ‘help themselves’ to relevant segments of data comes with a host of complex challenges – not least of these is building the right data models so other teams have access to data that makes sense for them.
For Holistics, a BI platform designed to make self-serve data a reality for other organizations, the task of democratizing data was no less challenging within their own team.
To get there, the team at Holistics went on a journey to build a self-service platform that would enable their product and marketing teams to ‘fish for themselves’, gathering the insights they needed to develop Holistics into the best-in-class platform for data modeling and BI.
Holistics at a glance:
Holistics is a data modeling & self-service BI platform that enables non-technical users to get access to analytics without bothering data teams. Once raw data is stored in a data warehouse, data teams use Holistics to transform, model the data and prepare well-defined datasets and reports for key data consumers.Holistics serves data teams in over 30 countries, with offices with offices based across Singapore, Ho Chi Minh City, and Jakarta..
One of the key innovations of Holistics is their SQL-based data modeling layer, where it allows data users to use familiar and powerful language (SQL) to define a central definition of metrics. These are then exposed to business users in a clean, simple interface to use, enabling them to get accurate analytics data without the need of an analyst.
The challenge: tracking across product, app and website
Holistics is a platform that empowers internal teams to discover data themselves, without relying on analysts to build dashboards for them. Holistics makes it possible to dive deep and explore data, gaining insights they can use on the fly.
At Holistics internally, there’s a lot of behavioral data that needs to be captured, modeled and analyzed. With two main properties that need to be set up for tracking: the core Holistics product and the Holistics website, plus a third application called dbdiagram, the team needed a way to understand how users interact across these platforms and be able to serve data to the product and marketing teams respectively.
Initially, the Holistics team began with basic tracking with Google Analytics. But after deciding to track user behavior within dbdiagram, they wanted to explore alternative tracking solutions to give them better oversight of interactions within the product.
First, they weighed the benefits of building their own tracking infrastructure with solutions like Segment and Snowplow. Being open source, the team at Holistics were attracted to the idea of testing out Snowplow themselves without a financial commitment or budget approval from management.
Taking control of their data
To reduce risks during the transition from GA, Holistics decided to experiment with Snowplow on dbdiagram before potentially rolling out tracking to their main product and the marketing website.
Snowplow was already in place when Ha Pham joined as the company’s first full time analyst. He found there were major discrepancies in the data provided by GA compared to the data the team were tracking with Snowplow.
Diving deeper into why these discrepancies existed, Ha first modeled the data into page views but later found it made more sense to aggregate the data further into the session level and then into the user level. One area where the gap was particularly stark was the bounce rate, where GA showed the bounce rate to be as high 60% but Snowplow showed a rate of 30-40%. With the ability to define this himself, Ha could calculate the bounce rate much more accurately, reduced down to almost half their original number.
Considering Holistics is a B2B SaaS website, Ha expected the typical user interaction to be very different to that of an Ecommerce website, so GA’s precalculated methods of measuring bounce rates were less likely to be reliable. In this instance, it made a lot more sense to work with Snowplow for web analytics. Snowplow now serves as the main tracking solution across Holistics’ marketing websites, where access to raw, granular data makes it possible for internal teams such as product and marketing to self-serve using Holistics datasets.
Refining the Holistics product with behavioral data
Tracking and analyzing website data is only part of the story for Holistics. As a data software company, they need a way to keep on top of their customer-facing product to identify what product features resonate with users, which don’t, and which need tweaking.
For the Holistics team, building a game-changing product is as much about eliminating unnecessary features as it is about building new ones. Nowhere is this more true than in the Holistics UI – the heart of the Holistics experience that makes self-serving data a breeze.
With Holistics, once your foundational data models are in place, it’s possible to drag and drop different datasets to build a view of certain metrics, geographies, usage and more without having to write complex SQL queries. This is especially powerful for marketing and product teams who can fish data for themselves.
You wouldn’t know it, but hidden behind their clean UI, a great deal of behind-the-scenes work has gone into understanding how users interact, what they click on, what they don’t click on, and how they generally progress on their analytics journey through the Holistics platform. These insights have allowed Holistic’s product team to ensure the platform stays minimal and doesn’t suffer ‘feature bloat’.
To get these insights, the Holistics team needed access to raw data that they could model and serve to the product team so they could turn those insights into a better experience for users. With help from Ha, the team could dive into Snowplow data to identify the least-clicked buttons and product elements by users, enabling them to inform their approach to streamlining the UI.
After these enhancements, the change in the look of the UI was striking. Moving away from having lots of buttons and different functionalities, the current version is a lot cleaner and less cluttered which makes for a smoother user experience overall. Using their own platform in tandem with Snowplow’s well structured data, the product team now has what they need to continually optimize the Holistics experience.
The future for the data team at Holistics
For Ha and the Holistics team, there is a bright future ahead of expanding their data capabilities and experimenting with new approaches. One new avenue Ha would like to explore is implicit tracking – capturing some data automatically to see if additional elements and events will lead to more insights.
“When someone asks me a question, I write down the hypothesis, the user flow, I follow the flow in the events, and I identify the elements that are interlaced with that event and I track them explicitly.”
Ha Pham – Data Analyst, Holistics
As for Holistics, there continues to be a strong data culture where product teams and data analysts like Ha work together to build frictionless data exploration experiences for organizations around the world.
Snowplow and Holistics: a powerful combination
Snowplow and Holistics can make for a powerful combination. With Snowplow, you have access to rich events made up of over 130 data points, captured in a way that gives you total control over how you use it.
Working in tandem with Holistics’ intuitive self-service platform, organizations can deliver granular behavioral data across the business, where it can be put to work – making an impact or allowing them to explore to uncover key insights.
That’s where Holistics technology shines: giving independent teams the ability to dive into and explore data further until they stumble upon that ‘aha’ moment that can be instrumental to innovation and business success. And while providing a seamless ‘self-serve’ data experience is still a logistical challenge, solutions like Holistics and Snowplow can go a long way to help data teams turn data democratization into reality.