ISSS608 2017-18 T3 Assign Liu Yuqing Analysis & Insights

       Vast: Mini Challenge 2: Like a duck to water

Background

Data preparation

Analysis & Insights

Feedback

Methodology

Parameters

Set range of standard deviation

Set start date of visualization to exclude data points not after the day

Set end date of visualization to exclude data points not before the day

Creating calculated fields

Create isInRangeDate

Create average value of measures cross window

Create lower value of control interval

Create upper value of control interval

Create outliers to mark datapoints out of control

Visualization analysis

Overview of measures

Trend of each measure

Measured time interval of each chemical is quite different, so first of all, we observed value trend over time of each measure using boxplot.

Data Discription

Entry gates are positioned at the Preserve entrances. Each vehicle receives an entry ticket at the gate and is assigned a vehicle class; the entry is recorded. The entry ticket contains an RF-tag that enables the Preserve sensors to pick up the passage of a vehicle through the Preserve. Each vehicle surrenders their entry ticket when exiting the Preserve and the exit is recorded.When vehicles enter the Preserve, they must proceed through a gate and obtain a pass.

Details Discription

1. Entrances: All vehicles pass through an Entrance when entering or leaving the Preserve.

2. General-gates: All vehicles may pass through these gates. These sensors provide valuable information for the Preserve Rangers trying to understand the flow of traffic through the Preserve.

3. Gates: These are gates that prevent general traffic from passing. Preserve Ranger vehicles have tags that allow them to pass through these gates to inspect or perform work on the roadway beyond.

4. Ranger-stops: These sensors represent working areas for the Rangers, so you will often see a Ranger-stop sensor at the end of a road managed by a Gate. Some Ranger-stops are in other locations, however, so these sensors record all traffic passing by.

5. Camping: These sensors record visitors to the Preserve camping areas. Visitors pass by these entering and exiting a campground.

Step by Step Discription

Exclude misleading records

Exclusion criterion: (1) id without full movement records( all visitors should come in and get out from both entrances so those ids that only have one entrance should be excluded). (2)id without full timestamp records.( those id without the come in and get out records). (3) repeat records

700px

Extract the car sequences

The most essentail step for data preparation is to extract the car sequences which helps to summary the life patterns. This step is conducted in JMP with the function[Col Rank(Timestamp,car-id)]

800px

Label vehicles in their movement order and then create Episode based on the movement order and id

Number the movement order for each car-id and then list the car-id with episode. Level: The order of movement(entrance---gate ：level of entrance is one and the level of gate is two) Episode: Each entrance & exit is one episode, so normally each id should has only one episode.

800px

Compute the last duration, camping hour and single checkpoint duration

Compute the multipul duration in excel for better visualization.Last duration(day),camping hour(hour),single checkpoint duration(min)

800px

Coordinates Extractation and Preparation for Gephi

Extract the coordinates in tableau and then prepare the coordinates for Gephi visualization

600px

Participent Segamentation

All the participents are classified into Camper,No-camper and Ranger

700px