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.

Practice

1. What is the main purpose of embedded analytics in Tableau?

easy

A. To display live Tableau dashboards inside other applications or websites

B. To create static images of dashboards for reports

C. To export data from Tableau to Excel

D. To design dashboards only for Tableau Desktop

Solution

1. Step 1: Understand embedded analytics concept

   Embedded analytics means putting live Tableau visuals inside other apps or websites.

2. Step 2: Identify the correct purpose

   Only To display live Tableau dashboards inside other applications or websites describes embedding live dashboards, others describe unrelated tasks.

3. Final Answer:

   To display live Tableau dashboards inside other applications or websites -> Option A

4. Quick Check:

   Embedded analytics = live dashboards inside apps [OK]

Hint: Embedded analytics means live dashboards inside other apps [OK]

Common Mistakes:

• Confusing embedded analytics with exporting data
• Thinking it creates static images only
• Assuming it only works inside Tableau Desktop

2. Which HTML tag is commonly used to embed a Tableau dashboard into a webpage?

easy

A. <embed>

B. <iframe>

C. <script>

D. <div>

Solution

1. Step 1: Recall embedding methods

   Tableau dashboards are often embedded using the <iframe> tag to load live content.

2. Step 2: Compare options

   <embed> is less common, <script> is for JavaScript code, and <div> is a container but not for embedding external content.

3. Final Answer:

   <iframe> -> Option B

4. Quick Check:

   Embedding uses iframe tag [OK]

Hint: Use <iframe> tag to embed live dashboards [OK]

Common Mistakes:

• Using <embed> which is less flexible
• Confusing <script> with embedding tag
• Thinking <div> embeds content directly

3. Given this Tableau JavaScript API snippet:

var vizDiv = document.getElementById('tableauViz');
var vizURL = 'https://public.tableau.com/views/SampleDashboard';
var options = { width: '800px', height: '600px' };
var viz = new tableau.Viz(vizDiv, vizURL, options);

What will this code do?

medium

A. Create a new Tableau workbook on the server

B. Export the dashboard as an image file

C. Embed a Tableau dashboard with 800x600 pixel size inside the element with id 'tableauViz'

D. Display an error because 'tableau.Viz' is not a valid function

Solution

1. Step 1: Understand the JavaScript API usage

   The code creates a new Tableau visualization inside the HTML element with id 'tableauViz' using the given URL and size options.

2. Step 2: Analyze the options and function

   The 'tableau.Viz' constructor embeds the dashboard with specified width and height, no export or server workbook creation occurs.

3. Final Answer:

   Embed a Tableau dashboard with 800x600 pixel size inside the element with id 'tableauViz' -> Option C

4. Quick Check:

   tableau.Viz embeds dashboard in element [OK]

Hint: tableau.Viz creates embedded dashboard in specified element [OK]

Common Mistakes:

• Thinking it exports or creates new workbooks
• Assuming 'tableau.Viz' is invalid
• Ignoring the size options

4. You embedded a Tableau dashboard using an iframe, but it does not resize properly on mobile devices. What is the most likely cause?

medium

A. The iframe lacks responsive design settings like width in % or viewport meta tag

B. The Tableau dashboard URL is incorrect

C. The iframe tag is missing the src attribute

D. The Tableau JavaScript API is not loaded

Solution

1. Step 1: Identify responsive design issue

   Improper resizing on mobile usually happens when iframe uses fixed pixel width instead of relative units or lacks viewport meta tag.

2. Step 2: Eliminate other causes

   Incorrect URL or missing src would prevent loading, not just resizing; missing API affects JS embedding, not iframe resizing.

3. Final Answer:

   The iframe lacks responsive design settings like width in % or viewport meta tag -> Option A

4. Quick Check:

   Responsive iframe needs relative width and viewport tag [OK]

Hint: Use % width and viewport meta for responsive iframes [OK]

Common Mistakes:

• Blaming URL or src attribute for resizing issues
• Confusing iframe with JavaScript API embedding
• Ignoring responsive design principles

5. You want to embed a Tableau dashboard in your company portal and ensure it is accessible to screen readers and keyboard users. Which approach best supports accessibility?

hard

A. Export the dashboard as a PDF and upload it to the portal

B. Embed the dashboard using a simple iframe without any additional attributes

C. Use an image snapshot of the dashboard with alt text

D. Use Tableau JavaScript API to embed the dashboard and add ARIA labels and keyboard navigation support

Solution

1. Step 1: Understand accessibility needs

   Screen readers and keyboard users require semantic markup and ARIA labels, which simple iframes or images lack.

2. Step 2: Choose embedding method supporting accessibility

   The Tableau JavaScript API allows adding ARIA attributes and keyboard controls, improving accessibility over static or iframe embeds.

3. Final Answer:

   Use Tableau JavaScript API to embed the dashboard and add ARIA labels and keyboard navigation support -> Option D

4. Quick Check:

   JS API + ARIA = better accessibility [OK]

Hint: Use JS API with ARIA labels for accessible embeds [OK]

Common Mistakes:

• Assuming iframe alone is accessible
• Using static images or PDFs instead of live dashboards
• Ignoring keyboard navigation needs