Difference between revisions of "Atom InterimProgress"

From Analytics Practicum
Jump to navigation Jump to search
Line 65: Line 65:
 
Thus far, we have managed to complete phase 1 of the project in January, which is to assist MRC to understand the car park issues in 6 development sites (AMK hub, AMK hawker centre, Compass Point, Jalan Salang F&B cluster, Rail Mall F&B cluster and Sengkang CC). MRC has categorized AMK hub and AMK hawker centre to be grouped together initially as given between the two sites is pretty nearby to each other.  Likewise for Compass Point and Sengkang CC to be grouped together to form Sengkang Cluster. As for the deliverables for phase 1, the team has analyzed and completed these deliverables for MRC: <br>
 
Thus far, we have managed to complete phase 1 of the project in January, which is to assist MRC to understand the car park issues in 6 development sites (AMK hub, AMK hawker centre, Compass Point, Jalan Salang F&B cluster, Rail Mall F&B cluster and Sengkang CC). MRC has categorized AMK hub and AMK hawker centre to be grouped together initially as given between the two sites is pretty nearby to each other.  Likewise for Compass Point and Sengkang CC to be grouped together to form Sengkang Cluster. As for the deliverables for phase 1, the team has analyzed and completed these deliverables for MRC: <br>
  
===Excel files:===<br>
+
=== Excel files: === <br>
 
1. AMK Hub.xlsx (7 tabs)<br>
 
1. AMK Hub.xlsx (7 tabs)<br>
 
2. AMK Hawker Centre.xlsx (7 tabs)<br>
 
2. AMK Hawker Centre.xlsx (7 tabs)<br>
Line 73: Line 73:
 
6. Jalan Salang.xlsx (7 tabs)<br>
 
6. Jalan Salang.xlsx (7 tabs)<br>
  
===Reports:===<br>
+
=== Reports: ===<br>
 
1. AMK Cluster.pdf (82 pages)<br>
 
1. AMK Cluster.pdf (82 pages)<br>
 
2. SengKang.pdf (99 pages)<br>
 
2. SengKang.pdf (99 pages)<br>
Line 79: Line 79:
 
4. Jalan Salang.pdf (62 pages)<br>
 
4. Jalan Salang.pdf (62 pages)<br>
  
===Info-graphics files:===<br>
+
=== Info-graphics files: === <br>
 
1. AMK Hub.pdf (7 slides)<br>
 
1. AMK Hub.pdf (7 slides)<br>
 
2. AMK Hawker Centre.pdf (8 slides)<br>
 
2. AMK Hawker Centre.pdf (8 slides)<br>
Line 91: Line 91:
 
Due to the file size is too huge and it is unable to upload onto SMU elearn, please refer to https://wiki.smu.edu.sg/ANLY482/Atom%3A_Documentation#Phase_1 to view or download the file. <br>
 
Due to the file size is too huge and it is unable to upload onto SMU elearn, please refer to https://wiki.smu.edu.sg/ANLY482/Atom%3A_Documentation#Phase_1 to view or download the file. <br>
 
 
 +
 
==Phase 2==
 
==Phase 2==
  
 
We will be utilizing the raw data provided by MRC to do more in depth analysis than what was required in Phase 1 of the project. Phase 1 did more of a summary of each parking site individually. In phase 2 we proposed time series data mining in order to identify and analyze any patterns that might exist between different parking sites, for example perhaps there might be a similarity between a retail mall in the east and west that might not be obvious from a superficial view of the data. Time series dating mining allows us to represent a collection of data that is obtained over a period of time, which allows us to view the shape of the data over time.<br>
 
We will be utilizing the raw data provided by MRC to do more in depth analysis than what was required in Phase 1 of the project. Phase 1 did more of a summary of each parking site individually. In phase 2 we proposed time series data mining in order to identify and analyze any patterns that might exist between different parking sites, for example perhaps there might be a similarity between a retail mall in the east and west that might not be obvious from a superficial view of the data. Time series dating mining allows us to represent a collection of data that is obtained over a period of time, which allows us to view the shape of the data over time.<br>
 
 

Revision as of 21:02, 28 February 2016

AtomTeamLogo.jpg


AtomHome.png

Home

  AtomTeam.png

Team

  AtomProjectOverview.png

Overview

 


AtomDocumentation.png

Documentation

  AtomAnalysis.png

Analysis

 


Revised Scope of work

Phase 1 [Completed]

Phase 1 of the project will take place till end of January or when all the project reports and info-graphics are completed (whichever is earlier). We will be focusing on helping our project sponsor (MRC): -

• To ascertain parking demand and thereafter, to revise parking planning provision for sites
• To check for data errors and anomalies
• To generate charts and tables
• To generate infographics with the data given
• To identify significant trends (if any) and across relevant key categories
• To compare data percentages and correlations between car park demand and human traffic count
• To compare data percentages and correlations between the use of public transport and human traffic count
• To compile all generated data, charts and infographics into a written report

Phase 2

Phase 2 of the project will take place from February till the end of the course. We will be building a platform for data representation: -

• To compare the differnece occupancy rate between the sites
• To check for data errors and anomalies
• To generate charts and tables
• To generate infographics with the data given
• To identify significant trends (if any) and across relevant key categories
• To compile all generated data, charts and infographics into a written report


Review of Previous Work

Phase 1 [Completed]

Thus far, we have managed to complete phase 1 of the project in January, which is to assist MRC to understand the car park issues in 6 development sites (AMK hub, AMK hawker centre, Compass Point, Jalan Salang F&B cluster, Rail Mall F&B cluster and Sengkang CC). MRC has categorized AMK hub and AMK hawker centre to be grouped together initially as given between the two sites is pretty nearby to each other. Likewise for Compass Point and Sengkang CC to be grouped together to form Sengkang Cluster. As for the deliverables for phase 1, the team has analyzed and completed these deliverables for MRC:

=== Excel files: ===
1. AMK Hub.xlsx (7 tabs)
2. AMK Hawker Centre.xlsx (7 tabs)
3. Compass Point.xlsx (7 tabs)
4. Sengkang CC.xlsx (7 tabs)
5. Rail Mall.xlsx (7 tabs)
6. Jalan Salang.xlsx (7 tabs)

=== Reports: ===
1. AMK Cluster.pdf (82 pages)
2. SengKang.pdf (99 pages)
3. Rail Mall.pdf (87 pages)
4. Jalan Salang.pdf (62 pages)

=== Info-graphics files: ===
1. AMK Hub.pdf (7 slides)
2. AMK Hawker Centre.pdf (8 slides)
3. Compass Point.pdf (8 slides)
4. Sengkang CC.pdf (9 slides)
5. Rail Mall.pdf (11 slides)
6. Jalan Salang.pdf (11 slides)

The excel files are processed to assist in analyzing and plotting out the charts for the info-graphics. The reports are generated to share and report the insights found in the development. Lastly, the info-graphics documents are prepared to capture and share the main insights from the respective sites.

Due to the file size is too huge and it is unable to upload onto SMU elearn, please refer to https://wiki.smu.edu.sg/ANLY482/Atom%3A_Documentation#Phase_1 to view or download the file.

Phase 2

We will be utilizing the raw data provided by MRC to do more in depth analysis than what was required in Phase 1 of the project. Phase 1 did more of a summary of each parking site individually. In phase 2 we proposed time series data mining in order to identify and analyze any patterns that might exist between different parking sites, for example perhaps there might be a similarity between a retail mall in the east and west that might not be obvious from a superficial view of the data. Time series dating mining allows us to represent a collection of data that is obtained over a period of time, which allows us to view the shape of the data over time.