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
Excel
12 posts in this collection. Explore all topics.
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
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
Scraping public health web page using Python, BeautifulSoup4, Requests and Pandas
During the 2020 COVID-19 pandemic in Canada I wanted to get COVID-19 confirmed cases counts data for the city of
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
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
How to create OData data source Gateway for Power BI Report
Microsoft has a free Microsoft Data Management Gateway that you can install on your desktop or server to act as
Visualization of Toronto’s 311 contact centre open data
This is based on City of Toronto’s Open Data website 311 call performance data for the 4 years 2010, 2011, 2012 and 2013.
LinkedIn ‘People You May Know’ web scraping and analysis
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.