Insights from the Field
Case-studies, product deep dives, and best practices from the team.
The Context Your Analytics Agent is Missing
Why agentic analytics makes the case for a metrics layer stronger than ever.
James Garbier
The Wrong Layer
Why use-case-first AI strategy is already obsolete, and what to build instead.
Kevin Koenitzer
Data standardization across networked entities
How PE rollups can reduce the cost and complexity of consolidating portco data by standardizing at the source.
Kevin Koenitzer
AI Didn't Replace Me. It Gave Me a Team.
What changes when the team you need is no longer limited by the team you can hire.
Jonathan Arellano
Earning the skeptic's approval
Setting standards for AI development at Snowpack Data
Kevin Koenitzer
Phase Transitions in Business Systems
Classical Analytics Fails at the Boundary
Kevin Koenitzer
Getting Started with Data Contracts
Practical Ways to Protect Your Metrics, Models, and AI Products
Ryan Burton
Two Approaches to dbt Slim CI
For data teams of varying sizes and maturity
Danny Blumenthal
From Complexity to Clarity: Building a Funnel Forecasting Model
A case study in using Markov chains and hazard functions to replace complex heuristic models
Nate Robinson
A Semantic Layer Solution for dbt Core Users at Last?
Enter Hex's new Semantic Model Sync
Danny Blumenthal
Case Study: Looker Dashboard Embedding
The cost benefits of metric stores and the technical challenges of dashboard embedding
Nate Robinson
Cloud Data Warehouses
A guide to choosing a modern cloud data warehouse
Nate Robinson
New Technology Implementation
Why you’re thinking about it (and doing it) wrong
Kevin Koenitzer
Federated Datasets
A guide to building useful (and useable) datasets.
David Olodort
Data Engineering in Modern Organizations
A framework for managing and structuring a data engineering team
Kevin Koenitzer
The Decision-Makers Guide To Building a Data Stack
Part 2: Cloud Storage - What it is, and why we need it
Kevin Koenitzer
The Decision-Makers Guide To Building a Data Stack
Part 1: Introduction to problems and solutions that modern data teams face
Kevin Koenitzer
Running Predictive Models Natively in dbt
A barebones approach for simple prediction models using only SQL + Jinja
Danny Blumenthal
Dagster and dbt: A Perfect Match
A powerful combo for orchestrating your data worfklows
Danny Blumenthal
Case Study: Building Replo's ETL Process
Building a modern end-to-end data stack
Danny Blumenthal
Case Study: Workforce Enhancement
Addressing key analytics staffing constraints in fast-growing organizations
Kevin Koenitzer
Case Study: Mosaic.tech
Metric Development and Modeling a Reporting Layer
Snowpack Data
Building Project Cronos
A peek into the development of our internal time tracking and project management tool
Nate Robinson
Introducing Project Cronos
Snowpack's custom project management software
Nate Robinson
The World of BI Tools
Our thoughts on some of the most popular BI tools on the market today.
Nate Robinson
Case Study: Improving Grid's ETL
Realizing an 80% reduction in BigQuery costs
Nate Robinson
Rapid Reports - Simple Metric Reports
Have we lost track of the goal of BI Tooling, and what can we do about it?
Kevin Koenitzer & Nate Robinson
Speed to Insights
The Value of Modern Data Tooling for Finance Organizations
David Shore
What is the modern data stack?
And why are so many people talking about it?
Kevin Koenitzer
Why Foundational Analytics
Why we invest in foundational layers, and remain flexible on consumer tooling
Nate Robinson
Why We Started Snowpack
Or how we learned to embrace the data journey
Nate Robinson