The Chartio Blog

Expert advice on business intelligence to help drive data at your company.
Sign up to get the latest data tips delivered to your inbox.

How Operations Builds Rocket Ship SaaS Companies

Operations has quickly become one of the most sought-after roles for growing companies. Learn the role of Operations plays in building and maintaining SaaS rocket ship companies from delivering metrics, balancing strategy versus tactics and working as a centralized Operations team across a larger organization.

Normal Distributions and Their Abnormal Occurrence

If a collection of data is normally distributed we’ll see the results show very nice and neat on a bell curve, and that bell curve won’t require any manipulation of data. The fact of the matter is, and this might be hard to hear, normal is rare. Almost no randomly arrayed statistic is normally distributed. Shockingly, normal is weird.

Read more to find out how a bell curve and a real curve compare.

Taking over the BART: Why and how we ran a metro advertising campaign in San Francisco

In September 2017, Chartio took over the Montgomery BART station with an advertisement campaign. Entering into the world of metro advertising wasn't easy. We couldn't just read a report and know exactly what to do and measure.

We were skeptical, cautious and excited. To say the least, we learned a lot, and now we're sharing those learnings with you.

How Analytics Drives the Golden State Warriors

The Golden State Warriors are pioneers in using technology in basketball. As the keynote discussion during Ops-Stars, Kirk Lacob of the Golden State Warriors pulled the curtain behind the team’s use of technology, analytics and data science to win.

Continue reading as we recap the session with Kirk and Mark Emmons from LeanData.

Grouping with a Case Statement

Using GROUP BY allows you to group columns to run specific SQL queries like aggregating data into a SUM, AVG or COUNT. With that, know which of the columns you want to GROUP BY and how you want to group them is important.

Continue reading our Data Tutorial as we walk you through how to use a CASE STATEMENT to GROUP a column with an alias or new string.

Pivoting a Table with Amazon Redshift or PostgreSQL

Changing the makeup of a relational table and summarizing it is the basic definition of a pivot table. Most people know pivot tables as an operation in Excel, but you can also create powerful pivot tables just as easily by writing SQL in a data analytics tool.

Continue reading our Data Tutorial on How to Pivot a Table with Amazon Redshift or PostgreSQL.

How to Create a Social Media Dashboard

A Social Media dashboard enables you to measure your company’s social activities from Twitter engagement, Facebook comments to LinkedIn shares. With a dashboard, you can understand what’s working and what isn’t, and proactively work to optimize each social channel.

Continue reading as we walk you through how to create a Social Media dashboard that quantifies ROI.

How To Calculate Annual Recurring Revenue with Salesforce Data

Annual Recurring Revenue, or ARR, is an insightful metric for B2B SaaS businesses to track the total dollar amount that comes in every year for the duration of a customer’s annual contract. No matter the size of your company or industry, ARR is a universal metric that gives businesses the most insight about the success of their business.

Continue reading to learn how to use your Salesforce data in Chartio to calculate ARR in two simple steps.

Hi, I’m Your Data Evangelist

Hi, my name is Tim and I am your new Data Evangelist. For the past year and a half I’ve worked as a Customer Success Engineer. It is more than possible that I helped you through one of your tickets, helped you build a dashboard or trained you during one of our customer webinars or on-site visits. If none of that rings true, then you’ll simply know my henceforth as your Data Evangelist. 

How to Track First Touch Marketing Attribution with Hubspot Data

Marketing attribution continues to be a hot topic of conversation for marketing teams, no matter the industry or size of the organization. As marketers are beginning to leverage data and dive into the analytics of their marketing campaigns, it has become apparent that marketing attribution is still a hurdle for many of us.

In this blog post, we’ll walk you through how to track first touch marketing attribution with Hubspot data in Chartio. In implementing, a first touch attribution model, you’ll be able to iterate on campaigns, content and messaging faster and earlier on.

The Power and Cost of Hurricanes

According to, September 2017 was the most active month on record for Atlantic Hurricanes. These hurricanes were large, dangerous and deadly and ran through the United States and the Caribbean Islands, leaving vast destruction and death in their wakes. We've visualized the data to show just how magnitude and destruction of these hurricanes. 

The Importance of Practicing Good Data Hygiene with Your Visualization Tool

Practicing good data hygiene is crucial. Not only for data teams, but for every aspect of the business. Good data hygiene is like washing your hands. I’ll explain it all in this blog post and provide best practices on how to implement good data hygiene at your organization. 

Three Ways to Track Marketing Attribution in Google Analytics

Marketing attribution is challenging. However, you can use Google Analytics as a starting point to understanding and measure attribution. In this blog post, we’ll walk you through three ways to use Google Analytics to jumpstart your attribution strategy.

How to Create a Customer Success Dashboard

As customers are the livelihood of your business, having a bird’s-eye-view on the revenue activity generated from your customers is crucial for growth. A Customer Success dashboard monitors the health of this growth.

In this blog post, we’ll show you how to create a Customer Success dashboard that optimizes for growth.

How to Create a CEO Dashboard

A CEO dashboard visualizes your business data and tracks the health of your business by measuring revenue trends, growth and operational cash flow. In this blog post, get a breakdown on which metrics to track and how to create your own dashboard in Chartio.

Optimizing Your Content Using Google Analytics

With more and more content out there, companies are looking for ways to rise above the noise and optimize their content. In this blog post, we’ll uncover five ways to optimize your content while leveraging Google Analytics.

Off the Charts: An Interview with Lukas Biewald of CrowdFlower

In this edition of Off the Charts, an interview series where we chat with individuals doing industry-changing work in the data space, we spoke with Lukas Biewald of CrowdFlower. 

Read our interview with Lukas as we discuss the importance of training data and the evolution of Artificial Intelligence. 

The Guide to Building an End-to-End Data Stack

If you have yet invest in an end-to-end data stack, this white paper will be core to your evaluation process. For more insight, download our white paper The Guide to Building an End-to-End Data Stack.

Off the Charts: Jake Stein, Yaniv Leven and Dave Fowler

In this edition of Off the Charts, an interview series where we chat with individuals doing industry-changing work in the data space, we spoke with Jake Stein, Yaniv Leven and Dave Fowler about the current state and future of data technologies.

How to Optimize Amazon Redshift Performance

In running complex queries against large amounts of data within your Amazon Redshift data warehouse, it can be taxing on the overall system. It’s important to apply best practices and resolve optimization issues fast, because the longer you wait, the fewer real-time insights you’ll have access to and the more deep debugging awaits you in the future. This post will take you through the most common issues Amazon Redshift users come across, and will give you advice on how to address each of those issues.