Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
11-24-2025 13:21 PM
I am excited to share my latest project, developed as part of the Microsoft Fabric Data Days Notebooks Contest.
As urbanisation accelerates, a critical question arises: Does high population density doom a city to low livability? In this project, I explored the "Density Myth" and uncovered actionable insights to guide urban planning and sustainability efforts.
Key Highlights:
- Objective: Decode the drivers of urban sustainability and challenge common misconceptions.
- Dataset: 3,400+ cities with features like green cover, renewable energy usage, and urban density.
- Tech Stack: Python (pandas, scikit-learn, seaborn), Microsoft Fabric Notebooks.
Key Findings:
1. Density is Not Destiny: Population density has minimal impact on sustainability.
2. The Green Imperative: Green cover percentage is the most critical predictor of urban livability (~47% importance).
3. City Archetypes: Using K-Means clustering, cities were grouped into actionable clusters:
- Cluster 0: High disaster risk, low sustainability.
- Cluster 1: Moderate sustainability, low green cover.
- Cluster 2: High sustainability, leveraging green spaces and renewable energy.
Recommendations:
- Increase Green Cover: Urban forestry, green roofs, and parks.
- Promote Renewable Energy: Subsidies for solar and wind energy projects.
- Improve Public Transport: Expand transit systems to reduce carbon emissions.
This project showcases the transformative power of data-driven urban planning in creating greener, safer, and more sustainable cities.
GitHub Repository: https://github.com/pythonist4444/cities-of-tomorrow
I would love to hear your thoughts. Let’s connect and discuss how data science can shape the future of urban sustainability.
https%3A%2F%2Fgithub.com%2Fpythonist4444%2Fcities-of-tomorrow