An independent academy
Northgate Institute
Data and technology skills, taught by people who do the work
- Dr Elena MarshData governance and protection · London
- Tom OkonkwoDatabases and data engineering
Start here
A path is several courses in the order they build on each other. The next one opens when you finish the one before it.
A path is several courses in the order they build on each other. The next one opens when you finish the one before it.
- Course series4 coursesBecome a data practitionerFour courses, about three months, from vocabulary to working independentlyData FoundationsWorking with DatabasesCleaning and Preparing DataTelling the Story: Data VisualisationSee the series →
- Course series2 coursesData governance trackThree courses for the person who has to write the rulesData FoundationsData Governance EssentialsSee the series →
Courses
5 courses
- BeginnerFree first lessonData FoundationsWhat data is, what makes it good, and how to talk about it
- Describe any dataset in terms of rows, fields, types and grain
- Judge whether a dataset is fit for a question before you use it
- Use the words accuracy, completeness and timeliness precisely
- IntermediateWorking with DatabasesThe relational model, and enough SQL to answer your own questionsStarts after Data Foundations
- Read a schema diagram and predict what a join will return
- Write SELECT, WHERE, GROUP BY and JOIN without looking them up
- Recognise when a query is answering a different question than you asked
- IntermediateData Governance EssentialsWho owns the data, who decides, and how it gets written downStarts after Data Foundations
- Name the standard governance roles and what each is accountable for
- Write a data policy somebody will actually follow
- Run a stewardship decision from question to written answer
- IntermediateCleaning and Preparing DataGetting from what you were given to what you can useStarts after Working with Databases
- Profile an unfamiliar dataset before changing anything in it
- Cluster and reconcile values that mean the same thing
- Keep a record of every change so the work can be repeated
- IntermediateTelling the Story: Data VisualisationCharts that answer a question instead of decorating a slideStarts after Cleaning and Preparing Data
- Choose a chart form from the question rather than from habit
- Strip a chart to what is actually carrying information
- Spot the three ways an axis can mislead