PANDA Aims to Make Data Analysis Easier for Journalists (And We’ll Be at ONA!)

    by Brian Boyer
    August 26, 2011

    What’s got rows and columns and sucks at data? Excel. Though to be fair, we misuse it. Excel was built for spreadsheets, but it’s become most folks’ go-to kit for poking at data. It’s installed on your computer. It opens CSV files. It’s what you know.

    Of course, databases are great at data, but they’re hard. Microsoft Access is limiting, and real databases like MySQL and PostgreSQL aren’t the easiest things for a non-hacker to get up and running, let alone query. Learning a little SQL will make you a better reporter, but digging through many datasets from different sources can take more than “a little SQL.”

    Plus, it doesn’t matter if you’re an Excel maniac or a database jockey — either way, the data is just sitting on your PC, invisible to your peers. Hidden data is sad data.


    We live in a data-soaked sci-fi future. It’s awesome. And in this future, every journalist must be a data journalist. But to get there, we need a better kit.

    1. PANDA will help

    We’re trying do two things with [PANDA](http://www.knightfoundation.org/grants/20110152/): make basic data analysis quick and easy for news organizations, and make data sharing simple. I’ll explain by example:


    Let’s say you’ve got an Excel spreadsheet of city employees with columns for first name, last name, department, position and salary. You visit your PANDA, upload the spreadsheet, give it a name, and tell PANDA it’s a list of people. Once the data’s in, you’ll be able to search and sort and filter — whatever you need.

    Each news organization will have their own PANDA, so your data stays private while you work. And every time you add a new spreadsheet, you’ll be building your newsroom’s data library. So next time one of your peers is scrubbing a name, they’ll be able to simultaneously search this and all the other lists of names your newsroom has collected.

    That’s just the baseline. We’ve got many more ideas, but we’d like to discuss them with you! So…

    1. Hello, ONA!
      The PANDA Gang is going to be at [ONA 2011 in Boston](http://ona11.journalists.org/) in a few weeks, and we need to hear from you! We’ll be roaming the halls, camping in the lobbies and crawling the bars — furiously taking notes about your newsroom data needs.

    Find us!

    We’ll be in the red PANDA T-shirts.

    Tagged: data analysis data journalism data sharing journalism ona 2011 panda project intros

    Comments are closed.

  • MediaShift received funding from the Bay Area Video Coalition (BAVC), which receives support from the Bill & Melinda Gates Foundation, to launch the MetricShift section to create a vibrant hub for those interested in media metrics, analytics and measuring deeper impact.

    About MetricShift

    MetricShift examines the ways we can use meaningful metrics in the digital age. We provide thoughtful, actionable content on metrics, analytics and measuring impact through original reporting, aggregation, and audience engagement and community.

    Executive Editor: Mark Glaser

    Metrics Editor: Alexandra Kanik

    Associate Metrics Editor: Tim Cigelske

    Reader Advisory Board

    Chair: Anika Anand, Seattle Times Edu Lab

    Brian Boyer, NPR

    Clare Carr, Parse.ly

    Anjanette Delgado, Gannett

    Hannah Eaves, consultant, Gates Foundation

    Ian Gibbs, Guardian

    Lindsay Green-Barber, CIR/Reveal

    Celeste LeCompte, ProPublica

    Alisa Miller, PRI

    Connect with MetricShift

    Facebook group: Metrics & Impact

    Twitter: #MetricShift

    Email: alexandra [at] rationalact [dot] com

  • Who We Are

    MediaShift is the premier destination for insight and analysis at the intersection of media and technology. The MediaShift network includes MediaShift, EducationShift, MetricShift and Idea Lab, as well as workshops and weekend hackathons, email newsletters, a weekly podcast and a series of DigitalEd online trainings.

    About MediaShift »
    Contact us »
    Sponsor MediaShift »

    Follow us on Social Media