Recent posts

Open Source your SQL queries

What would happen if we all took our SQL snippets and pooled them in one place? Would we coalesce around standardized and best-in-class solutions to common problems? Would we save ourselves hours of work looking up the same syntax again and again?
T
Jul 21, 2021
3 minute read

Bringing Notebooks to Snowflake

Two of the most significant trends in data are changing how we work. The first is the rise of cloud data warehouses, like Snowflake, and the second is the rise of notebooks. Count was designed for both.
T
Jun 14, 2021
5 minute read

Dashboards are Dead

Dashboards have been the primary weapon of choice for distributing data over the last few decades, but they aren’t the end of the story. To increasingly democratise access to data we need to think again.
T
Apr 9, 2020
7 minute read

How to Make Sure Your Analysis Actually Gets Used

One of the most universally demoralizing experiences is to see the results of your hard work go unseen, unappreciated, and unused. Here is a list of tips to make sure your analysis gets the credit it deserves.
T
Mar 9, 2021
7 minute read

The Analytical Workflow is Broken

The tools analysts use today were all built for a particular purpose at a particular time. But these same tools are holding us back. Now is the ideal time to step back and see what of these legacy tools we carry with us, and what we leave behind.
T
Feb 25, 2021
4 minute read

Your Organization's First Notebooks

Notebooks are powerful tools with multiple use cases. But what's the best way to bring them into your organization? Where can they have the biggest impact?
T
Feb 25, 2021
3 minute read

The Tableau Era is Over

The announcement last week that Tableau’s CEO Adam Selipsky is stepping down felt more significant than the casual media coverage it received. To me, it was a signal that the murmurings of discontent I’ve been hearing were true: Tableau is over.
T
Mar 28, 2021
6 minute read

Numbers Are No Longer Enough

To make better decisions, we need data tools that communicate more than just numbers. With all the hype around data, it can be easy to forget that data is about making better decisions.
T
Feb 24, 2021
4 minute read

Using BigQuery Arrays to Analyse my Netflix Viewing History

Once I heard you could request all your personal data from Netflix , I was excited to dig in to see what I could find. In the end I not only learned a lot about myself — like which season of Friends I watch the most (Season 6) — but it was also a great opportunity to put BigQuery’s analytical capabilities to the test.
T
Feb 8, 2021
4 minute read

Take your SQL from Good to Great: Part 4

Window functions are some of the most beloved functionality for SQL users. They are very powerful, and quickly eliminate the need for nested subqueries and annoying cross joining.
T
Jun 14, 2021
5 minute read

Take your SQL from Good to Great: Part 3

JOINs aren’t anyone’s favorite part of SQL. They aren’t as flashy as window functions or as transformational as CTEs. And yet, they’re arguably our most powerful tool to access and transform relational data.
T
Jun 10, 2021
5 minute read

Take your SQL from Good to Great: Part 2

Last week I saw a tweet that got me thinking: what are the SQL ‘hacks’ I would go back and teach myself sooner if I could? This simple question quickly turned into a series of articles that expounds on some of my favorite methods explaining both why they’re useful, and how to use them
T
May 19, 2021
5 minute read

Take your SQL from Good to Great: Part 1

Last week I saw a tweet that got me thinking: what are the SQL ‘hacks’ I would go back and teach myself sooner if I could? This simple question quickly turned into a series of articles that expounds on some of my favorite methods explaining both why they’re useful, and how to use them
T
Apr 22, 2021
4 minute read

A Call for Better Analytical Tools

Now more than ever, we depend on data to make better decisions and to stay ahead of the competition. The analytical tools we use are starting to hold us back, though. Between frankensteined dashboards, an impossibly fractured workflow, and an insatiable demand for data, we're in desperate need of new tools to move us forward.
T
Mar 3, 2021
1 minute read

How to Reduce Your Analytics Costs with BigQuery Partitioned Tables

BigQuery is one of the most popular data warehouses in the market today, but if you aren't careful you can easily rack up a debilitating bill. If BigQuery powers your analytics stack then partitioned tables can be a no-brainer solution to keeping costs down.
T
Mar 5, 2021
5 minute read

The Self-Service Myth

Building a data democracy is difficult, but not impossible. No tool can fix things like culture or create processes for you, but how well any tool integrates with these parts of your business can make the difference between making your data democracy a new reality, or just a failed experiment.
T
Apr 30, 2020
8 minute read

What is a Histogram?

In this post we’re going to touch on the elusive histogram. Ok, maybe it’s not elusive, but it’s one of those concepts that some of your team might struggle with but is actually pretty simple when it’s broken down.
T
Mar 5, 2020
4 minute read

