Expansion of Broadband Internet coverage is a high priority for CRTC, who has established a Broadband Fund providing $750 Million over 5 years to upgrade broadband internet access in remote regions of Canada. As a result, broadband infrastructure and coverage is undergoing rapid change. This further exacerbated the underlying requirement for timely reporting on [...]
Analytical Services and Project Management for Ottawa MacDonald-Cartier International Airport Authority
Sarah Vickers2023-08-25T12:05:19-04:00From 2018 to 2020, Bronson provided a wide-range of services to support Tableau, the Ottawa Airport Authority’s chosen tool for data analytics and visualization. Bronson provided a number of Tableau-related services in parallel including: Tableau dashboard development; Tableau maintenance and technical support; and Data strategy development. Bronson’s work with the Ottawa Airport Authority was [...]
Data Analytics and Advisory Services for Natural Resources Canada’s Audit & Evaluation Branch
Sarah Vickers2024-01-26T10:45:29-05:00Due to COVID-19 restrictions, Bronson’s training sessions were delivered virtually using Microsoft Teams. Each of these training sessions had an audience of 8-12 participants, and were designed to be interactive and encourage hands-on learning by participants. "Bronson was keen to work with NRCan's Audit & Evaluation Branch to modernize their data [...]
Forecasting Annual Maintenance Costs for the City of Ottawa’s Fleet Services
Sarah Vickers2023-05-30T12:26:37-04:00The City of Ottawa operates a diverse fleet of roughly 2,800 vehicles used in a wide range of services including garbage collection, snow removal, ambulance and fire response. The resulting model produced by Bronson for this project is a multi-variable model which forecasts annual maintenance costs based on vehicle data and characteristics where a [...]
Retained by IESO for Compliance Audits
Sarah Vickers2024-01-17T15:15:20-05:00At its outset, the IESO CFF Programs were to have been delivered over a five-year period from 2015 through 2020. These programs were expected to generate 6.9 TWh of energy savings, with a total budget of $1.9 Billion. The audit scope included review LDC wind-down activity for 9 separate CFF Programs which targeted a [...]
Analysis of Sales Data for Farm Boy
Sarah Vickers2024-01-26T10:45:17-05:00Farm Boy is high end chain of grocery stores focused on locally-sourced fresh produce and food products. Headquartered in Ottawa, Farm Boy currently has 40 locations throughout Ontario. "Bronson was hired by Farm Boy to analyze their sales data to improve promotions and product pricing." - Phil Cormier, CA, CPA, Senior [...]
Data Aggregation for The Department of National Defence’s Strong Secure Engaged Defence Policy
Sarah Vickers2024-01-24T11:09:58-05:00The tool which was used in the preceding capital forecasting exercise took roughly 4 hours to compile project data for capital forecasting purposes. The Alteryx tool which was developed by Bronson completed a full project load from start to finish in less than 10 minutes, and could develop modified scenarios in less than 5 [...]
Financial Security Data Review for the Bank of Canada
Sarah Vickers2024-01-27T12:18:00-05:00The Bank of Canada uses securities-related data from various external sources to monitor financial markets and perform associated research. To make this data usable, staff must spend vast amounts of time manually “cleaning”—organizing and preparing—the information they receive. The goal of this challenge was to discover innovative ways to clean data and to surpass [...]
Review of Know History
Sarah Vickers2022-01-13T14:05:44-05:00Bronson applied a customized approach to conducting an organizational review of Know History, a company specializing in historical services to assist in the research, presentation and documentation of Canada’s history. Company review required extensive document review and consultation to establish understanding of company processes, policies and systems. Final report offered observations on company strengths [...]
Organizational Review for the Labour Market Information Council
Sarah Vickers2022-01-13T14:15:49-05:00LMIC was created in April 2017 and is an independent non-profit organization with a mandate to provide Canadians with timely, reliable and relevant labour market information. Organizational Review included conducting 25 separate consultations with key stakeholders including all members of LMIC’s Board of Directors, select LMIC staff and representatives of the National Stakeholders Advisory [...]