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.

data

Off the Charts: An Interview with Kostas Pardalis of Blendo

In this Off the Charts, we spoke with Kostas Pardalis, CEO and co-founder of Blendo on the adventures of starting a company in Athens, Greece, finding the right talent to grow and building an ETL product for a global market.

Why I Wrote Yet Another SQL Tutorial

If you haven’t yet learned SQL, know someone who’s learning, or want to brush up in our practice areas, check out the new SQL Tutorial.

What 90,000 Dashboards Tell Us About Dashboard Creation

We analyzed 90,000 dashboards, and the findings showed interesting take-aways on dashboard creation, dashboard popularity and viewership.

Building a Data Stack: Amazon Athena + Chartio

We are excited to announce that Chartio supports Amazon Athena, an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Read more about the integration announcement in this blog post.

Customer Awards and State of the Chartio

Recently, we’ve hit notable milestones in our journey to JOIN people ON data. Read about our progress and what customer reviews mean to us.

Will 2018 Be a Good Year to Raise Funds?

Some historical trends tend to indicate whether or not there is VC funding money out there to be won. we dug into the data to determine whether or not the S&P and other market indicators are correlated to funding availability.

Off the Charts: An Interview with Daniil Bratchenko of DataRobot

In this Off the Charts, we spoke with Daniil Bratchenko of DataRobot on the future of analytics, dashboard management, his career in data analytics and managing data governance across a growing company.

Traditional BI Buzzwords for Modern Data Teams

Business Intelligence has a lot of jargon. After seven years in this industry, I'm sharing a curated version of my list with definitions.

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.

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

Read about Chartio's ad campaign at a San Francisco BART station and examine whether an advertising campaign is right for your business.

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

A pivot table reorganizes or summarizes data in a relational table. Learn how to pivot a table with Amazon Redshift or PostgreSQL.

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, Tim is here to help organizations utilize the power of data.

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.

3 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 on as we discuss training data and the evolution of AI.