I created a Fabric Dataflow Gen2 Web API connection to retrieve csv file data from an Environment Canada daily environmental […]
Fabric Dataflow Gen2 Web API connection with dynamic current date parameter Read More »
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 »
This is a list of Canadian COVID-19 related data analysis and visualization that I created during 2020/21 pandemic. Canada COVID-19
COVID-19 Data Analysis and Visualization Summary Read More »
Our World In Data (OWID) has been doing a hero’s job of collating the world’s covid vaccine distribution and administration
Use Excel Power Query to get data from Our World In Data Read More »
During the 2020 COVID-19 pandemic in Canada I wanted to get better understanding of the geographical distribution of COVID-19 related
What is Power Query? Power Query is an Microsoft tool for Excel and Power BI that is used to do
Introduction to Microsoft Power Query in Excel and Power BI Read More »
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 »
Power Query is quick and easy way to scrape HTML tables on web pages. Here is step by step on
Use Excel Power Query to scrape & combine Wikipedia tables Read More »
Do you want to create a Power BI Report that gets a daily scheduled refresh of data from a Sharepoint
How to schedule Power BI dataset refresh Read More »
Excel Power Query can make a connection to MySQL database but requires that you have a MySQL Connector/Net 6.6.5 for
Power Query MySQL database connection Read More »
BC Hydro made an amazing social media turnaround to communicate with customers in crisis! Go BC Hydro! On August 29,
BC Hydro’s amazing #BCStorm social media turnaround Read More »