Data Analysis Self Service Analytics Will business users ever be able to ask ad hoc questions without involving data teams?
Sources and Destinations: Data Engineering In a recent podcast of Sources and Destinations, our CEO Ahmed talks about data engineering, industry confusions and what is it really like to be a data-driven company.
Announcements Building a Data-Driven Culture Without Dashboards Our Head of Data, Brittany, gave a talk about building a data-driven culture without dashboards.
SQL PostgreSQL's missing DateDiff function DATEDIFF is an extremely useful function for analytical queries. Given two timestamps it'll tell you how many days, weeks, months, hours, etc they are apart. Here we show an implementation of this function for Postgres.
Identity Resolution in a privacy-first, cookie-less future: How to prepare tracking for analytics Using a combination of unique page views and a data warehouse, this post walks through how we've been able to get 95% attribution in the world of cookie consent banners and privacy-first updates to devices and modern browsers.
Data Engineering Shareable data analyses using templates We've been using shared data analyses in production for three years. Here's how you can create reusable templates for common metrics and analyses.
Data Engineering How To Do Data Democratization With Flexible Data Modeling Data democratization usually means simple dashboards. Here's how to safely give stakeholders the ability to ask any question
SQL Using PostgreSQL as a Data Warehouse With some tweaking Postgres can be a great data warehouse. Here's how to configure it.
Announcements Making Data Simple Podcast Ahmed joined the Making Data Simple podcast to talk about autonomous cars, WeWork, Narrator, and how to properly ask data questions.
Data Engineering Unleash your data's full potential with a modern data stack How to know if you're ready for a modern data platform built on a data warehouse.
Data Engineering Data Dictionary: A Symptom, not a Solution Having a data dictionary is really a symptom of a complex data modeling layer. With a simpler layer it's possible to avoid maintaining a dictionary altogether.
Data Stories: Fun Insights 5 Startups Found in their Data 5 startups share a story of how they arrived at an interesting insight using their data.
SQL Synthetic Data: Generating realistic user timestamps in SQL How to generate timestamps in SQL that match realistic user behavior data.
Announcements Intelligent Analyses with Ahmed Elsamadisi - Software Engineering Daily Ahmed joined the Software Engineering Daily podcast to talk about Narrator, how to properly do analysis, and our unique approach to modeling data.
Data Analysis The best way to calculate Customer Lifetime Value for Ecommerce Understanding what Customer Lifetime Value is, why it's a useful metric, and how to compute it.
SQL How to generate a series of numbers in SQL for Redshift, Azure, and Snowflake Generating a sequence of integers in Redshift, Azure, and Snowflake
Data Analysis One question to make your data project 10x more valuable Make sure your data analysis is actionable by asking this one question before getting started.
Data Engineering Why you should be using your data warehouse to sync your SaaS tools The most robust and simple way to sync between production systems is to use your warehouse as the single source of truth
Data Science How to choose an attribution model, advice from a data scientist The data-driven way to choose an attribution model
Using customer behavior to drive better product decisions Understanding which customer behaviors lead to conversion is the fastest way to know which product changes to make. As a data person, I frequently get asked for help from product
When good data analyses fail to deliver the results you expect A cautionary tale of a data analysis, a dashboard, and a huge waste of resourcesAny good data analyst will spend their days asking “What action (X) impacts my bottom line
SQL SQL Hack: How to join tables when the key is buried in a blob of text The SituationText blobs are a pain, but they are commonly used with data from email platforms, Salesforce, or dynamic UTMs. In these cases, the JOIN key is probably hidden in
SQL SQL Hack: How to get first value based on time without a JOIN or a Window Function? This is my favorite trick in SQL! If you are like me and have been working with data for a while, you have googled “how to get the first value
Top 10 Signs You Have a Data Modeling Problem 1. Your warehouse is really slowSituation “I just hit Run Query. I am going to get a cup of coffee and hopefully it’s done when I get back.” — Data
Star Schema is Set Up for Failure We interviewed our CEO/co-founder (and ex-Data Engineer) about why star schemas are doomed from the start What is star schema?Star schema is the most common approach to data
