Featured Posts
Understanding Gemini: Costs and Performance vs GPT and Claude
See how Gemini's flash and pro models measure up against GPT and Claude, and understand which ones to use for which tasks.
GPT vs Claude: What's The Best AI Model?
Which models are the most performant and cost effective? Which win at what use cases?
Product-Led Growth With Claude: Turning User Events into Customer Insights
Use product usage metrics to predict next best actions with Claude and Census GPT Columns
The 5 SQL date functions biz ops teams need to know | Census
Trying to figure out all the different SQL date functions out there? Follow a fictional company to learn 5 functions to help your business ops.
How to Export CSV Data from Snowflake | Census
Here's our guide to moving the data you need from Snowflake to the tools, cloud platforms, and reports you love via CSV.
Marketing mix modeling: Python tutorial with example dataset | Census
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.
Write to custom contact records w/ the HubSpot API | Census
Frustrated you can't leverage all your data in HubSpot? Here's a quick & dirty guide to writing to custom contacts w/ the HubSpot API & Python.
How to Hack It: Postgres to Google Sheets w/ Python | Census
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).
Essential SQL window functions for business operations | Census
Looking to take your SQL skills to the next level (and save some sanity)? It's time to tackle SQL window functions like ROW_NUMBER(), AVG(), and more.
Pipedrive API w/ Python tutorial: Contact records | Census
Want to use Pipedrive as your sales CRM, but need to get data from other sources into it? You can hack it with the Pipedrive API and python.
Intro to Survival Analysis in Python | Census
Survival analysis in Python will help you better understand your customers and organization. Here's what you need to get up to speed.
Your guide to revenue cohort analysis | Census
Gather insights pertaining to customer churn, lifetime value, product engagement, stickiness, and more with cohort analysis in SQL.
Enriching your Snowflake data with external functions | Census
Now you can enrich your records, like Users in your warehouse, in a snap. With Snowflakes' External Functions, it's simple to do and a breeze to maintain. Here's how.