Difference between revisions of "ISSS608 2016-17 T3 Assign PRIYADARSHINI Background and Analysis"
Line 31: | Line 31: | ||
| | | | ||
|} | |} | ||
+ | <br/> | ||
+ | = Data & Dashboard = | ||
+ | This section of the wiki tells Mitch how the data was cleaned and the dashboard tools he could use to further improve the analysis if need be. | ||
+ | |||
+ | == Dashboard == | ||
+ | Hi Mitch, | ||
+ | <br/> | ||
+ | This is where you can interact more with the dashboard. The Dashboard can be accessed through this link [https://public.tableau.com/views/Assignment1_MC/Dashboard1?:embed=y&:display_count=yes&publish=yes Legakul Investigative Dashboard] | ||
+ | |||
+ | === Dashboard User Guide === | ||
+ | |||
+ | [[File:Dashboard MC1.png|800px|centre]] | ||
+ | |||
+ | '''Section A''' | ||
+ | Section A is the Legakul reserve map with the travel paths drawn. This map is interactive. Interesting paths could be selected to further investigate. Upon hovering you can see the point order information and you can also see the Car ID and location name. | ||
+ | |||
+ | ''' Section B''' | ||
+ | This shows the distribution of the most popular areas visited in the selected time period. | ||
+ | |||
+ | ''' Section C ''' | ||
+ | This shows the individual car ids and the places they have visited. The x - axis is the point order or here stated as "Order of Travel". You can click on a particular car -iD and then zoom in. and see what has happened. | ||
+ | |||
+ | ''' Section C(a)''' | ||
+ | This section helps you search for a particular car-id that you happened to see on the map and know the exact path | ||
+ | |||
+ | ''' Section D''' | ||
+ | Here you can select your time periods. You can also select the type of motor that you want to zoom into. It also contains the legend of the location by gate-name group | ||
+ | |||
+ | === See the Dashboard in Action === | ||
<br/> | <br/> | ||
− | + | [[File:Dashboard.gif|centre]] | |
− | |||
+ | <br/> | ||
== Data transformation steps== | == Data transformation steps== | ||
Line 91: | Line 120: | ||
|- | |- | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 15:23, 14 July 2017
|
|
|
|
|
|
|
|
Contents
Data & Dashboard
This section of the wiki tells Mitch how the data was cleaned and the dashboard tools he could use to further improve the analysis if need be.
Dashboard
Hi Mitch,
This is where you can interact more with the dashboard. The Dashboard can be accessed through this link Legakul Investigative Dashboard
Dashboard User Guide
Section A Section A is the Legakul reserve map with the travel paths drawn. This map is interactive. Interesting paths could be selected to further investigate. Upon hovering you can see the point order information and you can also see the Car ID and location name.
Section B This shows the distribution of the most popular areas visited in the selected time period.
Section C This shows the individual car ids and the places they have visited. The x - axis is the point order or here stated as "Order of Travel". You can click on a particular car -iD and then zoom in. and see what has happened.
Section C(a) This section helps you search for a particular car-id that you happened to see on the map and know the exact path
Section D Here you can select your time periods. You can also select the type of motor that you want to zoom into. It also contains the legend of the location by gate-name group
See the Dashboard in Action
Data transformation steps
Before explaining the steps in detail let us speak about the "was" dataset and the transformed dataset. Here are the respective snapshots
The intial file contained just a few columns with coded data. It mainly had the timestamp, the car-id, car-type, gate-name. This was transformed to the following file