Most businesses are looking at cloud for all their big data analytics needs. They are remodeling their infrastructure to move faster and become more flexible. This is driving massive adoption of cloud storage and services across industries. Tableau is a leading BI tool that has always been the top choice for enterprises for their visualization needs. With BI on Big Data moving to cloud, Tableau on cloud is the most preferred option for most organizations.
Let’s discuss the challenges faced while using Tableau on cloud for Big Data, and how you can leverage Kyvos’ capabilities to overcome those challenges and achieve instant analytics.
Tableau’s Big Data challenge
Tableau helps you create brilliant visualization for analytics. This works well with small data sets in cloud, but with when the volume of data increases, the query response times go up to minutes or hours instead of seconds.
As the number of dimensions and cardinalities increase, Tableau takes a long time to analyze and fetch query results irrespective of whether your big data platform is on premise or in the cloud.This results in major lag for dashboard refresh. When you dive deeper into your data, add more fields, formulae and schemas– it becomes even more complicated. Any business user looking at a dashboard to answer their business questions would expect it to load and respond quickly. In fact, most users expect instant responses. Business SLAs require queries to return in seconds irrespective of the size of data.
If you believe Tableau extracts is the solution, you should remember that it is not live data. It is a stale sample of your business data that you are viewing. Will you be able to make informed business decisions using this data?
Tableau generates and executes a SQL statement for every interaction on every visualization. This means, even if you use extracts, you won’t achieve the speed of thought analysis. While Big Data platforms are exceedingly flexible and scalable, running interactive queries directly on them entails long, slow batch processes and extremely complex code.
The Kyvos solution
Creating a semantic layer between your big data platform and Tableau can reduce the query response times exponentially. Kyvos does exactly that. Tableau and Kyvos together form a powerhouse for fast and interactive business intelligence on Big Data. You can query trillions of rows of data from your Tableau on cloud interface and get response within seconds. No need to wait for days, and months to pull up reports.
Kyvos pre-calculates and caches all query results, enabling fast performance for queries used by Tableau visualizations and reports. With minimal degradation on high concurrency, it also allows you to make Big Data accessible to a large number of team members without adding any extra infrastructure.
Rather than having multiple systems for traditional and non-traditional data, Kyvos easily brings diverse data together, and allows you to directly analyze your data without any complex ETL. Our platform removes the complexity of the Big Data platforms, and allows you to develop insights from all data, both structured and unstructured, regardless of size and granularity using simple, drag and drop interface.
Let us now see how Kyvos achieves this.
Instant access to Big Data through BI consumption layer
Kyvos creates a BI Consumption layer directly on your big data platform, enabling you to use Tableau on cloud (and on-premise) at any scale for seamless access to big data. You can install Kyvos on your existing nodes, so there is no data movement or added infrastructure costs.
Further, you can install Kyvos on any cloud platform, including Amazon Web Services (AWS), Google Cloud, and Microsoft Azure, and leverage big data storage platforms like Hadoop Distributed File System or Amazon S3.
You can also analyze your raw data and drill down to the lowest level of granularity, without using any external code or complex ETL processes.
OLAP on Big Data to deliver superfast BI
Our proprietary OLAP on Big Data technology eliminates all performance challenges that come with Big Data. This ensures you can enjoy the speed and interactivity of OLAP combined with the scalability and flexibility of the Big Data platforms – all this with Tableau’s brilliant visualizations.
Kyvos comes with MOLAP, ROLAP, and HOLAP capabilities. This allows you to process data at any scale, granularity or complexity. You can then connect to you existing Tableau on cloud to provide open connectivity and easy integration. With Kyvos connector already built into Tableau, you can connect to your data in just a few clicks. Query, slice and dice, drill down, and explore data in Tableau dashboards with sub second response times. Kyvos also supports Open API and Library Connectivity using SQL or MDX queries, full JAVA and REST APIs, or existing libraries like OLAP4j or Python’s olap.xmla.
Pre-aggregated data cubes for linear scalability
The Kyvos BI Server pre-aggregates data into multidimensional cubes directly on the Big Data platform in the cloud, without any data movement. These multi-dimensional cubes store data in the most granular form supporting deep Big Data analytics across many dimensions with interactive response times. The Kyvos cubes are distributed across multiple nodes on the Big Data platform, providing linear scalability. These cubes can be stored on cloud, making it possible to easily scale up and build extremely large cubes while still providing instant response to queries.
Kyvos’ intelligent resource monitor makes recommendations to optimize your resource usage. As we are a self-service analytical tool, you can get answers to all your business queries, without the tedious work of creating hundreds of reports. Once you have built a cube with all the dimensions and measures that you want to analyze, you can fetch answers directly from these cubes for all your BI on big data needs. You can also build multiple cubes, that store data to the lowest granularity level and serve most queries within seconds.
Instead of getting rid of the granular level of detail that would ordinarily be summarized or aggregated in a traditional OLAP setup, use Kyvos to build a specific dimension for each column or field, whether it’s an individual customer or an individual product.
Intelligent caching with optimized querying for superior performance
Kyvos has an intelligent caching mechanism with features such as cache auto-population, purge, and repopulation that reduce query response times considerably. Caches are used extensively throughout Kyvos to deliver results at unparalleled speeds. The advanced caching mechanism not only ensures high performance but also optimizes the consumption of vital resources.
The caching service enhances performance by reducing the number of trips to the cubes or other external sources for fetching results. Besides this, it also ensures that resources are shared between processes, whenever possible, enabling efficient utilization of resources.
So, when you use your Tableau on cloud interface for any big data questions, the dashboards are refreshed at superfast speeds.
Advanced security features for fine-grained access control
Whenever you think about creating a semantic layer between your data and analytics tool, the first thing that comes to mind is – security. Business data is highly confidential and any breaches or leaks may have major legal and financial implications.
To ensure security and confidentiality of your data, Kyvos provides row and column level security, giving the users access to only those data fields that are relevant to them. It also enables integration with enterprise security infrastructures, so organizations are confident that their data is secure. You can easily import users from your organization’s active directory into Kyvos and be assured of access control.
Kyvos also supports enterprise-grade security including single sign-on authentication along with role-based access control till the lowest granular level.
Revolutionize your Analytics
Revolutionize your analytics using Tableau’s powerful visualizations with Kyvos’ capability to deliver high speed results unlimited scalability on Big Data.
To learn how Kyvos delivers instant insights with Tableau on Cloud for Big Data, request a demo now.
You can also watch our video where our customer, Walgreens, describes how they use Kyvos and Tableau to analyze two years of historical data instantly and interactively to get deeper insights into their supply chain.