Data Journalism

To create data visualisations with a some nice visual appeal we’re going to use Infogram

1. Open Infogram and login (Signup if you don’t have an account yet). To start a data visualisation, click on the ‘Library’ button, ‘Dashboard’.
2. Select a template for your visualisation.
3. Add the title “BBC Spending TV” to your chart.
4. Click on this link and download all the spreadsheet available.
5. Move between the Page and Settings tabs on the right hand side to customise the template.
6. To upload your data, you will need to: Double click on the chart that you wish to customise > Click on Upload File > select the spreadsheet from your computer. Repeat this step for each chart.
7. To style your visualisation, you can select each element you wish to change. The options panel to the right hand side will change in reason of which element you selected (Text, Chart etc..).
8. When finished, click on the Share button on the top right > scroll down and select:

Share: if you wish to send a link to the project to someone else.

Embed: if you wish to add the project to a website / WordPress post > after clicking Embed, copy the HTML code that will appear in the window > go to WordPress > open your post > Text view > Paste the code.

A popular way to visualise data is to display it on a map (obviously this will only work if the data contains geographical information), the following exercise shows how to use the Google Maps Engine to easily plot your data on a map.

1. Open Google – My Maps and login
2. Click on the ‘Create a New Map’ Button
3. Download from this Link the data to visualise on your map
4. Rename your map ‘British casualties in Afghanistan: 2011 – 2013’
5. Click on the ‘Import’ link and upload your spreadsheet of Data
6. In the ‘Choose columns to position markers’ window, click on ‘Where From’ and select the ‘Continue’ button.
7. In the ‘Choose a column to title your markers’ window, click on ‘Name’ and select the ‘Finish’ button.
8. If a notification of error shows up, click on the banner and fix the errors on the data spreadsheet.
9. You can change the markers style on your map. Before proceeding, decide if you wish to change the Style for all markers or 1 by one or by columns etc.. To do so, click on ‘Uniform style’ and select a choice from the menu.
10. Select the marker you wish to change; a panel will appear showing the marker’s data. Click on the ‘Style’ button at the bottom right and choose how you want your marker to look like (if you kept the ‘Uniform style’ option selected, all the other markers will change too).
11. If you wish the markers to show labels: click on the ‘Uniform style’ option > click on the ‘Labels’ button > choose which label on the show on the markers
12. To change the Map’s terrain: click on the ‘Base Map’ button and select a terrain that you like
13. When finished, you can:Share: click on the ‘Share’ button > activate the options ‘Anyone with this link can view’ and ‘ Let others search for this map on the internet’ > Copy the shareable link > Close > send the link to show your work.Embed: if you wish to add the project to a website / WordPress post > after clicking Embed, copy the HTML code that will appear in the window > go to WordPress > open your post > Text view > Paste the code.