In this section I have a collection of portfolio pieces related to the City of Mississauga. I used a combination of data available from Mississauga Data and Esri Business Analyst. These are demonstration portfolio pieces of an educational nature.

Ranking Tim Hortons performance at locations in Mississauga.

Ranking Tim Hortons performance at locations in Mississauga.


Coffee or ‘black gold’ as it is referred to by those working in the industry is big business. It was the highest selling hot beverage in Canada and in 2011 with over 14 billion cups consumed. Approximately 64% of Canadians drink coffee every day which is the equivalent to 12.7 pounds of roasted coffee per capita. The predominant market for coffee is age driven. It is the drink of choice for Canadians aged 25 to 49 (after water). Coffee consumption is the highest in the 50+ age category and lowest in those below 24 years of age (Source: Coffee and Tea Industry Trends from the Canadian Coffee and Tea Show (2011) Agri-Food Canada).

The purpose of this study is to examine the coffee shop industry in Mississauga, Ontario. The focus of the study is the Tim Hortons coffee shop chain which will be compared to its competitors. A combination of estimated sales volume and census data will be used to rank stores and compare Tim Hortons performance to competitors. All data used in this study was obtained from Esri Business analyst.

Mississauga is Canada’s 6th largest and fastest growing major city (Source: City of Mississauga Website). Mississauga is home to over 720,000 residents with a work force of over 425,000 people. Mississauga is also a part of the Greater Toronto Area (GTA) which is the largest population centre in Canada.

In this study 154 coffee shops were assessed of which Time Hortons had the highest number of stores at 68 locations. The total sales volume of the Mississauga coffee shop market was estimated at over 10 million dollars. The market share and sales volume of the coffee shop market in Mississauga is shown in Figure 1.

Click here to view the pdf of the poster.


Mapping Mississauga’s Land Use by Ward


Mississauga is a booming metropolis located on the Northern Shore of Lake Ontario. It has a population of over 757,000 people and is home to over 59,000 businesses. Mississauga is a part of the Greater Toronto Area (GTA), the financial heart of Canada and the third largest financial centre in North America with over 6 million residents.

For this analysis I used open data available from the Mississauga Data website (http://www.mississauga.ca/portal/residents/mississaugadata). The open data contains a land use polygon file in the form of a kml. Using Esri ArcMap the kml was converted to a shapefile. The area calculator tool was then used to calculate the area of each polygon. The results were grouped into categories and aggregated based on wards. The results are several maps and tables breaking down the city of Mississauga by ward and top land use.

The predominant three land uses in Mississauga are transportation, detached residential housing and industrial. Mississauga is a very well balanced city with high amount of residential land throughout. The north-east corner (Home of Lester B. Pearson Airport, the largest in Canada) contains some of the largest concentrations of industry. The north-west boundary towards also contains a high proportion of industrial and institutional land. The southern half of Mississauga towards Lake Ontario has the highest amount of green space.

Here is a link to the pdf.


Mapping How Mississauga Gets to Work


Mississauga has a diverse and complex transportation network including roadways, highways and public transportation. The road network in Mississauga is over 5,500 lane kilometres of road and 2,400 lane kilometers of sidewalks. From Mississauga you can access three 400 series highways including the 401, 401 and 407 ETR. Mississauga is serviced by MiWay Ontarios third largest municipal transit provider. They provide services with over 930 transit operators, 460 buses and over 3,600 bus routes.


With all of these options how are residents of Mississauga getting to work, and are there any special trends for transportation methods. Three methods of transportation were examined in this study: driving, public transportation and walking. The census data used in this analysis was obtained from Esri Business Analyst. The analysis was conducted using the Esri ArcMap hot spot analysis tool. This tool uses the Getis-Ord Gi statistic method and identifies statistically significant hot spots. A hot spot indicates a statistically significant high area and a cold spot indicates a low area.

The hot spots for driving and public transportation show opposite trends. The majority of public transportation is centered on the downtown core and the western edge of the city. The north-west corner with ample highway access was identified as a hot spot. The analysis of walking to work shows that walking is heaviest in the southern edges of the city towards the lake shore. There is a walking cold spot that coincides to a high driving low public transportation zone.

Click here for the pdf.