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 [...]
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. [...]
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 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 [...]
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 [...]
The temperatures were recorded at 5-minute intervals from June 14 to September 2, 2021. All offices regularly exceeded room temperature during a typical workday, some reaching temperatures as high as 30C. One office was above room temperature over 60% of the time during workdays. Another office was below room temperature over 27% of the [...]