ISSS608 2016-17 T3 ROGER DATA EXPLORATION

From Visual Analytics and Applications
Jump to navigation Jump to search

Bird cover.jpg VAST MINI CHALLENGE 1

Main Page

Data Exploration

Visualizations

Insights

Conclusion

References

 

Data Preparation

First, the map has been added in tableau. At every location point right click is done, and annotate point option is selected. This gives us the X and Y coordinates for every point.

1 Anootate Point.PNG


In this similar way, all the location coordinates are found and is joined with the given sensor data based on the gate names.

2 Sensor Data.PNG


The formula used to calculate seconds spent is shown below. Only if the previous car id and current car id are the same, then the number of seconds spent is calculated by subtracting time with the time of the previous row.

3 Seconds Spent Formula.PNG


From the date, the day and the hour are calculated using the data and time functions.

4 Day and Hour.PNG


The day of the week is captured using the formula as shown below.

5 Weekday.PNG


For multiple day users, the day of the trip is calculated using the below formula.

6 Multiple Day Users.PNG


To find single day users and multiple day users, 1. Create a summary table by grouping car-id and day fields.

7 Grouping.PNG


2. Another summary table is made by grouping car id and providing N(days) as value.

8 Summary table.PNG


3. The result provides car id with no of days spent.

9 Users and no of days.PNG


4. Now filter one day visitors where N(day) is 1 and the rest are multiple day users. These filtered data sets can be used for analysis.

Creating dashboard data

From the above filtered data, the vehicle counts per location point data is calculated.

11 tableau 0.PNG


To create a radar plot, the list of gates in order and a specific degree (0-359) is assigned. Then for every gate, cos(degree) and sin(degree) is taken as the rotation coordinates.

10 X rot and Y rot.PNG


This is imported to tableau along with the previously prepared data and joining is done based on gate name.

11 tableau.PNG


Vehicle counts are then multiplied with X_rot and Y_rot (aggregated to avg) to get the actual X and Y coordinates are radar plot.

12 Calc.PNG



13 Calc.PNG


Once the points are placed, the marks is set to polygon for filled color. Details, color and filter are given based on calculated vehicle type.

14 Pic.png


Finally ,hour is added into pages section to navigate vehicle counts over hour.

For pattern movements

Filter the data with fishy pattens.

Plot them in the map.

Set SUM(Seconds) as size.

Put timestamp as the pages.

Tick “Show history” box and set the configurations to map traces.

15 Traces.png


Now, the final picture is ready to be used.

16 Final.PNG