Author Archives: Ryan Garnett

 About Ryan Garnett

My current pet project is getting to know tattoos in Libya. Had some great experience donating glue in Jacksonville, FL. A real dynamo when it comes to developing teddy bears in Libya. Garnered an industry award while creating marketing channels for love worldwide. Had some great experience managing cabbage in Jacksonville, FL. Spent 2001-2008 importing walnuts in Fort Lauderdale, FL.

Accessing open data with Google Sheets

Posted on October 8, 2019 - 2:22 pm by
Google Drive’s suite of free document editing tools provide a means for educators and students to work more seamlessly together, with one lacking area: data access. There are many ideas on data access, with “go where people play” being a growing trend. For this reason, we partnered with a local developer to create the the CKAN Google Sheets add-on. Now you can access open data with a few clicks in Google Sheets. Read all about it on Medium: Accessing open data with Google Sheets

Towards Location Intelligence

Posted on September 10, 2019 - 4:13 pm by
Do you geo? Interested in location data and location intelligence? The City of Toronto’s Open Data team partnered with BergWerkGIS to update the QGIS CKAN Browser plugin, allowing GIS users to access open data directly within QGIS, the leading open source desktop GIS. No longer do desktop GIS users need to download data from open data portals, with the QGIS CKAN Browser open datasets managed in CKAN are loaded directly into QGIS. Accessing Open Data with QGIS Read the full article on Medium.

Towards Data Analytics: Data literacy in R

Posted on August 1, 2019 - 5:54 pm by
Data is everywhere, and is a critical component in every faction of work. Understanding data is essential for evidence based decision making. Within most organizations Excel is King, the application that is used to collect, share, manipulate, analyze, and communicate information from data. While great for many things, Excel has limitation related to data analytics. This story aims to demystify the perceived notions around the difficulty associated to data analytics. Focusing on understanding data, and introducing principle elements that data practitioners face daily, the hands-on approach will help those looking to improve their analysis abilities beyond using Excel.

This Data Story focuses on using RStudio, an open source industry leader for data analytics. Specific focus areas include:

  • Importing data
  • Explore data
  • Working with data
  • Performing calculations
  • Visualizations
  • Next steps in the RStudio journey
Ready to get started? Read it on Medium: Towards data analytics: Data literacy in R

Prioritizing Open Data

Posted on June 28, 2019 - 5:38 pm by
The City of Toronto developed an Open Data Master Plan that was unanimously accepted by Toronto City Council on January 31, 2018. The Open Data Master Plan provides strategic direction for the improvement and delivery of the City’s Open Data team. The plan available here consists of four themes and 13 actions, with one action focusing exclusively on the prioritization of data releases. The prioritization framework, including expected value scores and weighting methodology, will be shared with the public for enhanced visibility into planned open data releases. Read more on Medium: Towards a Priority Framework for Open Data