Project · Digital & Data

Digital Tools &
Data-Driven Operations

Designed and developed a complete suite of Power BI dashboards and Power Apps applications — transforming raw operational data into real-time decision-making tools across quality, production, HSE, supply chain and compliance.

Power BI SAP Integration Power Apps Real-time Dashboards Process Automation Data-Driven Decisions

Impact at a glance

Key Numbers

5
Power BI dashboards developed & deployed
3
Power Apps built & deployed in production
Live
Real-time SAP data connection — instant refresh
$20K+
Annual saving — NC dashboard eliminated manual labor extraction
100%
Certificate of Conformity generation automated
0
Manual reporting — replaced by automated dashboards

Power BI · SAP Connected

Dashboards Developed

Non-Conformance Dashboard
Power BI · SAP Live

Real-time monitoring of all non-conformances on the site — connected directly to the SAP database with instant refresh. Enables proactive quality management and rapid escalation of critical NCs.

Live NC count by type, product and severity
KPI tracking — open NCs, closure rate, aging
Scrap cost monitoring by defect category
Pareto view — top contributors to quality cost
MES Operator Time Tracking
Power BI · MES Data

Dashboard tracking operator time entries on MES — distinguishing direct and indirect time per product, enabling STD time accuracy analysis and targeted improvement actions.

Direct vs indirect time per operator & product
Run time vs STD time accuracy monitoring
IDLE time tracking — utilization rate per shift
Action plan triggers on accuracy below threshold
HSE Reporting Dashboard
Power BI · Site HSE

HSE reporting dashboard tracking monthly observation and RIR objectives per team member, mandatory certification compliance (target ≥95%) and overall site HSE performance — ensuring full visibility for management and proactive follow-up.

Monthly HSE observation & RIR objective tracking per person
Mandatory certification compliance — target ≥95% acquired
Individual & team compliance rate — gap identification
Management-ready view — instant HSE status at a glance
Raw Material Stock Dashboard
Power BI · SAP Live

Real-time raw material stock monitoring connected to SAP — enabling shortage anticipation, stock rupture prevention and proactive supply chain relaunch before critical levels are reached.

Live stock levels vs minimum threshold alerts
Shortage risk identification — days of coverage
Automatic supply chain relaunch trigger
Consumption trend vs production forecast
Incoming Inspection Dashboard
Power BI · SAP GR

Dashboard tracking all incoming goods receipt inspections — monitoring team KPIs, inspection lot status, decisions taken and pending controls to ensure full traceability and team performance visibility.

Inspection lot status — controlled, pending, decision
Team KPI tracking — inspection throughput & delays
Control date, inspector and decision per lot
Backlog view — lots awaiting inspection

Power Apps · Process Automation

Applications Developed

Certificate of Conformity Generator
Power Apps · Automated

Power Apps application automating the generation of Certificates of Conformity (CoC) for finished products — eliminating manual document creation, reducing errors and ensuring standardized, traceable certification for every shipped product.

Automated CoC generation from product data
Standardized format — zero manual input errors
Full traceability — linked to production order
Instant generation — replacing multi-step manual process
Operator Tool Request App
Power Apps · Stock Management

Power Apps application managing operator tool requests on the shopfloor — digitalizing the request process, maintaining a full request history, tracking current stock levels and enabling proactive stock anticipation before shortages occur.

Digital tool request workflow — operator to manager
Full request history — who, what, when
Live stock visibility — current tool inventory
Shortage anticipation — consumption trend alerts
TPM Management App
Power Apps · Paperless

Power Apps application replacing the paper-based TPM (Total Productive Maintenance) process — digitalizing maintenance rounds, checklists and anomaly reporting directly from the shopfloor, with full history and real-time visibility for supervisors.

Digital TPM rounds — operators fill checklists on app
Anomaly reporting with photo & description
Full TPM history — machine, date, operator, status
Real-time supervisor view — pending & completed rounds
100% paperless — eliminates lost or incomplete forms

Outcomes

Results

Real-time operational visibility

All critical KPIs accessible live — quality, production, HSE, stock and inspections in one ecosystem

Shortage prevention

Raw material dashboard enabled proactive supply chain relaunch before stock ruptures occurred

CoC generation automated

Certificate of Conformity process fully automated — eliminating manual errors and saving significant admin time

HSE reporting streamlined

Site HSE reporting consolidated in a single live dashboard — ready for management review at any time

Data-driven decision making

Management and frontline teams equipped with real-time data — decisions based on facts, not assumptions

Tool request digitalized

Paper-based tool request process replaced by a digital app — full history, stock visibility and anticipation

Certification & Recognition

Industry Validation

Official Certification

Manufacturing Business Intelligence
Fundamental Certificate

Certified on the development and deployment of manufacturing BI dashboards — validated through a real-world project delivering measurable business impact.

Key Achievement

NC Dashboard — Presented to Vice President

The Non-Conformance Power BI dashboard was presented directly to the site Vice President and leadership team — demonstrating the business impact of data-driven quality management at the highest level.

$20K+
Annual saving — labor cost
eliminated (manual extraction)
VP
Presented to Vice President
& leadership team

Stack

Tools & Technologies

Power BI
Power Apps
SAP HANA
SAP Quality Module
MES / MEPOD
Real-time Data Connection
Process Automation
KPI Dashboarding

“Built a complete digital ecosystem from the ground up — 5 Power BI dashboards connected to live SAP data and 2 Power Apps automating critical shopfloor processes — transforming manual reporting into real-time, data-driven operations across quality, production, HSE, supply chain and compliance.”