A blog about data & Ops

5 questions data owners should answer before submitting data discovery requests

While a lot of the lift on data discovery is done by the data team, here are five important questions data owners can ask themselves to make the analysis go smoother (and faster).

How To

4 ways to export CSV files from Redshift

Whether you're Redshift superuser or a newcomer trying to make the most out of all its features, you'll want to export CSV files at one point or another. Here are four solid ways to get the job done.

How To

You oughta know: 5 SQL date functions for business operations

Trying to make heads or tails of all the different SQL date functions out there? Follow our favorite fictional company--Sandy Shores--to learn five date functions to help your business ops.

Lessons learned from implementing DIY & pre-built reverse ETL tooling

Is your bespoke reverse ETL tool snowballing into a maintenance nightmare? Set yourself up for success with a tool like Census and check out these lessons the Perpay team learned from implementing both DIY and out-of-the-box solutions.

Best Practice

Primer on the types and features of fraud prediction models

There's a lot of powerful things you can do with good modeling, not least among the options is fraud prediction. In this article, we'll take a look at the types of fraud prediction models, the features you should include, and how to evaluate these models for your use case.

Company News

Operational analytics has never looked so good 💇

Surprise! Census has a new look (and we're pretty jazzed about it). Here's a deep dive into how we decided on our new color, typography, and logo design.

How To

Introduction to data-driven lead scoring for sales & marketing analysts

Do you wish you knew which leads were most likely to convert and where they needed the most support in their customer journey? Lead scoring can give you the answers you need.

How To

3 ways to export CSV files from Snowflake (and one better idea)

So you want to move your data from Snowflake to the tools, cloud platforms, and reports you love. Here are three ways to do it via CSV file export from Snowflake (and a bonus method to make you happy).

How To

Introduction to marketing mix modeling in Python

Data can help turn your marketing from art into measured science. Here's a primer on how you can harness marketing mix modeling in Python to level up your efforts and insights.

How To

Write to custom contact records with the HubSpot API & Python

Feeling frustrated that you can't leverage all your data in HubSpot to boost sales? Here's a quick and dirty guide to writing to custom contacts using the HubSpot API and a little Python.

How To

Moving customer data from Postgres to Google Sheets with Python

Need to move all your customer data from Postgres into Google Sheets with Python? Here's a quick guide to get from A to B (and a shortcut).

Product Announcement

Announcing the Census Airflow Provider to trigger syncs from your DAGs

Sync scheduling shouldn't stress anyone out. That's why we're excited to announce our newest data orchestration improvement: the Airflow Provider.

Product Announcement

Census has achieved SOC 2 Type 2 compliance 🎉

We know customer data security is more important than ever. So we're excited to announce we're officially SOC 2 Type 2 compliant.

How To

5 essential SQL window functions for business operations

Looking to take your SQL skills to the next level (and save some sanity)? It's time to tackle SQL window functions to unlock advanced analytics and deeper data insights.

Best Practice

Start small when building a modern data stack

Companies often get caught up feeling like they need the entire modern data stack built before they can start getting more out of their data. Instead, you can get started today by focusing on the most important, lowest-lift stack improvements.

Opinion

A nervous system of data sits at the center of the modern company

We often talk about the warehouse as the brain of your business, but it takes a full nervous system of tooling to make the modern data stack possible. Check out the unique role each tool plays in turning your data into action.

How To

Pipedrive API with Python: How to write to contact records

If you've been struggling to use Pipedrive as a sales CRM, but can't figure out how to get the other valuable info your team needs into it, you're in luck. With a bit of custom python, you can significantly improve your sales process.

Operational Analytics Conference 2021

Lessons learned from our first Operational Analytics Conference

Our inaugural Operational Analytics Conference came with a lot of operational and topical lessons. Here's what we walked away with.

Best Practice

New to data orchestration? Start here.

Shiny new tools alone won't rid you of data silos. You need good governance paired with data orchestration services to truly operationalize your data.

Product Announcement

Data orchestration with Census: Announcing trigger syncs via API & dbt Cloud

You shouldn't have to worry about sync scheduling. That's why we're excited to announce trigger syncs via API and dbt Cloud. Free yourself from sync scheduling stress.

Operational Analytics Conference 2021

You need more than technical skills to build a great data career

There's more to a great, meaningful data career than technical skills. To take your career to the moon, you need to invest in people skills to help you understand why your data matters, too.

Operational Analytics Conference 2021

5 Data Leaders on Category Creation

Category creation and definition is, as our experts during the Operational Analytics Conference said, a bit like eating glass. Thankfully, you can spare yourself a few bites and score some second-hand experience from our data leaders round-up here.

How To

Primer on survival analysis in Python for businesses

While machine learning and deep learning are shiny trends, there are plenty of insights you can glean from tried-and-true statistical techniques like survival analysis in python, too. Here's how.

Product Announcement

Census + Braze: Building hyper-targeted segments and personalized emails with your warehouse data

we're excited to excited to officially partner with Braze and announce our Braze Connector 🎉 Send data from your data warehouse to Braze with Census

Customer stories

How Handshake uses Census to track their full customer journey in Salesforce

How Handshake use Census to track their full customer journey in Salesforce to enable their sales team to contact customers at the right time with the right action.

Subscribe to Census Blog