OpenRefine Foundation course available on Big Data university. The OpenRefine Foundation course is a progressive program that provides structure and direction for students new to data cleaning and preparation. Each lesson comes with a comprehensive overview of its goals and content, five video tutorials, and a lab to put your learning into practice. The course ends with a quiz to test your knowledge.
Convenience and Flexibility: Learn the basics of OpenRefine and data manipulation in only 7 hours. The courses give students the opportunity to plan their study time around the rest of their day, and learn at their own pace. There are a total of 23 instructional videos and 7 hands-on lab split into 5 challenging lessons:
Lesson 1: Introduction to OpenRefine shows how OpenRefine will help with your data transformation and integration projects. You will learn about the community that supports OpenRefine and how to install the software.
Lesson 2: Data Mining & Discovery. Explore data sets to find data quality gaps or information nuggets. Learn how to use facets and filters, how to combine them and sort data better.
Lesson 3: Data Preparation & Normalization goes in-depth into actual data cleaning including removing duplicates, eliminating typos, splitting cells and using the undo/redo functions.
Lesson 4: Introduction to GREL. The General Refine Expression Language is OpenRefine’s scripting language, you will learn its syntax and most commonly used expressions for data cleaning.
Lesson 5: Data Enrichment explains how you can add value to your data by joining data sets together and use third parties services available via API.
This class is taught by Martin Magdinier who started to blog tips and tutorials about OpenRefine in order to help other business users get the most out of this open source tool. In 2012, when Google released the software to the community, Martin helped to structure the new organization. In late 2014, he launched RefinePro, a cloud-based SaaS data cleaning platform based on OpenRefine. Martin made this course available online to help new OpenRefine users to gain basic OpenRefine skills faster.