Learn to ‘interview’ data for original stories or to support your investigation. First we'll cover the questions you can ask of data. Then we'll use simple statistics to answer those questions. Discover differences, trends, typical examples, exceptions, proportions and relationships you would never have noticed without data. We do not treat the techniques ‘separately’ but as parts of a logical workflow; you will also learn to organize a data project. Also covered are: finding data, building your own databases, scrapping with Google, cleaning with OpenRefine, merging tables, statistics with formulas, analyzing with pivot tables and visualizing with Google charts. After this course, you will master 90 percent of the techniques used by typical data journalists. The course includes a reference book that explains the work process and all techniques.
Details
You will learn to:
• Generate angles for data stories
• Search for and find data
• Import data from the Internet and from PDFs
• Use simple scrapers
• Merge data sets together
• Clean up data before you analyze them
• Keep a grip on your workflow with a data diary
• ‘Interview’ data with functions and pivot tables
• Collaborate in data projects
• Talk to statisticians
• Work in Google Sheets
• Use tools to visualize data
• Put data into words
Calendar & Registration
Follow-up course
