Ultimate Tableau Desktop Course - Beginner to Advanced Bundle - Exercise 5

This tutorial guides users through the process of importing a US energy generation dataset into Tableau, creating calculated fields, and constructing a Sankey diagram. It covers steps for data manipulation, view construction, and formatting. The tutorial also includes creating additional views and setting up a dashboard with highlight actions to visualize energy generation by producer and source.

What is the first step in importing the US energy generation data set into Tableau?

• Create a new dashboard

• Import the data set and UNION the sheet to itself

• Create a calculated field

• Set up highlight actions

What is the purpose of creating a 'two pad' calculated field?

• To adjust the size of the lines

• To tag numbers for the first and second tables

• To create a bin for visualization

• To set the color of the chart

How is the 'padded' bin used in the visualization?

• It is used to set the color of the chart

• It is placed in the Rows shelf

• It is used to adjust the axis range

• It is placed in the Details card

What is the expression used for the 'sigmoid' calculated field?

• 1 / (1 + Exp(1) to the power symbol minus t)

• Running_sum(generation MW hours) over total

• Index Open and close (-25) / 4

• Window_average(some(generation MW HOURS))

Which calculated field is used to construct the view by placing it into the row's shelf?

• Rank one

• Curve

• Sigmoid

• Line size

What is the final step in formatting the chart before adjusting line size?

• Set Grid lines and 0 lines to None

• Hide both headers

• Set the Mark type to Circle

• Edit the color palette

How is the 'line size' calculated field used in the visualization?

• It is used to set the color of the chart

• It is placed in the size card

• It is placed in the Columns shelf

• It is used to adjust the axis range

What is the purpose of creating a dashboard in the final section?

• To format the chart

• To create calculated fields

• To arrange views and set highlight actions

• To import the data set

Which action should be set to run on hover in the dashboard?

• Highlight action for Energy Source

• None of the actions

• Highlight action for type of Producer

• Both highlight actions

What is the final title set for the dashboard?

• Power generation of each producer to Energy Source

• US Energy Generation Overview

• Sankey Diagram of Energy Sources

• Energy Source and Producer Analysis