Opinion Write better SQL: In defense of group by 1 My love for group by 1, 2 developed when I was a fledgling analyst and has only grown. Even if you disagree, I hope this rant will inspire you to be more opinionated in your SQL style.
Opinion Analytics Engineering: Operating with Leverage If your time is valuable, it should be important to you to operate with the highest possible leverage. This allows you to get more done with your fixed number of hours. Simple. Here's how analysts can operate with leverage.
Opinion Five principles that will keep your data warehouse organized The natural state of the universe is chaos: entropy tends to increase in closed systems, and there’s really nothing that we can do about that. So too is the nature of data warehouses: unless action is taken to maintain order.
Opinion A wave of acquisitions in business intelligence Holy crap! Within the past week we’ve seen the acquisitions of the two biggest players in the modern BI landscape, Looker and Tableau.
Opinion Pricing-vision fit Thoughts on pricing strategy and what it communicates about your company's vision for the future of the market you're in.
Opinion Is dbt the right tool for my data transformations? As dbt is adopted by a wider community, we want to be extremely clear about when dbt is, and is not, a fit for your project. This guide will help you figure out if dbt is right for your data transformations.
Opinion The missing layers of the analytics stack Modular analytics tools allow companies to choose components to fit their needs and switch out or augment components as their needs change. Here's what I think is missing from the market.
Opinion What are the steps / tools in setting up a modern, SaaS-based BI infrastructure? Business intelligence tech has changed really dramatically over the past 3-4 years since the advent of cloud-based analytics databases.
Opinion Is Looker the right business intelligence tool for my company? This post, originally published in 2016, was most recently updated in November 2017.