Portrait mode: What is the future of dashboards?

We need BI tools that are easy to use and deeply collaborative. Are dashboards up to the task?
T
Jun 19, 2020
9 minute read

Why your Data Literacy training isn't working

We need to rethink the way we do data training if we truly want to make it accessible to everyone.
T
Feb 7, 2020
5 minute read

4 things developers can teach us about data

Data has made a home between worlds, but most frequently data teams are wedged between the technical and operational sides of the business. While often that can make us feel like misfits, it actually puts us in an incredible position to leverage the best of these worlds in our own domain.
T
May 5, 2020
7 minute read

The Life of an Analyst

Which one of these workflows describes you?
T
Feb 16, 2021
1 minute read

Free and paid tools for ETL and data integration

Here at Count we're firm believers that having all of your data in one place makes it much more useful - all of the information crucial to your business is just a LEFT JOIN away.
J
Jun 4, 2021
3 minute read

Plotting libraries for Python compared

You've got some data, let's get it on the screen. This article will review some simple 'hello world' examples of the most popular plotting libraries for python.
J
Jun 4, 2021
4 minute read

Best Jupyter Alternatives For Data Analysis

Jupyter notebooks have become the de-facto tool for anyone doing data analysis in the last few years, and it's no wonder why. Data analysis is particularly iterative and the linear format makes it easy to build up your code step-by-step.
T
Jun 4, 2021
3 minute read

How to query PostgreSQL in Python

PostgreSQL is one of the market-leading databases, and being able to access this data easily in Python is key for any data scientist. This article walks through the basics of how to query your PostgreSQL data in Python.
T
Jun 3, 2021
3 minute read

How to parameterize your SQL queries

When writing SQL you may find yourself repeating similar logic, but swapping out simple parameters. If you're copying and pasting queries just to replace a user_id, it's time to look at query parameterization.
J
Jun 3, 2021
3 minute read

How to query BigQuery in Python

BigQuery is one of the market-leading data warehouses, and being able to access this data easily in Python is key for any data scientist. This article walks through the basics of how to query your BigQuery data in Python.
T
Jun 3, 2021
3 minute read

How to share your SQL queries online

How many times have you ended up copying and pasting a long and complex SQL query into an email or instant message? In this article we will review some tools and online SQL editors for sharing queries online.
J
Jun 3, 2021
2 minute read

Jupyter notebooks for SQL

Jupyter notebooks have been the tool of choice for data scientists for the last few years. These computational notebooks give analysts a way to build up their analysis step-by-step using cell blocks and annotate along the way using text blocks.
T
Jun 3, 2021
3 minute read

Best BigQuery visualization tools

Google BigQuery is an excellent choice for a cloud-based data warehouse. Unfortunately the BigQuery UI is still relatively rudimentary, so to visualize any query results you'll need to use a separate tool.
J
Jun 3, 2021
2 minute read

Best visualization tools for Snowflake

Snowflake is a data warehouse that's been built for the cloud. It provides a fast and robust engine for storing and querying data, but what's data without a way to visualize and communicate insights?
T
Jun 3, 2021
3 minute read

Website KPI report built from Google Analytics

You've got a website, but now you want to understand how your website is performing. You need to build a report based on Key Performance Indicators (KPIs).
J
Jun 3, 2021
4 minute read

Build the first KPI report for your startup

Starting a company is not simple, and it's easy to start making decisions based on gut feeling. To succeed, you'll need adopt data-driven decision making based on the most appropriate Key Performance Indicators.
J
Jun 3, 2021
4 minute read

An Introduction to SQL Notebooks

SQL notebooks are a type of computational notebook that enables SQL to be written and executed. In this article we compare several different implementations.
T
Jun 2, 2021
2 minute read

How to Version Control Your SQL Queries

In an era when nearly everything we do is version-controlled, it's hard to imagine that most of our SQL queries are not.
T
May 26, 2021
4 minute read

How to Build a KPI Report

KPIs (Key Performance Indicators) are the metrics that best indicate the performance of your business. This article will teach you how to create a KPI report effectively.
T
May 26, 2021
3 minute read

Best Online SQL Editors

Traditionally, SQL queries are run either directly in the terminal (super old school), or through a SQL IDE that runs on your desktop (still pretty old school). But recently, there's been an uptick in browser-based SQL editors that aim to bring SQL into the modern technical landscape.
T
May 25, 2021
2 minute read

How to Migrate from Chartio to Count

Chartio is joining Atlassian, which means we can expect some cool analytics in Atlassian soon, but it also means your dashboards are going to need a new home...quickly. This guide walks you through how to migrate your Chartio dashboards to Count notebooks.
T
Mar 3, 2021
3 minute read

