ISSS608 2017-18 T3 Assign Vaishnavi Praveen Agarwal Visual

  VAST Challenge: Mini Challenge 2

The Challenge

Data Preparation

Visualizations

Insights and Conclusion

Feedback and Comments

All Assignments

Dimensions and Measures

The finals dataset contains various columns and the columns are divided into Dimensions and Measures in Tableau based on their properties. Before starting with the Visualization, lets get familiar with the available Dimensions and Measures.

Measure by Location

The data has a total of 106 chemicals (12 groups) and 10 places. I want to analyze the trend of each measure at all the places for years 1998 - 2016. This visualization will help to compare the average values and select the place that has the highest reading of a measure.

Create a Calculated Field The measures have three different units: mg/l, µg/l, and °C. The unit for average value should change according to the measure, therefore we will use this calculated field to automate the y-axis label. Right click on Dimension and select Create Calculated Field Name it as Automatic_Axis The formula for the calculated field is as shown in the picture.
Add Filters The user should be able to visualize the measure of their choice, therefore the graph should filter the data according to the selected measure. Create a hierarchy of Groups and Measures, this will allow the user to select a group and then select a measure of that group. Drag and drop Groups and Measures to Filters. Click on the fields in filters, select Show Filter and select the Filters to be Single Value (list).
Plotting the Graph Columns: Location, YEAR(Sample Date) Rows: Automatic_Axis, AVG(Value) Details: Measure, Groups, Location, YEAR(Sample Date) Tooltip: Measure, Groups, Location, YEAR(Sample Date), AVG(Value) Title: Measure, Groups NOTE* The Measure for Value is selected as Average(AVG) because there are various readings taken every year, and to compare the readings across years I have plot the value of a measure in a year as the average of all the readings in that year.

Month-wise Readings

This graph will give the user month-wise readings of the selected measure, for the selected place and year. This can help the user get a detailed insight as for which month the readings are high, and is there any particular month where the reading are high. This graph will be a drill-dwon from Measure by Value graph.

Plotting the Graph Columns: YEAR(Sample Date), MONTH(Sample Date) Rows: Automatic_Axis, AVG(Value) Details: Measure, Groups, Location, YEAR(Sample Date) Tooltip: Measure, Groups, Location, YEAR(Sample Date), MONTH(Sample Date), AVG(Value), SUM(Number of Records) Title: Measure, Location, YEAR(Sample Date) NOTE* The Measure for Value is selected as Average(AVG) because there are various readings taken in a month, and to compare the readings across months, I plot the value of a measure in a month as the average of all the readings in that month.

No. of Records

This graph will show how many reading where taken for the selected measure from 1998-2016. The heat-map makes it visually easy to spot the variation in the number of readings based on the color.

Add Filters The user should be able to visualize the measure of their choice, therefore the graph should filter the data according to the selected measure. Create a hierarchy of Groups and Measures, this will allow the user to select a group and then select a measure of that group. Drag and drop Groups and Measures to Filters. Click on the fields in filters, select Show Filter and select the Filters to be Single Value (list).

Plotting the Graph Columns: Measure, Location Rows: YEAR(Sample Date) Details: Measure, Location, YEAR(Sample Date) Label: SUM(Number of Records) Color: SUM(Number of Records) Tooltip: Measure, Location, YEAR(Sample Date), SUM(Number of Records) Title: Measure, Groups