Oh, this is pretty much all I know about how to use python.

I don't have any formal data qualifications. I learned everything I do now on the job.

I thought I was pretty good at excel, with formulas, pivot tables, and vlookups and all that junk.

Then, during the start of the pandemic, I started using "KNIME" to automate the crap I'd do in spreadsheets all day. It's basically a visual coding tool that lets you string together different operations on data sets and do things you wouldn't believe.

I learned by basically saying "right, I how do I do {thing} in excel?" let me try and reproduce it in Knime. As a result, the only time I typically use excel now is for my household budget, and to track upcoming personal tax liabilities (though, I'd rather be throwing up in the street).

Then, I was introduced (by necessity) to PowerBI and Power Query as I moved into a temporary role at my org as a Reporting and Insights specialist.

Now all I do is extract data, transform it (and clean it up) and try to get it be represented in a way in which business stakeholders can easily see "green number good, red number bad, we blame filthy {blame recipient}"

The thing about data is the same thing about programming, I've found (and I've only done python stuff for less than a year) - is you are literally this guy:

Get a whole bunch of things which don't seem to have an obvious link, or connection to one another, and make them work together.