Cloud data warehouses are being touted as the next big thing for business analytics. Several enterprises have either moved or considering migrating their data loads to the Google Cloud Platform and use Google BigQuery for their BI needs. However, there are some key questions that need to be addressed. Is it possible to achieve multidimensional analytics at interactive speeds? Can we get the same performance while dealing with trillions of rows or billions of cardinalities? How would performance be impacted if concurrency increases to thousands of users, and most importantly – does it offer self-service analytics?
In this blog, I will discuss how Kyvos enables self-service, multidimensional analytics on Google BigQuery, delivering speed-of-thought analysis for trillions of rows. I will also explain how you can quickly connect your BigQuery data warehouse to Kyvos and start building AI-powered smart aggregates for multidimensional analysis.
Google BigQuery allows you to run queries on vast volumes of data using a SQL interface. However, as it works with SQL over tables stored in columnar format, multidimensional analytics is not possible. Further, as the query complexity increases, query performance decreases.
Running complex queries on a consumption-based pricing plan increases the costs exponentially. If you buy more slots to accommodate your workload, it adds to your already high bills. Besides these, you need SQL expertise to create queries.
Kyvos brings the power of multidimensional analytics to data in BigQuery and the Google Cloud Platform (GCP). Using Kyvos, you can build data models on top of your BigQuery warehouse and store them in Google Cloud Storage.
Some of the key benefits of using Kyvos with your BigQuery warehouse are:
To start creating data models on BigQuery, you need to create a data connection between Kyvos and BigQuery. You can create the connection quickly from the Kyvos user interface. For this, perform the following steps.
To refresh connections, click the menu ( ⋮ ) at the top of the Connections column and select Refresh.

Figure 1. Sample BigQuery Connection
The schedule is created and displayed, as shown in the following figure.
You can now register files to identify the data that you want to analyze, create data relationships to define schemas, and build data models for interactive analysis on your data.
Kyvos brings the power of multidimensional analytics on flat table structure. As the entire data is aggregated, all queries, standard or ad-hoc, old or new, are served equally fast. Kyvos lets you build data models on top of your BigQuery warehouse, which you can then connect to any BI or data science tool for visualization using SQL or MDX connectivity. You can run multidimensional reports on Google BigQuery and create interactive dashboards and workbooks too.
To see Kyvos in action on Google BigQuery, request a demo today.