When you’re thinking about putting data in front of your customers, you might be imagining bespoke charts, color-coded metrics, and an abundance of white space.
This article shows you why starting with embedded dashboards (or any pre-defined view of your data) tends to cause problems with maintainability and scalability.
If you’re already convinced, check out the embedding approach you can take to avoid giving yourself grief.
Sample use case
Let’s say you run an e-commerce platform. Your analysts have built a dashboard where your team can look at the success of each merchant based on data such as visits per customer, transaction volume over time, and average customer rating.
You plan to embed the dashboard in a merchant-facing app so that your merchants can take advantage of those metrics and visualizations to understand and grow their business.
Stage 1: Denial
People are using your dashboard everyday, so you feel pretty confident that it already meets the bar for high-quality external analytics.
After reading through the strategies for delivering customer analytics, you decide to combine single sign-on (SSO), data sandboxing, and white labeling to embed your existing dashboard directly into the merchant-facing app.
Stage 2: Anger
A few weeks after rolling out the first iteration, you find that your merchants love using the dashboard, so much so that your data warehouse doesn’t quite scale to meet their enthusiasm.
Your merchants start to get frustrated with how long it takes to load the dashboard. You decide to copy your dashboard’s data sources to a faster data warehouse, and you adjust the number of instances for good measure.
Stage 3: Bargaining
Feature requests are beginning to roll in for your dashboard — it seems that the more your merchants get to work with data, the more questions they have about filters, pivots, and custom calculations.
Some of your merchants want to use their own calculations for revenue. Others are strongly opinionated about line charts vs. bar charts. And a small (but vocal) faction don’t even care for charts at all — all they want is a way to get de-anonymized customer data for running personalized campaigns.
Stage 4: Depression
You realize that the tables in your database require some serious SQL wizardry to support the latest dashboard additions that your merchants have been asking for.
Your team lacks the time to refactor the schemas (they’re busy maintaining the existing views), so you start writing custom SQL scripts to meet the needs of your most important merchants. Your data warehouse becomes cluttered with arbitrary tables.
Even though your product team does their best to track the requests for more data and more ways to look at that data, your once-successful internal dashboard seems to have mutated into a hundred-tile abomination.
When you finally have time to check out the usage stats of your merchant dashboard, you’re heartbroken to learn that your merchants have only ever looked at those tiles once, if at all.
Stage 5: Acceptance
You’re delighted to remember that this entire scenario is hypothetical. As you reflect on your simulated trauma, you come to understand that:
- People reach answers by looking at the data in different ways.
- Dashboard requests (can I get a specific view of the data?) are actually requests to self-serve data (can I get as many views as I need to answer my question?).
- You shouldn’t have to create or update your tables in response to dashboard requests.
A mindset shift: from embedded dashboards to embedded data models
The best way to get started with embedding is to treat your data models as the end product (and by data models, we mean the design of the fields, tables, and relationships that live in your data warehouse).
If your data models are easy for non-engineers to find, understand, modify, and verify, you’ll give them the confidence and autonomy to use data in the way that makes the most sense to them (and get your time back from herding ad-hoc dashboard requests).
Of course, you’ll still want to avoid creating a whole new category of ad-hoc data model requests. It’s well worth your time (now that you’ve got some back) to construct data models that are not only optimized from an engineering perspective, but also from a product design one.
Learn more about data modeling strategy, design, and implementation:
- The problems with democratizing analytics
- What is a data model?
- Common data model mistakes made by startups
Did this article help you?
Thanks for your feedback!