How to Prepare Your Data for Analysis


Course Description

You have a perfectly clean dataset, but your favourite stats program isn’t happy – it needs your data in a different format.

This course is about teaching you how to transform your data from what you have into what you need to get your analyses done.

In this course you’ll learn how to make calculations on your data, create composite variables and convert numerical data to categories. You’ll also learn how to code your data to make it easier to work with in stats programs, and determine the data type of each of your variables, helping you to decide which analyses are appropriate.

The 14 Day Data Cleaning Challenge

This course is Part 3 of our 14 Day Data Cleaning Challenge, where I’m going to teach you a method of data cleaning and preparation that I developed some years ago. It’s been tried and tested by hundreds of people, and it’s been tweaked along the way, improving it so that it’s always up-to-date and always works!

It will help you get your data clean and analysis-ready in minutes rather than weeks.

Yes, you read that correctly – minutes!

The 14D2C2 is a 14 day course that will take you through 1 hour of video lessons and practice sessions every day. In other words, with a 1 hour investment daily for 14 days you will become an expert in data collection, cleaning and preparation!

If you’re ready to take the 14D2C2, email me and I’ll send you the details to get started.


At the end of this course you will receive a certificate of completion. Post it to Facebook, your LinkedIn page or print it out and stick it on your wall. Just don’t throw darts at it, ok…

Learning Outcomes

  • Over 1.5 hours of video content!
  • 1.5 hours of practice exercises
  • Learn how to make calculations with your data
  • Learn how to create composite variables
  • Learn how to convert numerical data to categories
  • Learn how to code your data
  • Learn how to round your data
  • Learn how to determine the correct data type of each variable
  • Excel is used as a learning tool, but the lessons learned are transferable to other media
  • Data files are provided for the student to practice with
  • Practical learning experience with real data

Course Content

Total learning: 14 lessons Time: 198 minutes


Lee Baker is an award-winning software creator that lives behind a keyboard in a darkened room. Illuminated only by the light from his monitor, he aspires to finding the light switch. With decades of experience in science, statistics and artificial intelligence, he has a passion for telling stories with data, yet despite explaining it a dozen times, his mother still doesn’t understand what he does for a living. Insisting that data analysis is much simpler than we think it is, he creates friendly, easy-to-understand video courses that teach the fundamentals of data analysis and statistics. As the CEO of Chi-Squared Innovations, one day he’d like to retire to do something simpler, like crocodile wrestling.



  • Over 1.5 hours on-demand video
  • Language: English
  • Certificate of Completion