The Data Story Guide Academy

Home Dashboard
Profile Settings Sign Out
course
Advanced Data Checking, Cleaning, and Tidying
Advanced Data Checking, Cleaning, and Tidying
Advanced Data Checking, Cleaning, and Tidying

About the Course

This course covers a range of skills required for survey data preparation.  It builds on introductory material covered in our "Survey Analysis Foundations" and "Beginners Guide to Data Checking and Cleaning" courses.  By the end of his course ... 

  • you will know how to identify opportunities tidy and transform variables, or create new variables from existing ones
  • know how to perform these tasks
  • and gain exposure to some automated methods for variable transformation and creation (that you might use for ongoing work, like tracking studies.

You can then sit the exam and get certified!

You can then build on this knowledge and skill set via The Data Story Guide and future courses.

Limited-time offer! Enroll now for free before we add a nominal fee.

Course Instructor

Andrew Kelly
Andrew Kelly
Director

Degree qualified in Marketing and Advertising Research (University of Technology, Sydney), Andrew has over 30 years experience as a market research professional.   He is highly regarded for his ability to find stories in data and tell them in a clear and actionable way

Course Progress
Not started
Enroll
Course Outline
  1. Getting Started
    1. How to approach this course
    2. What you need
    3. Course Overview
  2. Data File Checking
    1. Automated Data File and Variable Checking Methods
    2. Exercise: Practice automated steps
  3. Transforming Variables
    1. Overview
    2. Categorical Variables
    3. Numeric Variables
    4. Dimension Reduction
    5. Text Variables
    6. Recapping the Workflow
    7. Dealing with Missing Values
  4. Data Quality Checks
    1. Standard Data File Quality Checks
    2. Creating Custom Data Quality Checks
  5. Certification
    1. Before you start
    2. Examination
    3. Course Completion
course
Advanced Data Checking, Cleaning, and Tidying
Advanced Data Checking, Cleaning, and Tidying
Course Progress
Not started
Enroll

About the Course

This course covers a range of skills required for survey data preparation.  It builds on introductory material covered in our "Survey Analysis Foundations" and "Beginners Guide to Data Checking and Cleaning" courses.  By the end of his course ... 

  • you will know how to identify opportunities tidy and transform variables, or create new variables from existing ones
  • know how to perform these tasks
  • and gain exposure to some automated methods for variable transformation and creation (that you might use for ongoing work, like tracking studies.

You can then sit the exam and get certified!

You can then build on this knowledge and skill set via The Data Story Guide and future courses.

Limited-time offer! Enroll now for free before we add a nominal fee.

Course Outline
  1. Getting Started
    1. How to approach this course
    2. What you need
    3. Course Overview
  2. Data File Checking
    1. Automated Data File and Variable Checking Methods
    2. Exercise: Practice automated steps
  3. Transforming Variables
    1. Overview
    2. Categorical Variables
    3. Numeric Variables
    4. Dimension Reduction
    5. Text Variables
    6. Recapping the Workflow
    7. Dealing with Missing Values
  4. Data Quality Checks
    1. Standard Data File Quality Checks
    2. Creating Custom Data Quality Checks
  5. Certification
    1. Before you start
    2. Examination
    3. Course Completion

Course Instructor

Andrew Kelly
Andrew Kelly
Director

Degree qualified in Marketing and Advertising Research (University of Technology, Sydney), Andrew has over 30 years experience as a market research professional.   He is highly regarded for his ability to find stories in data and tell them in a clear and actionable way

Northpass logo Powered by Northpass