The project involves end-to-end project management, including planning, resource allocation, risk assessment, and stakeholder communication, to deliver a data-driven Tableau dashboard evaluating Toronto's apartment building standards.
- Develop a comprehensive Tableau dashboard showcasing Toronto's apartment building landscape.
- Evaluate building conditions, repairs, and resident satisfaction across Toronto.
- Identify patterns and trends in building quality across different neighbourhoods.
- Analyze the correlation between building age, size, and evaluation scores.
- Provide actionable insights for stakeholders to improve housing standards.
- Interactive Tableau Dashboard: Visualize key insights, trends, and patterns in building conditions.
- Geospatial Visualizations: Map building locations and scores across Toronto neighbourhoods.
- Statistical Models: Identify key factors influencing building evaluation scores.
- Exploratory Data Analysis (EDA): Uncover trends and correlations in the dataset.
- User-Centric Design: Incorporate stakeholder feedback to ensure relevance and usability.
- Data Analysis: Python (Pandas, NumPy, Scikit-learn)
- Data Visualization: Tableau
- Geospatial Analysis: Tableau, Python (Geopandas)
- Database: SQL
- Machine Learning: LightGBM, XGBoost (for predictive modeling)
- Deliver an interactive Tableau dashboard visualizing Toronto's apartment building landscape.
- Create geospatial visualizations mapping building locations and scores across neighbourhoods.
- Develop statistical models to identify key factors influencing building scores.
- Provide actionable insights for stakeholders through data analysis and visualization.
- Conduct thorough data collection and preparation from the Apartment Building Evaluation dataset.
- Perform exploratory data analysis (EDA) to uncover trends in building conditions over time.
- Identify clusters of high and low-performing buildings through geospatial analysis.
- Incorporate user testing in dashboard design to ensure stakeholder relevance.
- Prepare comprehensive documentation to communicate insights to all stakeholders.
- Cleaned Dataset: A refined version of the Apartment Building Evaluation dataset.
- Tableau Dashboard: An interactive dashboard visualizing key insights from the data analysis.
- Analysis Report: A comprehensive report detailing findings, trends, and recommendations.
- Final Presentation: A summary of project findings and recommendations for stakeholders.
| Milestone | Date |
|---|---|
| Project Initialization | Sept 17, 2024 |
| Data Collection | Sept 20, 2024 |
| Exploratory Data Analysis (EDA) | Oct 25, 2024 |
| Initial Dashboard Creation | Nov 15, 2024 |
| Final Dashboard & Report Delivery | Nov 30, 2024 |
- Time: The project must be completed by November 30, 2024, to align with the current schedule.
- Technical: The dashboard must be compatible with the city's existing IT infrastructure, with potential for future updates.
- Data: Analysis is limited to the available data in the Apartment Building Evaluation dataset.
- The Apartment Building Evaluation dataset will continue to be updated regularly.
- Stakeholders will provide timely feedback during the dashboard development process.
- The project team will have access to necessary software and hardware resources.
- The findings will be used to inform policy decisions and improve housing quality in Toronto.
- Data Quality Issues: Inconsistencies or missing data in the Apartment Building Evaluation dataset.
- Regulatory Changes: Changes in city regulations or evaluation criteria during the project timeline.
- Technical Challenges: Difficulties in integrating data sources or creating complex visualizations.
- Stakeholder Resistance: Potential resistance from property owners or managers to the public display of building scores.
Key findings from the analysis include:
- Geospatial trends emphasize the need for targeted maintenance initiatives in underperforming neighbourhoods.
- Policymakers can use these insights to prioritize funding and improve tenant policies.
- Property managers and investors can focus their resources on buildings requiring the most urgent interventions.
The dashboard provides a comprehensive overview of building evaluations in Toronto. It tracks the total number of buildings evaluated (15,322), along with the timing of those evaluations (immediate, within 1, 2, or 3 years).
Key metrics include the correlation of building component condition with the overall building score (e.g., how much does the condition of the entrance lobby, exterior cladding, etc., influence the total building score) and their respective ratings (Excellent, Good, Average, Poor) based on a 0-1 scale. Geographic distribution of building scores is visualized on a map, overlaid with ward boundaries.
Further analysis is facilitated through charts displaying ward-level performance, frequency of building age (year built), and the distribution of building stories. This allows users to understand trends and prioritize interventions based on various factors like location, age, and the influence of specific building components on overall building condition.
