What’s the catch? For these technologies, data must be copied from the source data platform, and the amount of data is limited to what can be precomputed on disk or stored in memory. Since OLAP engines are powered by a semantic layer, the concepts of “measures” and “dimensions” make data easily accessible to end users without further data modeling. Once data is loaded and formatted, these technologies can deliver queries in under a few seconds. Modern OLAP engines like SQL Server Analysis Services (SSAS), Power BI Premium and Qlik Sense ingest data and store it in an optimized data structure or memory for fast access.
What is it? Online Analytical Processing, or OLAP, has been around since the ’80s.
The following approaches, coupled with a modern data platform, can deliver “speed of thought” queries for end users. While modern cloud data platforms do offer virtually unlimited scalability, they can’t consistently deliver queries in a few seconds or less without significant data engineering and tuning. I’ve seen many organizations who thought that moving to a modern cloud data platform would “fix” their existing query performance issues. It’s downright inhumane! 3 Approaches For Delivering “Speed Of Thought” Analytics So, if humans are able to process information in a half second and be happier for doing so, why do we make our analytics users wait tens of seconds or even minutes for a single query? It’s not natural. That’s a pretty compelling list-and no, I didn’t make up that last benefit.
0 kommentar(er)
