Featured Posts
Unlock Hidden Revenue with AI-Powered Upsell Scoring and Census AI Columns
How to use AI to identify premium customer characteristics and create Upsell Scores for all customers, then sync high potential individuals to marketing channels
Build a churn prevention campaign for Braze using AI
Learn how to build a churn prevention campaign in Braze powered by AI
AI for RevOps: How We Automated Fit Scoring in Salesforce
Learn how to build an automated ICP analysis and account scoring system in an afternoon using Census AI Columns, transforming weeks of work into actionable sales insights.
How to Fix SQL Compilation Error: Missing Column Specification | Census
If you've been around the Snowflake block a time or two, it's more than likely that you've encountered the dreaded SQL compilation error: "Missing column specification." Here's how to fix it.
Streamline Data Processes with the Data Engineering Lifecycle | Census
Understanding the data engineering lifecycle helps every role on the team perform better and get the results they're after. Check out this SCD session recap to learn how.
Snowflake + SQLAlchemy Tutorial: Installation & Example Queries | Census
SQLAlchemy is one of the most popular libraries to interface with relational databases in Python. So how can you leverage this to interface with Snowflake? Check out this step-by-step tutorial.
Tipping points: How individual decisions make big impacts in data careers & data teams | Census
All of our careers (and the collective careers of our data teams) are the sum of critical decisions made at the right or wrong time. Drizly's data team grew 7x in just 3 years. Here's how.
Diversity in data: Modeling a better future for data teams | Census
When it comes to data, as with all other industries, diversity is crucial. Check out this SCD keynote recap to hear some steps you can take to make your data team more diverse.
Stars, tables, and activities: How do we model the real world? | Census
For 25 years, Ralph Kimball and Margy Ross’s The Data Warehouse Toolkit has provided the mainstream method of data modeling. But is it still relevant? Or is there another alternative?
Operational analytics in B2B startups | Census
Operational analytics empowers organizations, but there are trade-offs between the amount of data you have & its value. Check out this SCD session recap featuring SpatialChat's journey to OA.
Server-side tag manager or reverse ETL: Which one should you use? | Census
How are server-side tag managers and reverse ETL different? How are they similar? Can you use both in your data stack? Here are the answers to these questions and more.
Fix SQL Error 'is not a valid GROUP BY expression' in Snowflake | Census
The SQL compilation error "[...] is not a valid group by expression" is one of the compilation errors in Snowflake SQL. Here's what can cause the error (and an example of how to solve it).
Webinar recap: How Figma operationalizes data across their $20B PLG business | Census
Figma has seen huge success due to their PLG motion. Check out what Praveer Melwani, CFO at Figma, had to say about how they operationalized data to drive revenue across their $20B PLG business.