- 919866784338, 1(480)5807667
- info@jabharathsefoundation.org
- Saroor Nagar, Hyderabad 500035.
Mon 24 Aug 2026
Stop Fighting Pivot Tables: Build an HSE Dashboard from Excel with AI
Most HSE teams – we – already have the data.
It is sitting across inspection sheets, incident registers, training trackers and CAPA files, patiently waiting for someone to spend half a day formatting charts.
This week, let’s explore Bricks, a freemium AI data-analysis platform that can turn an Excel, CSV, PDF or image-based data table into a dashboard containing charts, KPIs, tables and written insights. We can then refine the dashboard through plain-language instructions instead of constructing every formula and chart manually.
How can we use it?
Incident trend dashboard
Step 1: Prepare an anonymised spreadsheet containing:
Incident date
Location
Department
Incident type
Severity
Body part affected
Immediate cause
Lost days
Hours worked
Step 2: Upload the spreadsheet.
Step 3: Ask Bricks to create:
Monthly incident trend
Incidents by site and department
Severity distribution
Most frequent incident types
Lost-day trend
TRIR or LTIFR, only where the required data is available
Step 4: Check every calculation against the original register.
Example prompt:
“Create an executive HSE incident dashboard from this file. Show monthly trends, incidents by location, department, type and severity. Calculate TRIR and LTIFR only if the required hours-worked data is available. Do not invent missing values. Clearly flag incomplete or inconsistent data.”
CAPA and inspection dashboard
We can upload our inspection or audit action tracker containing:
Finding | Risk Rating | Department | Action Owner | Due Date | Status | Verification Date
Then ask Bricks to show:
Open and closed actions
Overdue CAPAs
Actions by risk level
Closure performance by department
Average closure time
Monthly inspection findings
Repeated observation categories
This gives management a much clearer picture than an Excel sheet containing 487 rows and the emotional atmosphere of an abandoned warehouse.
Training-compliance dashboard
Upload a training tracker containing:
Employee | Department | Course | Completion Date | Expiry Date | Status
Bricks can help visualise:
Overall compliance percentage
Training completion by department
Expired certificates
Courses expiring within 30, 60 or 90 days
Employees with multiple overdue requirements
Monthly refresher-training demand
This can support HSE managers, training coordinators and contractor-safety teams during compliance reviews.
A necessary data-safety check
Bricks is operated by The Bricks Inc., a US-based company. Its terms state that data is stored in US AWS data centres. The company says customer content is encrypted using AES-256 at rest and TLS 1.2 or higher in transit, and is not used for general or third-party AI-model training. However, uploaded content may be processed by external AI providers, including OpenAI, Anthropic, Google and others, to provide the requested output.
Therefore, we should:
✅ Use anonymised or sample HSE data for initial testing
✅ Remove names, employee IDs and medical information
✅ Obtain company approval before uploading internal records
✅ Verify every figure, chart and AI-written conclusion
❌ Avoid confidential incident evidence, legal material, process-security information and client-sensitive records
> Safety data becomes valuable only when it helps someone notice a risk, ask a better question and take timely action. Let’s spend less time decorating spreadsheets and more time understanding what the data is trying to tell us. Because an HSE dashboard should not merely report what happened. It should help us decide what must happen next.
Official Website: https://www.thebricks.com/
Note:
All previous AI Friday capsules are uploaded in our website https://jabharathsefoundation.org/artificial-intelligence-ai-tools-in-hse/
Copyright © 2022 J&A Bharat HSE Foundation. All rights reserved
J&A BHF / GHF Annual Keval Shanti & Dr Pravin Patel - Mita Patel Students Scholarship Program 2026 | Last Date 31 Aug 2026 | Click Here
