From 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 [...]
Digital Readiness Assessment for Canadian Heritage
Sarah Vickers2024-08-12T13:27:46-04:00Digital Readiness Framework based on Government policies, specifically the Government of Canada Digital Standards. Representation across department and diverse job levels for consultation and survey. Report describes as-is state and identifies area for improvement. Next step is a detailed roadmap to improve and progress digital maturity. More information can be found in our 2021 [...]
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 [...]
Retained by IESO for Compliance Audits
Sarah Vickers2024-08-12T13:31:47-04: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-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 [...]
Revising Business Processes for the Public Health Agency of Canada
Sarah Vickers2024-08-12T13:45:00-04:00Developed an Intervention Framework to aid decision-making for $27 million annual investment in primary prevention interventions to change behaviour that will positively impact health. Documented 10 As-Is and To-Be business processes using Business Process Model Notation. Projects funded under this initiative focus on innovative, integrated approaches to promote healthy living, prevent chronic disease and [...]
Seeking Authorities for Contaminated Site Projects in Canada’s North
Sarah Vickers2024-08-12T13:42:32-04:00Since 2011, Bronson has been supporting CIRNA’s NCSP with the drafting of program, project and expenditure authority documentation related to contaminated sites in Yukon, the Northwest Territories and Nunavut, for which the Government of Canada is responsible. Northern contaminated sites tend to be large, complex and in remote locations, which make them unique and [...]
Business Process Review and Modelling Simulation Services to Canada Post Corporation
Sarah Vickers2024-08-12T13:46:58-04:00A small packet mail operations sorter is highly automated and can process 10,000 packets an hour. Resources are needed to load packets such that the labels can be read, so resourcing (numbers, proficiency, assignment) have a high degree of influence on output. Several scanning technologies are used to read packet labels, such as barcodes [...]
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 [...]