Given its role, partnerships, and access to data and statistics, the AFMC is positioned to provide strategic insight on the most pressing priorities faced by its stakeholders, members, medical students, physicians, and other relevant medical practitioners in Canada.The AFMC engaged Bronson to perform a Data Maturity Assessment tied to evaluate the AFMC’s current abilities in [...]
CRTC Tableau Dashboard Development
Mansi Sethi2024-08-14T11:04:19-04:00Bronson developed multiple Tableau dashboards for the CRTC's Data Collection System (DCS) to monitor operational details for telecommunications service providers. Dashboard development was primarily conducted on-site at CRTC offices due to confidentiality considerations. The DCS data was hosted in an on-site SQL Server, and Bronson used queries to extract datasets required for the dashboards. [...]
Tableau and AWS Implementation for Saskatchewan Polytechnic
Mansi Sethi2024-08-14T11:05:45-04:00Bronson implemented and supported a Tableau Server at Saskatchewan Polytechnic’s Saskatoon campus, including AWS hosting and Single Sign-On integration. The project included comprehensive training for Tableau users and ongoing analytics/BI consulting, software support, and project management services. Bronson's role extended into Phase 2 with advanced analytics strategies, training, software maintenance, and detailed project management. [...]
Labour Market Data Hub Research for LMIC
Mansi Sethi2024-08-12T16:41:04-04:00Bronson supported LMIC in upscaling the LMIC Data Hub by conducting market research on similar public and private labour market data systems. The project involved developing a comparative analysis template and identifying all relevant data delivery systems. Bronson provided comprehensive analysis, status reports, and final recommendations to avoid duplication of existing systems. [...]
Automation of Geospatial Data Processing and Quality Assurance Review for the CRTC
Sarah Vickers2024-08-20T13:37:45-04:00Expansion 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 Vickers2024-08-12T13:24:33-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-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 [...]
Data Analytics Support to the Indigenous Community-Based Climate Monitoring Program
Sarah Vickers2024-08-12T13:50:02-04:00Bronson provided support to CIRNA’s ICBCMP by analysing data management tools, guiding work planning and developing program management guidance. As a new program, the support and tools provided to the ICBCMP allowed them to plan their work and effectively provide funding to Indigenous communities for long-term, community-based climate monitoring projects. [...]
Data Transformation for Canadian Radio-Television Telecommunications Commission Analysts
Sarah Vickers2024-08-12T14:04:33-04:00ETL pipeline in Tableau Prep. Finely tuned to suit CRTC short and long-term needs. Proof-of-concept for automating ETL with larger datasets. Project Description Bronson used Tableau Prep to develop an ETL pipeline to transform normalized quarterly survey data into a Tableau-ready format for CRTC analysts. Business Challenge Anticipating the [...]
Data Management Strategy for Ottawa MacDonald-Cartier International Airport Authority
Sarah Vickers2024-08-12T14:08:33-04:00Developed a 3- to 5- year roadmap with 17 activities to mature YOW data management to a level aligned with industry trends. Made recommendations to make specific data FAIR (findable, accessible, interoperable and re-useable) to authorized users. Project Description Ottawa/MacDonald-Cartier International Airport Authority (YOW) was at a turning [...]