Data and Technology Consulting

Data Maturity Assessment for the Association of Faculties of Medicine of Canada

2024-08-14T16:07:03-04:00

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 [...]

Tableau Services for the Ottawa Airport

2024-08-15T09:27:48-04:00

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 [...]

Klipfolio Dashboard Creation for Colliers Project Leaders

2024-08-14T11:35:43-04:00

Bronson built a dynamic Klipfolio dashboard for Colliers to report on metrics related to SharePoint usage. The project involved identifying key performance indicators (KPIs) and determining the best visual representation for each KPI. The dashboard enhanced Colliers’ awareness and understanding of their SharePoint use through visually compelling and informative displays. [...]

CRTC Tableau Dashboard Development

2024-08-14T11:04:19-04:00

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. [...]

Tableau and AWS Implementation for Saskatchewan Polytechnic

2024-08-14T11:05:45-04:00

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. [...]

Social Media Dashboard Development for Colliers Project Leaders

2024-08-13T15:39:13-04:00

Bronson built Klipfolio dashboards for Colliers to report on social media and website metrics, enhancing awareness and understanding of their online presence. The project involved identifying and visually representing key performance indicators (KPIs) for various platforms, including Twitter, Facebook, LinkedIn, YouTube, Google+, and Google Analytics. Bronson conducted dashboard testing, provided performance measurement advice, and [...]

Labour Market Data Hub Research for LMIC

2024-08-12T16:41:04-04:00

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. [...]

Data Analytics Training and Capacity Building for NRCan

2024-08-12T15:08:18-04:00

Bronson provided data analytics advisory and capacity building services to the Audit and Evaluation Branch of NRCan. Services included basic training in Alteryx Designer and Tableau Desktop for NRCan Audit and Evaluation staff. Training sessions were conducted virtually using Microsoft Teams and consisted of two half-day sessions for both Alteryx and Tableau, utilizing internally [...]

Data Entry Services for the Integrity Services Branch of the ESDC

2024-08-12T11:47:02-04:00

Bronson provided data entry services for Integrity Services Branch (ISB) of ESDC for a three year period (2017 to 2020) and captured data from over 2 million Record of Employment and Request for Payroll Information forms. The data capture was performed according to detailed specifications and was subject to an acceptable error rate of [...]

Airport Productivity Dashboard for the Ottawa Airport

2024-08-12T11:48:08-04:00

Bronson replicated the Ottawa International Airport Authority's 2019 Airport Comparison Dashboard from Excel to Tableau. They developed a methodology to illustrate various productivity metrics with differing units of measurement. Bronson worked closely with the Ottawa Airport Project Authority to ensure the Tableau dashboard met the intended objectives. Project [...]

Go to Top