ISSS608 2017-18 T3 Assign Vaishnavi Praveen Agarwal Visual

The Challenge

Data Preparation

Visualization Tools

VAST Submissions

Feedback and Comments

 

 

 

[[| Chart Creation]]

[[| Dashboard Creation]]

|} -->

[ Click here to explore the live dashboard]

The visualizations covered in this section are in order of creation and presentation on the live dashboard. The dashboard investigative journal is compartmentalized into 5 chapters. For each chapter, a brief description of each of the visualizations created is summarized below:

Chapter 1

1. Calendar Plot:

[[|center|border]]

Figure 1

The calendar plot is a representation of a monthly calendar to show the number of observations captured by each Sensor for the months of April, August and December 2016.

To make the above plot, the fields added to Tableau rows and columns and the filters applied are shown below:

[[|500px|center|border]]

Figure 2

[[|200px|center|border]]

Figure 3

Users are given the option to filter by Month (April, August and December), Monitor (Sensors 1 to 9) and the calculated field – Selected Chemical, which enforces the option to select any or all chemicals to view in the Calendar chart. Selected Chemical is a calculated field that leverages on the user selection of one or more chemicals using a user input Tableau Parameter called Q1_ChemicalList. The calculations for both are as follows:

[[|400px|center|border]]

Figure 4

[[|250px|center|border]]

Figure 5

As shown above, the DateTime field was modified to show the month, week and weekdays in the respective columns and rows. The Marks card and Tooltip configuration in Tableau for this chart is shown below:

[[|250px|center|border]]

Figure 6

[[|350px|center|border]]

Figure 7

The SUM(Number of Records) are filled in this calendar plot. All the fields in the Marks card except for Monitor Color Bin are used to configure the tooltip which provides more detail on hovering through this chart.

The use of stepped colors allows the audience to differentiate between lesser than expected number of observation, expected number of observations and greater than expected number of observations on that day.

The Monitor color bin calculated field helps in doing so. The calculation and usage of this field to color the calendar plot is shown below:

[[|350px|center|border]]

Figure 8

[[|250px|center|border]]

Figure 9

2. Hourly Heatmap of Chemical Readings:

[[|800px|center|border]]

Figure 10

Similar to the Calendar chart described above, the Hourly heatmap data table chart uses the Monitor and Hours of the day fields in the respective Rows and Columns section as shown below.

The Marks section in Tableau for this chart is shown below. Labelling and coloring of this chart is configured by the field SUM(Number of Records) and the selected shape type is Square.

[[|350px|center|border]]

Figure 11

[[|200px|center|border]]

Figure 12

[[|200px|right|border]]

This chart allows for filtering on all the fields shown below and also by a particular day. The reason for doing so is to interactively link this hourly readings heatmap with the Calendar chart described above to show the hourly readings of any selected day.

3. Deviation by Chemical: Line Chart:

[[|400px|center|border]]

Figure 13

The purpose of this graph is to show deviation in the number of observational readings captured for each chemical on any day. The line graph shows hourly deviations, if any.

Hours of the day and the SUM(Number of records) have been plotted on the rows and columns. Instead of showing the absolute value of number of records, a table calculation to show the deviation in number of records has been made; as shown below:

[[|350px|center|border]]

Figure 14

[[|200px|center|border]]

Figure 15

The Marks section and tooltip configuration is shown below. The Chemical field has been for the detail and coloration of this chart.

[[|150px|center|border]]

Figure 16

[[|300px|center|border]]

Figure 17

Similar to filters applied in the previous two graphs, this chart also filters on monitor, time-period and selected chemical. The additional filter added to SUM(Number of Records) is to remove null values if any.

[[|300px|center|border]]

Figure 18

[[|300px|center|border]]

Figure 19

Chapter 2

1. Dynamic Horizon Chart:

[[|800px|center|border]]

Figure 20

The dynamic Horizon Chart is used to show the magnitude of chemical readings for monitors or chemicals and for any given time-period.

Audiences are encouraged to choose their Y and X axis to decide whether they want to plot the Horizon chart by chemical or by sensor and either by hours of the day or days of the selected month.

This is achieved by using the following two parameters.

[[|300px|center|border]]

Figure 21

[[|300px|center|border]]

Figure 22

Two corresponding calculated fields have been created which leverage on the user input through the above parameters. The fields are:

[[|450px|center|border]]

Figure 23

[[|350px|center|border]]

Figure 24

Based on the above fields, the fields of X and Y axis can be dynamically selected. Thus, the rows and columns of this chart include the following fields:

[[|400px|center|border]]

Figure 25

