DEV Community

Cover image for Embedded Analytics with Tableau and Cube
Artyom Keydunov for Cube

Posted on • Originally published at cube.dev

Embedded Analytics with Tableau and Cube

These days, customer-facing analytics are everywhere.

We are, after all, in The Data Age—hence why you’re reading this blog and why we’re writing it. And because of the ubiquity of data, as consumers, we’ve become extraordinarily curious; we want to know everything about our businesses, investments, and lap times.

Consumers are pining for insights—presented in fast-loading, beautifully customized dashboards. And so, many companies are turning to embedded analytics with Tableau.

But as more consumers demand analytics, raising the standards of UI customization, interactivity, and speed, what if there were a more tailored, more performant way to give users the insights they need?

Well, there is: embedded analytics with Tableau and Cube. Let’s explain.

What is Embedded Analytics?

Simply put, embedded analytics is the practice of integrating data analytics and visualization capabilities with a user’s natural workflow, such as their web portals, internal tools, or applications.

For example: with embedded analytics, rather than needing to export sales data from their e-commerce platform and then conduct analysis separately in Excel, a seller could derive insights from dashboards and reports available to them directly within their commerce portal.

Of course, embedded analytics can be used in internal- and external-facing applications to provide real-time static and interactive reports, dashboards, and data visualizations.

There are many benefits of using embedded analytics. First, it can save the user time and effort and add a lot of value. In turn, this saved time and gleaned insights contribute to a user-centric UX that drives adoption—even among those who aren’t as analytics-experienced. And higher adoption means a better ROI on internal tooling and an increase in revenue for external tooling.

Embedded Analytics with Tableau

embedded analytics with tableau schema

So, why do so many companies turn to embedded analytics with Tableau?

Tableau is one of the leading platforms for data visualization and dashboarding. It's based on its own VizQL, which expresses data visually by translating drag-and-drop actions into data queries.

This drag-and-drop capability makes data analytics and business intelligence accessible to a much wider pool of people—which is a great thing. Clearly, given its smashing success, Tableau met a hot demand for data democratization and did it well.

However, things get a little more hinky when it comes to the embedded analytics stack. This is because users not only use Tableau for analytics within Tableau itself but also use it to power embedded analytics within other applications.

The problem is that having your embedded analytics with Tableau sit directly on top of your data warehouse comes with a few shortcomings, such as:

  1. Difficulty with customizability and designing user-centric UIs

  2. Duplicated effort and opportunities for inconsistency when creating multiple sets of data definitions and security contexts

  3. Weaker analytics performance

1) Difficulty with customizability and designing user-centric UIs

Tableau has many visualization layer options, but it just doesn’t have one for every audience or use case. You can undoubtedly brand the Tableau visualizations embedded in your app; however, there are restrictions on what you can build with the visualization layers Tableau offers (e.g., extremely use-case-specific drill-downs).

And so, Tableau’s visualization templates may work just fine for 80% of your applications, but those that truly need a highly tailored, custom UI will require you to build a custom presentation layer from scratch.

The problem is that using multiple different visualization layers together with Tableau—meaning, both custom-built and from Tableau—leads to…

2) Duplicated effort and opportunities for inconsistency

embedded analytics with tableau problems

So you want to use Tableau and a separate charting library to build a custom presentation layer? That makes perfect sense when you want to combine the advantages of Tableau’s presentation layers with the flexibility of a custom UI.

However, the challenge lies in consistently orchestrating data modeling, security, and caching across all of your presentation layers.

By connecting multiple presentation layers to your data warehouse, you’ll need to individually orchestrate your data models and access controls so they’re uniformly defined. That’s a lot of duplicated effort—which opens the door to gaps and errors.

3) Weaker analytics performance

Lastly, powering embedded analytics with Tableau without a BI layer between Tableau and the data warehouse can cause latency in your user-facing visualizations and dashboards.

Latency is a true user adoption killer: a Google study showed that bounce likelihood increased by 32% when a page’s load time increased from one second to three, and by 90% when page load time increased from one to five seconds. So, performance is essential.

In a stack in which Tableau’s presentation layer sits directly on top of your data source, your users request data from the data source for every query. At best, this is redundant and costly, as multiple users may be requesting the same information.

At worst, however, building a stack like this can result in latency and lower performance. Request volume across users is unpredictable; you can’t control how many people simultaneously request data or consume visualizations. And so, if you have multiple presentation layers, each with duplicate data modeling, security, and caching layers, each making separate and redundant requests directly of the data source—that opens the door to latency.

Latency can be a problem even if you only use Tableau (don’t worry, we happen to have a fix). But, with multiple presentation layers, the chance of uneven performance across them is much higher.

The best of both worlds: embedded analytics with Tableau and Cube

Alright—let’s get to the solution.

Tableau is a fantastic tool (in fact, here’s how to use Tableau with Cube.) Combining it with custom presentation layers is a great way to get both efficient, out-of-the-box visualizations and user-centric UI for your embedded analytics.

So how can you fix the issues above? With upstream, centralized data modeling, security, and caching orchestration. Hi, we’re Cube.

Cube streamlines building embedded analytics with Tableau and custom presentation layers

embedded analytics with tableau and cube

Cube is a headless BI platform that enables your data modeling, data access control, and caching layers to live upstream of every presentation layer and data application in your stack.

So, rather than individually orchestrating role-based access controls or metrics definitions for each presentation layer, you’re centralizing and defining them once—removing duplicated effort and its inevitable inconsistencies.

Cube ensures uniformly performant embedded analytics powered by Tableau and custom presentation layers

Cube’s robust caching layer manages the throughput of data requests and acts as a buffer between your data source and your data application. Its advanced pre-aggregation capabilities, query queue, and refresh keys protect your data warehouse from redundant, costly, and latency-causing queries.

Designed to protect the data source from the possibility of even an unlimited number of concurrent requests, Cube can significantly speed up your embedded Tableau dashboards and visualizations.

Cube also makes embedded analytics more performant even when built with a combination of Tableau and custom presentation layers. By allowing Cube to do the heavy lifting of data modeling, security, and caching orchestration, the presentation layers become very “thin”—essentially, not needing to process much. This enables them to become uniformly performant and allows the application’s embedded analytics to become more performant as a whole.

Learn More

Interest piqued? We thought it might be.

Give your users a performant, data-rich embedded analytics experience with Tableau and Cube—especially since Cube is free to use and we already have a tutorial for using Tableau with Cube.

Get in touch with us and the rest of the Cube community on Slack or Github.

In the mood for some hands-on help with building a modern embedded analytics data stack? Schedule a time to chat with us 1:1.

Top comments (0)