Adding sheets to dashboard in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a worksheet named 'Sales' to the dashboard.

Tableau

dashboard = tableau.Dashboard()
dashboard.[1]('Sales')

Drag options to blanks, or click blank then click option'

Ainsert_sheet

Binclude_sheet

Cappend_sheet

Dadd_sheet

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'insert_sheet' which is not a valid Tableau method.

Using 'append_sheet' which is not recognized in Tableau API.

Use add_sheet method to add a worksheet to the dashboard in Tableau's API.

2fill in blank

medium

Complete the code to set the position of the sheet on the dashboard.

Tableau

dashboard.add_sheet('Profit')
dashboard.sheets['Profit'].[1] = (10, 20)

Drag options to blanks, or click blank then click option'

Acoordinates

Bposition

Clocation

Dplacement

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'location' which is not the correct property name.

Using 'coordinates' which is not a valid property.

The position property sets the location of a sheet on the dashboard.

3fill in blank

hard

Fix the error in the code to add multiple sheets to the dashboard.

Tableau

for sheet in ['Sales', 'Profit', 'Expenses']:
    dashboard.[1](sheet)

Drag options to blanks, or click blank then click option'

Aadd_sheet

Binsert_sheet

Cappend_sheet

DaddSheets

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'addSheets' which is not a valid method.

Using 'append_sheet' which does not exist.

The correct method to add sheets one by one is add_sheet. There is no method named 'addSheets'.

4fill in blank

hard

Fill both blanks to set the size and position of a sheet on the dashboard.

Tableau

sheet = dashboard.sheets['Expenses']
sheet.[1] = (300, 200)
sheet.[2] = (50, 100)

Drag options to blanks, or click blank then click option'

Asize

Bposition

Clocation

Ddimensions

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing 'location' with 'position'.

Using 'dimensions' which is not a valid property.

Use size to set width and height, and position to set the location on the dashboard.

5fill in blank

hard

Fill all three blanks to add a sheet, set its size, and position it on the dashboard.

Tableau

dashboard.[1]('Revenue')
sheet = dashboard.sheets['Revenue']
sheet.[2] = (400, 300)
sheet.[3] = (20, 40)

Drag options to blanks, or click blank then click option'

Aadd_sheet

Bsize

Cposition

Dinsert_sheet

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'insert_sheet' instead of 'add_sheet'.

Mixing up 'size' and 'position' properties.

First, use add_sheet to add the sheet. Then set size and position properties to control its appearance on the dashboard.

Practice

1. What is the main purpose of adding sheets to a Tableau dashboard?

easy

A. To delete unnecessary data sources

B. To combine multiple views for better insights

C. To create new calculated fields

D. To export data to Excel

Solution

1. Step 1: Understand the role of sheets in Tableau

   Sheets are individual views or charts created from data.

2. Step 2: Understand dashboard purpose

   Dashboards combine these sheets to show multiple views together for better analysis.

3. Final Answer:

   To combine multiple views for better insights -> Option B

4. Quick Check:

   Combining views = better insights [OK]

Hint: Dashboards show many sheets together for clear insights [OK]

Common Mistakes:

• Confusing sheets with data sources
• Thinking dashboards create new data
• Believing sheets export data

2. Which of the following is the correct way to add a sheet to a Tableau dashboard?

easy

A. Drag the sheet from the Sheets panel to the dashboard workspace

B. Right-click the sheet and select 'Delete'

C. Double-click the sheet to open it in a new window

D. Click 'Export' on the sheet menu

Solution

1. Step 1: Locate sheets panel in Tableau

   The Sheets panel lists all created sheets available to add.

2. Step 2: Add sheet to dashboard

   Dragging a sheet from this panel to the dashboard workspace places it on the dashboard.

3. Final Answer:

   Drag the sheet from the Sheets panel to the dashboard workspace -> Option A

4. Quick Check:

   Drag sheet to dashboard = add sheet [OK]

Hint: Drag sheets to dashboard workspace to add them [OK]

Common Mistakes:

• Trying to delete sheets instead of adding
• Double-clicking opens sheet, not adds to dashboard
• Exporting does not add sheets

3. You have a dashboard with two sheets: Sales by Region and Profit by Category. After dragging both sheets onto the dashboard, what will you see?

medium

A. Only the first sheet added will show

B. Sheets will merge into one combined chart automatically

C. Both sheets displayed side by side or stacked depending on layout

D. Dashboard will show an error message

Solution

1. Step 1: Understand dashboard layout behavior

   Tableau dashboards arrange sheets side by side or stacked based on layout settings.

2. Step 2: Confirm sheets display

   Dragging multiple sheets adds them all; they do not merge or hide.

3. Final Answer:

   Both sheets displayed side by side or stacked depending on layout -> Option C

4. Quick Check:

   Multiple sheets show together on dashboard [OK]

Hint: Multiple sheets appear together unless layout hides them [OK]

Common Mistakes:

• Thinking sheets merge automatically
• Assuming only one sheet shows
• Expecting error when adding multiple sheets

4. You tried to add a sheet to your Tableau dashboard by dragging it, but it does not appear. What is the most likely cause?

medium

A. The sheet is hidden or minimized in the dashboard layout

B. You need to restart Tableau to add sheets

C. Sheets cannot be added to dashboards after publishing

D. The data source is disconnected

Solution

1. Step 1: Check dashboard layout for hidden sheets

   Sometimes sheets are added but placed in hidden or collapsed containers.

2. Step 2: Verify sheet visibility

   Ensure the sheet container is visible and not minimized or overlapped.

3. Final Answer:

   The sheet is hidden or minimized in the dashboard layout -> Option A

4. Quick Check:

   Hidden sheet containers cause sheets not to appear [OK]

Hint: Check if sheet container is hidden or collapsed [OK]

Common Mistakes:

• Restarting Tableau unnecessarily
• Believing sheets can't be added after publishing
• Assuming data source disconnect stops adding sheets

5. You want to create a dashboard showing Sales, Profit, and Customer Count sheets. How can you arrange these sheets to make the dashboard clear and easy to understand?

hard

A. Overlap sheets to save space on the dashboard

B. Stack all sheets vertically without spacing or titles

C. Add all sheets randomly without arranging

D. Place sheets logically with related data close, use containers for alignment

Solution

1. Step 1: Understand dashboard design best practices

   Arrange sheets logically so related data is near each other for easy comparison.

2. Step 2: Use containers and spacing

   Containers help align sheets neatly; spacing and titles improve clarity.

3. Final Answer:

   Place sheets logically with related data close, use containers for alignment -> Option D

4. Quick Check:

   Logical layout + containers = clear dashboard [OK]

Hint: Use containers and logical placement for clarity [OK]

Common Mistakes:

• Overlapping sheets causing confusion
• No spacing or titles making dashboard cluttered
• Random placement reducing readability