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 [...]
Bronson 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. [...]
Bronson 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. [...]
Bronson 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. [...]
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 [...]
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 [...]
Due 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 [...]
Bronson 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. [...]
ETL 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 [...]
Developed 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 [...]