- What problem this project solve?
- Methodology
- Tech Stack
- Project Pipeline
- Project Limitations and Areas for Improvement
- Data Sources
In this data analysis project, I conducted an extensive analysis of all the neighbourhoods in Edmonton to provide valuable insights for individuals looking to rent a property. The project focuses on two key factors: rent prices and crime rates, providing a comprehensive overview of the rental market and safety aspects in Edmonton. Click here to view interactive map.
The main objective of this project is to empower individuals with the necessary information to make informed decisions about where to rent in Edmonton. By analyzing rent prices and crime rates in different neighbourhoods, this project aims to offer valuable insights that can guide individuals in finding the perfect rental property that aligns with their budget and safety considerations.
Click here to open project visualization on Tableteau.
To achieve the project's objective, I collected and analyzed data on rent prices and crime rates from various reliable sources. The rent prices were meticulously categorized into four types: Studio, 1 bedroom, 2 bedroom, and 3+bedroom apartments and townhouses, ensuring a detailed analysis of rental options available in each neighbourhood. The crime rates were obtained from official crime statistics, ensuring the accuracy and reliability of the data.
- Excel: Used for basic data manipulation and data exploration
- SQL: Used for creating joins, cleaning, and transforming data
- Tableau: Used for visualizing the data analysis results
- Data Collection:
- Gather information on rent prices and crime rates from reliable sources.
- Categorize rent prices into different types of properties (studio, 1 bedroom, 2 bedroom, 3+ bedroom).
- Obtain official crime statistics for accurate crime rate analysis.
- Find relative spatial data
- Data Cleaning and Preparation:
- Use Excel for basic data manipulation and exploration.
- Utilize SQL for creating joins, cleaning, and transforming the data.
- Data Analysis:
- Conduct in-depth analysis of rent prices and crime rates in each neighbourhood.
- Explore trends and patterns to identify key insights.
- Data Visualization:
- Utilize Tableau to create visualizations that effectively communicate the analysis results.
- Present rent prices and crime rates in an easy-to-understand format.
- Limitation and Improvement Assessment:
- Evaluate the limitations of the project, such as limited data availability and additional factors to consider.
- Identify areas for improvement, such as obtaining more comprehensive and up-to-date data and implementing real-time updates.
- Recommendations and Insights:
- Provide valuable insights for individuals seeking rental properties in Edmonton.
- Summarize top neighbour based on the analysis findings to guide decision-making.
- Limited data availability: The analysis heavily relies on the data collected from various sources. However, the availability and completeness of the data may vary, which could impact the accuracy of the analysis. Obtaining more comprehensive and up-to-date data would enhance the reliability of the findings.
- Additional factors for consideration: While this project focuses on rent prices and crime rates, there are other important factors to consider when choosing a rental property, such as proximity to amenities, transportation options, and quality of schools. Expanding the analysis to include additional factors would provide a more comprehensive evaluation for individuals seeking rental properties.
- Real-time updates: The data used in this analysis may not reflect the most recent changes in rent prices and crime rates. Implementing a system for real-time data updates would ensure that the insights provided remain accurate and up-to-date for users.
Overall, by addressing these limitations and making improvements, the project can offer even more valuable insights to individuals looking to rent a property in Edmonton.
- Rent prices: Data on rent prices was collected from reputable real estate websites, including Canada’s national housing agency
- Crime rates: Official crime statistics were obtained from the Edmonton Police Service Report.
- Spatial data: Relative spatial data was sourced from Edmonton Opendata