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
17 posts in this collection. Explore all topics.
TL;DR Canada’s Innovative Solutions Canada programme publishes the grants it gives to help SMEs solve public-sector challenges. But our deep
I created a Fabric Dataflow Gen2 Web API connection to retrieve csv file data from an Environment Canada daily environmental
The Government of Canada is working with Canadian First Nations communities to end long-term drinking water advisories which have been
This is a list of Canadian COVID-19 related data analysis and visualization that I created during 2020/21 pandemic. Canada COVID-19
Our World In Data (OWID) has been doing a hero’s job of collating the world’s covid vaccine distribution and administration
During the 2020 COVID-19 pandemic in Canada I wanted to get COVID-19 confirmed cases counts data for the city of
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
I have a local Hadoop server running on my Windows laptop. To connect Power BI to this Hadoop file system
Step 1 – Download latest version of Power BI to get new features (version that came out in early August
This data comes from Statistics Canada. Statistics Canada download pages often provide the opportunity to modify the data structure and
Power Query is quick and easy way to scrape HTML tables on web pages. Here is step by step on
Do you want to create a Power BI Report that gets a daily scheduled refresh of data from a Sharepoint
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 made an amazing social media turnaround to communicate with customers in crisis! Go BC Hydro! On August 29,
Microsoft has a free Microsoft Data Management Gateway that you can install on your desktop or server to act as
A while back LinkedIn sneakily vacuumed up all of my contacts from my phone via the Android Cardmunch app. Turns out Cardmunch is owned by LinkedIn. There must be fine print somewhere that indicates they do this but I sure didn’t see it.