Exploring complex data visualization | My Assignment Tutor

1CopyrightWarningThis material has been reproduced and communicated to you by or on behalf ofFederation University Australia in accordance with Section 113P of the Copyright Act1968 (the Act).The material in this communication may be subject to copyright under the Act. Anyfurther reproduction or communication of this material may be the subject of copyrightprotection under the Act.Do not remove this notice.ITECH3101 –Business Analytics and Decision Supportweek 4Lab Exercise – Exploring complex data visualizationID: Name: __________In this week’s projects, we mainly discuss how to visualize complex data. Herevisualizing complex data indicates that visualization cannot be achieved through directlyusing existing fields from raw data source because these fields don’t exist in raw datasource. Instead, for visualizing complex data, we need to take simple computation onthe existing fields and to combine the existing fields in order to make new dimensions ormeasures that don’t exist in raw data source. In particular, we visualize complex data bycreating calculated fields and using parameter controls, etc. Before introducing detailedtechniques for visualizing complex data, we briefly discuss basic approaches that can beused to process complex data.Two basic approaches to process complex dataBasic approaches for processing complex data is to create calculations for improving andenhancing your data. We mainly discuss two approaches to enhance data: calculatedfields and parameter controls. These approaches can be used to derive fact anddimensions that don’t exist in your source data and these newly derived measures anddimensions can be used in an interaction design in dashboard and worksheet.2Calculated fieldsCreating a calculated field refers to add new fields into Tableau workbook where thesefields don’t exist in raw data source. Calculated fields can be used to generate numbers,dates and strings, etc. In particular, calculated fields can be used to compare therelationship among fields such as ratio and percentages, etc., answer interactionquestions and design effective interaction.Parameter controlsParameters refer to variables that enable users to change the content that appears inworksheets and dashboards. With properly using parameter and parameter controls, thecontext of views can be changed dynamically. For example, parameters can be used toquickly toggle between views with different variables and thus they provide an effectiveway to control what facts and dimension are displayed based on visual designer’sintention.Project 1: Creating calculated fields to display population density of adistrictTask: The given dataset provides information about population and area in a city. Thegoal of this task is to create calculated field for displaying population density of a district.1. Download Dataset: simple-data-bogoughs.xlsx from Week 4 in MoodleStep 1. Load the data into Tableau and check that your data has been loaded correctly..Step 2. Create a calculated field.Step 3. Create a filled map to display population density.Step 4 Edit locationStep 5 Add label to mapStep 1. Load the data into Tableau and check that your data has been loadedcorrectly.3Step 2. Create a calculated field.Population density can be expressed as formula of population being divided by area.Right click any location in Dimensions or Measures area and select Create CalculatedField.Then input density formula as following. After clicking OK button, a new field ofPopulation Density you just created appears in the Measures area.4Step 3. Create a filled map to display population density.Select County, hold down the Control key and then select Population Density andselect filled map in Show Me cardStep 4. Edit locationIn the lower-right area of the map, there is a gray text (5 unknown). This indicates thatfive geographic records are unrecognized in dataset. So we need to change location fromAustralia to United States.Clicking the gray text to open a menu5Click Edit Location and change location6Step 5. Add label to mapDrag County to Label in the Marks card.QuestionBased on the above filled map, which county has the highest population density? Why?Project 2: Use parameter controlsTask: The given dataset provides information about premier league games such as teams,played, won, d, and points, etc. The goal of this task is to create a slopegraph and to allowyou to be familiar with using parameter controls for visualising complex data.To complete this task, complete the following steps:Step 1. Load the data into TableauStep 2. Create a parameterStep 3. Create a calculated fieldStep 4. Create a slopegraph7Step 5. Change line thicknessStep 6. Create a dashboardDownload Dataset: club-game-data.xlsx from Week 4 in MoodleStep 1. Load the data into TableauCheck that your data has been loaded correctly.Step 2. Create a parameterThe parameter created here will allow users to select which stat to chart. Right click anylocation in Dimensions and Measures area and select Create Parameter.8Then type parameter in the dialog box.After clicking OK button, you would see that the parameter Select you just createdappears at the bottom left. Clicking the parameter allows you to change the value ofparameter.9Step 3. Create a calculated fieldIn order to connect to different team stats according to users’ selection, we need to createa calculated field for linking the parameter. In other words, this newly created calculatedfield will match the parameter of users’ input so that the visualization will dynamicallyreflect users’ choices.Right click any location near Parameter area, select Create Calculated Field and fill outthe box. After clicking OK button, you see that Selected appears in Measures area.Step 4. Create a slopegraphWe now use newly created calculated field to create slopegraph.Drag Year to Columns shelf, right click Year in Columns shelf to select Discrete. Thiswill change Year from continuous data type (green color) to discrete data type (bluecolor).Drag Selected you just created to Rows shelf, navigate to Marks card area and changeMarks type from Automatic to Line.Drag Club to Detail in Marks area and resize the view, and then drag another Club fromDimensions to Label in Marks area.In Marks area, click the Label and untick Allow label to overlap other marks and selectLine ends10Step 5. Changing line thicknessTo change line thickness, we create two calculated field.Create a calculated field Delta and a calculated filed Magnitude.11Drag Magnitude to Size and drag Selected to Label in Marks area12Step 6 create a dashboardClick Dashboard on the top tool bar, drag Sheet 1 from the left pane to the centre andchange dashboard title.13Project 3: Explore different color coding schemesPurpose: To visualise data by using different colour encoding schemes.Task: The given dataset provides information about product sales, product price, profit,product category and customers for a superstore. The goal of this task is to visualise thedata by selecting proper colour encoding schemes.1. Download data set: product–sales–customer.xlsx from Week 4 in MoodleFollow the steps below in Tableau:• Step 1. Load the data into Tableau and check your data has been loaded correctly.• Step 2. Create a bar chart.• Step 3. Add color to the bar chart.• Step 4. Create customized colors for individual marks.• Step 5. Compare your bar chart with a pie chart.Step 1. Load the data into Tableau and check your data has been loaded correctly.Step 2. Create a bar chartDrag Product Sub-Category to Rows shelf, then drag Sales to Columns shelf, then sortthe bars in descending order.14Step 3. Add color to the bar chartDrag Product Sub-Category to the Color shelf and drag Sales to Label shelf.Step 4. Create customized colors for individual marks.15Click Color button, and click Edit Colors to select required color.Step 5. Compare the bar chart with the pie chartClick on the pie chart in the Show Me panel, and drag the Sales to the Label shelf.16Discussion: Are colors and charts used effectively?Task: What do you think about the visualization shown below? If the visualization ispoor, give your reasons and provide ideas for how to improve it. Go to the Are colors andcharts used effectively? discussion forum.When participating in the discussion, please focus on the following questions:1. Are colors used effectively?2. Does this visualization encourage any misperceptions?3. How could this visualization be improved? Offer specific suggestions.17Project 4: Visualizing spatial dataPurpose: To become familiar with a map as an effective approach for visualizing spatialdata.Task: The given dataset provides information about population, spatial data and thedistricts in a city. The goal of this task is to explore the spatial data and visualize thespatial data as a map by using two positional encodings: latitude and longitude. We alsouse different color coding schemes in visualizing spatial data.1. Download Dataset: borough-population-area.xlsx from Week 4 in MoodleStep 1. Load the data into Tableau and check your data has been loaded correctly.Step 2. Create a map.Step 3. Edit location data.Step 4. Add population information to the map.Step 5. Add color encoding to show population density on the map.Step 1. Load the data into Tableau and check your data has been loaded correctly.18Step 2. Create a mapDouble-click on the geographic data field ‘State’ and double-click on geographic datafield ‘County’ to show background map. There is a grey text (in the lower-right area ofthe map) that includes words (5 unknown). This indicates that five geographic records areunrecognized in the dataset. Thus, we need to deal with the unknown records.19Step 3a. Edit location dataClick the grey text to edit location data.Step 3b. Change County location.Change County/region from Australia to United States.2021Step 4. Add population information to the mapDrag Population from the ‘Measures’ shelf to ‘Size’ shelf.Step 5. Add color encoding to show population density to mapCreate a new calculated field to show population density. Right-click anywhere in the‘Dimensions’ or ‘Measures’ area and select ‘Create Calculated field’.22Drag the ‘Population Density’ field to ‘Color’ shelf.Change color to green.23Project 5. Answering questions (Please do this at your home by using your owncomputer)1. List and describe the three major categories of business reports.Project 6. Creating a Professional ReportSummarize the above experiments procedure, results, answering questions andscreenshots (project 1, 2, 3, 4,5) into one report. Your report is the assignment that is24required to be submitted for evaluation on week 9. Create a report by following belowsteps.You can add a chapter called Chapter 4 in your previous report.1. Open your last week’s report and find the end of last week’s report.2. Copy this week’s related experimental results, your findings and Screenshots, andpaste them at the end of last week’s report.3. Delete original Table of Content you created.4. Select all content , align all text to both left and right margin5. Use shortcut key approach, generate Chapter 4: Exploring complex datavisualization6. Then use shortcut key approach to generate proper sub-chapters for this week’slab work.7. Insert Table of Contents to your report.