The official Operational Analytics blog
The official OA blog
Product
Integrations
Pricing
Get a Demo
Subscribe to OA Digest
Subscribe to OA Digest
Top Content
Best Practices
Tutorials
Product News
Product
Integrations
Pricing
Get a Demo
Featured
Best Practices
What is Operational Analytics (and how is it changing how we work with data)?
Rather than empowering teams, they often have to choose between fresh or accurate data; being able to trust it, or taking quick action on it. Operational Analytics solves this pain point to drive action w/ real-time data to all the tools you need.
Sylvain Giuliani
Sylvain Giuliani and
Feb 23, 2022
Best Practices
What is "data as a product" really?
If you're on Data Twitter, Data Slack, or subscribe to a data newsletter, chances are you're no stranger to the "What is data as a product?" debate. Here, we've rounded up the most popular views so you can decide for yourself.
Parker Rogers
Parker Rogers and
Jan 27, 2022
Best Practices
What is reverse ETL? Here's everything you need to know.
Feel like you should be able to do so much more with all that data you've been collecting? Now a new class of data tools known as reverse ETL (rETL) can help you move data from a data warehouse into 3rd-party systems to make data operational.
Sylvain Giuliani
Sylvain Giuliani and
Jan 14, 2022
Interviews
How Prolific’s first data hire Jim Lumsden supercharged their brand new sales team with product usage data in Hubspot
Prolific, helps launch studies to thousands of trusted participants in minutes. Jim Lumsden, their Data Lead, joined us to talk about his journey to Prolific and how he drove impact using key product analytics to help the young sales team flourish.
Roslyn Coutinho
Roslyn Coutinho and
Jul 13, 2022
Best Practices
What’s wrong with technical interviews (and how to fix it)
Technical interviews exist to accurately measure a candidate's ability to do the job. But do they deliver on that promise? And how can we fix the broken interview process so it's better for everyone?
Nicole Mitich
Nicole Mitich and
Aug 03, 2022
Interviews
How Hugo’s COO Darren Chait used data to increase conversions with more personalized emails
Meeting productivity hub, Hugo, helps businesses simplify meeting workflows for all their teams. Their COO & co-founder, Darren Chait, joined us to chat about how he used their data to personalize emails & drive conversions.
Roslyn Coutinho
Roslyn Coutinho and
Aug 05, 2022
Product News
Census is a Snowflake Premier Technology Partner for Reverse ETL
Census is now a Snowflake Premier Technology Partner! Mutual customers like Canva, TripActions, Figma, and Notion use Census and Snowflake to help every team get the data they need to act and automate with confidence.
Katy Yuan
Katy Yuan and
Aug 04, 2022
Product News
Census is the #1 Leader in the new G2 Reverse ETL category (thanks to you)
Today we're celebrating a huge milestone: G2, the world’s largest technology review site, has officially recognized Census as the undisputed leader in the G2 Grid® for Reverse ETL! 🎉 It’s not just hype – Reverse ETL is here to stay.
Katy Yuan
Katy Yuan and Roslyn Coutinho
Aug 17, 2022
Product News
Towards Data Contracts with Census: Iterate faster in dbt without breaking business workflows
Today we take the first step towards enabling Data Contracts for Reverse ETL by integrating with your data CI/CD process. We’re releasing dbt Continuous Integration (CI) Checks: a feature to double-check that your dbt work won’t break your syncs.
Katy Yuan
Katy Yuan and
Aug 15, 2022
Latest
Search our full library
Tutorials
Redshift unload: Your complete guide
Not sure where to start when unloading data from Amazon Redshift? We've created a guide that outlines 3 examples, so you know exactly what options are available to you and how to execute them. Here's everything you need to know about Redshift unload.
Volodymyr Grin
Volodymyr Grin and
Aug 18, 2022
Tutorials
Redshift unload: Your complete guide
Not sure where to start when unloading data from Amazon Redshift? We've created a guide that outlines 3 examples, so you know exactly what options are available to you and how to execute them. Here's everything you need to know about Redshift unload.
Volodymyr Grin
Aug 18, 2022
Product News
Census is the #1 Leader in the new G2 Reverse ETL category (thanks to you)
Today we're celebrating a huge milestone: G2, the world’s largest technology review site, has officially recognized Census as the undisputed leader in the G2 Grid® for Reverse ETL! 🎉 It’s not just hype – Reverse ETL is here to stay.
Katy Yuan
Katy Yuan and Roslyn Coutinho
Aug 17, 2022
Product News
Census is the #1 Leader in the new G2 Reverse ETL category (thanks to you)
Today we're celebrating a huge milestone: G2, the world’s largest technology review site, has officially recognized Census as the undisputed leader in the G2 Grid® for Reverse ETL! 🎉 It’s not just hype – Reverse ETL is here to stay.
Katy Yuan
Aug 17, 2022
Product News
Towards Data Contracts with Census: Iterate faster in dbt without breaking business workflows
Today we take the first step towards enabling Data Contracts for Reverse ETL by integrating with your data CI/CD process. We’re releasing dbt Continuous Integration (CI) Checks: a feature to double-check that your dbt work won’t break your syncs.
Katy Yuan
Katy Yuan and
Aug 15, 2022
Product News
Towards Data Contracts with Census: Iterate faster in dbt without breaking business workflows
Today we take the first step towards enabling Data Contracts for Reverse ETL by integrating with your data CI/CD process. We’re releasing dbt Continuous Integration (CI) Checks: a feature to double-check that your dbt work won’t break your syncs.
Katy Yuan
Aug 15, 2022
Best Practices
View all
Best Practices
Starting your data career on the right foot
When starting a data career, you can be overwhelmed by the available options. Census Co-founder & CEO Boris Jabes talked with Scott Breitenother, Founder & CEO of BDC., about how to navigate: Stay calm, seek out chances to learn, and be confident.
Nicole Mitich
Nicole Mitich and
Aug 09, 2022
Best Practices
What’s wrong with technical interviews (and how to fix it)
Technical interviews exist to accurately measure a candidate's ability to do the job. But do they deliver on that promise? And how can we fix the broken interview process so it's better for everyone?
Nicole Mitich
Nicole Mitich and
Aug 03, 2022
Best Practices
What is dbt? An explanation we can all understand.
What's dbt? Maybe you've heard your data teams chatting about it, but when they try to explain it to you technically, you're at a loss. Here's your guide to dbt in a digestible format that even non-technical folks (like you) can understand.
Madison Schott
Madison Schott and
Jun 29, 2022
Sign up for The Operational Analytics Digest to get the best (and freshest) data content from the community delivered to your inbox.
Tutorials
View all
Tutorials
Redshift unload: Your complete guide
Not sure where to start when unloading data from Amazon Redshift? We've created a guide that outlines 3 examples, so you know exactly what options are available to you and how to execute them. Here's everything you need to know about Redshift unload.
Volodymyr Grin
Volodymyr Grin and
Aug 18, 2022
Tutorials
Moving data from Snowflake to Google Sheets
Need to get your data from Snowflake to Google Sheets? With no native integration between the two, you have three options to get your data from one destination to the other: One that's good, one that's bad, and one that's just plain ugly.
Volodymyr Grin
Volodymyr Grin and
Jul 05, 2022
Tutorials
How to sync data from Snowflake to Slack
Want to sync your data from Snowflake to Slack? Look no further! This tutorial will walk you through three methods of syncing data from your data warehouse to Slack: one manual method, one method using APIs, and one using Census reverse ETL.
Michel Zurkirchen
Michel Zurkirchen and
Jul 01, 2022
Join the Operational
Analytics Club
Join the Club
Product News
View all
Product News
Census is the #1 Leader in the new G2 Reverse ETL category (thanks to you)
Today we're celebrating a huge milestone: G2, the world’s largest technology review site, has officially recognized Census as the undisputed leader in the G2 Grid® for Reverse ETL! 🎉 It’s not just hype – Reverse ETL is here to stay.
Katy Yuan
Katy Yuan and Roslyn Coutinho
Aug 17, 2022
Product News
Towards Data Contracts with Census: Iterate faster in dbt without breaking business workflows
Today we take the first step towards enabling Data Contracts for Reverse ETL by integrating with your data CI/CD process. We’re releasing dbt Continuous Integration (CI) Checks: a feature to double-check that your dbt work won’t break your syncs.
Katy Yuan
Katy Yuan and
Aug 15, 2022
Product News
Census is a Snowflake Premier Technology Partner for Reverse ETL
Census is now a Snowflake Premier Technology Partner! Mutual customers like Canva, TripActions, Figma, and Notion use Census and Snowflake to help every team get the data they need to act and automate with confidence.
Katy Yuan
Katy Yuan and
Aug 04, 2022