Furqon E. Muhammad← Portfolio
Case Study 14 / 27Civil Construction / Production Monitoring / Financial Intelligence

Levee Project Daily Production & Revenue Rate Dashboard

Designed a Power BI dashboard linking physical output (Trips, BCM, Shifts) with revenue metrics and Truck Running efficiency.

14 — EPC & Mining AnalyticsLevee Project Daily Production & Revenue Rate Dashboard
PT. Petrosea Tbk · Papua · 2025
Problem

Monitoring daily output against targets required tedious cross-referencing between volume logs and revenue sheets.

Solution

Designed a Power BI dashboard linking physical output (Trips, BCM, Shifts) with revenue metrics and Truck Running efficiency.

Impact

Immediate operational clarity for monitoring daily revenue against targets.

Levee Project Daily Production & Revenue Rate Dashboard14 / 27
A Executive Summary

Overview

14 / 27
Project No.
14
Client / Org
PT. Petrosea Tbk
Role
Production BI Lead
Year
2025
Location
Papua
Discipline
EPC & Mining Analytics

A pilot Daily Production Rate dashboard for Levee, unifying operational output with financial tracking.

Overview — Project Exhibits1 image · add up to 14.12
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.1
PT. Petrosea Tbk · 2025 · Exhibit 14.1
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.2
PT. Petrosea Tbk · 2025 · Exhibit 14.2
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.3
PT. Petrosea Tbk · 2025 · Exhibit 14.3
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.4
PT. Petrosea Tbk · 2025 · Exhibit 14.4
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.5
PT. Petrosea Tbk · 2025 · Exhibit 14.5
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.6
PT. Petrosea Tbk · 2025 · Exhibit 14.6
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.7
PT. Petrosea Tbk · 2025 · Exhibit 14.7
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.8
PT. Petrosea Tbk · 2025 · Exhibit 14.8
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.9
PT. Petrosea Tbk · 2025 · Exhibit 14.9
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.10
PT. Petrosea Tbk · 2025 · Exhibit 14.10
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.11
PT. Petrosea Tbk · 2025 · Exhibit 14.11
Levee Project Daily Production & Revenue Rate Dashboard — exhibit 14.12
PT. Petrosea Tbk · 2025 · Exhibit 14.12
Executive Summary14 / 27
B Outcomes

Strategic Business Impact

14 / 27
01

Production vs. Target Tracking

Volume output (163,424 BCM) vs targets (Avg Revenue MTD $71.12K vs $1.85M total).

02

Fleet & Truck Efficiency Monitoring

The Truck Running module contrasting effective units against availability.

03

Performance Grading Matrix

A color-coded legend (Excellent, Good, Fair, Poor, Bad).

Strategic Business Impact14 / 27
C Delivery

End-to-End Ownership & Technical Execution

14 / 27
01

Data Integration & Modeling

Datasets combining daily logs, trips, volume, and revenue formulas.

02

UI/UX & Visual Layout

Dual-axis charts, revenue trend indicators, and a date-range audit panel.

Power BIProduction RateRevenueBCMFleet Efficiency
Technical Execution14 / 27
ContinueCase 14 / 27