Statistics Canada
Statistics Canada tables
https://www150.statcan.gc.ca/n1/en/type/data
Consumer Price Index visualization tool
https://www150.statcan.gc.ca/n1/pub/71-607-x/2018016/cpilg-ipcgl-eng.htm
Consumer Price Index frequently asked questions
https://www.documentcloud.org/documents/22672133-consumer-price-index-frequently-asked-questions
The eight major components in the Consumer Price Index
https://www.documentcloud.org/documents/22672133-consumer-price-index-frequently-asked-questions#document/p1/a2199262
Labour Force Survey, April 2023 – The Daily
https://www150.statcan.gc.ca/n1/daily-quotidien/230505/dq230505a-eng.htm
Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm
Unemployment rate – Alberta
https://economicdashboard.alberta.ca/dashboard/unemployment-rate/
Labour force characteristics, three-month moving average, seasonally adjusted
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410038001
Labour force characteristics, three-month moving average, seasonally adjusted (Canada, Province or territory, Census metropolitan area, Census)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1410038001
Labour force characteristics, three-month moving average, unadjusted for seasonality, last 5 month (Canada, Province or territory, Economic region)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1410038701
Labour force characteristics by educational attainment, monthly, unadjusted for seasonality
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1410001901
Labour force characteristics by industry, monthly, unadjusted for seasonality
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410002201
Industry groups by class of worker including job permanency, labour force status, age and gender: Canada, provinces and territories, census metropolitan areas and census agglomerations with parts
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=9810044801
Census Program Data Wiewer
https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/dv-vd/cpdv-vdpr/index-eng.cfm
Census Profile – 2021
https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/prof/index.cfm?Lang=E
Census Profile, 2016 Census
https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=E
Population estimates, quarterly
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1710000901
Population estimates on July 1st, by age and sex
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000501
Investment status of residential properties
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=4610007001
Employee wages by industry, annual
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410006401
Open data portals
Open Data 101
https://open.canada.ca/en/open-data-principles
The Open Data Charter
https://opendatacharter.net/who-we-are/
Open Data Portal
https://open.canada.ca/en
Provinces and territories
B.C.
http://www.openinfo.gov.bc.ca/ibc/index.page?
http://www.data.gov.bc.ca/
Alberta
http://data.alberta.ca/
Saskatchewan Open Data
http://www.opendatask.ca/
Manitoba
https://www.gov.mb.ca/openmb/index.html
Ontario
http://www.ontario.ca/government/open-data-ontario
Québec Ouvert (les données ouvertes pour le Québec)
https://www.donneesquebec.ca/
New Brunswick
https://gnb.socrata.com/
Nova Scotia
https://data.novascotia.ca/
Newfoundland and Labrador
http://open.gov.nl.ca/
Prince Edward Island
https://www.princeedwardisland.ca/en/search/site/?f%5B0%5D=type%3Aservice&f%5B1%5D=field_service_topics%3A2237
Yukon
https://open.yukon.ca/data/
Northwest Territories
https://www.opennwt.ca/
Nunavut
https://open.canada.ca/data/en/dataset?keywords=Nunavut&page=1
Cities
Edmonton
http://data.edmonton.ca/
Halifax
https://www.halifax.ca/home/open-data
Fredericton
http://www.fredericton.ca/en/open-data
Mississauga
http://www.mississauga.ca/portal/residents/mississaugadata
Oakville
http://oakville.ca/data/
Saskatoon
http://opendata-saskatoon.cloudapp.net/
Ottawa
http://data.ottawa.ca/en/?page=1
Toronto
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/
Saint John
http://catalogue-saintjohn.opendata.arcgis.com/
St. John’s
http://www.stjohns.ca/event/open-data
Vancouver
https://opendata.vancouver.ca/pages/home/
Winnipeg
https://data.winnipeg.ca/
http://www.mbcdp.ca/local-data-portals.html
Montreal
https://donnees.montreal.ca/
The environment
National Pollutant Release Inventory
https://www.canada.ca/en/services/environment/pollution-waste-management/national-pollutant-release-inventory.html
Carbon Tracker
https://carbontracker.org/
Zero-emission vehicle statistics – Transport Canada
https://tc.canada.ca/en/road-transportation/innovative-technologies/zero-emission-vehicles
Cool sites to produce story ideas
Canada Revenue Agency – List of Charities
https://apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch?request_locale=en
Office of the Superintendent of Bankruptcy
https://ised-isde.canada.ca/site/office-superintendent-bankruptcy/en
Office of the Superintendent of Bankruptcy – open data portal
https://search.open.canada.ca/en/od/?od-search-portal=Open+Data&search_text=office+of+the+superintendent+of+bankruptcy
Canadian Institute for Health Information
https://www.cihi.ca/en
Our World in Data
https://ourworldindata.org/
Data visualizations
http://www.davidmckie.com/category/digi-1examples/
Tableau
https://www.tableau.com/
Datawrapper
https://www.datawrapper.de/
Resources
Video of May 25 session
https://www.youtube.com/watch?v=y0zNGiICalE
A checklist of questions for data analysis.pdf
All the Best Microsoft Excel Keyboard Shortcuts
https://www.howtogeek.com/361582/all-the-best-microsoft-excel-keyboard-shortcuts/
Excel Shortcuts for Mac to Make Your Life Easy
https://www.99signals.com/excel-shortcuts-for-mac/
Investigative Reporters & Editors
https://www.ire.org/
Tutorials
To obtain the pivot table tutorial, please click here.
Data Journalism Academy
https://sites.google.com/view/mj-basic-data-academy/home?authuser=0
https://sites.google.com/view/mj-basic-data-academy/excel-magic?authuser=0
Google Sheets guide in Excel worksheets
SpiceUpYourSheetLife_ExcelGoogleSheetTips_BenCollins.pdf
Create a pivot table in Google Sheets with the help of this tutorial.
To obtain the tutorial on calculating per cents, please click here.
To obtain the specialized functions tutorial, please click here.
Math Tools for Journalists
https://www.amazon.ca/Math-Tools-Journalists-Professor-Professional/dp/0972993746
Data Visualization: A Primer
https://open.canada.ca/en/data-visualization
Jan 28, 2022, Tableau tutorial usting Statistics Canada CPI data
https://www.youtube.com/watch?v=23wA4LM4BE8
Feb 3, 2023, Tableau tutorial part two
https://www.youtube.com/watch?v=k_i6jXTetoQ
Feb 3, 2023, Tableau tutorial part three
https://www.youtube.com/watch?v=tXLBlvCX4SM