Embedded analytics in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

What is the primary benefit of embedded analytics in business applications?

Embedded analytics integrates data visualizations directly into business software. What is the main advantage of this approach?

A Users can access insights without switching between multiple tools, improving decision speed.

B It requires users to export data to external tools for analysis, increasing flexibility.

C It limits data access to only IT specialists, ensuring data security.

D It replaces all existing business applications with a single analytics platform.

💡 Hint

Think about how embedding analytics affects user workflow and tool switching.

Embedded analytics allows users to see data insights inside the applications they already use, so they don't waste time switching tools. This speeds up decisions and improves productivity.

❓ dax_lod_result

intermediate

Calculate total sales per customer embedded in a dashboard

Given a sales table with columns CustomerID and SalesAmount, which Tableau LOD expression correctly calculates total sales per customer for embedding in a dashboard?

Tableau

{FIXED [CustomerID] : SUM([SalesAmount])}

A Total Sales per Customer = SUM([CustomerID])

B )]DIremotsuC[(MUS = remotsuC rep selaS latoT

C Total Sales per Customer = {FIXED [CustomerID] : SUM([SalesAmount])}

D Total Sales per Customer = COUNT([SalesAmount])

💡 Hint

Consider how to keep the filter on CustomerID while summing sales.

Option C sums sales but keeps the filter on CustomerID using FIXED LOD, so it calculates total sales per customer correctly.

❓ visualization

advanced

Best visualization type for embedded analytics showing sales trends

You want to embed a sales trend visualization in a CRM system. Which chart type is best for showing monthly sales changes clearly?

A Line chart showing sales amount over months

B Pie chart showing sales distribution by product category

C Bar chart showing total sales by region

D Scatter plot showing sales vs. customer age

💡 Hint

Think about which chart best shows changes over time.

Line charts are ideal for showing trends over time, making monthly sales changes easy to see in embedded analytics.

🎯 Scenario

advanced

Embedding analytics with user-specific data filtering

You embed a dashboard in a web app used by multiple sales reps. How do you ensure each rep sees only their own sales data?

A Create separate dashboards for each sales rep with hardcoded filters.

B Disable all filters so everyone sees the same data.

C Embed the full dataset and ask reps to filter manually.

D Use row-level security (RLS) to filter data based on the logged-in user's ID.

💡 Hint

Think about how to automate data filtering per user securely.

Row-level security automatically filters data based on user identity, ensuring reps see only their own data without manual filtering.

🔧 Formula Fix

expert

Identify the error in embedding Tableau dashboard with JavaScript API

Review this JavaScript snippet embedding a Tableau dashboard. What error will occur?

var viz;
function initViz() {
  var containerDiv = document.getElementById('vizContainer');
  var url = 'https://public.tableau.com/views/SalesDashboard';
  viz = new tableau.Viz(containerDiv, url, {width: '800px', height: '600px'});
}
window.onload = initViz;

A No error; the dashboard will embed correctly.

B ReferenceError because 'tableau' is not defined (missing Tableau JS API script).

C TypeError because 'containerDiv' is null (missing HTML element with id 'vizContainer').

D SyntaxError due to incorrect object literal syntax in options.

💡 Hint

Check if all required scripts are loaded before using the Tableau API.

The code assumes the Tableau JavaScript API is loaded, but if the script is missing, 'tableau' is undefined, causing a ReferenceError.