Dirty Data Dojo - Data Cleaning

Learn to Clean Your Data Quickly

In Excel, Python & R

Huge Savings !!!


or is it?

Does this sound familiar?

My boss needs me to analyse some data - I have 2 weeks to do it

2 weeks later I'm still cleaning the data...

...and I haven't even started the analyses yet!

  • The data are riddled with spaces
  • There are spelling mistakes and typos
  • There are loads of inconsistencies
  • There are lots of zeros where there shouldn't be any
  • The numerical data have errors
  • And my boss is unhappy

I'm stressed - how can I get these data cleaned faster?


--- 80% ---

Data analysts and statisticians spend up to 80% of their time cleaning data.

As much as 2 weeks per data set.

Even for small amounts of data!

Would you rather measure your progress with a stopwatch than a calendar?

(Hint: minutes rather than days or weeks)

Then we've got just what you're looking for!


Dirty Data Dojo:

Data Cleaning

Unique Video Course

Learning how to clean data quickly puts a powerful tool at your fingertips.

You'll discover that most of your data cleaning operations can be automated - meaning that you can clean entire datasets in minutes rather than weeks or months!

Being able to recognise and clean each type of data error quickly and easily will give you a great foundation that will help you take your data ninja skills to the next level.

What is the Dirty Data Dojo?

The Dirty Data Dojo is where you learn how to be a Dirty Data Ninja!

The Dirty Data Dojo will teach you all aspects of handling dirty data, so you can get your dataset clean, analysis-ready and fit-for-purpose in just a couple of hours (or less).

There are 6 courses in the Dirty Data Dojo:

Dirty Data Dojo - Data Collection
Dirty Data Dojo - Data Cleaning
Dirty Data Dojo - Data Preparation
Dirty Data Dojo - Data Validation
Dirty Data Dojo - DataKleenr
Dirty Data Dojo - Grand Project

Each course can be taken individually or together.

Each lesson in every course is valuable on its own, and will save you HUGE amounts of your precious time.

For maximum efficiency and time saving, we recommend that you take all courses, but it is not necessary.

Every lesson learnt is another step on your path to becoming a Data Ninja Warrior!

What's Included

Did you know that there are only 2 broad types of data you need to consider?

Once you've learnt to clean numerical data and text data, you're all done.

Then you can get right on to your analyses...

First, I'll teach you the fundamentals of what a good data workbook should look like:

  • Introduce 'flow' into your processes
  • Learn to recognise each type of data error
  • Use multiple worksheets to clean each type of error

After that, you'll learn how to remove all unwanted spaces from your dataset in less than 60 seconds:

  • Trailing spaces
  • Leading spaces
  • Interstitial spaces

BONUS: learn to standardise the case of all text entries in your dataset in precisely ZERO seconds!

Then you'll learn how to automate text data cleaning using 3 different methods:

  • Remove Duplicates and Find & Replace
  • Remove Duplicates and VLOOKUP
  • Filter and Find & Replace

BONUS: learn when to use each of these methods, depending on specific features of your datasets

Then you'll learn how to automate numerical data cleaning using 2 different methods:

  • Sort & Filter

BONUS: learn when to use each of these methods - and when not to!

Finally, you'll learn that the order in which you clean your data is just as important as the processes you use!

And at every stage you'll get lots of data to practice with, so you can perfect your data cleaning and become a Dirty Data Ninja Warrior!

Better still, you'll learn to do all these in Excel AND in your choice of Python or R!

Special Offer!

Dirty Data Dojo: Data Cleaning is a course that has been carefully honed and improved over several years.

And it's still improving - for the first time it now includes Python and R!

Right now you can get lifetime access for an amazing price!

Lock in this price with one single payment

With nothing more to pay


Who is 'Dirty Data Dojo: Data Cleaning' for?

This course is for you if you want to:

  • Learn how to clean your data in hours rather than weeks
  • Learn how to transition to data cleaning in Python or R
  • Get your analysis report to your boss in double-quick time!

I'm all about telling stories with data, but dirty data was always a barrier to getting there.

That's why I created this method and this course - so you can learn from my mistakes and get there sooner.

If you really want to fast forward to the sexier parts of your job, this is an absolute must-see!

I look forward to seeing you on the inside!

Lee Baker


How much time will this course save me?

If you're still cleaning your data manually, by-eye, this course will save you HUGE amounts of time - by learning to automate your data cleaning processes you can cut your 'time to analysis-ready data' from weeks to just a couple of hours (or less).

Do I need to be an expert in Excel?

Absolutely not!

Even if you've never used Excel before you'll be able to learn everything in this course.

Everything is explained in simple terms and you'll learn as you go by practicing with real data (provided).

Is it difficult to learn these techniques?

No, everything in this course is very simple - but incredibly powerful!

You can learn all of these techniques yourself without taking this course - but why would you want to?

It took me years to learn everything in this course, and I want you to save all the time that I wasted - that's why I created this course!

Do I need to take other courses in the Dirty Data Dojo?


Although you would benefit from taking all 6 courses (they were created to go together), each course can be taken as a stand-alone, and every lesson in every course is valuable and will save you huge amounts of time.

Do I need to be a Python/R programmer?


The lessons in this course use Excel as the teaching medium.

If you only do the exercises in Excel, you will be an expert in data cleaning in Excel. If you want to progress your learning into Python and/or R, you will be encouraged (with strong code hints) to code your own solutions - and you will then have your own code library for data cleaning!

Is there a satisfaction guarantee?

Yes there is!

If, after purchasing the course you're having second thoughts and would like your money back, we offer a 30 day money-back guarantee.

See below for more details.

For how long can I access the course?

When you purchase this course, you will have lifetime access to it!

How do I pay for the course?

You can pay for the course using PayPal or Stripe.

Both of these providers allow you to pay by credit card.

Dirty Data Dojo - Data Cleaning

Dirty Data Dojo (2 of 6): Data Cleaning

RRP $250

Lifetime Access!

30 day risk free

Nothing more to pay. Ever!

Already registered?

Log in here

100% Satisfaction Guarantee for 30-Days

We are proud to offer a 30 day no-quibble money back guarantee*.

We don't like being hassled when we want our money back, and we extend that same courtesy to you.

Course fees can be refunded in full any time during the first 30 days after payment*. After the 30 day period you will not be able to get a refund.

*If any member logs in several times or follows the majority of any premium course, we reserve the right to refuse refund.

Copyright 2021, Chi-Squared Innovations TCs

Chi-Squared Innovations