Hello Gainsight Community,
We are building a universe (business intelligence/business objects) from the export of the Gainsight AWS bucket files as per the Gainsight AWS specification online.
I seek your knowledge on the architectural design of the universe. The simple joins by account id, identifier id, as well as also in master data engagement id and master data feature id… is not enough.
That design gets us one path to list the account, user, ..engagements, or list the features, or list the external events for a product.
In one universe, I am looking for pulling all tenant, all product, engagements, features, events, surveys, etc. into one business objects report. Or even if I go into Power BI, the same thing. or even if I go into Access.
Has anyone combined data in one universe, etc. to allow overall reporting of Gainsight data for the company?
Thanks for your help.