Data Hub - data model for BI reports
Avantages
It's eassy to use, have steps in case that you need to turn back, have an ELT process, tabular or cube in SQL.
Is an excellent tool to improve the backend process, that increase the speed and reduce de risk to do all this in the different SQL languajes.
Inconvénients
The software is managed for their own team and in case of a bug, you need to contact them to help you.
Zap BI for Dynamics AX
Avantages
Makes for very quick cube build and has XMLA built especially for AX. Not much work needs to be done for mapping or relationships. Zap support has always been very quick to respond and resolve issues. I have had a very positive working relationship with everyone I've met from Zap as company.
Inconvénients
It would be nice to have some better insight to the CubeXpress product and how to make some tweaks for our own customization of our environment. It would be a nice feature to be able to view the MDX code behind the scenes.
I don't have anything specifically that i like least about the vendor.
To complement Power BI or any visual solution, Data Hub is an excellent option that help the business and reduce time to implement a solution of BI that can have multiple database that need to be integrated