Excel and CSV connections in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Excel and CSV Data Connections in Tableau

Which of the following statements about connecting Excel and CSV files in Tableau is correct?

A Tableau can connect to both Excel and CSV files, but CSV files are always imported as extracts, not live connections.

B Tableau can connect to Excel and CSV files, and both can be used as live connections or extracts depending on user choice.

C Tableau treats Excel and CSV files the same way and always imports data as live connections.

D Tableau can connect to Excel files but cannot refresh data from CSV files automatically.

💡 Hint

Think about how Tableau handles file-based data sources and the options it offers for data refresh.

Tableau allows connections to both Excel and CSV files. Users can choose to use live connections or create extracts for both file types, depending on their needs.

❓ dax_lod_result

intermediate

Data Refresh Behavior for Excel and CSV Connections

When you connect Tableau to an Excel file and a CSV file, which statement best describes how Tableau handles data refresh for these files?

A Tableau cannot refresh data from Excel files once connected; CSV files refresh automatically.

B Tableau automatically refreshes data from Excel files but requires manual refresh for CSV files.

C Tableau requires manual refresh for both Excel and CSV files unless extracts are scheduled on Tableau Server.

D Tableau refreshes data automatically for both Excel and CSV files without any user action.

💡 Hint

Consider how Tableau handles file-based data sources and the role of Tableau Server in scheduling refreshes.

Tableau requires manual refresh of data from Excel and CSV files unless extracts are published and scheduled on Tableau Server or Tableau Cloud.

❓ visualization

advanced

Best Practice for Visualizing Data from Excel and CSV in Tableau

You have connected Tableau to a large Excel file and a CSV file with millions of rows. What is the best practice to ensure smooth and fast visualization performance?

A Split the CSV file into smaller files and connect to each separately using live connections.

B Use live connections for both files to always get the latest data.

C Convert the Excel file to CSV and use live connection only for the CSV file.

D Create extracts for both files and apply filters to reduce data size before visualization.

💡 Hint

Think about how Tableau handles large datasets and what improves performance.

Creating extracts and applying filters reduces data size and improves performance when working with large Excel and CSV files in Tableau.

🔧 Formula Fix

advanced

Troubleshooting Data Type Issues in Excel and CSV Connections

You connected a CSV file to Tableau, but some numeric columns are treated as text, causing aggregation errors. Which option is the most likely cause?

A The CSV file has mixed data types in the same column, causing Tableau to treat the column as text.

B Tableau does not support numeric data in CSV files.

C The Excel file connected previously is interfering with the CSV data types.

D Tableau automatically converts all CSV columns to text by default.

💡 Hint

Consider how Tableau infers data types from CSV files.

If a CSV column contains mixed data types (numbers and text), Tableau treats the entire column as text to avoid errors.

🎯 Scenario

expert

Scenario: Automating Data Refresh for Excel and CSV Sources

You have a Tableau dashboard connected to an Excel file and a CSV file stored on a shared network drive. You want the dashboard to update automatically every morning without manual intervention. Which setup is most effective?

A Publish extracts of both files to Tableau Server and schedule daily extract refreshes pointing to the network drive location.

B Convert both files to a database and connect Tableau to the database for automatic refresh.

C Use live connections to both files and rely on Tableau Desktop to refresh data when opened.

D Manually refresh extracts in Tableau Desktop every morning before opening the dashboard.

💡 Hint

Think about how Tableau Server can automate data refreshes for file-based sources.

Publishing extracts to Tableau Server and scheduling refreshes allows automatic daily updates without manual steps.