Excel Pivot Chart

Canadian Government First Nations long term water advisory data

The Government of Canada is working with Canadian First Nations communities to end long-term drinking water advisories which have been in effect for more than 12 months since November 2015. This includes projects to build or renew drinking water infrastructure in these communities. The First Nation drinking water advisories were a big part of the […]

Canadian Government First Nations long term water advisory data Read More »

Heat maps of Canadian activity changes due to COVID-19 using Google Community Mobility Reports

During the 2020 COVID-19 pandemic in Canada I wanted to get better understanding of the geographical distribution of COVID-19 related activity changes across Canada. Google has helpfully provided freely available global “Community Mobility Reporting” which shows Google location history change compared to baseline by country, and country sub-regions. These provide changes in activity by location

Heat maps of Canadian activity changes due to COVID-19 using Google Community Mobility Reports Read More »

Excel Power Query tutorial using Canadian potato production statistics

This data comes from Statistics Canada. Statistics Canada download pages often provide the opportunity to modify the data structure and content before it is downloaded. For example clicking on the [Add/Remove data] link provides options select different groupings of data by provinces. I choose to group data by provinces. I also limited the content to

Excel Power Query tutorial using Canadian potato production statistics Read More »

Visualization of Toronto’s 311 contact centre open data

This is based on City of Toronto’s Open Data website 311 call performance data for the 4 years 2010, 2011, 2012 and 2013. The data is provided by the City in a Google Spread Sheet and has been downloaded and saved here in Excel 2013 format 311_daily_contact_centre_data. I used Excel pivot tables and charts for analysis and

Visualization of Toronto’s 311 contact centre open data Read More »

Scroll to Top