Exploration of Socio-Economic Trends in the Greater Toronto Area (GTA)

I led the data analysis and visualization for a comprehensive study conducted for the non-governmental agency United Way Greater Toronto (UWGT). The project aimed to uncover socio-economic trends in the Greater Toronto Area, focusing on key domains such as Demographics, Financial Stability, Housing Stability, Community Services, and Resident Engagement.

A cornerstone of this project was the development of dynamic Power BI dashboards, which played a critical role in transforming complex datasets into actionable insights. I designed these dashboards to provide an interactive and intuitive interface, enabling stakeholders to explore trends across multiple socio-economic dimensions effortlessly.

Using Power BI, I integrated diverse datasets from Statistics Canada, city planning resources, and NGO reports. The dashboards featured custom visuals and advanced DAX measures to highlight key metrics, such as income inequality (via Gini Index analysis), housing affordability, employment trends, and demographic shifts. One of the highlights was the Financial Stability Dashboard, which visualized predictive models forecasting rising income inequality in Toronto through 2050. This dashboard allowed UWGT to identify high-risk regions and demographic groups, helping in resource allocation and policy planning.

Another significant dashboard focused on Housing Stability, where I visualized eviction trends, projected housing starts, and core housing needs across the GTA. By incorporating real-time data filters, end-users could analyze trends based on specific neighborhoods, age groups, and income brackets, providing granular insights into housing challenges.

Additionally, the Demographic Insights Dashboard showcased migration trends, population projections, and diversity indices. Through interactive slicers and drill-through functionalities, users could delve deep into population dynamics, such as the projected growth of racialized communities by 2041 and the shifting age structure of immigrant populations.

The dashboards not only facilitated data-driven decision-making but also enhanced stakeholder engagement during presentations to UWGT. They provided a clear, visual narrative that highlighted critical socio-economic patterns and supported predictive analytics models developed during the project.

This project demonstrated my ability to manage end-to-end data analysis workflows—from data cleaning and statistical modeling to visualization and stakeholder communication—using Power BI as a powerful tool for impactful storytelling.

Below are the Dashbaords I created and presented to United Way Greater Toronto (UWGT).