I confirm that I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in PowerBI and Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please contact me to discuss the details.
Just FYI, I own a small consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/
https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/