Please let me know the available options for data virtualization using Microsoft BI Technologies for scenarios where high data volume and complex transformations are involved. I'm looking for a virtualization solution such that there is no persistent DWH
built, no ETL involved and the virtualized layer can be built directly on top of the source databases using which reports can be generated. The main objective is to let the business users generate their reports in real-time/near real-time.
Power Query/ROLAP SSAS/SSAS Tabular with DirectQuery serve as virtualization options but it doesn't appear to be an optimal solution for high data volume/complex transformations. Please share your thoughts if you have any other ideas.
Not sure what you mean by data visualization. If you are talking about an OLAP layer that only contains metadata that sits directly on a OLTP system with large data volumes, I would suggest ROLAP with SSAS. Check out this paper for further details.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.