Power Query

Fabric Dataflow Gen2 Web API connection with dynamic current date parameter

I created a Fabric Dataflow Gen2 Web API connection to retrieve csv file data from an Environment Canada daily environmental data web API. The API provides parameters for specific date ranges eg start and end dates. I wanted to get data for a date range that had a fixed start date but dynamic end date […]

Fabric Dataflow Gen2 Web API connection with dynamic current date parameter Read More »

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 »

COVID-19 Data Analysis and Visualization Summary

This is a list of Canadian COVID-19 related data analysis and visualization that I created during 2020/21 pandemic. Canada COVID-19 Case Map – COVID-19 new and total cases and mortalities by Canadian provincial health regions. https://sitrucp.github.io/canada_covid_health_regions Canada COVID-19 Vaccination Schedule – Canada’s current and historical vaccine doses administered and doses distributed. Also includes two distribution

COVID-19 Data Analysis and Visualization Summary Read More »

Use Excel Power Query to get data from Our World In Data

Our World In Data (OWID) has been doing a hero’s job of collating the world’s covid vaccine distribution and administration data. They generate additional metrics and allow site visitors to analyse them in awesome interactive visualizations. However, I wanted to do some analysis that went beyond what was possible on the site. No problem, because

Use Excel Power Query to get data from Our World In 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 »

Scroll to Top