Freelance

<h2><strong>🎯 Business Objectives</strong></h2><ul><li><p>Monitor <strong>incident performance</strong> and exposure</p></li><li><p>Track <strong>safety trends over time</strong> (monthly &amp; cumulative)</p></li><li><p>Compare performance by <strong>site, activity, and company</strong></p></li><li><p>Calculate <strong>standardized safety rates</strong> using man-hours</p></li><li><p>Enable <strong>Year-over-Year (YoY)</strong> performance comparison</p></li><li><p>Support data-driven HSE decision-making</p></li></ul><h2><strong>📊 Key KPIs</strong></h2><p><strong>KPI Description :</strong></p><ul><li><p>Total Incidents </p></li><li><p>All reported incidents </p></li><li><p>Total Recordable Incidents (TRI) OSHA / IOGP recordable incidents</p></li><li><p>Lost Time Incidents (LTI)</p></li><li><p>Incidents resulting in lost workdays</p></li><li><p>Total Man-Hours</p></li><li><p>Exposure basis for rate calculations</p></li><li><p>LTI Lost Days</p></li><li><p>Severity indicator</p></li><li><p>Days Since Last LTISafety maturity metric</p></li></ul><p>All major KPIs include <strong>YoY % variation</strong>.</p><h2><strong>🧭 Dashboard Pages</strong></h2><h3><strong>1️⃣ Incidents – Executive Overview</strong></h3><ul><li><p>KPI cards with YoY indicators</p></li><li><p>Incidents by Site</p></li><li><p>Recordable Incidents (TRI) by category</p></li><li><p>Incidents by Type</p></li><li><p>Monthly incidents with cumulative trend</p></li><li><p>Days Since Last LTI</p><div class="image-container"><div class="image-row-wrapper"><div class="image-wrapper"><img src="https://cdn.collective.work/cmnaphd9be8ur3th1e3mx05re.png"><div class="image-overlay"></div></div></div></div></li></ul><h3><strong>2️⃣ TRI Details</strong></h3><ul><li><p>TRIR Rolling 12 Months</p></li><li><p>TRIR Year-To-Date</p></li><li><p>Benchmark comparison</p></li><li><p>Breakdown by site, activity, and company</p><div class="image-container"><div class="image-row-wrapper"><div class="image-wrapper"><img src="https://cdn.collective.work/cmnapgq6zefrv3vjb0nl9apdh.png"><div class="image-overlay"></div></div></div></div></li></ul><h3><strong>3️⃣ LTI Details</strong></h3><ul><li><p>LTIFR Rolling 12 Months</p></li><li><p>LTIFR Year-To-Date</p></li><li><p>LTI Severity Rate</p></li><li><p>Lost days analysis</p><div class="image-container"><div class="image-row-wrapper"><div class="image-wrapper"><img src="https://cdn.collective.work/cmnaphpgbe6la3vi2650j39wb.png"><div class="image-overlay"></div></div></div></div></li></ul><h2><strong>🎛 Filters &amp; Interactivity</strong></h2><p>The dashboard includes dynamic slicers:</p><ul><li><p>Year</p></li><li><p>Incident Type</p></li><li><p>Activity</p></li><li><p>Site</p></li><li><p>Company / Contractor</p></li></ul><p>All visuals respond interactively to slicer selections.</p><h2><strong>🗂 Data Model</strong></h2><p></p><div class="image-container"><div class="image-row-wrapper"><div class="image-wrapper"><img src="https://cdn.collective.work/cmnapig4xed8f3ujbbcwy0j6w.png"><div class="image-overlay"></div></div></div></div><h3><strong>🔹 Architecture</strong></h3><ul><li><p><strong>Star Schema</strong></p></li><li><p>Optimized for analytical performance</p></li><li><p>Clear separation between facts and dimensions</p></li></ul><h3><strong>🔹 Fact Tables</strong></h3><p><strong>fact_incident</strong></p><ul><li><p>Incident-level data</p></li><li><p>Injury severity, recordability, lost days</p></li><li><p>Linked to site, company, activity, equipment, body part</p></li></ul><p><strong>fact_hours_worked</strong></p><ul><li><p>Total worked hours</p></li><li><p>Used as the exposure denominator</p></li></ul><h3><strong>🔹 Dimension Tables</strong></h3><ul><li><p>dim_date</p></li><li><p>dim_site</p></li><li><p>dim_company</p></li><li><p>dim_activity</p></li><li><p>dim_employee</p></li><li><p>dim_incident_type</p></li><li><p>dim_incident_category</p></li><li><p>dim_equipment</p></li><li><p>dim_body_part</p></li></ul><h2><strong>🧮 Key DAX Measures (Samples)</strong></h2><p>Total Incidents = COUNT(fact_incident[Incident_ID])</p><p>TRIR = DIVIDE( [Total Recordable Incidents] * 1000000, [Total Man-Hours] )</p><p>LTIFR = DIVIDE( [Total Lost Time Incidents] * 1000000, [Total Man-Hours] )</p><p>Additional measures include:</p><ul><li><p>Rolling 12 Months (TRIR / LTIFR)</p></li><li><p>Year-To-Date metrics</p></li><li><p>YoY % change</p></li><li><p>Cumulative incidents</p></li><li><p>Days Since Last LTI</p></li></ul><h2><strong>📐 Benchmarks &amp; Standards</strong></h2><ul><li><p>Industry benchmarks (e.g. IOGP)</p></li><li><p>Internal corporate targets</p></li><li><p>Performance comparison integrated into TRI &amp; LTI pages</p></li></ul><h2><strong>🎨 Design Principles</strong></h2><ul><li><p>Executive-friendly layout</p></li><li><p>Clean and consistent color palette</p></li><li><p>High readability for management reporting</p></li><li><p>Logical navigation using buttons</p></li><li><p>Minimal clutter, insight-focused visuals</p></li></ul><h2><strong>🛠 Tools &amp; Technologies</strong></h2><ul><li><p>Power BI Desktop</p></li><li><p>DAX</p></li><li><p>Power Query</p></li><li><p>Star schema modeling</p></li></ul><h2><strong>🚀 Potential Enhancements</strong></h2><ul><li><p>Predictive safety analytics</p></li><li><p>Near-miss &amp; safety observations module</p></li><li><p>Automated data refresh</p><p></p></li></ul>

📌 Project Overview
This repository contains a professional Power BI HSE Dashboard designed to analyze and monitor Health, Safety, and Environment (HSE) performance across multiple sites, activities, and companies.

The dashboard follows industry-standard safety metrics (TRI, LTI, TRIR, LTIFR) and uses a star-schema data model to ensure scalability, performance, and analytical depth.

It is suitable for:

Corporate HSE reporting
Executive & management reviews
Contractor safety monitoring
This project's data was simulated using Claude AI (randomly)

https://github.com/Meryemkacem/HSE_Dashboard_Pbi_2026

Meryem KACEM

Senior Data Analyst | Power BI & SQL | PMP®

À propos

Expérience de travail

Data Analyst

SEREPT

HSE Data Analytics and Reporting Specialist

Health Safety Environment Engineer

Formation

IU International University of Applied Sciences

National Engineering School of GABES (ENIG)

IPEIEM EI Manar

Lycé Carthage Byrsa

Licences et certifications

Google Data Analytics Professional Certificate

Microsoft Certified: Power BI Data Analyst Associate

PMP®

Portfolio

HSE Dashboard

Freelance

Talents

Recruteurs

À propos