I recommend contacting your business' Helpdesk group and confirm those programs work with an iPad WITH the feature you need.
Microsoft Teams is on the App Store
https://apps.apple.com/us/app/microsoft-teams/id1113153706?l=en
Microsoft PowerBI Is on the App Store
https://apps.apple.com/us/app/microsoft-power-bi/id929738808?platform=ipad
Citrix Workspaces is on the App Store
https://apps.apple.com/us/app/citrix-workspace/id363501921
Do they have the same features as the desktop version that you need? I don't know
Microsoft Office is on the iPad, however there are a lot of limitations between the desktop and the iPad version:
How the apps for Android and Office for iOS mobile apps work with Microsoft 365.
support.microsoft.com
> currently a beast of a Laptop, i7 32gb of ram, 15inch but am looking for something lighter.
I have no idea what weight of your current machine is, or why you have so much memory. I'm assuming you have a MacBook Pro 2018 (since that's the last model they released with a 15" display). The weight is 4.2lbs.
There isn't any iPads with a 15" display. The largest is the iPad Pro, 12.9" display. The weight is about 1.5lbs, and the smart keyboard is 1.2lbs, or about 2.7lbs total.
My advice would be to purchase a new MacBook Air M2 machine. The weight is 2.7lbs, so lighter than your current setup. The software compatibility would be greater than what you can find on the iPad. The 13.6" display is a nice compromise between the 12.9" of the iPad Pro and the 15" display of your current machine.