ISSS608 2016-17 T3 ROGER DATA EXPLORATION
VAST MINI CHALLENGE 1
|
|
|
|
|
|
|
|
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. In this similar way, all the location coordinates are found and is joined with the given sensor data based on the gate names. 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. From the date, the day and the hour are calculated using the data and time functions. The day of the week is captured using the formula as shown below. For multiple day users, the day of the trip is calculated using the below formula. To find single day users and multiple day users, 1. Create a summary table by grouping car-id and day fields. 2. Another summary table is made by grouping car id and providing N(days) as value. 3. The result provides car id with no of days spent. 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.