Bringing Notebooks to Snowflake

Two of the most significant trends in data are changing how we work. The first is the rise of cloud data warehouses, like Snowflake, and the second is the rise of notebooks. Count was designed for both.
T
Jun 14, 2021
5 minute read

The Analytical Workflow is Broken

The tools analysts use today were all built for a particular purpose at a particular time. But these same tools are holding us back. Now is the ideal time to step back and see what of these legacy tools we carry with us, and what we leave behind.
T
Feb 25, 2021
4 minute read

Numbers Are No Longer Enough

To make better decisions, we need data tools that communicate more than just numbers. With all the hype around data, it can be easy to forget that data is about making better decisions.
T
Feb 24, 2021
4 minute read

Take your SQL from Good to Great: Part 4

Window functions are some of the most beloved functionality for SQL users. They are very powerful, and quickly eliminate the need for nested subqueries and annoying cross joining.
T
Jun 14, 2021
5 minute read

Take your SQL from Good to Great: Part 3

JOINs aren’t anyone’s favorite part of SQL. They aren’t as flashy as window functions or as transformational as CTEs. And yet, they’re arguably our most powerful tool to access and transform relational data.
T
Jun 10, 2021
5 minute read

Take your SQL from Good to Great: Part 1

Last week I saw a tweet that got me thinking: what are the SQL ‘hacks’ I would go back and teach myself sooner if I could? This simple question quickly turned into a series of articles that expounds on some of my favorite methods explaining both why they’re useful, and how to use them
T
Apr 22, 2021
4 minute read

How to Reduce Your Analytics Costs with BigQuery Partitioned Tables

BigQuery is one of the most popular data warehouses in the market today, but if you aren't careful you can easily rack up a debilitating bill. If BigQuery powers your analytics stack then partitioned tables can be a no-brainer solution to keeping costs down.
T
Mar 5, 2021
5 minute read

What is a Histogram?

In this post we’re going to touch on the elusive histogram. Ok, maybe it’s not elusive, but it’s one of those concepts that some of your team might struggle with but is actually pretty simple when it’s broken down.
T
Mar 5, 2020
4 minute read

Portrait mode: What is the future of dashboards?

We need BI tools that are easy to use and deeply collaborative. Are dashboards up to the task?
T
Jun 19, 2020
9 minute read

The Life of an Analyst

Which one of these workflows describes you?
T
Feb 16, 2021
1 minute read

Free and paid tools for ETL and data integration

Here at Count we're firm believers that having all of your data in one place makes it much more useful - all of the information crucial to your business is just a LEFT JOIN away.
J
Jun 4, 2021
3 minute read

Best Jupyter Alternatives For Data Analysis

Jupyter notebooks have become the de-facto tool for anyone doing data analysis in the last few years, and it's no wonder why. Data analysis is particularly iterative and the linear format makes it easy to build up your code step-by-step.
T
Jun 4, 2021
3 minute read

How to parameterize your SQL queries

When writing SQL you may find yourself repeating similar logic, but swapping out simple parameters. If you're copying and pasting queries just to replace a user_id, it's time to look at query parameterization.
J
Jun 3, 2021
3 minute read

How to share your SQL queries online

How many times have you ended up copying and pasting a long and complex SQL query into an email or instant message? In this article we will review some tools and online SQL editors for sharing queries online.
J
Jun 3, 2021
2 minute read

Best BigQuery visualization tools

Google BigQuery is an excellent choice for a cloud-based data warehouse. Unfortunately the BigQuery UI is still relatively rudimentary, so to visualize any query results you'll need to use a separate tool.
J
Jun 3, 2021
2 minute read

Website KPI report built from Google Analytics

You've got a website, but now you want to understand how your website is performing. You need to build a report based on Key Performance Indicators (KPIs).
J
Jun 3, 2021
4 minute read

An Introduction to SQL Notebooks

SQL notebooks are a type of computational notebook that enables SQL to be written and executed. In this article we compare several different implementations.
T
Jun 2, 2021
2 minute read

How to Build a KPI Report

KPIs (Key Performance Indicators) are the metrics that best indicate the performance of your business. This article will teach you how to create a KPI report effectively.
T
May 26, 2021
3 minute read

How to Migrate from Chartio to Count

Chartio is joining Atlassian, which means we can expect some cool analytics in Atlassian soon, but it also means your dashboards are going to need a new home...quickly. This guide walks you through how to migrate your Chartio dashboards to Count notebooks.
T
Mar 3, 2021
3 minute read

Dashboards are Dead

