Unlock automations, remove tedious work

Guten Tag! 👋 

Many greetings from Munich, Germany. It’s easy to think that data cleaning techniques are only useful for running fancy data analyses.

But the more data pipelines I build, the more I realize that data cleaning techniques are also a key skill for automations. Let me explain.

Imagine that you regularly have to provide updated information from some database or some file that you get delivered. This can be stuff like

• Sales Reports: Detailed breakdowns of sales by product, region, or time period for a business.

• Inventory Levels: Updated counts of stock for various items in a warehouse or store.

• Customer Records: Updated profiles, contact details, and activity logs for clients or customers.

The possibilities are endless. My point here is this: All of these tasks are not necessarily about delivering “fresh, novel insights”. Instead, this is more about updating standard reports for stakeholders.

And while this isn’t super sexy, it is a fantastic playground for running automations. Imagine just re-running a script to get the updated numbers instead of having to manually

• assemble the new data,

• tweak bits and pieces of your code here and there

• and then putting the updated numbers into a new report.

Imagine the time saved! But to actually save that time, you will need the skills to write scripts that are general enough to handle vasts formats of changing data.

So that was one of the visions when I started my data cleaning master class: Teaching R users the skills to be quicker with the mundane stuff and free up time for more meaningful things. That is why the course covers so many things:

• Productivity boosts with summarise() and mutate()

• Loading all kinds of data into R (in particular stupid Excel files)

• Handling many tricky formats (like texts or times & dates)

And with the code “FRIDAY20” you can still get 20% off this course to become a data wrangling pro. So if you want to build automations and free up some of your time, then check out the course page now. The code is only available for a few more days.

Best,
Albert