Quick Summary

Bronson produced a suite of Tableau Desktop visualizations of office temperature data for use in legal proceedings.

The dataset covered five office spaces and thousands of temperature readings captured at 5-minute intervals from June 14 to September 2, 2021.

Visualizations were designed for dual audiences: technical reviewers requiring analytical rigour and a non-technical legal audience requiring clarity.

The analysis quantified that on average, office temperatures fell outside the accepted 20°C to 22°C range approximately 50% of working hours across all five offices.

The Tableau outputs were accepted for use in legal proceedings as compelling, evidence-based documentation of systemic workplace conditions issues.

Project Overview

A client engaged Bronson to analyze thousands of office temperature readings and produce data visualizations that would clearly demonstrate unreasonable working conditions across five office spaces. The visualizations were being prepared for legal proceedings, which placed a premium on clarity, precision, and evidentiary rigour.

The visualizations had to do two things at once. They had to communicate the ongoing pattern of problematic temperatures across the workday. They also had to show the substantial fluctuations in thermostat readings that made conditions routinely untenable. Both layers needed to be visible in a single set of artifacts that could be understood by a general legal audience while still standing up to detailed analytical review.

Bronson approached the engagement as a focused Tableau visualization and exploratory data analysis project, with deliverables shaped specifically for an evidentiary use case. The result was a suite of charts that translated a large, granular dataset into clear, defensible visual evidence.

The Challenge

Producing visualizations for legal proceedings is a different exercise from producing visualizations for an internal business audience. The work has to satisfy expert scrutiny and lay interpretation in the same artifacts.

The main challenges Bronson tackled:

  • Volume and granularity of data. Temperature readings were captured at 5-minute intervals across five offices over roughly two and a half months, producing thousands of data points per office that had to be synthesized into a comprehensible visual story.
  • Dual-audience design. Visualizations had to be technically precise enough for expert review and visually clear enough for a non-technical legal audience to interpret without specialist support.
  • Evidentiary rigour. Charts needed to be defensible. Reference points, benchmarks, and methodological choices had to be transparent and grounded in authoritative sources.
  • Pattern and severity in one view. The visualizations had to demonstrate not only that temperatures were elevated, but that the conditions were systemic, sustained, and materially different from a reasonable workplace standard.
  • Workday vs. non-workday separation. The legal argument concerned working conditions during normal hours. Visualizations had to clearly distinguish workday readings from off-hours readings without losing the underlying time-series signal.

The client needed visualizations that converted raw thermostat data into clear, court-ready evidence of unreasonable workplace conditions.

Our Solution

Bronson designed a focused, evidentiary-grade visualization engagement using Tableau Desktop.

The work was organized into four streams:

  1. Data Preparation and Exploratory Analysis: Bronson began by structuring the temperature dataset for analysis, validating data quality, and conducting exploratory analysis to identify patterns across offices, days, and times of day. This baseline analysis informed the design of every subsequent visualization.
  2. Time-Series Visualization Design: Bronson built a dedicated time-series visualization for each of the five offices, plotting temperature as a function of time at 5-minute resolution. Colour coding distinguished workday readings (8:00 AM to 6:00 PM) from other periods, making it possible to immediately identify conditions during working hours.
  3. Reference Benchmarking: Each chart included a grey reference band marking the accepted room temperature range of 20°C to 22°C, drawn from Statistics Canada data. The reference band gave viewers a clear, authoritative benchmark against which to assess the recorded temperatures and strengthened the evidentiary value of the visualizations.
  4. Summary and Comparative Visualizations: Bronson developed a heatmap of workday temperature maximums and a bar chart showing the percentage of time each office spent above, at, or below the room temperature range. These summary visualizations layered quantified findings on top of the time-series data, supporting both expert and lay interpretation of the evidence.

Key Deliverables

Workday Maximum Temperature Heatmap – A Tableau heatmap visualization showing daily workday temperature maximums across all five offices, allowing immediate identification of the most problematic days and offices.

Time-In-Range Bar Chart – A bar chart visualization quantifying the percentage of time each office spent above, at, or below the accepted room temperature range during workday hours.

Quantitative Findings Summary – A documented summary of the quantitative findings derived from the visualizations, including office-by-office percentages and cross-office averages, suitable for direct use in legal submissions.

Tableau Visualization Suite for Legal Submission – The full assembled set of Tableau outputs, prepared in evidentiary-grade form for use in the client’s legal proceedings.

The Impact

The Tableau visualizations gave the client clear, quantified, and legally usable evidence of systemic workplace conditions issues across the five offices. Specifically, the analysis demonstrated:

  • All five offices regularly exceeded the accepted room temperature range during the workday, with some recording temperatures as high as 30°C.
  • One office was above the room temperature range for more than 60% of working hours.
  • Another office was below the room temperature range for more than 27% of working hours.
  • On average across all five offices, temperatures fell outside the accepted 20°C to 22°C range approximately 50% of working hours.

The visualizations were accepted for use in legal proceedings, providing the client with compelling, evidence-based documentation of unreasonable working conditions. The engagement demonstrates how rigorous data analytics and well-designed Tableau visualizations can convert raw operational data into defensible, court-ready evidence.

4.5 min read
Project Themes:
, , , , ,

Similar Projects

Let’s work together.

Don’t let data challenges hold back your operations. Explore how data, analytics, and AI can drive success in your business processes. Contact us today for a consultation and unlock the full potential of your data.