Excel Pivot Chart – Digital, Data, AI, Analytics

Canadian Government First Nations long term water advisory data

Business Intelligence, Excel Pivot Chart, Excel Pivot Table, Javascript, Plotly, Power Query, Python, Web Development

The Government of Canada is working with Canadian First Nations communities to end long-term drinking water advisories which have been […]

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

D3.js, Excel Pivot Chart, Excel Pivot Table, Javascript, Power Query, Web Development

During the 2020 COVID-19 pandemic in Canada I wanted to get better understanding of the geographical distribution of COVID-19 related

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

Excel Pivot Chart, Excel Pivot Table, Power Query

This data comes from Statistics Canada. Statistics Canada download pages often provide the opportunity to modify the data structure and

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

Visualization of Toronto’s 311 contact centre open data

Excel Pivot Chart, Excel Pivot Table, Open Data

This is based on City of Toronto’s Open Data website 311 call performance data for the 4 years 2010, 2011, 2012

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