What I do myself is use the information from swgoh.gg, they provide an excellent api via https://swgoh.gg/api/.
For example https://swgoh.gg/api/guilds/522/units/ has a list of all the units of my guild.
I created a small Java program the convert that in the dataset I need.
With the help of powerbi desktop (free) I create some datasets.
I haven't come around to fully implement everything but I have enough for now for the basis stuff.
Luckily some other officers also have their own solution for platooning and stuff like that.