Announcements Narrator is SOC 2 Type II Certified Staying accountable to a rigorous compliance framework is one way Narrator aims to keep its customers' data safe and secure.
Unlocking the Value of Data Governance How deploying data governance can bring meaning to your data and accelerate your digital transformation.
Announcements Announcing the Analyze Button Overview of the Analyze Button, the first self service data analysis tool. It creates a full analysis, with recommendations, in one click.
Data Analysis What (actually) is self service analytics? Why data-informed decisions are more important than broad access to data for self service analytics
Data Science When Correlation is Better than Causation A heuristic approach for using correlations to inform decisions
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 How to generate a sequence of integers for most data warehouses, including Postgres, Redshift, BigQuery, Snowflake, and Azure SQL
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
