The Challenge: Before Metabase, for every question the Reforge team had, they ran a query against their database and then put the results in a spreadsheet. While this answered their questions at the time, they felt like they could do a lot better.
The Solution: After having used Looker, Reforge’s Head of Data wanted a lightweight solution to enable the entire company to have access to critical data about the business.
The Results: Metabase was instrumental in democratizing access to Reforge’s data. Now over 75% of employees are leveraging Metabase on a monthly basis.
"Metabase has allowed us to make data accessible to anyone in the organization, whether it’s for a deep analysis or for a quick status update on an important initiative. "Dan Wolchonok
Head of Data at Reforge
Reforge helps people do the best work of their careers. They offer educational programs, networking opportunities, events, and community to help people understand which strategies have worked for the best companies in the world. And the programs feature top growth leaders from companies that include Google, Dropbox, LinkedIn, Pinterest, Atlassian, Slack and others. Reforge was profitable and bootstrapped before they raised their Series A in early 2021. In their first 5 years, they spent $0 on paid marketing and had no sales reps.
The Reforge team needed to get straightforward answers to basic questions about how the business was performing, and to get insight into what people were doing within their web application.
In early 2018, Dan Wochonok, Head of Data at Reforge saw how a PM would ask an engineer to write SQL, then the PM would export the results to a spreadsheet to share with others within the company.
After having used Looker while working at HubSpot, Dan wanted a lightweight solution to help enable the entire company to have access to critical data about the business. That’s how they started using Metabase.
With Metabase, Reforge wanted to build basic dashboards that would let them know how the business was performing. They wanted to understand at a high level what the trends looked like as a starting point.
Reforge uses Snowflake as their data warehouse. They replicate data from a production read replica into Snowflake to combine production data with analytical data. They use dbt to build models that combine data from multiple source systems and enable denormalized tables that bring together multiple sources into simple-to-use models for anyone in the organization to query. They’re able to seamlessly run queries that mix and match data between the two systems so that they can use the latest production data with an analysis built on raw event-based data or models computed in the data warehouse.
Some of the tools they use:
Dan has posted a diagram showing their tooling and how it is connected here.
For each tool they use, Reforge team has documentation describing what to use the tool for, and examples to get everyone started.
In Metabase, Reforge team is looking at:
In the beginning, Dan set up all the reporting for the team. He would generate a simple report and then share it with a colleague knowing that it should always be up to date, even if the underlying data is updated. Dan also liked the ability to combine data from multiple databases into the same dashboard, and drag and drop the charts in any configuration you want.
One of the features the team enjoys a lot is the possibility to post questions to Slack or email at a regular interval. It’s a great way to ensure that important metrics are top of mind for the team and that they’re aware of how metrics are performing.
Now, however, Reforge has a team of analysts and data engineers that work with stakeholders across the company to self-serve basic questions and do deeper analyses that require more technical skills.
In Metabase, Reforge measures everything from how they’re performing against their top-line business metrics for the year, down to individual reports on how users and teams are engaging with the platform.
Every department uses Metabase for insight into user behavior, answering customer questions, getting insight to help in the sales process, trends about what content people view the most, and doing advanced analytics through segmented reports, YoY comparisons, and retention charts.
With Metabase, Reforge teams were able to get the basic understanding of what’s happening (revenue, engagement, traffic, conversion analysis, retention, behavior on site, popularity of content, etc). Everyone has access to the latest and greatest data sets to help them make better, more-informed decisions.
Create video tutorials of key elements that are a part of the onboarding material for new employees:
Monitor how your org is using Metabase. Find out who isn’t using Metabase (and who should be), and look to address their concerns, misunderstandings, or frustrations.
Avoid custom SQL in your centralized key reporting
Leverage the events feature in your charts to add context.
Clockwise optimizes your team’s calendars to create more time in everyone’s day. It brings together a powerful optimization engine with a personal calendar assistant to make your work life run smoothly.Read the case study