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.

Building a Data Stack: Amazon Athena + Chartio

We are excited to announce that we now support Amazon Athena, an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Together, Chartio and Amazon Athena allow users across an organization to quickly analyze large-scale datasets and get insights. 

Customer Awards and State of the Chartio

In the past couple of years we’ve hit some very significant milestones along our ever going journey to JOIN people ON data. We envision a future where anyone (not just data analysts or scientists) can explore and understand their data

Read more about the State of Chartion 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 took a dive into the data available to determine whether or not the S&P and other market indicators are correlated to funding availability.

Your SaaStr Survival Guide

Three days, over ten thousand attendees and at least five things all happening at once.

Welcome to SaaStr Annual! We've scoured the official schedule for the best SaaStr events and dedicated many nights and mornings taste testing food and sipping coffee nearby the conference venue - all in the name of saving you time. Check out our picks for sessions, restaurants, cafes and events during SaaStr.

The Importance of Usability for Business Intelligence Platforms

Usability is one of the most important features of any platform. For Business Intelligence platforms, usability is paramount to user adoption and can signal the difference between invaluable insights and zero visibility. Learn what the data from G2 Crowd’s Usability Index says about BI platforms.

Buffalo Winter Weather: is it Really That Cold?

Have you ever spent January in Buffalo? I have. A Lot. Eighteen times actually, I grew up there. In fairness, I left there as soon as I could, and moved a little farther west and south, and then 15 years later decided to leave because (among MANY other reasons) I had had my fill of winter.

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.

The Disparity Between Median Household Incomes and the Cost of Buying a Home

Housing Prices are skyrocketing! Heard that one before? Yeah, me too.

So I went to the internet to find data on the cost of housing in the United States broken down by state and then found a source that gave me information on the average cost of a home in those states as well.

GDPR Statement

On May 25th, 2018, The EU GDPR (General Data Protection Regulation) will go into effect. This regulation enhances the data privacy protections for European Union citizens and is a mandatory requirement for any company with access to personal data of EU citizens. Chartio is both a controller and processor in the context of GPDR with many customers in the EU - meaning we are actively working on GDPR preparations.

Distance Running and its Closing Gender Gap

Taking a closer look at the NYC and Boston Marathons you will see a trend that is very interesting. These two races gather the most elite of elite marathon runners in the world on both sides of this gender gap, whereas the smaller races like in Casper, or Albuquerque, or Marshall do not necessarily gain the attention of the world’s elite. It looks like the gap between men and women is narrowing.

Traditional BI Buzzwords for Modern Data Teams

Business Intelligence is an incredibly jargon filled industry. After seven years of being in this industry, I believe I've heard most of them. Now I'm sharing a curated version of my list and definitions with you to help modern data team understand traditional concepts and help traditional BI users understand the modern take on these concepts.

Our BART Ads and The Power of Informed Decision Making

In September, we ran 10 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 today announced the availability of the world’s first Automatic Cloud Data Stack. The combined offering enables data analysts and business users to connect to disparate cloud applications and databases and 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. When ranked against the yearly totals for the last 14 years, 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

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.