Dashboards have been the primary weapon of choice for distributing data over the last few decades, but they aren’t the end of the story. To increasingly democratise access to data we need to think again.
T
Apr 9, 2020
7 minute read

How to Make Sure Your Analysis Actually Gets Used

One of the most universally demoralizing experiences is to see the results of your hard work go unseen, unappreciated, and unused. Here is a list of tips to make sure your analysis gets the credit it deserves.
T
Mar 9, 2021
7 minute read

Your Organization's First Notebooks

Notebooks are powerful tools with multiple use cases. But what's the best way to bring them into your organization? Where can they have the biggest impact?
T
Feb 25, 2021
3 minute read

The Tableau Era is Over

The announcement last week that Tableau’s CEO Adam Selipsky is stepping down felt more significant than the casual media coverage it received. To me, it was a signal that the murmurings of discontent I’ve been hearing were true: Tableau is over.
T
Mar 28, 2021
6 minute read

Using BigQuery Arrays to Analyse my Netflix Viewing History

Once I heard you could request all your personal data from Netflix , I was excited to dig in to see what I could find. In the end I not only learned a lot about myself — like which season of Friends I watch the most (Season 6) — but it was also a great opportunity to put BigQuery’s analytical capabilities to the test.
T
Feb 8, 2021
4 minute read

Take your SQL from Good to Great: Part 2

Last week I saw a tweet that got me thinking: what are the SQL ‘hacks’ I would go back and teach myself sooner if I could? This simple question quickly turned into a series of articles that expounds on some of my favorite methods explaining both why they’re useful, and how to use them
T
May 19, 2021
5 minute read

A Call for Better Analytical Tools

Now more than ever, we depend on data to make better decisions and to stay ahead of the competition. The analytical tools we use are starting to hold us back, though. Between frankensteined dashboards, an impossibly fractured workflow, and an insatiable demand for data, we're in desperate need of new tools to move us forward.
T
Mar 3, 2021
1 minute read

The Self-Service Myth

Building a data democracy is difficult, but not impossible. No tool can fix things like culture or create processes for you, but how well any tool integrates with these parts of your business can make the difference between making your data democracy a new reality, or just a failed experiment.
T
Apr 30, 2020
8 minute read

Why your Data Literacy training isn't working

We need to rethink the way we do data training if we truly want to make it accessible to everyone.
T
Feb 7, 2020
5 minute read

4 things developers can teach us about data

Data has made a home between worlds, but most frequently data teams are wedged between the technical and operational sides of the business. While often that can make us feel like misfits, it actually puts us in an incredible position to leverage the best of these worlds in our own domain.
T
May 5, 2020
7 minute read

Plotting libraries for Python compared

You've got some data, let's get it on the screen. This article will review some simple 'hello world' examples of the most popular plotting libraries for python.
J
Jun 4, 2021
4 minute read

How to query PostgreSQL in Python

PostgreSQL is one of the market-leading databases, and being able to access this data easily in Python is key for any data scientist. This article walks through the basics of how to query your PostgreSQL data in Python.
T
Jun 3, 2021
3 minute read

How to query BigQuery in Python

BigQuery is one of the market-leading data warehouses, and being able to access this data easily in Python is key for any data scientist. This article walks through the basics of how to query your BigQuery data in Python.
T
Jun 3, 2021
3 minute read

Jupyter notebooks for SQL

Jupyter notebooks have been the tool of choice for data scientists for the last few years. These computational notebooks give analysts a way to build up their analysis step-by-step using cell blocks and annotate along the way using text blocks.
T
Jun 3, 2021
3 minute read

Best visualization tools for Snowflake

Snowflake is a data warehouse that's been built for the cloud. It provides a fast and robust engine for storing and querying data, but what's data without a way to visualize and communicate insights?
T
Jun 3, 2021
3 minute read

Build the first KPI report for your startup

Starting a company is not simple, and it's easy to start making decisions based on gut feeling. To succeed, you'll need adopt data-driven decision making based on the most appropriate Key Performance Indicators.
J
Jun 3, 2021
4 minute read

How to Version Control Your SQL Queries

In an era when nearly everything we do is version-controlled, it's hard to imagine that most of our SQL queries are not.
T
May 26, 2021
4 minute read

Best Online SQL Editors

Traditionally, SQL queries are run either directly in the terminal (super old school), or through a SQL IDE that runs on your desktop (still pretty old school). But recently, there's been an uptick in browser-based SQL editors that aim to bring SQL into the modern technical landscape.
T
May 25, 2021
2 minute read
Data is more than numbers
Sign up to our newsletter to receive our latest content
Sign up
Thanks for signing up!