Project Title : Visualizing Urban Dynamics: Unveiling Patterns and Opportunities for Urban Planning in Ohio

💻 Domain:

Data Visualization

📖 Skills Used:

Tableau, Excel

📈 Project Overview:

The goal of the study is to understand the current situation of the city and identify areas where development can be done. To this end, the city has built an app that collects data from about 1000 users and creates logs of their daily activities. This data is then used to create visualizations to help determine where improvements can be made.

💡 Recommendations:

  • Urban planners can focus on promoting access among residents to higher education and collaborate with local employers to create more job opportunities.
  • Increase affordable housing options by encouraging more multi-room residential development.
  • Urban planners can provide personalized marketing and tailored services to different demographic groups based on their spending patterns and preferences.
  • The number of schools can be increased and distributed more evenly across the city. For example, there are no schools serving the north-east side of the city.
  • Urban planners can introduce restaurants that charge lesser food costs as at the moment, it seems that all restaurants in the city serve a specific clientele. Hourly costs in pubs on the other hand seem to be more evenly distributed.

📚 Learnings:

  • Tableau is a powerful data visualization tool that allows you to create interactive and shareable dashboards.

Dashboard can be accessed here - https://tinyurl.com/iste782team8 Project presentation can be accessed here - Project Presentation