Furqon E. Muhammad← Portfolio
Case Study 03 / 27Operational Intelligence / Business Intelligence / Process Optimization

Awakmas Mine Operational Excellence & Productivity Dashboard

Architected a multi-tiered Power BI platform over 3 months, converting Excel logs into diagnostics covering Productivity, EWH, and Fuel Analysis.

03 — EPC & Mining AnalyticsAwakmas Mine Operational Excellence & Productivity Dashboard
PT. Petrosea Tbk · Awakmas (MDA) · 2026
Problem

The OpEx team lacked visibility into heavy equipment inefficiencies; raw .xlsx data obscured bottlenecks.

Solution

Architected a multi-tiered Power BI platform over 3 months, converting Excel logs into diagnostics covering Productivity, EWH, and Fuel Analysis.

Impact

Shifted the OpEx team from reactive reporting to data-led advisories, isolating downtime causes and flagging fuel burn.

Awakmas Mine Operational Excellence & Productivity Dashboard03 / 27
A Executive Summary

Overview

03 / 27
Project No.
03
Client / Org
PT. Petrosea Tbk
Role
Operational Intelligence Lead
Year
2026
Location
Awakmas (MDA)
Discipline
EPC & Mining Analytics

A comprehensive Operational Intelligence suite for Awakmas (MDA), translating heavy machinery metrics into actionable insights.

Overview — Project Exhibits4 images · add up to 03.12
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.1
PT. Petrosea Tbk · 2026 · Exhibit 03.1
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.2
PT. Petrosea Tbk · 2026 · Exhibit 03.2
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.3
PT. Petrosea Tbk · 2026 · Exhibit 03.3
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.4
PT. Petrosea Tbk · 2026 · Exhibit 03.4
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.5
PT. Petrosea Tbk · 2026 · Exhibit 03.5
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.6
PT. Petrosea Tbk · 2026 · Exhibit 03.6
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.7
PT. Petrosea Tbk · 2026 · Exhibit 03.7
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.8
PT. Petrosea Tbk · 2026 · Exhibit 03.8
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.9
PT. Petrosea Tbk · 2026 · Exhibit 03.9
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.10
PT. Petrosea Tbk · 2026 · Exhibit 03.10
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.11
PT. Petrosea Tbk · 2026 · Exhibit 03.11
Awakmas Mine Operational Excellence & Productivity Dashboard — exhibit 03.12
PT. Petrosea Tbk · 2026 · Exhibit 03.12
Executive Summary03 / 27
B Outcomes

Strategic Business Impact

03 / 27
01

Asset Utilization & Downtime Diagnostics

Separated EWH into Ready, Delay, Standby, Breakdown states, isolating time-sinks (SNJ, Digger Repair).

02

Production vs. Effort Correlation

Mapped EWH against earthmoving volume (Bcm), highlighting low-yield high-hour days.

03

Fuel Economics & Cost Control

Deployed Fuel Ratio (L/Bcm) tracking across activities, flagging suboptimal performance.

Strategic Business Impact03 / 27
C Delivery

End-to-End Ownership & Technical Execution

03 / 27
01

Data Architecture & Transformation

Engineered ingestion of fragmented .xlsx logs into a relational DAX model.

02

UI/UX & Business Intelligence

Designed modules (Productivity, EWH, Digger Detail, Fuel) with slicers and variance indicators.

03

Operational Advisory

Advised OpEx on interpreting diagnostics for continuous improvement.

Power BIEWHFuel AnalysisProductivityOpEx
Technical Execution03 / 27
ContinueCase 03 / 27