Learn the basics of OpenRefine with our Foundation course available on the tranzform course platform.
The OpenRefine Foundation course is a progressive program that provides structure and direction for students new to data cleaning and preparation. Each lesson comes 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 course was developed in 2015 by Martin Magdinier founder of RefinePro in partnership with BigData University and Cognitive Class.. We made the OpenRefine Foundation courses to help new OpenRefine users to gain basic OpenRefine skills faster. Since 2011, RefinePro developed training programs for OpenRefine including free online courses, in person or remote courses and individual coaching sessions. Learn more about RefinePro’s training