Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data Fields and Variables Lab and Homework The reactors - operating file was downloaded from Data.gov in January of 2 0 2 0 and contains
Data Fields and Variables Lab and Homework
The reactorsoperating file was downloaded from Data.gov in January of and contains information about location and power capacity of nuclear reactors in the United States.
As you had done in your previous assignment:
Open the Januaryreactorsoperating.xls file in Tableau.
Drag Operating Rxdata.gov sheet into the data connection canvas.
Run interpreter.
Review the excel file that Tableau generated.
Select capacity factor through capacity factor columns and pivot.
Split the Pivot Field Names column right click on the column and select split in the dropdown
Question : Are all fields or columns named appropriately? If not, what fields need to be renamed?
Rename fields that need to be renamed.
Question : Are all data types correct? For example, are date fields showing the date icon? Are there any fields that seem numeric but refer to categories? List incorrect data types.
Correct the data types click on icon and select the appropriate type from the dropdown menu
Question : Which column contains a calculated field hint: look for a in front of the data type icon Why is this column a calculated field?
Click on Sheet Drag the capacity factor field the field that was created in the pivot step to rows. Notice that the field is aggregated as sum. Change the sum aggregation to average by rightclicking on the field and selecting measure and then average.
Drag the date field corresponding to the year that the capacity factor was measured to the columns shelf. Note the result. Hint: examine the xaxis.
Drag reactor and containment type to color.
Change the date field to continuous right click on the field and select continuous Note how the graph changes. Hint: examine the xaxis
Question : How did graph change when you changed the date field to continuous. Why is it better to use the continuous field?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started