Google Sheets connection in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Google Sheets Connection in Tableau

Which of the following is required to connect Tableau to a Google Sheets document?

A A downloaded CSV file of the Google Sheet

B Only the Google Sheets URL without login

C The Google Sheets URL and a valid Google account login

D An API key from Google Cloud Platform

💡 Hint

Think about what Tableau needs to access private Google Sheets data.

Tableau requires both the Google Sheets URL and a valid Google account login to authenticate and access the sheet data.

❓ dax_lod_result

intermediate

Filtering Data from Google Sheets in Tableau

You connected Tableau to a Google Sheet containing sales data. You want to create a calculated field that sums sales only for the year 2023. Which Tableau calculation will give the correct sum?

Tableau

SUM(IF YEAR([Date]) = 2023 THEN [Sales] ELSE 0 END)

A SUM(IF [Date].Year = 2023 THEN [Sales] ELSE 0 END)

B SUM(IF [Date] = 2023 THEN [Sales] ELSE 0 END)

C SUM(IF YEAR([Date]) = '2023' THEN [Sales] ELSE 0 END)

D SUM(IF YEAR([Date]) = 2023 THEN [Sales] ELSE 0 END)

💡 Hint

Remember how to extract the year from a date in Tableau calculations.

Option D correctly uses YEAR([Date]) to extract the year and compares it to 2023 as a number.

❓ visualization

advanced

Best Visualization for Google Sheets Sales Data

You imported monthly sales data from Google Sheets into Tableau. You want to show trends over time and compare sales by product category. Which visualization type is best?

A Line chart with months on the x-axis and sales on the y-axis, color-coded by product category

B Pie chart showing total sales by product category

C Bar chart with product categories on the x-axis and total sales on the y-axis

D Scatter plot with sales on x-axis and months on y-axis

💡 Hint

Think about how to show changes over time and compare categories simultaneously.

A line chart with time on the x-axis and sales on the y-axis, colored by category, clearly shows trends and comparisons.

🔧 Formula Fix

advanced

Troubleshooting Google Sheets Refresh in Tableau

You connected Tableau to a Google Sheet, but after updating the sheet, Tableau does not show the new data. What is the most likely cause?

A Tableau data source is not set to refresh automatically or manually refreshed

B Google Sheets URL has changed and needs to be updated in Tableau

C Google Sheets file is corrupted and cannot be read

D Tableau does not support Google Sheets as a data source

💡 Hint

Think about how Tableau handles live data connections and refreshes.

Tableau requires manual or scheduled refresh to update data from Google Sheets; without refresh, old data remains.

🎯 Scenario

expert

Optimizing Performance for Large Google Sheets in Tableau

You have a very large Google Sheets file connected to Tableau. The dashboard loads slowly. Which approach will best improve performance?

A Increase the size of the Google Sheets file by adding more columns to reduce row count

B Extract the Google Sheets data into a Tableau Data Extract (TDE) and use the extract instead of live connection

C Use a live connection and refresh the data every 5 seconds

D Remove all filters from the Tableau dashboard to speed up loading

💡 Hint

Think about how Tableau handles large data and the difference between live and extract connections.

Using a Tableau Data Extract improves performance by storing data locally and reducing load times compared to live connections.