Thanks to the participants of @SchoolOfData Data Skills Training for media & CSOs! Props to teachers @anpe @mexflow pic.twitter.com/5EAOQ7BDLz
— Open Data PH (@datagovph) May 14, 2014
Some of the CSO representatives who participated during the workshop were from The Asia Foundation, Asia Society Philippines, PinoyME Foundation, INCITEGov, and Code-NGO. Invited media practitioners represented ABS-CBN, GMA News, GMA News Online, Inquirer, Philstar, Rappler, and Solar News.
Happening now: Media and CSOs team up to explore the @CustomsPH dataset and generate insights #OpenDataPH pic.twitter.com/H49OViXIgK
— Open Data PH (@datagovph) May 17, 2014
Ivory Ong of the Department of Budget and Management and Outreach Lead of Open Data PH briefly discussed about the history of the Open Data Taskforce in the Philippines leading to the creation of the National Open Data Portal of the Philippines -- http://www.data.gov.ph "which aims to make national government data searchable, accessible, and useful, with the help of the different agencies of government, and with the participation of the public".
The trainers who conducted the two-day workshop were Anders Pedersen, Knowledge Development Lead of School of Data and Sergio Araiza, a trainer and programmer at Social Tic and Escuela De Datos.
Data driven journalism was discussed on the first day of the workshop. It included topics about planning data investigation and scraping data from websites and pdfs. Through the use of powerful Google-related tools, data from websites such as Philgeps can be downloaded in an easier way, saving time and effort. Data cleaning was also taught, because not all data downloaded were organized. Tables from pdfs can be downloaded using an online tool called Tabula.
@SchoolOfData Data Sherpa @mexflow guiding @solartvnews & @Code_NGO to use @GooglePH Refine #OpenDataPH #opendata pic.twitter.com/lA0zbeJDkk
— Open Data PH (@datagovph) May 17, 2014
Another online tool, onlineocr.net, which Solar News Researchers frequently use to convert pdfs to word documents, was also presented but for the purpose of scraping data from pdfs and convert the data to csv file.
Introduction to data visualization was also part of the first day of the workshop. Techniques on how to present timelines through timeline.knightlab.org and playing data through timemapper were also taught. To visualize the data, the output must be published in a website. On the other hand, tools to create maps with emphasis on locating the coordinates were also presented.
How the readers will appreciate the data presented depends on the design of the data visualization. There were so many ways to visualize the data by creating amazing maps through cartodb.com. Most of the tutorials presented can also be found at http://www.schoolofdata.org.
On the second day of the workshop, Open Data PH Chairman Edwin Lacierda was present. Groups were formed and the participants were taught the use of Google Refine in cleaning scraped or downloaded data. In preparation for the Data Expedition, a sample table from the Bureau of Customs was given to each group. The importance of data expedition is for the journalist to ask himself what he needs to get from the data. There are some data that isn't interesting, or not really needed for the story he is going to write or present, and those need to be eliminated. Data expedition also aims at finding interesting new angles for the story.
All groups presented their outputs. The participants were surprised to learn that their were discrepancies in the data published by the BOC. Regardless of the discrepancies, China is still the top exporter of goods to the Philippines. Other groups presented about which countries pay the highest tax for exportation and many others.
The Data Skills Training came to a close after all groups have presented their outputs and Anders Pedersen have invited all participants to join the School of Data Fellowship program. I'm grateful to be part of this rich and comprehensive training.
Today's Data Expedition comes to a close. Thanks to everyone who participated. Job well done, Data Sherpa, @mexflow! pic.twitter.com/9QfEG1pTrA
— Open Data PH (@datagovph) May 17, 2014