How do you kill the dashboard monster? My weapon of choice is going metrics-first. Let me explain why with these three core concepts; abstraction, composability, and built-in consistency.
If you've ever used a BI tool you've probably grappled with a common hurdle that's the reality in most BI tools - dashboard chaos. Your data team builds dashboards to give users data and insights, but once a dashboard is ready to ship, there's a new request. This results in an endless loop if ad-hoc work, and what's even worse, a big pile of slightly different dashboards that nobody uses collects dust in your data warehouse. Efficient? Not really.
Metrics-first is an approach where all data is defined as metrics within a semantic layer. Instead of relying on static, SQL-dependent dashboards, all data is structured into metrics, serving as centrally defined and governed building blocks that can be flexibly explored and analyzed in endless combinations by all users.
Do you want to know the harsh truth? Nobody cares about your data model. Data teams might obsess about star schemas and consistent column names, but in reality, the whole point of analysts' work is making data useful to people, and business users rarely want to learn about table structures.
That's one of the reasons why metrics-first is great. Metrics and dimensions give a higher-level of abstraction than of tables and columns. It allows people to engage with data using a language they already understand. “Hey, let's look at transaction volume, card payments only, and how we are growing in the US vs Europe?”. Pretty straightforward.
These are the terms your business already uses, and by packaging your data model in the same way makes it immediately available to everyone. So, instead of doing another pass on your data dictionary, get started defining your company key metrics. That's a change with some big implications - it means that the data team can take a step back and focus on the semantic layer, and that all end users can do much more BI work themselves.
Once you've defined your data into metrics, they're like building blocs. Anyone can stack them up in endless combinations again and again - without breaking the foundational component.
Let's look at a classic BI example: Creating a combined graph of New user accounts and Ad CTR. In a traditional tool, you would start by first getting both these values into the same dataset, in the same query, or “explore” to build your vizualisation on the combined data. This task can range from pretty easy to fairly complex, and typically requires the attention of an analyst.
With metrics-first BI, no prep work is needed. Every metric has it's own identity, and can be queried independently, while the result is combined from multiple, separate calls. This means that you can allow end users to mix and match any metrics without ever having to care about joins and queries. With the right tool, you can also use dimensions across metrics. So, if several metrics have a dimension in common, say, country, then you can analyze the country dimension on any level.
Metrics provide a single source of truth, ensuring that key business figures, like revenue, churn, and customer acquisition are centrally defined, governed, and reused across all reporting and analysis. If you're trying to serve a growing number of data-hungry users in an efficient way, going metrics-first eliminates a classic dilemma where using dashboards commonly leads to either of these two scenarios:
Data teams trying to make sure people are using the “good dashboards” (the ones where the latest definitions and metric names are up to date) is a common one. It usually leads to business users turning to the data team for even the simplest questions, adding up to more dashboards, eventually creating a “dashboard hell” and an endless request log. Needless to say, it's nearly impossible to govern.
On the other end of the spectrum, you let teams create their own content using your data - without any aspect of governance. Most analysts would agree that this is going from bad to worse. If the consistency problem is bad in scenario 1, then this is the wild west.
Ironically, some reach the conclusion that self-service doesn't work and that they're are stuck trying to govern dashboards and restrict flexibility.
Luckily, there's a third option available.
What's great about metrics-first is that it gives us strong governance at the right level of abstraction. Business users can use metrics freely - combine, slice, and dice them - and should be encouraged to create their own content. The key is that every chart and table is simply referencing centralized metric definitions, so that names and numbers are the same no matter who creates the chart. And when definitions change centrally, it updates all of the content that was ever created by anyone. Which means you get this beautiful built-in consistency, and can safely encourage folks to both explore and create content together.
The age of dashboard-driven BI is fading. Static reports, duplicate metrics, and governance struggles slow businesses down. Metrics-first BI solves this by enabling composable, intuitive, and governed data exploration—without sacrificing flexibility.
It's time to ditch the dashboard chaos. Define your metrics, empower your users, and embrace a BI model that actually scales.
Discover how Steep can help your team kill the dashboard monster and go metrics-first.
More posts
Once Upon's data team was on a mission to bring end users closer to data. They helped transform analytics from a behind-the-scenes function to a driving force, making data accessible and easy to use for everyone.
We've listened to our users and focused on small but mighty improvements that take your Steep-experience to the next level. Enjoy this month's product update with 17 improvements to Steep!
Tracking performance against targets is an essential part of any business, but in most BI tools it's often complex and difficult to manage - especially for business users. Steep's metrics-first approach allows targets to be deeply integrated and effortless to manage.
Steep’s Semantic Graph gives you a complete overview of your data tables and their relationships, making it easier than ever to define join paths between them.
Voi, a European leader in micro-mobility, needed smarter data practices to make better use of analysts' time and increase data engagement across the company.
We're excited to introduce a game-changing addition to Steep's semantic layer. Entities unlock the power of row-level insights, giving you the tools to go beyond metrics and explore the granular details that drive your business.
Bounce was searching for a tool to centralize its data capabilities and empower all employees with an easy-to-use data and analytics tool. Here's why they chose Steep.
We talked with Emilio Biz, a data consultant at Pyne, to learn about his experience setting up and rolling out Steep for his e-commerce clients, and why they opt for Steep when choosing a BI tool.
We know it’s crucial for you to keep your company engaged and up-to-date on the latest insights while being smart about your time. So, we’re happy to introduce Slack Subscriptions, allowing you to seamlessly automate the delivery of reports to your team’s favorite workspace communication tool, Slack.
There are fancier analysis techniques out there, but nothing beats a good pivot table for the sheer amount of insights you can get out of it. As a bonus, it’s easy to understand for large audiences, so it will make your insights pop. Adding a heat map is where the magic happens. Here are 3 powerful ways to use pivot tables:
We're excited to share that this year at Coalesce, we’ll be attending, hosting a talk, and having our own booth. Find all the details below. Can’t wait to see you there!
This month, we've rolled out a number of updates designed to take Steep reports to the next level, making them more powerful and fully customizable to suit your needs.
Steep is on a mission to make data more useful, simple and enjoyable for everyone. This month, we’re excited to introduce the AI Chart Builder, a new intuitive way to explore and analyze metrics.
We're excited to share that Steep has raised €4 million in a seed funding round led by Connect Ventures, along with existing investor Inventure and participation from Alliance VC, Antler, and Greens.
Our latest product updates are designed to simplify your workflow and make everyday tasks a breeze. Here’s how we’re addressing your most requested improvements:
This month, we’re excited to introduce cohorts! What was previously reserved for experts can now be built by anyone. Track how different groups of users behave over time and easily spot patterns in our latest visualization update.
For our second update this month, we’re launching several requested improvements to make analysis even easier and more intuitive. These include keeping context when analyzing metrics, improved filters and active member tracking.
This month we’re introducing pivot tables, upgraded targets and pinning reports to your home and team screens.
TL;DR: Adding targets to your BI visualizations remains unreasonably hard. It frustrates your business controller peers while draining your team's time. Current approaches are essentially hacks and the time has come for a proper solution.
Unlike the modern data stack, BI hasn't evolved much in the last ten years. Here's why the Semantic Layer is the new paradigm we need to serve the data-driven companies of the future.
We’ve teamed up with dbt Labs to bring you a complete semantic stack! With the new integration, you can now connect Steep to the dbt Semantic Layer via dbt Cloud. This lets you build your semantic layer with code in dbt Cloud and publish your metrics to all your end users in Steep.
We have partnered up with the good folks at Cube to bring you a powerful semantic combo. With the new Steep + Cube integration you can now connect Steep to an external semantic layer powered by Cube. Build your semantic layer with code in Cube, and publish your metrics to all your end users in Steep.
This month, we're rolling out filters in reports, a powerful feature designed to add a layer of flexibility to your reporting experience.
If you're running a startup and thinking about your data setup - good news! Getting started is not that hard anymore, and you don't need a data specialist. This is how we did it at Steep.
This month, we’re introducing powerful and intuitive tables that work like you expect in 2023.
One of the big frustrations I’ve had as a data leader is working with teams that are too busy shipping to care about impact and analysis. Here’s my approach.
I’ve been an analytics leader three times over, and my friends - we sure didn't choose this job because it’s easy!
Wondering what we’ve been working on lately? Check out the latest updates below.
dbt is doubling down on the semantic layer and this time it’s serious.
The other day Janne, one of the developers on the team, turned around and said - oh I just got totally mixed up, I thought I was in Notion but I was actually in Steep!
This month we’re introducing more ways to analyze, combine and visualize your metrics, all in one place.
The product has come a long way in two years, the mission remains the same.
This month we are bringing you a whole new way to create, collaborate and communicate with data - introducing the new Reports.
This month we are introducing new ways of bringing order to your metrics and more flexibility defining metrics with joins. Read on for more.
Steep has partnered up with dbt to provide a best-in-class metrics integration. But that’s not all. Read on for more exciting updates.
This month we are making it easier to grow with Steep using Team spaces, launching a completely new Help center, as well as adding a few nice visualization improvements.
Trying out Steep is now easier than ever with the introduction of demo data. There are plenty of new features this month, so make sure you read to the end for a special treat 🍰
The year is coming to an end and we are wrapping up with a whole bunch of new features and improvements. Our focus has been on enabling even more teams to be able to use Steep as well as new ways of gaining insights from your data. A big thanks to all of you for this year! Let's get to the news.
Early last month marked the public release of Steep. Thanks to everyone who signed up and got started so far. Please keep the feedback coming! We have not been idle in the meanwhile and there is a a whole bunch of news to share - so let's get right to it.
Im very glad to share the next step in our journey with Steep - announcing that we raised €1M pre-seed round co-led by Alliance and Inventure, and that today we are launching Steep to general access!