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.

5 February 2025
GPT vs Claude: What's The Best AI Model?

Which models are the most performant and cost effective? Which win at what use cases?

27 January 2025
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

27 January 2025
Posts about : Tutorials (5)
The 5 SQL date functions biz ops teams need to know | Census

7 September 2021
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

15 July 2021
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

12 July 2021
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

7 July 2021
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

1 July 2021
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

22 June 2021
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

8 June 2021
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

6 May 2021
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

19 January 2021
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
28 October 2020
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.