Open Data, Hidden Mess: What 405 Canadian Innovation Grants Reveal About Government Data Quality
TL;DR Canada’s Innovative Solutions Canada programme publishes the grants it gives to help SMEs solve public-sector challenges. But our deep
Topic
Power Query
12 posts in this collection. Explore all topics.
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
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
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
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
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
Introduction to Microsoft Power Query in Excel and Power BI
What is Power Query? Power Query is an Microsoft tool for Excel and Power BI that is used to do
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
Use Excel Power Query to scrape & combine Wikipedia tables
Power Query is quick and easy way to scrape HTML tables on web pages. Here is step by step on
How to schedule Power BI dataset refresh
Do you want to create a Power BI Report that gets a daily scheduled refresh of data from a Sharepoint
Power Query MySQL database connection
Excel Power Query can make a connection to MySQL database but requires that you have a MySQL Connector/Net 6.6.5 for
BC Hydro’s amazing #BCStorm social media turnaround
BC Hydro made an amazing social media turnaround to communicate with customers in crisis! Go BC Hydro! On August 29,