Care about data quality? Want to know how to prepare data for publication, analysis and visualisation. This half day course will teach you all you need to know to start making better use of data.
Open data is a means to an end. It can answer questions, support claims, drive innovation, discover trends and tell stories. Finding the right data, and getting it into the correct shape to start using it, is the first essential step towards achieving results.
Get the right skills and knowledge you need to achieve this on this half day course on practical data management.
Whatever you want to do with data, start your journey here.
For ODI Open Data skill level
To learn how to source, organise, clean and prepare data ready for usage.
Over the course you will learn
- Collect data from a number of different sources
- Organise data into a spreadsheet
- Clean a large dataset
- Automatically apply data cleaning to multiple datasets
- Use pivot tables and other advanced spreadsheet functions to verify and analyse data.
- Prepare data for publication and visualisation
With a mixture of practical exercises, case studies and the latest learnings from the field of open data, our experts will remove the complexity of working with open data.
By the end of the course you will be able to
Expect to enjoy a small and personalised workshop taught by an expert trainer and data specialist. The workshop takes a skills-based learning approach and enables you to get hands-on. Leave the workshop with the ability to apply your learning immediately in the workplace or for a personal project.
Who is this for?
Open Data in a Day is ideal for those starting to advance from Explorer and into the Practicioner level of the ODI’s Open Data Skills Framework. Finding the right data, and getting it into the correct shape to start using it, is the first essential step towards achieving results.
It is suitable for researchers, government employees, educators, consultants, policy workers, students, artists, analysts and anyone who wants to explore what data can do for them.
What prior knowledge do you need?
The workshop is designed for non-specialists. No previous data or statistical skills are required; however, comfort with using the web and good computer literacy (including basic spreadsheet skills) is essential.
What to bring
A wifi enabled laptop or iPad if you have one.
What we will provide
- free wi-fi
$250 + GST
Ellen is a leading international expert in open data and is an ODI Certified open data trainer. Ellen just returned to Australia from the UK, where she was Head of Policy for the Open Data Institute. While in the UK, Ellen was recruited by then Secretary of State for the Department for Environment, Food and Rural Affairs (Defra) Elisabeth Truss (now Lord Chancellor and Justice Secretary), as her expert adviser on data. Ellen steered Defra’s #OpenDefra commitment to publishing 8,000 datasets as open data and changing the way Defra’s 22,000 staff worked together. Ellen also designed the open data board game, Datopolis together with ODI CEO Jeni Tennison, which is being played in 19 countries.
Ibrahim is an international expert and ODI Certified open data trainer. He founded the Dubai Node of the ODI Global Network in 2013. He has since delivered training programs and advised governments in various countries on their open data programs. In 2016, his certified training programs were attended by more than 100 trainees. Ibrahim is also a member of the United Nations e-Government expert group and has contributed to the UN e-Government Survey 2016 and the Open Data Barometer. His most recent activities include co-delivering an Open Data Maturity Assessment workshop for NSW government and speaking at the ODI Summit in London.
Friday 23 June @ ODI Queensland, TC Beirne Building, Fortitude Valley (Brisbane) with Ellen Broad.
Friday 28 July @ Microsoft Australia (Canberra) with Ellen Broad.
Friday 15 September @ Data61 CSIRO, Docklands (Melbourne) with Ellen Broad.