How did the graph change when you changed the date field

Assignment Help Business Management

Reference no: EM133668294

Assignment: Tableau Lab

Open the Reactors Operating File (xls) in Tableau.

Drag the Operating Rx-data.gov sheet into the data connection canvas.

Run interpreter.

Review the Excel file that Tableau generated.

I. Question I: Note the changes that the interpreter made.

A. What data (if any) did the interpreter ignore?

B. What data were interpreted as column headers?

C. How many rows did the interpreter remove?

Select "2018 capacity factor" through "2003 capacity factor" columns and pivot.

II. Question II: How many rows does your dataset contain after pivoting? (Note that Tableau displays a maximum of 1000 rows. You can increase the maximum number by clicking the box containing "1,000" and increasing the number).

III. Question III: Is this dataset ready for analysis? Would you make any other changes? Explain.

Split the "Pivot Field Names" column (right-click on the column and select split in the dropdown)

IV. Question IV: Are all fields (or columns) named appropriately? If not, what fields need to be renamed?

Rename fields that need to be renamed.

V. Question V: 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 the icon and select the appropriate type from the drop-down menu)

VI. Question VI: Which column contains a calculated field (hint: look for a = in front of the data type icon)? Why is this column a calculated field?

A. Click on Sheet 1. Drag the capacity factor field (the field that was created in the pivot step) to rows. Notice that the field is aggregated as a sum. Change the sum aggregation to average by right-clicking on the field selecting measure and then average.

B. Drag the date field corresponding to the year that the capacity factor was measured to the column's shelf. Note the result. (Hint: examine the x-axis.)

C. Drag reactor and containment type to color.

D. Change the date field to continuous (right-click on the field and select continuous). Note how the graph changes. (Hint: examine the x-axis).

VII. Question VII: How did the graph change when you changed the date field to continuous? Why is it better to use the continuous field?

Reference no: EM133668294

Questions Cloud

How do you communicate the diagnosis : When you are speaking with a client who may have just been diagnosed with a serious mental illness, how do you communicate the diagnosis

Purpose of a swot analysis in a business planning process : Outline three areas that the initial business planning process may address. Describe the purpose of a SWOT analysis in a business planning process

What caused the challenging behavior in the child : Describe what behavior causes the teacher to use the FLIP IT technique? What triggered/caused the challenging behavior in the child?

Person-centered therapy in addressing the clients needs : What are the benefits and limitations of using Person-centered therapy in addressing the client's needs?

How did the graph change when you changed the date field : How did the graph change when you changed the date field to continuous? Why is it better to use the continuous field?

Definition of conduct disorder : Definition of conduct disorder. Which contributing factors do you see as most impactful in the development of Conduct Disorder?

Describe early childhood profession in terms of personality : Describe essential attributes of the early childhood profession in terms of personality, education, cultural competency, and ethical conduct.

Learning experiment and were randomly assigned : Participants were recruited and told that they would be part of a learning experiment and were randomly assigned to groups.

How are you raising your awareness of implicit bias : How are you raising your awareness of implicit bias on a regular basis? Explore your organization's implicit bias training.

User Account

All Pages