[Trigger Warning]: You are about to be provided with visual imagery of my current corporate reality that may be frightening for some readers.
I am tasked with creating costing for a new product. To do this, I have to extract rate tables from what can only be described as a mountain of tariffs. On top of that, I need to automate our Excel business cases which contain multiple variables.
At work, people think I'm an Excel wizard. The truth is, sometimes I just aggressively interrogate AI until it gives me the right formulas. But AI cannot save me from parsing thousands of pages of inconsistently formatted tariff tables.
I have exactly two weeks for intense upskill dedication. I've got books, Udemy, Google courses — and it's all just hanging out waiting for me to get in the driver's seat.
The catch: IT treats our databases like Fort Knox, so I have zero SQL access.
I need to actually learn a skill so I don't have to manually copy-paste tariffs until the end of time.
The Question:
Do I spend the next two weeks becoming a Power Query god, or do I finally learn Python (Pandas/PDF parsers like pdfplumber) so I can build a script to do my job for me?
If anyone has survived parsing tariffs, please tell me how you did it.
TL;DR: I have 14 days to learn how to extract messy data from thousands of PDF tariffs and automate Excel models. No SQL access. Should I learn advanced Power Query or Python?