Lab2

docx

School

Humber College *

*We aren’t endorsed by this school

Course

1252

Subject

Information Systems

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by DukeAlpaca3895

Lab-2 Ayush Shah N01543077 1) Launch Tableau and connect to the “DataFile-Incidents” Excel file. 2) Review the data in the data grid. What do you observe?

According to the data in the data grid, it appears that headers and footers are being entered into tables along with additional fields labeled F1, F2, and so forth. 3.Turn on Data Interpreter and observe the changes in data grid.

When the data interpreter is turned on, the data grid displays the changes, such as the fact that the field names are now appropriate based on the excel data and that the header and footers are no longer regarded as data in the table. 4.Next, we want to change the format from the column-per- month layout into a single date column and a single column for Resolved Incidents. Use the Pivot functionality to merge the information from the original columns and rows into two new columns. Select all the columns that are required, use right click, and select Pivot.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

5 Rename these new columns to give appropriate names.

6 Go to the worksheet and recreate the following three visualizations.

7 Create a new Tableau workbook. 8 Connect to DataFile-GlobalSuperstore excel sheet provided on the Blackboard.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

9 Create a textual view of the measures in the Orders dataset. Use the visualizationbelow as a guide. Drop Measure names (dimension) in rows Drop Measure values (measures) in Text in Marks.

10 Create a graphical view of the measures in the Orders dataset. Use the visualizationbelow as a guide. double click Measure values (Measures)

11 \Create a visualization to compare the Sales, Profit and Shipping cost in a single graph.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

12 Create a drill down visualization to compare the sales with Product category and sub-category.  Create a Hierarchy by dragging Sub- Category into Category in the Data Pane.  Rename the hierarchy.  Drag Sum(Sales) in Rows and Category_Hierarchy in columns. Use the drill down button to create the visualization below.

13 Create a visualization that groups the Canada and US markets and compares that to sales of other markets. Drag and drop Sales and Market in columns and rows respectively. Highlight Canada and US and select the paperclip button at the top and group them into Market.

 The final display looks like this:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Lab2

Related Documents