Join our newsletter

#noSpamWePromise
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
cross-icon
Subscribe

Run your data operations on a single, unified platform.

  • Easy setup, no data storage required
  • Free forever for core features
  • Simple expansion with additional credits
cross-icon
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Download the file

#getsmarter
Oops! Something went wrong while submitting the form.

Planetly: Scaling companies’ carbon management with data

Learn how Planetly relies on Keboola throughout its data operations to help empower its green mission.

Customer Stories
October 20, 2022
Planetly: Scaling companies’ carbon management with data
Learn how Planetly relies on Keboola throughout its data operations to help empower its green mission.

Planetly uses technology to simplify carbon management for companies at scale.

Their data-driven software solution helps companies reach net-zero emission targets in four steps:

  1. Calculate your company’s carbon footprint and identify hotspots throughout your organization. From sales travel flights to air conditioning at the office, Planetly puts a number to the carbon-producing processes. 
  2. Develop science-backed reduction targets and help companies along the journey to achieve them.
  3. Offset residual emissions by supporting recognized and certified carbon reduction projects outside the company.
  4. Share progress with internal and external stakeholders. 

The entire carbon management life cycle is powered and fueled by data. 

We talked to Cari Davidson, VP of Engineering and Patricia Montag, the Engineering Lead Analytics, to better understand what role Keboola (and data as a whole) play in the company’s operations and what that means for the engineering team.

Set up and automate your ETL process in minutes. Sign up for the forever-free tier, no credit card required.

Planetly before Keboola

When Cari took over Planetly’s DataOps, the datascape consisted of an operational PostgreSQL database with materialized views for analytics. 

As Cari explained,

"We were in the process of implementing Looker, which doesn't work well when data is in different locations, in different formats. We have a very small data analytics team and I had the vision of having a tool that allowed us to manage our ETL pipelines and data warehousing, without the need for us to set up a lot of platforms that the team would need to maintain. Keboola met that need, allowing us to do this in a way that fits with our ways of working."

That is where Keboola stepped in. A couple of months later, Planetly could rely on Keboola throughout its data operations to help empower its green mission.

At the beginning of their journey, Planetly’s data ecosystem required a lot of time-consuming maintenance. 

To add new data, data ingestion pipelines had to be built with manual code requiring backend engineering to supply the Postgres database with additional data. Analytics and data validation were often done by exporting data to Excel files and constructing ad-hoc reports.

The problem with such a setup? It didn’t scale with Planetly’s growth, slowing down the team and their customers on the journey towards net-zero carbon emissions.

As Patricia noted,

“We wanted to build a data product that would enable customers to act quickly and allow us to build better solutions faster.”

Planetly revamps their data stack with Keboola

Cari and her team shifted their focus from maintaining an existing data stack to changing it into a more flexible, resilient, and scalable data platform.

They introduced Keboola as the centerpiece of their data architecture for all the data pipelines and flows, extracting data from multiple sources and integrating it into Snowflake as their data warehouse and Looker as their BI tool.

Primarily, Keboola allowed Patricia and her team to move faster. In just over 5 months, they constructed a full end-to-end self-serving analytic platform with a small team of 6 selected data operatives. Secondarily, Keboola was cheaper when it comes to the total cost of ownership. 

As Cari put it,

“We went from having data spread all over the place, to having our data pulled into our data warehouse, within a couple of months.”

So why Keboola and not any other tool? Why not just code all the pipelines manually?

Cari has evaluated other tools like Prefect and Homegrown, according to her, they landed on Keboola because:

“It was a complete solution. Prefect was a bit more challenging, and we needed to manage our coding flows a lot more intensely, which this team wasn't prepared to do. Keboola was easier for us to implement quickly. We were able to get our ETL pipelines up and running within days, without a lot of fuss.”

The four use cases of Keboola in Planetly

Keboola helped build a fully-integrated analytics platform that delivered four business outcomes.

Use case #1: Business intelligence

With the vast collection of ready-to-use connectors, Keboola helps extract data from multiple sources but also loads it to multiple destinations, like Snowflake (data warehouse) and Looker (business intelligence).

This simplified the building up of an analytic infrastructure. This infrastructure and tooling allow Patricia and her teams to keep an eye on the company’s performance and quantify the business processes surrounding it.

Use case #2: Client-facing analytics

Patricia and her team provide and help integrate the data they analyze back to their clients. Planetly’s clients can now more easily identify carbon management causes and opportunities for improvement.

Use case #3: Internal tools for data quality assurance 

Before Keboola, internal data quality assurance was done manually by various departments. For example, client data was exported to Excel files, to validate its correctness and completeness.

With Keboola Planetly were able to build tools that automate data validation. By automatically checking for errors and reporting quality assurance metrics in dashboards, Patricia and her team empower their coworkers to do their jobs more effectively and with fewer manual errors. 

Use case #4: Competitive advantage

Planetly is a leader in the carbon management vertical, but competition is growing. By building their carbon management solution with data, they continuously enrich, develop, and add new data-driven features that push their product beyond its competition.

What Planetly loves about Keboola

Here are the 6 things Patricia and her team love about using Keboola:

  1. Ease of onboarding
    Instead of spending time figuring out the software, new team members can quickly grasp its intuitive nature and spend more time trying and experimenting with new features to build a superior product for Planetly. 
  2. Keboola’s customer support
    Patrica truly loves the customer support Keboola offers. They don’t need it often, but when they do, the customer support is “really impressive” and they offer “immediate feedback that is extremely helpful”. 
  3. API-first design
    Patricia and her team are very technical. And they adore the API-first design of Keboola. Anything you see in Keboola’s user-friendly front-end can be used as a backend API. Which informs the data team at Planetly of what is possible. That helps the data team design backend data solutions that integrate with Planetly‘s software and scale with operations. 
  4. Incremental extraction
    Often, when building proofs of concept or augmenting existing data in the data warehouse, you just need to add a single column from a data source. Traditionally, this can be quite painful (time zone conversions, code refactoring, etc.) and computationally expensive (re-import all data, not just new data). With incremental extraction, Patricia and her team can just select the new data they need, and Keboola takes care of all the heavy-lifting in the background. (read more about how we do it here). 
  5. Increased transparency
    The Data Flows are extremely easy to see in Keboola. This allows Patricia and her team to have smoother conversations with non-technical colleagues to help them discuss data processes. It also helps the data team discover and debug issues easily. 
  6. Team autonomy
    With Keboola, everyone on Planetly’s data team is empowered to do their best work without having to rely on others. Need additional external data for an analysis? Simply construct a new data pipeline. Have to access a novel data set? Connect to the centralized data warehouse. 

These and other features allow Patricia and her team to deliver use cases efficiently while building more resilient data products at scale.

According to Patricia, without Keboola they wouldn’t just need more people to do the same workload, they would also need different engineering profiles, ranging from DevOps to Cloud and Backend Engineers.

“It would definitely take much longer to cover all the processes without Keboola.” 

Instead, Patricia and her team of data engineers and analysts can build and scale data products that empower coworkers and delight customers on the journey towards a greener future.

Set up and automate your ETL process in minutes. Sign up for the forever-free tier, no credit card required.

Keboola can help build and scale your data operations as well

Keboola is the data stack as a service platform that helps you integrate all your data tools and centralize operations. 

Read more about how Keboola’s clients simplified and scaled their data operations or try Keboola yourself.

Don’t worry, you’ve got the first 300 minutes for free and no credit card is required.

Recomended Articles