With more than a decade of experience in local and national newsrooms, I'm passionate about exploring issues that matter most to people and communities—from affordable housing to access to quality health care.
Each month, I search for and scroll through dozens of datasets to find trends and engaging stories for our newswire. In this post, I’ll break down ways to distill data and tell stories without overloading an audience.
How to highlight relevant information in unwieldy datasets
Whether you’re just starting to dabble in data journalism or you’re a beat reporter wanting to add hard numbers to your stories, navigating a spreadsheet with thousands of rows and dozens of columns can seem daunting. But like any good story, it’s a matter of finding the right source and knowing what questions to ask.
Housing is a perfect example of data that can be analyzed and localized in hundreds of ways (though I may be biased, as Stacker’s resident real estate expert). What follows is how I tackle the dozens of real estate stories we publish each month. These tips can be applied to nearly any topic.
Step 1: Choose your data
Countless datasets from government and private sources are available for free online. In my real estate coverage, I often refer to the Census Bureau, which offers data on building permits for new construction and where people are moving. Real estate websites (including Zillow, Realtor.com, and Apartment List) also make some of their data available to download. These are good sources for tracking home and rent prices in specific states, metros, or zip codes.
Regardless of the dataset, read its data dictionary or other supplemental files to understand what each column represents and identify any major caveats.
Step 2: Know your audience
As a rule, reporters and editors act as translators. It’s our job to distill complex information—including data—into terms and visualizations readers can grasp and relate to.
On my beat, I typically write for average Americans: potential home buyers and sellers (who are usually buyers themselves). Much like a crime reporter would avoid using police jargon like “vehicle” or “APB,” in my real estate stories I explain and define common metrics like “median list price” or “days on market,” which may be unfamiliar terms for some readers—especially first-time homebuyers.
Gauge your target audience’s familiarity with data terminology, and define or simplify anything that may impede their understanding.
Step 3: Provide context, but don’t overwhelm
Context is key. Include a frame of reference for your audience, especially if your readers aren’t steeped in the subject matter.
If the story covers home prices or rents, show how they have changed from a decade, year, or month before. For local newsrooms, note how your county or metro compares to the rest of the state or country. Using supplemental data can also be helpful. For example, showing the difference between what homes are listed for and how much buyers typically pay can be a good barometer of how the market is doing overall.
No matter the topic, don’t overload your story with too much data. While it may be tempting to include everything and show off your data skills, too many numbers can be overwhelming and detract from the information you’re trying to convey.
You can continue to expect real estate data series monthly and quarterly. As for this May, we have stories for Asian American and Pacific Islander Heritage Month, summer travel, maternal health and much more.
Elena Cox is a Senior Data Reporter at Stacker. After earning a master's degree in data journalism from Columbia University, she worked for Realtor.com and CBS News. She was awarded a Goldschmidt FRED fellowship in 2022 and was able to visit the Federal Reserve Bank of St. Louis to learn about economic data.
Featured Image Credit: Photo Illustration by Stacker // Canva