Skip to content
Back to PortfolioKembali ke Portofolio
Enterprise Systems

Business Intelligence & Financial Operational System Dealer Motor

An enterprise analytics platform & financial operational system powered by Next.js App Router, PostgreSQL Star Schema, Redis query caching, SARIMA time-series forecasting, and Random Forest SHAP Explainable AI.

Production UI Webview Preview
Business Intelligence & Financial Operational System Dealer Motor

TECH STACK & ARCHITECTURE COMPONENTSSTACK TEKNOLOGI & KOMPONEN ARSITEKTUR

appsNext.js
Fullstack Framework
paletteTailwind CSS
Design System CSS
dnsExpress.js
REST API Server
layersPrisma ORM
Type-Safe Database ORM
storagePostgreSQL
Primary Relational DB
memoryRedis
In-Memory Cache
show_chartRecharts
BI Chart Engine
mapLeaflet GIS
Map Visualization
model_trainingPython SARIMA/SHAP
ML & XAI Engine
ProblemPermasalahan Utama

Motorcycle dealerships face slow analytical queries over large transaction sets, lack of predictive sales insight, and manual paper signature bottlenecks.

Engineering SolutionSolusi Rekayasa

Built an enterprise BI platform featuring a PostgreSQL Star Schema data warehouse, sub-100ms Redis caching layer, Machine Learning pipeline (SARIMA time-series forecasting + Random Forest SHAP XAI), Recharts analytics, Leaflet GIS customer mapping, and SHA-256 digital document signature overlays.

System ImpactDampak Sistem

Delivers sub-100ms aggregation performance and provides executive decision makers with actionable, transparent AI forecast metrics.

BI DEALER MOTOR — FINANCIAL SYSTEM ARCHITECTURE

Hover any node for component specsHover node untuk spesifikasi komponen
BI DEALER MOTOR — FINANCIAL SYSTEM ARCHITECTUREClient:Web App 15 &(Next.js Vercel)Middle:Express & AuthGateway FirebaseStorage:PostgreSQL &Redis Cache DBLogic:Thinking AI &(SARIMA SHAP XAI)Logic:Executive &Portal CRUD CoreLogic:Redis Cache &Performance EngineLogic:GIS Density &Heatmap EngineLogic:Document & PDFSignature EngineOutput:Recharts & PDFSignedOutput:Leaflet GISDensity MapOutput:Peak-HourIntensity HeatmapDeploy:Vercel Cloud &GitHub CI/CD
System Legend:Legenda Sistem:
Frontend & IngressCore Service & GuardLogic & AI EngineDatabase & StorageSecurity & Audit