As shown above, the Measure Values fields are a part of the rows of this chart. The Measure values have been carefully selected by creating new calculated fields which consist of binned values of Chemical Readings.

For the purpose of this illustration, 4 bin fields have been created. Chemical readings have been binned based on the percentile and quantile values of ‘Chemical Readings’, based on the univariate analysis as covered in the Data Preparation section.

[[|300px|center|border]]

Figure 26

[[|350px|center|border]]

Figure 27

Therefore, the border conditions of the 4 Reading Bin fields has been calculated as:

[[|950px|center|border]]

Figure 28

This chart is filtered by month and using only the above previously mentioned Measure Names.

The Marks card contains the detail of SUM(Reading) which is then colored by the Measure Values which primarily consists of the 4 Reading bin values.

[[|250px|center|border]]

Figure 29

[[|200px|center|border]]

Figure 30

Finally, the titles resultant color legend of the resultant Horizon chart thus created was renamed to make the legend descriptions more readable.

[[|200px|center|border]]

Figure 31

Chapter 3

1. Marimekko Chart - Base:

[[|600px|center|border]]

Figure 32

In order to create the base part Marimekko chart, two new calculated fields were created.

[[|300px|center|border]]

Figure 33

[[|350px|center|border]]

Figure 34

Based on the above 2 fields, the Number of Readings and SUM(Readings) fields were placed on columns and rows respectively.

[[|400px|center|border]]

Figure 35

However, table calculations were added for these fields in order to show the Readings as a percent of total readings and to ensure that the Number of Readings was calculated separately for each monitor.

[[|250px|center|border]]

Figure 36

[[|250px|center|border]]

Figure 37

The Marks card, as shown in the figure below, consisted of coloring by Chemical, labelling by percentage SUM(Reading) and size by Reading per column. All other fields in details were used for the tooltip configuration.

[[|250px|center|border]]

Figure 38

[[|350px|center|border]]

Figure 39

Finally, this chart was filtered by months in order for the audience to see the distribution of chemical readings across monitors for each month.

[[|200px|center|border]]

Figure 40

2. Marimekko Chart - Header:

[[|800px|center|border]]

Figure 41

The Marimekko header which consists of the Sensor names has to be placed on top of the Marimekko base with the exact width size of each sensor. In order to achieve this, the SUM(Readings) and a hardcoded title was plotted on Columns and Rows.

[[|300px|center|border]]

Figure 42

The following fields were added to the Marks section, with the corresponding tooltip configuration.

[[|250px|center|border]]

Figure 43

[[|350px|center|border]]

Figure 44

Finally, this header too was filtered by Selected Month as the width of each sensor heading should change as per its monthly chemical readings.

[[|250px|center|border]]

Figure 45

3. Dot Plot - Chemical Readings:

[[|800px|center|border]]

Figure 46

The dot plot chart shows the chemical readings across hours of the day or days of the month depending on user selection.

Similar to the Horizon chart, the X axis is dynamic based on the Q2_TimeFilter parameter and calculated field.

[[|400px|center|border]]

Figure 47

[[|500px|center|border]]

Figure 48

Therefore, the columns and rows for this chart are as follows:

[[|300px|center|border]]

Figure 49

The Marks card configuration is shown below. The SUM(Readings) is used to configure the label and size of the circles in this chart. The plot is also colored by Chemical and the remaining fields in the details pane are used to configure the tooltip.

[[|250px|center|border]]

Figure 50

[[|500px|center|border]]

Figure 51

Finally, this chart is filtered on months and actions have been defined to filter this plot based on selections made on the Marimekko chart.

[[|200px|center|border]]

Figure 52

Chapter 4

1. Wind Rose Illustration:

[[|400px|center|border]]

Figure 53

The purpose of the visualization in this chapter is to show an appropriate chart that could use the meteorological dataset and the location coordinates of Sensors to highlight the area where the chemical readings could have been captured from. For the purpose of this analysis, we call this the ‘influence area’ of each sensor.

Based on the given wind speed and direction at any point in time, a triangular region (polygon) is to be visualized for each sensor. As an illustration, the visualization in this chapter shows the mapping of the influence area of Sensor 1.

To recreate this illustration, we need to determine the 3 required coordinates for the triangle covering the influence area at any particular time. Since the origin point (sensor location) is already known, we need to calculate the 2 other coordinates of the triangle (Destination 1 and Destination 2). The angle thus created to map a triangle is unknown and therefore can be determined from a user input parameter, as shown below:

[[|400px|center|border]]

Figure 54

Since the entered angle would be based on a 2-D map and the requirement of this analysis is to visualize the direction of north-facing wind; the input angle is recalculated by using the following formula:

