Difference between revisions of "IS428 AY2019-20T1 Assign Chan Huang Suan Processing"
Hschan.2016 (talk | contribs) (Created page with "{| class="wikitable" |- ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 30%;" | File name ! style="font-weight: bold;background: #536a87;color:#fbfcfd;widt...") |
Hschan.2016 (talk | contribs) |
||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | <!-- header --> | ||
+ | <div style=background:#4d92e8 border:#4d92e8> | ||
+ | [[Image:St_Hilmark_Logo_ChanHuangSuan.png|200px]] | ||
+ | <font size = 5; color="#ffffff"><b>VISUALIZATION OF ALWAYS SAFE NUCLEAR POWER PLANT</b></font> | ||
+ | </div> | ||
+ | |||
+ | <!-- Navigation --> | ||
+ | {|style="background-color:#4d92e8 " width="100%" cellspacing="0" cellpadding="0" valign="middle" border="0" | | ||
+ | |||
+ | | style="text-align:center;border-bottom:5px solid; border-bottom-color: #386aa8;" width="20%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Chan_Huang_Suan | <font color="#ffffff" size=4 face="Open+Sans"><b>Project Details</b></font>]] | ||
+ | |||
+ | | style="text-align:center;border-bottom:5px solid; border-bottom-color: #386aa8;" width="20%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Chan_Huang_Suan_Processing | <font color="#ffffff" size=4 face="Open+Sans"><b>Data Processing</b></font>]] | ||
+ | |||
+ | | style="text-align:center;border-bottom:5px solid; border-bottom-color: #386aa8;" width="20%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Chan_Huang_Suan_Case | <font color="#ffffff" size=4 face="Open+Sans"><b>Case Analysis</b></font>]] | ||
+ | |||
+ | | style="text-align:center;border-bottom:5px solid; border-bottom-color: #386aa8;" width="20%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Chan_Huang_Suan_Tableau | <font color="#ffffff" size=4 face="Open+Sans"><b>Tableau Visualization</b></font>]] | ||
+ | |||
+ | | style="text-align:center;border-bottom:5px solid; border-bottom-color: #386aa8;" width="20%" | | ||
+ | [[IS428_AY2019-20T1_Assign_Chan_Huang_Suan_Reference | <font color="#ffffff" size=4 face="Open+Sans"><b>References</b></font>]] | ||
+ | |} | ||
+ | |||
+ | <!-- Body --> | ||
+ | <p> | ||
+ | Before the analysis began, the dataset given is analysed to identify its respective format and attributes. This section will elaborate on the dataset analysis and transformation process for each dataset in order to prepare the data for import and analysis on interactive visualization. | ||
+ | </p> | ||
+ | <p> | ||
+ | Upon opening the project files, we can see: | ||
+ | </p> | ||
+ | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
− | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: | + | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | File name |
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Image | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Image | ||
− | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: | + | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Purpose |
|- | |- | ||
− | || Static Sensor Location | + | || <b>Static Sensor Location</b> |
− | || [[File: | + | || [[File:Static Sensor Location ChanHuangSuan.PNG|200px|center]] |
− | || | + | || Lists static sensor's geographic coordinates |
|- | |- | ||
− | || Static Sensor Readings | + | || <b>Static Sensor Readings</b> |
− | || [[File:Static_Sensor_Readings_ChanHuangSuan. | + | || [[File:Static_Sensor_Readings_ChanHuangSuan.PNG|200px|center]] |
− | || | + | || Lists static sensor's radiation reading values at a 5 second interval |
|- | |- | ||
− | || Mobile Sensor Readings | + | || <b>Mobile Sensor Readings</b> |
− | || [[File:Mobile_Sensor_Readings_ChanHuangSuan. | + | || [[File:Mobile_Sensor_Readings_ChanHuangSuan.PNG|400px|center]] |
− | || | + | || Lists mobile sensor's radiation reading values at a 5 second interval, with coordinates. <p><b>Note: </b> There are more rows that exceeds the Excel limit when we open the file.</p> |
|- | |- | ||
− | || Map | + | || <b>St Hilmark Map & Coordinates</b> |
− | || [[File:Map_Image_ChanHuangSuan.png| | + | || [[File:Map_Image_ChanHuangSuan.png|200px|center]] |
− | || | + | || An image file showcasing St Hilmark's neighborhood and its landmarks. There is a St Hilmark .shp file that plots geometry for each neighborhood. |
|} | |} | ||
+ | |||
+ | == Tableau Prep == | ||
+ | [[File:0 -DataProcessFlow_ChanHuangSuan.png|800px|center]] | ||
+ | <p> | ||
+ | In tableau prep, the objective is to merge the files of both Static and Mobile Sensor together. | ||
+ | This will help to reduce the load to perform table-joining operations Tableau Desktop, hence effectively boosting performance. | ||
+ | Based on the white paper shared by [https://www.tableau.com/about/blog/2018/1/extracts-hyper-speed-what-you-need-know-79397 Tableau], we understand that .hyper extension output file helps to boost performance. Hence, the project will leverage this tableau technology to enhance performance. | ||
+ | </p> | ||
+ | |||
+ | <p> | ||
+ | <b>Tableau Prep Steps:</b> | ||
+ | </p> | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%;" | Description | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 60%;" | Screenshot | ||
+ | |- | ||
+ | | <b>1.</b> Import all 3 excel files into Tableau Prep || N.A | ||
+ | |- | ||
+ | | <b>2.</b> Aggregate Mobile Sensor ID to create a list of key-value pair for Mobile ID & User ID || [[File:Prep_GroupMobileName_ChanHuangSuan.png|600px|center]] | ||
+ | |- | ||
+ | | <b>3.</b> Inner Join Static Sensor Reading and Static Sensor Location based on Static ID || [[File:Prep_InnerJoin_ChanHuangSuan.png|600px|center]] | ||
+ | |- | ||
+ | | <b>4.</b> Rename Static ID into unique string ID names || [[File:Prep_Rename_ChanHuangSuan.png|600px|center]] | ||
+ | |- | ||
+ | | <b>5.</b> Union Static Sensor Reading and Mobile Sensor Reading based on Static ID and Mobile ID respectively || [[File:Prep_Union_ChanHuangSuan.png|600px|center]] | ||
+ | |- | ||
+ | | <b>6.</b> Group columns and aggregate readings of 5-second interval readings into minute level || [[File:Prep_FinalAggregate_ChanHuangSuan.PNG|600px|center]] | ||
+ | |- | ||
+ | | <b>7.</b> Save output as .hyper file extension || [[File:Prep_Hyper_ChanHuangSuan.png|600px|center]] | ||
+ | |- | ||
+ | | <b>8.</b> Run Tableau Prep Flow to get 2 .hyper file as output || N.A | ||
+ | |} | ||
+ | |||
+ | == Tableau Desktop == | ||
+ | <p> | ||
+ | In order to make sure of the shape file of St Hilmark, we need to combine the readings obtained from Tableau Prep with the geometry shape file. This is possible only with the MakePoint function that allows intersection of geometry files as shown below where we inner join both data sets. | ||
+ | </p> | ||
+ | |||
+ | [[File:Prep_MakePoint_ChanHuangSuan.png|300px|center]] | ||
+ | |||
+ | == Issues to Highlight == | ||
+ | === Getting the average radiation reading value based on minute level === | ||
+ | <p> | ||
+ | <b> Issue: </b> It is documented in the data description, that the radiation readings are obtained from all sensors in a 5-second interval. This meant that in a minute, there are at least 12 recorded rows of data per sensor. The total number of rows would severely inflate the size of the data file more than necessary which creates a situation where there is a lot of redundant data. | ||
+ | </p> | ||
+ | <p> | ||
+ | <b> Solution: </b> Obtain the average radiation reading per minute for each sensor for all timestamps value. This should reduce the size of the data file by at least 12 times and enhance the performance of tableau while maintaining accuracy of the radiation reading that is relevant for the sensor's coordinates. | ||
+ | </p> | ||
+ | |||
+ | === Mobile Sensor ID and User ID Name === | ||
+ | <p> | ||
+ | <b> Issue: </b> In Mobile Sensor Reading file, the User ID column has a lot of repeated values that can be easily distinguished by using Sensor ID. This makes the column of data slightly redundant. | ||
+ | </p> | ||
+ | <p> | ||
+ | <b> Solution: </b> By borrowing concepts from database normalization, we can create a key-value pair that corresponds Sensor ID with User ID. By creating a separate list, we can reduce the amount of data in the excel file. This file is then extracted as a Mobile ID List for future reference if necessary. | ||
+ | </p> | ||
+ | |||
+ | === Renaming of St Hilmark Static Sensor === | ||
+ | <p> | ||
+ | <b> Issue: </b> By identifying the unique values for the sensors, we realize that there are common integer values that are used to uniquely identify both static and mobile sensors. The Sensor ID for Static sensors ranges from 1 to 15. This would complicate the work process to identify the sensors if both static and mobile sensors use the same values. | ||
+ | </p> | ||
+ | <p> | ||
+ | <b> Solution: </b> The Sensor ID used for the static sensor is renamed as a string value to reflect the neighborhood that each sensor is located in. This would make it easy to interpret where this static sensor is located in. To reflect the changes on the mobile sensors, the integer values are changed to string type accordingly. | ||
+ | </p> | ||
+ | [[File:ReferenceTable ChanHuangSuan.PNG|300px|center]] |
Latest revision as of 16:29, 13 October 2019
Before the analysis began, the dataset given is analysed to identify its respective format and attributes. This section will elaborate on the dataset analysis and transformation process for each dataset in order to prepare the data for import and analysis on interactive visualization.
Upon opening the project files, we can see:
File name | Image | Purpose |
---|---|---|
Static Sensor Location | Lists static sensor's geographic coordinates | |
Static Sensor Readings | Lists static sensor's radiation reading values at a 5 second interval | |
Mobile Sensor Readings | Lists mobile sensor's radiation reading values at a 5 second interval, with coordinates. Note: There are more rows that exceeds the Excel limit when we open the file. | |
St Hilmark Map & Coordinates | An image file showcasing St Hilmark's neighborhood and its landmarks. There is a St Hilmark .shp file that plots geometry for each neighborhood. |
Contents
Tableau Prep
In tableau prep, the objective is to merge the files of both Static and Mobile Sensor together. This will help to reduce the load to perform table-joining operations Tableau Desktop, hence effectively boosting performance. Based on the white paper shared by Tableau, we understand that .hyper extension output file helps to boost performance. Hence, the project will leverage this tableau technology to enhance performance.
Tableau Prep Steps:
Description | Screenshot |
---|---|
1. Import all 3 excel files into Tableau Prep | N.A |
2. Aggregate Mobile Sensor ID to create a list of key-value pair for Mobile ID & User ID | |
3. Inner Join Static Sensor Reading and Static Sensor Location based on Static ID | |
4. Rename Static ID into unique string ID names | |
5. Union Static Sensor Reading and Mobile Sensor Reading based on Static ID and Mobile ID respectively | |
6. Group columns and aggregate readings of 5-second interval readings into minute level | |
7. Save output as .hyper file extension | |
8. Run Tableau Prep Flow to get 2 .hyper file as output | N.A |
Tableau Desktop
In order to make sure of the shape file of St Hilmark, we need to combine the readings obtained from Tableau Prep with the geometry shape file. This is possible only with the MakePoint function that allows intersection of geometry files as shown below where we inner join both data sets.
Issues to Highlight
Getting the average radiation reading value based on minute level
Issue: It is documented in the data description, that the radiation readings are obtained from all sensors in a 5-second interval. This meant that in a minute, there are at least 12 recorded rows of data per sensor. The total number of rows would severely inflate the size of the data file more than necessary which creates a situation where there is a lot of redundant data.
Solution: Obtain the average radiation reading per minute for each sensor for all timestamps value. This should reduce the size of the data file by at least 12 times and enhance the performance of tableau while maintaining accuracy of the radiation reading that is relevant for the sensor's coordinates.
Mobile Sensor ID and User ID Name
Issue: In Mobile Sensor Reading file, the User ID column has a lot of repeated values that can be easily distinguished by using Sensor ID. This makes the column of data slightly redundant.
Solution: By borrowing concepts from database normalization, we can create a key-value pair that corresponds Sensor ID with User ID. By creating a separate list, we can reduce the amount of data in the excel file. This file is then extracted as a Mobile ID List for future reference if necessary.
Renaming of St Hilmark Static Sensor
Issue: By identifying the unique values for the sensors, we realize that there are common integer values that are used to uniquely identify both static and mobile sensors. The Sensor ID for Static sensors ranges from 1 to 15. This would complicate the work process to identify the sensors if both static and mobile sensors use the same values.
Solution: The Sensor ID used for the static sensor is renamed as a string value to reflect the neighborhood that each sensor is located in. This would make it easy to interpret where this static sensor is located in. To reflect the changes on the mobile sensors, the integer values are changed to string type accordingly.