data journalism Sentence reviews & Intelligent pivots: Google sheets gets an update The recent update to Google sheets adds intelligent pivot tables and makes asking some basic questions of the data almost too easy...
coding The GIANT CAP approach to coding for journalists. There are lots of approaches to coding and software development. Methodologies like Agile, Scrum and Lean are even becoming the norm in newsrooms. But I have a suggestion for a quick and easy methodology for journalist’s getting to grips with coding
data journalism Two fundamentals that define good data journalism Defining data journalism is a hostage to fortune but as I start teaching a data journalism module I’ve boiled it down to two things visible methodology and data.
data journalism Is Data Journalism any more open? What does the shortlist of the open data category of the Data journalism awards tell us about data journalism’s approach to open data.
data journalism Local votes for hyperlocal #DDJ There’s a good deal of interest in my feeds in a BBC report showing how local voting figures shed new light on EU referendum.
data journalism Why open data needs to be "Citizen literate" A “data literate” citizen isn’t someone who knows how to handle a spreadsheet — it’s someone who inherently understands the value of data in decision making.
data journalism How open is open data journalism? Simon Rogers published a post last week that asked “What does data journalism look like in 2016?”. For Rogers, the winners of the data journalism awards“give us a great
data journalism The Panama Papers & trickle down journalism I’ve been reading a lot about the Panama Papers. As a ‘thing’, the Panama Paper’s is an amazing project. It’s pretty much written the textbook on how
data journalism Pulling policing data into Google sheets Last week I had a regional newspaper group in for a few days exploring lots of different things. One area that popped up was data and we did a quick
data journalism Icons of the dead: visualising the deaths of migrant workers in Qatar. Update: The data from the WaPo story was challenged by the Qatar Government resulting in an amendment stating that the data was deaths for all migrants not just those working
data journalism Data Journalism: Meyerism and Vox's new data team. A few weeks back I wrote a post about Data Journalism and how it was defined (on Wikipedia at least). So I was interested to read Vox’s take on it when they announced, last Wednesday, that they were creating a Vox data team:
data journalism When is data journalism not data journalism? When it’s data driven journalism…. I’m doing lit-review at the moment (this might sound academic but it essentially consists of me yellow-highlighter-penning-the-feck out of papers and journal articles) and I came across a little loop in defining data journalism that got me
data journalism Doing data in a journalism course It’s a subject that isn’t going away and it’s also one that generate a huge amount of debate – data journalism. If ever there was a perfect hook to hang all of journalisms best and worst it’s data journalism! But a
data journalism Data journalism: Making it real The following is an edited version of a chapter I contributed to a new book Data Journalism: Mapping the Future, published by Abramis academic publishing. The fact that I’m in it aside, I can heartily recommend it as a great mix of practical
data journalism Does Data Journalism help democracy? I’m writing a book chapter on data journalism (I know, who isn’t these days) which I’ll share more of when it makes sense! But one of the areas that is giving me real pause for thought at the moment is the
data journalism Fusion tables and maps: Post office map revisited [Tweet](https://twitter.com/share)A few years ago I wrote a post about *[mapping post office closures using google maps and yahoo pipes](http://www.andydickinson.net/2008/02/29/maps-spreadsheets-yahoo-pipes-and-post-offices/)*. I used that combination because of an issue with google maps and
data journalism ScraperWiki: Hacks and Hackers day, Manchester. [Tweet](https://twitter.com/share)If you’re not familiar with [scraperwiki ](http://scraperwiki.com/about/) it’s “*all the tools you need for Screen Scraping, Data Mining & visualisation”*. These guys are working really hard at convincing Journos that data is their friend by
data journalism Channel 4 and ITN sign new deal Channel 4 have signed a new five-year contract with ITN for production of Channel 4 News up to the end of 2010, that will see the news service extend its new media operations. (http://www.netimperative.com/2006/04/07/C4_News ) Mark Wood,