When you comply with GoodData or any of our group members on social media, then you’ll have seen a flutter of exercise round one thing referred to as FlexQuery this week. However should you’re in a job that bridges each enterprise and technical domains, the relevance of this to your day-to-day is probably not completely clear. Concern not although, as this text goals to interrupt it down for you!

Everyone knows that the proliferation of information sources and escalating volumes pose important challenges and there are seemingly dozens of instruments on the market that declare to resolve them. Nonetheless, to take action requires analysis time, budgeting, RFIs, vendor administration, procurement groups, and so forth.

Fortuitously, FlexQuery now affords the advantage of not solely enhancing your knowledge administration capabilities but additionally unlocking new potential — like AI, ML, direct knowledge feeds, reside knowledge streaming, caching and controls, and rather more. As such, should you’re out there for a brand new analytics resolution or you might be already a GoodData buyer, you want look no additional.

So, to save lots of you time and to keep away from confusion learn on for the highest 5 advantages of FlexQuery that you just’ll discover essentially the most precious.

1. Semantic and metrics layer for knowledge governance

Our semantic and metrics layer is the key sauce of FlexQuery. Outline as soon as, reuse an infinite variety of occasions in our dashboards, in Python and React functions, and even in competitor merchandise — all due to our headless metrics engine. FlexQuery connects your knowledge work to your whole downstream makes use of; be that BI, utility improvement, or machine studying.

2. Decreased prices via optimized knowledge processing

FlexQuery is constructed on Apache Arrow, which we’ve taken full benefit of to construct a collection of caches to enhance question efficiency and cut back load — and subsequently value — on knowledge warehouses or knowledge lakes. We retailer full and partial question end result units for reuse at runtime, sure in fact by your safety and tenancy necessities. We additionally provide the management to pre-cache knowledge on the desk, mannequin, visualization, or dashboard degree to make sure nice efficiency in your most crucial belongings.

3. Empower your groups to leverage open-source applied sciences

At its coronary heart, FlexQuery is a composable knowledge service layer. This implies which you can write pluggable FlexQuery modules to carry out almost any data-related job you’ll be able to consider. Whether or not it’s including a brand new knowledge supply, manipulating knowledge in pandas knowledge frames, or making use of complicated, AI-driven transformations, FlexQuery permits you to construct the instruments you might want to ship in your finish customers.

4. Keep away from knowledge integration challenges with knowledge federation

Information federation on the BI layer is inevitable. Due to FlexQuery, now you can mix knowledge from any variety of techniques, pre-aggregated in reminiscence or on the fly at runtime. This offers you supreme management over the place and when computation happens to maximise efficiency and reduce prices whereas letting your analytics engineers mix knowledge to ship options rapidly.

5. Keep away from much more knowledge integration challenges with knowledge materialization

FlexQuery permits you to pre-compute and materialize knowledge into GoodData as you see match. You’ll be able to choose particular person tables or complete fashions for materialization, or materialize SQL end result units. We provide the full suite of SQL capabilities to carry out joins, calculations, logical operations, and transformations and use the ensuing knowledge simply as you’d every other desk in your mannequin.

In abstract, GoodData’s FlexQuery supplies greater than only a instrument, however a strategic edge for BI leaders and knowledge product builders alike as a holistic resolution to fashionable knowledge administration. Embracing FlexQuery, which is out there for all GoodData clients, can drive effectivity, value financial savings, and innovation as organizations transfer nearer to their data-driven targets.

To be taught extra about FlexQuery, its advantages, and the underlying know-how head right here. Alternatively, request a demo and we’ll present you the way it all works.