Near Real-Time Analytics with xVelocity (without DirectQuery) [BIA-312]

Marco Russo
75 minutes
Analyze
BI Platform Architecture, Development & Administration
BI/Analytics Practitioner
300
Real-time analytical systems are challenging, but interesting. The classic solution for real-time systems is to build ROLAP partitions, so you have a MOLAP cache with consolidated data and a ROLAP partition for fresh information. However, with the Tabular model in Analysis Services 2012, there's no option for this solution. You must go either in-memory or with DirectQuery, making DirectQuery the only available choice for real-time analytics. But is DirectQuery really the only option? By using partitions in a clever way and pushing the process time to its limits, it is possible to obtain good performance for near real-time systems. This session will show you the techniques for this solution and analyze how close we can get to real-time analysis by using in-memory databases.
Basic knowledge of Tabular models in Analysis Services 2012

cage-aids
cage-aids
cage-aids
cage-aids