This article originally appeared on Column Five.
Data storytelling is one of the best tools out there for content marketers. But for data noobs it can seem super intimidating. Where do you get data? What do you do when you have it? How do you find stories in data? Relax. We’ve been doing this a while, and we’re here to help you get through it.
HOW TO FIND STORIES IN DATA
Good stories don’t just come from data; they’re actually hidden in data relationships. When you start to play with your data, you begin to see how each data point relates to another. The patterns you see (or don’t) help uncover what—if any—story is there. Understanding what type of data relationships to look for helps you find those stories faster. But first, let’s guide you through the steps to get to that point.
STEP 1: GET YOUR DATA
This is where most marketers get tripped up. You have a spreadsheet in front of you with a few or a million data points. The first step? Make sure it’s clean and organized.
Organize your data: Most of the time you’ll be working with data from a spreadsheet. The format of your data depends on what kind you have. Let’s talk about different kinds of data.
- Is this data one point in time? For example, If you have data from a 2017 survey, you’d have survey questions in the column and answers in the rows.
- Are there multiple time periods with only one observation? For example, if you have data on Apple stock prices from 1990-2016, the format would have years in the rows and the variable or stock prices in the columns. Note: If years and the variable are switched, no big deal. Spreadsheets have a function where you can paste the values “Transposed.” This will switch the rows and columns of the data.
- What if your data has multiple observations over a time period? Let’s say you have a dataset that has info on multiple countries from 1990-2016. This data will still have years in the rows, but each column will specify which observation is for that particular year. In this example, you would have a “country” variable that identifies which country the data is referring to.
Identify missing values or bad data: These make you a less credible source since your statistics will be wrong. Do a visual inspection to make sure that the data points make sense. For example, if the data set measures human weights, does it make sense for someone to be 2,000 pounds? Get rid of rows where there are tons of missing data.
Look for outliers in your data: These would be data points that don’t seem to fall into your range of expectations. Outliers are usually thought of as a nuisance, but they could also offer interesting stories and insights. For example, if we expect sales to go down in all counties, then a spike in sales in one county would be an outlier (more on that later).
STEP 2: VISUALIZE YOUR DATA
When we talk about data visualization at this stage, we’re not talking about the beautiful data visualizations your designers create. It’s simply the tools that let you literally “see” your data. (This is why we love data visualization so much—it’s an easy way for our brains to understand what we’re looking at.) Technically, this phase is referred to as exploratory data analysis, but we don’t want you to get too overwhelmed too quick.
For this example, we’re using Google Sheets.
1) Highlight the data you want to visualize.
2) Click on “Insert” and scroll down to “Chart.”
From the “Chart” editor you can use the recommended charts or choose your own graphs by clicking on the “Chart Types” tab. The “Customization” tab allows you to do things like rename your title and axes, change colors, or increase the font size.
Remember that different types of data are best represented with certain types of graphs. In the next section, we’ll cover what kinds of graphs can help you answer your data questions.
STEP 3: EXAMINE DATA RELATIONSHIPS
This is actually the fun part where you start to search for your story by examining relationships. As you play around with visualizations and analyze according to relationship, you’ll start to see behavior patterns that will lead you in the right direction.
But first, you need to understand what type of relationships to look for.
5 TYPES OF DATA RELATIONSHIPS
There are many different data relationships, but we’re going to cover the top 5 most common. These will most likely apply to the data you have at hand, and they’ll help you start to get a sense of what else you might like to explore in other data sets.
As you dive into these, consider what types of interesting angles your findings might support. A few questions to ask yourself as you go:
- Does the data support or disprove my hypothesis?
- Does it debunk a widely held belief?
- Did data increase, decrease, or flatline?
- Does the data show any differences between groups?
- What are the top 10 (or bottom 10) observations for a metric or variable?
RELATIONSHIP 1: CORRELATION
This is data with two or more variables that may demonstrate a positive or negative correlation to each other.
- Positive: An increase in one variable results in an increase in the other.
- Negative: An increase in one variable results in a decrease in the other.
Common chart types:
- Scatterplot with a fitted line
The strength of a correlation is measured by a correlation coefficient. A popular way to measure this is using the Pearson Correlation Coefficient of Pearson’s R ranging from -1 to 1. This measures how closely the points in your scatterplot resemble a line. A correlation coefficient of 1 means there is a perfect positive correlation. A correlation coefficient of -1 means there is a perfect negative correlation. A correlation coefficient of 0 means there is no correlation.
(In less technical terms, the more the dots on your scatterplot resemble a line, the higher the strength of a correlation.) You can also check out this game, which helps you identify the strength of correlation visually.
Here’s a scatterplot with a fitted line that shows the relationship between GDP per Capita and Coca-Cola prices for different countries. The line shows that there is a positive relationship. This means as GDP per Capita increases, the price of a Coke increases. Through visual inspection we can see the dots don’t make a perfect line, so we can say the correlation is only moderately strong. In fact, after calculating Pearson’s R, the correlation coefficient is 0.51.
What you want to look at here is how they interact. Do both variables influence each other? Do they increase, stay the same, or decrease? Remember: Correlation does not equal causation. (Just because there are more ice cream sales and shark attacks in the summer doesn’t mean that ice cream causes shark attacks.)
Example: You might wonder about the relationship between leads generated by a blog post and the number of hours spent writing the post.
Relationship 2: Trends
Look for noticeable trends, increasing or decreasing, in the data.
Common chart types:
- Bar chart
- Line chart
Example: You might look at how many page views your website gets every day in a month to identify which days of the week generate the most traffic.
RELATIONSHIP 3: DISTRIBUTION
This shows data distribution, often around a central value. Distributions are useful for understanding the minimum, maximum, mean, median, and range of a specific variable. Looking at a distribution lets you understand the shape of your data by looking at the average and end values.
Common chart types:
Example: You could group clients by how much revenue they generate for your company in a year. This way you can see what the average client spends, as well as the range a client might be expected to spend.
RELATIONSHIP 4: OUTLIERS
This is any data that acts unusually or outside the norm.
Common chart types:
- Scatterplots: Shown by points on the plot that lie away from the trending areas.
- Histograms: The tails of the histogram show if there are many outliers in the data.
- Bar charts: Any unusually high or low values.
Example: Going back to our previous example, the trend of the histogram we expect to see is that there are less clients in the first and the last groups. But this histogram shows us an outlier. There are actually a lot of clients that spend $51,000 – $55,000—even though we expected there to be less. It would be interesting to investigate why there are so many clients in that group.
RELATIONSHIP 5: COMPARISONS AND RANKINGS
Comparison: This is a simple comparison of the quantitative values of subcategories.
Common chart types:
- Bar chart
There are many ways to compare data. You can compare sets or look at subcategories within those sets.
Example: You might look data comparing click through rates for different colored CTA buttons. Which get higher clicks, and why?
Ranking: This shows how two or more values compare to each other in relative magnitude.
Example: Which content has the highest page views? Rankings help you easily compare how much traffic a page is generating.
5 DATA STORYTELLING DOS AND DON’TS
Once you think you’ve found your story, follow these tips to make sure you tell it effectively.
1) Have your audience in mind: Effective data storytelling doesn’t mean you tell whatever story you want. It means you find a story that is interesting for you audience. Consider:
- Is this relevant?
- Does it solve a problem or expand their knowledge?
- Have they heard this story before?
Sometimes you have a story that can be told to multiple (or larger) audiences. If you have the data, hone in on the most interesting angles.
2) Use a credible source: Your data should always be from a credible source and presented without spin. Follow these 5 tips to source correctly.
3) Don’t lie with your data: Data can be powerful; it can also be manipulated, misinterpreted, and misrepresented. Make sure you are telling the full story.
4) Design according to best practices: Data visualization doesn’t just visualize the data; it enhances comprehension. Make sure your designers are presenting it in its most optimized—and accurate—form. For more on this, see our guide to designing the most common graphs and charts.
5) Ditch your story if it isn’t actually there: Sometimes people have an idea for a data story and try to retroactively make their data fit that narrative. If the data isn’t there, the story isn’t there. Luckily, oftentimes searching for one story will lead you to another.
If you need to look for more data, check out:
- Kaggle Datasets
- UCI Machine Learning Repository
- US Open Data Project
- Financial Data
- Awesome Public Datasets
- Datasets Subreddit
- Google BigQuery Public Datasets
- Our roundup of 104 free data sources.
Data storytelling isn’t always easy, but it’s always worth it. Keep an eye out for more opportunities to flex your skills and you’ll find great stories to turn into great content.
For more on data storytelling:
- Learn more about why content marketers need data storytelling.
- See 9 great sources of data right in front of you.
- Find out how to craft an effective data narrative.
- Try Visage, our easy data design platform.
Need help creating powerful branded content? Let Column Five hook you up.