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

Is Silicon Valley Losing Its Lead? The Status of VC Funding

The fact that California, and especially the Bay Area, leads the U.S. in Venture Capital (VC) funding in all rounds isn’t new news.  But is this changing?  We took a look at all early VC funding rounds (Seed, Series A, and Series B) were also staying mostly in California or if other areas in the U.S. were starting to pull some of that funding away from the Golden State.

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.

5 Tips for Selecting the Right Data Warehouse

In this article, you’ll find out what exactly a data warehouse is, information on data warehouse architecture, and most importantly, tips on how to select the right data warehouse for your company.

What 90,000 Dashboards Tell Us About Dashboard Creation

We analyzed 916,000 charts on 90,000 dashboards, and the findings showed interesting take-aways on dashboard creation, dashboard popularity and viewership. Continue reading to learn the insights we found after analyzing the data.

Customer Awards and State of the Chartio

In the past couple of years we’ve hit significant milestones in our journey to JOIN people ON data. We envision a future where anyone can explore their data. Read more about the State of Chartio 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.

Your SaaStr Survival Guide

We've scoured the schedule for the best SaaStr events and dedicated many nights and mornings taste testing food and sipping coffee nearby the conference venue. Check out our picks for sessions, restaurants, cafes and events.

Buffalo Winter Weather: is it Really That Cold?

Is it really that cold in Buffalo, New York? In this blog post, our Data Evangelist put that question to the test and let the data answer that question for us. Read this blog post to learn if, in fact, Buffalo is really that cold.

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

Is the price of purchasing a home in the United States skyrocketing? We dug through the median income and home cost data to find out if this trends was true or false, broken down by state. Read what we uncovered from the data.

Distance Running and its Closing Gender Gap

In this blog post, we examine whether or not there is a closing gender gap in the world of distance running. Continue reading as we delve deeper into this question and provide answers by way of data analysis.

Traditional BI Buzzwords for Modern Data Teams

Business Intelligence has a lot of jargon. After seven years of being in this industry, I'm sharing a curated version of my list and definitions to help modern data team understand traditional concepts and take on these concepts.

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.

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.