Furqon E. Muhammad← Portfolio
Case Study 07 / 27Business Intelligence / Process Automation / Pipeline Management

Business Development Tender Summary & Pipeline Command Center

Engineered a Power BI dashboard integrated with a SharePoint list, tracking the BD lifecycle across five stages.

07 — Business Development IntelligenceBusiness Development Tender Summary & Pipeline Command Center
PT. Petrosea Tbk · Head Office · 2026
Problem

BD and BOD relied on manual PowerPoint to review pipelines, creating silos and consuming time.

Solution

Engineered a Power BI dashboard integrated with a SharePoint list, tracking the BD lifecycle across five stages.

Impact

Eliminated manual drafting, giving the BOD an instant view of prospect statuses, values, and win/loss ratios.

Business Development Tender Summary & Pipeline Command Center07 / 27
A Executive Summary

Overview

07 / 27
Project No.
07
Client / Org
PT. Petrosea Tbk
Role
BI & Automation Lead
Year
2026
Location
Head Office
Discipline
Business Development Intelligence

An end-to-end BD tracking platform replacing legacy PowerPoint updates with a live command center via SharePoint + Power BI.

Overview — Project Exhibits6 images · add up to 07.12
Business Development Tender Summary & Pipeline Command Center — exhibit 07.1
PT. Petrosea Tbk · 2026 · Exhibit 07.1
Business Development Tender Summary & Pipeline Command Center — exhibit 07.2
PT. Petrosea Tbk · 2026 · Exhibit 07.2
Business Development Tender Summary & Pipeline Command Center — exhibit 07.3
PT. Petrosea Tbk · 2026 · Exhibit 07.3
Business Development Tender Summary & Pipeline Command Center — exhibit 07.4
PT. Petrosea Tbk · 2026 · Exhibit 07.4
Business Development Tender Summary & Pipeline Command Center — exhibit 07.5
PT. Petrosea Tbk · 2026 · Exhibit 07.5
Business Development Tender Summary & Pipeline Command Center — exhibit 07.6
PT. Petrosea Tbk · 2026 · Exhibit 07.6
Business Development Tender Summary & Pipeline Command Center — exhibit 07.7
PT. Petrosea Tbk · 2026 · Exhibit 07.7
Business Development Tender Summary & Pipeline Command Center — exhibit 07.8
PT. Petrosea Tbk · 2026 · Exhibit 07.8
Business Development Tender Summary & Pipeline Command Center — exhibit 07.9
PT. Petrosea Tbk · 2026 · Exhibit 07.9
Business Development Tender Summary & Pipeline Command Center — exhibit 07.10
PT. Petrosea Tbk · 2026 · Exhibit 07.10
Business Development Tender Summary & Pipeline Command Center — exhibit 07.11
PT. Petrosea Tbk · 2026 · Exhibit 07.11
Business Development Tender Summary & Pipeline Command Center — exhibit 07.12
PT. Petrosea Tbk · 2026 · Exhibit 07.12
Executive Summary07 / 27
B Outcomes

Strategic Business Impact

07 / 27
01

Comprehensive Pipeline Visibility

Segmented the lifecycle (Preparation, Submitted, Budgetary, Wins/Losses, Cultivating).

02

Automated Executive Reporting

A live summary tracking tenders invited (18), submitted (2), and awarded (1).

03

Centralized Data Governance

A standardized SharePoint list as a single source of truth for client interactions.

Strategic Business Impact07 / 27
C Delivery

End-to-End Ownership & Technical Execution

07 / 27
01

Data Integration & Automation

Pipelines connecting SharePoint to Power BI via Power Query for real-time extraction.

02

UI/UX & Business Intelligence

A multi-page interface with status charts, value aggregations, and table views.

03

Process Optimization & Change Management

Shifted BD from static reporting to proactive pipeline management.

Power BISharePointPower QueryPipelineAutomation
Technical Execution07 / 27
ContinueCase 07 / 27