Difference between revisions of "ISSS608 2016-17 T3 ROGER DATA EXPLORATION"
Rogers.2016 (talk | contribs) |
Rogers.2016 (talk | contribs) |
||
| Line 36: | Line 36: | ||
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. | 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. | ||
| + | <br /> | ||
| + | [[File:1 Anootate Point.png|800px|centre]] | ||
| + | <br /> | ||
In this similar way, all the location coordinates are found and is joined with the given sensor data based on the gate names. | In this similar way, all the location coordinates are found and is joined with the given sensor data based on the gate names. | ||
| + | <br /> | ||
| + | [[File:2 Sensor Data.png|800px|centre]] | ||
| + | <br /> | ||
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. | 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. | ||
| + | <br /> | ||
| + | [[File:3 Seconds Spent Formula.png|800px|centre]] | ||
| + | <br /> | ||
From the date, the day and the hour are calculated using the data and time functions. | From the date, the day and the hour are calculated using the data and time functions. | ||
| + | <br /> | ||
| + | [[File:4 Day and Hour.png|800px|centre]] | ||
| + | <br /> | ||
The day of the week is captured using the formula as shown below. | The day of the week is captured using the formula as shown below. | ||
| + | <br /> | ||
| + | [[File:5 Weekday.png|800px|centre]] | ||
| + | <br /> | ||
For multiple day users, the day of the trip is calculated using the below formula. | For multiple day users, the day of the trip is calculated using the below formula. | ||
| + | <br /> | ||
| + | [[File:6 Multiple Day Users.png|800px|centre]] | ||
| + | <br /> | ||
To find single day users and multiple day users, | To find single day users and multiple day users, | ||
1. Create a summary table by grouping car-id and day fields. | 1. Create a summary table by grouping car-id and day fields. | ||
| + | <br /> | ||
| + | [[File:7 Grouping.png|800px|centre]] | ||
| + | <br /> | ||
2. Another summary table is made by grouping car id and providing N(days) as value. | 2. Another summary table is made by grouping car id and providing N(days) as value. | ||
| + | <br /> | ||
| + | [[File:8 Summary table.png|800px|centre]] | ||
| + | <br /> | ||
3. The result provides car id with no of days spent. | 3. The result provides car id with no of days spent. | ||
| + | <br /> | ||
| + | [[File:9 Users and no of days.png|800px|centre]] | ||
| + | <br /> | ||
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. | 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. | ||
Revision as of 10:54, 16 July 2017
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.
