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 [...]
Data Analytics and Advisory Services for Natural Resources Canada’s Audit & Evaluation Branch
Sarah Vickers2024-08-12T13:29:04-04: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. Project Description Bronson was engaged by NRCan’s Audit & Evaluation Branch to [...]
Forecasting Annual Maintenance Costs for the City of Ottawa’s Fleet Services
Sarah Vickers2024-08-12T13:30:20-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 [...]
Analysis of Sales Data for Farm Boy
Sarah Vickers2024-08-12T13:38:11-04: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. Project Description Bronson was hired by Farm Boy to develop Alteryx workflows to conduct an analysis of their sales data for use [...]
Data Aggregation for The Department of National Defence’s Strong Secure Engaged Defence Policy
Sarah Vickers2024-08-12T13:48:21-04: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-08-12T13:59:11-04: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 [...]