ISSS608 2016-17 T3 Assign ERIC PRABOWO CUNDOMANIK Data

Background

Data

Solutions and Answers

Comments and Feedbacks

Dataset Description

Mini-Challenge 2 provides a three month set of data for you to analyze, covering April, August, and December 2016.

I. COORDINATES:
The factories and sensors locations are provided in terms of x,y coordinates on a 200x200 grid, with (0,0) at the lower left hand corner (southwest). The sensors map shows the locations of the sensors and factories by number for the sensors and by name for the factories. Some of the other features of the map (such as entrances and gates in that area) have been removed for readability. (Please note that the terms “sensor” and “monitor” are used interchangeably.)

The following are the factory locations:
Roadrunner Fitness Electronics: 89,27
Kasios Office Furniture: 90,21
Radiance ColourTek: 109,26
Indigo Sol Boards: 120,22

The following are the sensor locations:
1: 62,21
2: 66,35
3: 76,41
4: 88,45
5: 103,43
6: 102,22
7: 89,3
8: 74,7
9: 119,42

---

II. METEOROLOGICAL DATA
[Date, Wind Direction, Wind Speed]
Date: The date and time of the readings, local time with no change for Daylight Savings.
Wind Direction: The compass directions where the wind is originating from, using a north-referenced azimuth bearing where 360/000 is true north.
Wind Speed: The speed of the wind in meters per second.
Each of these reading is taken at the date and time provided.

---

III. SENSOR DATA
[Chemical, Monitor, Reading, Date Time]
Chemical: Which one of the four chemicals detected by the sensors
Monitor: Which one of the nine sensors picking up the reading
Reading: The air sensor detected amount in parts per million
Date Time: The date and time of day of the reading, local time with no change for Daylight Savings.

Data Preparation and Cleaning [in progress..]

[in progress..]

1. Create X, Y coordinate Excel file for sensors and companies

Create a table with X and Y data

---

2. Clean meteorological data

Remove empty 4th column, and delete 5th column with elevation data

---

3. Duplicate meteorological data (wind data) for building the polygon shape in Tableau

• Add 3 additional columns [Angle, Length, and Point]: new columns are specifically for building the polygon shape for the Wind Rose on the chart. Each of them are for building components of the lines of the Wind Rose, for example the Angle is Tripled with the additional +10 and -10 degree from the original data.

Added 3 column on Meteorological Data (wind)

• Triple the data: by adding 3 columns above, there should also be copying process of the data. Data should be copied 3 times for each of the angle, before applying formula to calculate the Angle and Length column.

---

4. Connecting to Tableau with inner join method

• Going forward to Tableau, add the 3 flat files of the data (Sensor, Coordinate, and Meteorological in sequence). This will make Sensor as the key data point, and connect to both Coordinate and Meteorological data. For meteorological data used is the one tripled, or modified by copying the data 3 times for the polygon shape drawing on Wind Rose.

• Add another dataset in Tableau by joining a new combination, where the dataset is not tripled (as for the polygon shape drawing). Use the Sensor, Coordinate, and Meteorological (non-modified meteorological dataset).

5. Convert Map Coordinates and Windspeed to miles standard unit

• Convert measurement units to miles

Data Visualization Charts [in progress..]

[in progress..]