Preparing your data for analysis means understanding your data, knowing what you can and can't do with it, and knowing how to work with it to get it in the shape you need.
In this course you're going to learn how to understand and prepare your data for analysis - in Excel, Python and R - quickly and effectively!
I’ll teach you how to transform data from what you have into what you need, and show you how to create new variables.
I'll also teach you how to use knowledge of the different data types to plan your entire study - from beginning to end.
The steps you’ll learn in this course are very simple to follow, but are extremely effective, so you’ll know that you’re getting the best start possible, saving you weeks of misery!
Certificate of completion
Perfect for beginners
- Python & R
This course is about teaching you how to prepare your data and transform it from what you have into what you need to get your analyses done.
Here’s a quick rundown of what you’re going to learn:
Here's what you'll learn:
you’ll learn how to make calculations on your data
you’ll learn how to create composite variables
you’ll learn how to convert numerical data to categories
you’ll learn how to code your data to make it easier to work with in stats programs
you’ll learn the data type of each of your variables, helping you to decide which analyses are appropriate
Suitable for beginners to analysing data in Excel (and those that have a basic grounding in Python and/or R), in this course you’ll learn to ‘play’ with your data, learning what you can and – more importantly – can’t do with it.
Each lesson starts with a quick question to find out where your strengths and weaknesses are, then you’ll dive straight into the data. There will be LOTS of playing and practising with data, and you’ll learn by doing.
Then you’ll finish each lesson with quiz – by now you should have learned EXACTLY what the correct responses are, and answer with confidence!
With the fundamentals mastered in Excel, you’ll then learn to make the transition to your choice of Python or R and gain confidence in knowing precisely how to do the same analyses as you learned in Excel in the programming language of your choice.
In this course, you will get:
Is This a Course or Project?
This course is a mixture of a traditional course and a project, a 'croject', if you will...
Some lessons will be in the form of videos, and some text-based, and there will be a lot of practice exercises to build your experience.
All the lessons are done in Excel, where you will learn the concepts, as it is a non-threatening, familiar medium that everyone starts with when handling data.
There will be lots of practice exercises in Excel.
I won't formally teach the concepts in Python or R, but I will point you in the right direction with strong code hints.
I could just hand you all the code to use, but that wouldn't aid your learning path and would only hinder your progress in the long run.
The best way for you to make the transition from Excel to Python/R is for me to:
- 1teach you the concepts (which are all simple)
- 2point you in the right direction (code hints)
- 3encourage you to create your own code (with access to a forum where you can learn from others)
So for every exercise you will be encouraged to write your own code to perform precisely the same data cleaning tasks in Python/R as you do in Excel.
Don't worry - there are already pre-built functions in Python that we can use. It's all rather straight-forward!
In this course, Excel is used as a learning tool, but the lessons learned are transferable to other media - like Python and R, and you will learn how to:
This course has a dedicated forum where you can ask questions, get answers and connect with our learners.
You can find the forum here:
Students completing the course will have the knowledge and confidence to be able to prepare their data in Excel (and optionally in Python and R as well) quickly and accurately.
Complete with HD videos, data, examples and practice exercises, you’ll be able to work alongside the instructor as you work through each concept, and will receive a certificate of completion upon finishing the course.
Oh, yes – and there are lots of little surprises for you along the way!
This course is Part 3 of our 14 Day Data Cleaning Challenge, where I’m going to teach you a method of data cleaning 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.
Introduction to Data Preparation
An introduction to this course and to the 14 Day Data Cleaning Challenge!
Introduction to Data Preparation
Making Data Calculations
In this chapter you'll learn how to 'work' with your data to get it into the right shape for your analyses. You'll also learn how to convert numerical data to categories
Creating Composite Variables
Converting Numerical Data to Categories
Rounding Your Data
How to Code Your Data
The focus in this chapter is on how to code your data for use in statistics programs - how to convert your data from text to integers
Converting Text Data to Integers
How to Code Using If-Then-Else
How to use VLOOKUP
Knowing Your Data Types
The focus in this chapter is on knowing and understand the 4 types of data in statistics - so you can plan your entire study from beginning to end!
Knowing and Understand the 4 Data Types - Ratio, Interval, Ordinal, Nominal
In this chapter you'll recap all the techniques you've learned
A Recap of Everything in This Course