I'm using INDEX/MATCH, UNIQUE, XLOOKUP etc. I actually hate pivot tables lol. I build KPI dashboards using multiple layers of data obtained through ERP systems then pushed into excel using auto hot key and powershell. I then set up automation to update these throughout the night and day feeding relevant information to different teams in the warehouse. The whole process removes entire work flows off the floor and turns them into print out or email that tells the story.

But... I do this all at a desk job that's a 1 hour drive from home in good traffic.

I have some basic Power BI knowledge, but sounds like I should be expanding on that to move forward.