[[|300px|center|border]]

Figure 55

Based on the given angle of the triangle to be plotted, we need to calculate the two other triangular coordinates – Destination 1 and Destination 2. The calculated fields for the same are as follows.

[[|500px|center|border]]

Figure 56

[[|500px|center|border]]

Figure 57

Based on the above calculated fields, the Recalculated X and Recalculated Y were then added as columns and rows. Moreover, the SUM(Reading) and Date fields were added as details in the Marks card with the selected shape as Polygon.

[[|350px|center|border]]

Figure 58

[[|200px|center|border]]

Figure 59

Additionally, filters were added for this illustration so that the readings for only Sensor 1 is shown and the audience can only look at one time frame at a time.

[[|200px|center|border]]

Figure 60

After this, worksheet was formatted to remove all the axis labels and marks.

Finally a background image of a compass was added with the following dimensions and axis points to map around the origin points of Sensor 1.

[[|400px|center|border]]

Figure 61

Chapter 5

Based on the concepts covered in Chapter 4, the visualizations in Chapter 5 include a Coxcomb chart for all sensors overlayed by the geographical map of Mistford to highlight the wind direction during the time-frame of high chemical readings. The visualizations developed for this dashboard are described below:

1. Top Chemical Readings table:

[[|250px|center|border]]

Figure 62

This data table ranks the instances of high chemical readings that were captured by any of the sensors. There is flexibility for the audience to see as many records at a time (upto top 100 records). This has been achieved by using a parameter field:

[[|350px|center|border]]

Figure 63

To rank the observations with high chemical readings and dynamically display these records depending on how many observations the audience wants to see, the following calculated fields were created.

[[|300px|center|border]]

Figure 64

[[|300px|center|border]]

Figure 65

After this, a data table with ranked chemical readings per sensor was created by adding the relevant fields to the Rows; and the details and label text section of the Marks card.

[[|500px|center|border]]

Figure 66

[[|200px|center|border]]

Figure 67

Finally, since the users can filter this table for each chemical; the Filters card contained the following fields. A table calculation was added to the FilterRank field in order to rank the chemical readings across the entire table.

[[|250px|center|border]]

Figure 68

[[|200px|center|border]]

Figure 69

2. Coxcomb Chart:

[[|650px|center|border]]

Figure 70

The Coxcomb chart was constructed based on the fields created in the visualizations for Chapter 4. For this chart, a background image of the geolocation points of the city of Mistford was added.

[[|500px|center|border]]

Figure 71

As explained in the visualization of Chapter 4, the fields – Recalculated X and Recalculated Y were used in Rows and Columns. Additionally the date field was added to show the exact date and time during periods of high chemical reading.

[[|400px|center|border]]

Figure 72

The date field was reformatted as follows:

[[|400px|center|border]]

Figure 73

The following fields were added to the Marks card and the shape was set to Polygon. The opacity of the Color was changed to 20% and a border was added.

[[|150px|center|border]]

Figure 74

[[|150px|center|border]]

Figure 75

In addition, the following fields were added to the Filters card:

[[|200px|center|border]]

Figure 76

As shown above, the Selected Chemical is filtered upon as the audience has the capability to dynamically change the selected chemical. The Date field has been added as a shared filter which is commonly applied also to the Sensor monitor worksheets (as explained in the next visualization). This is done so that all the worksheets in this dashboard display one reading at a time on a particular date. Finally the Recalculated X field is filtered on non-null values as a precaution.

3. Sensor Monitors:

There are 9 sensor monitors displayed in the dashboard which are represented by 9 corresponding worksheets.

Each of these worksheets contains readings for one sensor at a time and the worksheet has been overlayed on top of a Monitor image in the final dashboard.

[[|300px|center|border]]

Figure 77

In order to make this data table, the Chemical field was added to Rows and the Attribute of the Reading field was added to label text in the Marks card. Additionally, the SUM(Reading) field was used to color the chemical readings using stepped colors, as shown below:

[[|300px|center|border]]

Figure 78

[[|150px|center|border]]

Figure 79

[[|250px|center|border]]

Figure 80

Other formatting/cosmetic changes in these sheets include:

• Changing the background color of the worksheet to Black
• Removing all borders
• Changing the font color of Chemicals to White.

Finally, the Filters card included fixing the worksheet for one Sensor, the shared date filter across all Sensor sheet and the Coxcomb chart and Selected Chemical to be true so that the audience can analyse one chemical at a time.

[[|300px|center|border]]

Figure 81

The worksheets for the other 8 monitors were constructed in a similar fashion all the remaining 8 sensors.