Visual Analytics Project

 

Grade Received

🏆Awarded DAAA Outstanding Project Presentation

🏆Distinction

Project Scope

✍️ Project Task

According to a popular website on living and working in Singapore, quality of life is a measure of one's overall well-being that includes economic, social, physical, political, and spiritual factors. Singapore is considered to have a high quality of life and has been ranked as the top city in Asia in terms of quality of living. The country is also regarded as the happiest country in Southeast Asia according to the 2022 World Happiness Report. Factors considered in determining the quality of life in each country include the political and social environment, economic environment, socio-cultural environment, health and sanitation, schools and education, public services and transportation, recreation, natural environment, consumer goods, and housing.

Based on the report, it seems that Singapore is a good place to live / work in. Is this true?

📝 Main Hypothesis:

Is Singapore a good place to live/work in?

📝 Sub Hypothesis

• Damian :Safety (Singapore is a very safe country)
• Natelie : Education (Singapore has a good education system)
• Amber: Healthcare (Singapore has a good healthcare system)
• Javerine: Housing (Singapore has a good housing infrastructure)

Date

12/12/2022 - 14/2/2022

Goals

Our main objective is to allow users to better understand Singapore's standard of living using data analysis by providing an informed perception to our target audience.

Pitching Work Process

💜 Survey

• We conducted a comprehensive survey consisting of 10 questions to gain insight into our users' perspectives on Singapore.
• Each topic selected for the survey included 2-3 questions designed to understand which factors are important to consider when living or working in Singapore.
• The survey aimed to provide valuable feedback on a range of topics, such as housing, safety, healthcare, and education in Singapore.
• The survey results would be used to inform our future plans and strategies and to better cater to the needs and preferences of our users.

🗣️ Interview

• We conducted eight in-depth interviews to gain a more comprehensive understanding of our target users.
• The interviews were designed to elicit valuable insights from individuals with diverse backgrounds and experiences.
• Interviewees were selected based on factors such as age, gender, occupation, nationality, and length of time spent living in Singapore.
• The interviews helped us to understand our users' needs, preferences, challenges, experiences, and perceptions of living and working in Singapore.
• The insights gained from the interviews will be used to inform our future plans and strategies to better serve our users.
• The question that help us best to understand our target users was "If you could create a country, what would it be like?", which gave us unrestricted space to share their dreams and desires, enabling us to gather perspectives that we might have otherwise missed.

👤 Creating User Persona for interviews conducted by me

Data Preparation & Modelling Work Process

📜 Scope of Datasets

• Datasets were taken from singstat and gov.sg which are from reliable government statistical sites
• A total of 16 datasets was collected

📜 Data Preparation

• After downloading my datasets, I started to clean my data:
  • Rename Columns to remove underscores and commas
  • Rename Table to readable and with easy understanding of the datasets it contain's
  • Transpose tables that requires
  • Remove extra datasets years which I will not be using

Final Project Report Work Process

🤝 Integration

• To allow the smooth process of integrating our work, we have use two days coming toegther to individual add in our datasets and working through our report
• After all of us were done with the data preparation, we had discuss the ideas to make our report more usefriendly

✍ Creating with user in mind

• With our user in mind, we wanted to create a dashboard that will attract the users to use and with ease
• We create a navigation bar and a main page which allow our users to view all 4 factors

Outcome & Results Achieved

This report provides an overview of the different types of housing grants available in Singapore. Users can select the Housing Grant Scheme they want to learn about and choose their preferred flat type to see the estimated prices with grants provided. It was observed that the general trend for housing prices after the grant has been provided is a decrease, making housing more affordable for citizens. Based on the forecast selling price, it is predicted that housing grants would continue to help make housing more affordable. Overall, housing grants in Singapore play a crucial role in helping citizens attain their dream of owning a home and are increasingly accessible and beneficial with more subsidies provided.

This report focuses on addressing users' top priorities when searching for housing, namely location and cost. I used a heat map to show median prices per area square and a line graph to demonstrate the impact of distance on housing prices. A pie chart estimated costs based on flat type, and a Town slicer allowed users to search for specific locations. These interactive features provide a personalized and accurate understanding of the housing market.

The factors of Storey Range and Remaining Lease are commonly brought up by housing buyers, so I conducted a linear regression analysis to investigate their impact on resale price. The analysis showed a strong correlation between storey range and resale price for 3-ROOM, 4-ROOM, and 5-ROOM flats, highlighting the importance of considering this factor when purchasing these types of flats. However, remaining lease showed a weak positive relationship with resale price, indicating that other factors have a greater influence. Overall, the analysis provides valuable insights for buyers, allowing them to make informed decisions when considering these factors.

To provide a more comprehensive analysis of resale prices, I have included visuals showing maximum, average, and minimum trends, highlighting that while resale prices may seem to be increasing, they have remained relatively constant. Additionally, I forecasted resale price trends for 2023 to help users determine the best time to purchase a house.

I also conducted an analysis of key influencers on housing prices and found that Bukit Timah had the most significant impact on resale prices, followed by Bishan and the Central Area, with an average resale price of $443,238.35. This information provides valuable insights for prospective homebuyers in these areas, helping them understand what to expect in terms of pricing.

Lastly, I utilized a decomposition tree to display the information on which types of units tend to be more expensive and which towns have higher prices for those types of units. This visual aids users in making more informed decisions by providing a better understanding of the factors that influence resale prices in different areas.

I provide users with viewing options for market trends: the button for viewing data by country shows an overall understanding of market trends across different countries, while the button for viewing data by city offers a detailed view of how specific cities are performing. This flexibility helps users make informed decisions based on their requirements.

I use KPI visuals to show Singapore's ranking among 482 cities and 112 countries, indicating that it is not affordable overall. However, since different countries have varying standards of living, environments, and other factors, I allow users to choose the countries they want to compare. Using the city or country slicer, they can compare cities based on the Price to Income Ratio and affordability index. For instance, comparing Singapore to other First World countries like the United States, Germany, and Canada, shows that Singapore's housing market is satisfactory in terms of affordability.

Conclusion

In conclusion, Singapore provides a high-quality and accessible housing environment for its residents, with about 90% of the population being accommodated. The government has implemented various initiative, such as the Enhance CPF Housing Grant (EHG), to help citizens afford homes. However, potential home buyers should keep in mind that location and unit size can greatly impact the cost of housing. While Singapore may not rank as the most affordable compared to other countries, it provides a high standard of living and factors such as the environment should be also be considered when evaluating the overall cost of living. Ultimately, it is up to the individual to determine their own criteria for comparison to other countries.

Difficulties

• Finding datasets that were reliable and meets my user requirements was a challenge
  • With time spend on researching and help from seniors, I was able to achieve what I have today

Feedback Recieved For Presentation

• "Excellent visualization"
• Interactive design
• Good teamwork and integration
• Informative and suitable for our age group audience
• Best group presentation
• Our work was praised and been requested to be use for open house and orientation.
• The teachers have also requested for our scripts to also be submitted
• Overall execllent presentation.

Acknowledgement

I am deeply grateful to my group mates for being the most supportive and helpful teammates throughout the project. Their constant encouragement and assistance made the journey a smooth and enjoyable one.