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.

Our BART Ads and The Power of Informed Decision Making

In September 2017, we ran ten different Ads that lined the entire Montgomery BART platform. Now, read about how all that data came together and how it helped one tourist couple plan out their entire day visiting San Francisco.

Panoply, Stitch and Chartio Partner to Offer the World’s First Automatic Cloud Data Stack

Panoply, Stitch and Chartio announces the world’s first Automatic Cloud Data Stack. The combined offering enables everyone to connect their cloud applications and databases to gain business insight by visualizing their data.

Fire and Rain: How Rain Impacted the NorCal Wildfires

The 2017 Fire Season in Northern California was one of the most costly and deadly on record. 2017 ranks as the most deadly, and is among the most costly in terms of Structures and Acreage Destroyed. We've visualized the data.

How Operations Builds Rocket Ship SaaS 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 on a bell curve, and that bell curve won’t require any manipulation of data. 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

Chartio took over a San Francisco BART station with an advertisement campaign and had to figure out what to do and measure. Read our insights from this journey and examine whether an advetising campaign is right for your business.

How Analytics Drives the Golden State Warriors

The Golden State Warriors are pioneers in using technology in basketball. Kirk Lacob pulls the curtain behind the team’s use of technology, analytics and data science to win. Continue reading as we recap Kirk's session from Ops-Stars.

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. Read this data tutorial to learn 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 definition of a pivot table. Commonly known as an operation in Excel, pivot tables can be done with SQL. Learn how to pivot a table with Amazon Redshift or PostgreSQL.

How To Calculate Annual Recurring Revenue with Salesforce Data

Annual Recurring Revenue is an insightful metric for SaaS businesses to track the dollar amount that comes in every year for a customer’s annual contract. Learn how to use your Salesforce data in Chartio to calculate ARR.

Hi, I’m Your Data Evangelist

Introducing our new Data Evangelist, Tim Miller. As the Data Evangelist, one of his responsibilities is to help convince the world of the importance and the power of data and how to utilize the power of data within an organization.

How to Track First Touch Marketing Attribution with Hubspot Data

Marketing attribution gives conversion credit to a specific touchpoint in the buyer's journey. In this blog post, we’ll walk you through how to track first touch marketing attribution with Hubspot marketing data in Chartio.

The Power and Cost of Hurricanes

September 2017 was the most active month for Atlantic Hurricanes. These hurricanes were large and ran through the US and the Caribbean Islands. We've visualized the data to show the 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. Get 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 measure attribution. In this blog post, we'll examine three ways to use Google Analytics to jumpstart your attribution strategy.

Optimizing Your Content Using Google Analytics

Amazon Redshift is a fully managed, petabyte-scale data warehouse. With that, running complex queries can be taxing against your data warehouse. Get best practices and queries on how to optimize Amazon Redshift performance.

Off the Charts: An Interview with Lukas Biewald of CrowdFlower

In this edition of Off the Charts, 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 cloud-based 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 Off the Charts, a 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

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 in relation to performance.