IS428 2017-18 T1 Assign Shi Xiaoyu

Problem & Objective

Mistford is a mid-size city, located to the southwest of a large nature preserve. The city has a small industrial area with four factories. Recently, there is a significant decrease on the number of nesting pairs of the Rose-Crested Blue Pipit, a popular local bird. It is speculated that the downfall of the Rose-Crested Blue Pipit may be related to noxious gases from the factories near the preserve.

With the passage of the Mistford Pact of 2010, the city and the preserve have adopted certain safeguards to help ensure the safety of the people, animals, and vegetation of the area. With the aim in mind, air sampling sensors have been placed near the town and in the preserve to monitor air quality. In total, there are nine sensors to collect information on several substances of potential concern, such as Appluimonia, Chlorodinine and etc.

By using the data given, I aim to implement data visualization techniques to better analyse data and conduct tasks below:

• Characterize sensors’ performance and detect unexpected behaviors
• Identify the chemicals detected by the sensor group and the chemical release pattern
• Determine which factories are responsible for which chemical release with explanation. Identify operation pattern of the factories

Data Preparation

There are three types of data provided, location data of the four factories and nine sensors, air sampling data from sensors and meteorological data (wind direction & wind speed) from a weather station in proximity to the factories and sensors. To prepare data before importing into Tableau, I implement the following solutions to cope with different data issues.
Issue 1: Location data of the four factories and nine sensors are stored in the unstandardized format (word document). Tableau fails to load the data.
Solution 1: Create a spreadsheet named Location Data. Put the factory location data and sensor location data shown as below.