Bintulu Port HR Analytics
An AI-powered workforce intelligence platform combining three specialized AI engines for comprehensive HR data analysis, knowledge discovery, and document understanding.
System Architecture
Interactive 3D visualization — orbit to explore how the AI engines connect. Each node represents a component, edges show data flow.
Three AI Engines
Working together to answer any HR question from every angle
Vanna AI
Text-to-SQL Engine
Converts natural language questions into precise SQL queries. Trained on the HR database schema, it generates accurate queries, executes them, and returns results with explanations.
EdgeQuake
Knowledge Graph Engine
Builds and searches a knowledge graph of HR entities and relationships using Apache AGE. Maps connections between employees, departments, competencies, and organizational structure.
PageIndex
Document Retrieval Engine
A vectorless, reasoning-based RAG system that builds hierarchical tree indexes from documents. Uses LLM reasoning to navigate document structure like a human expert — finding the most relevant sections with traceable evidence.
How a Question Gets Answered
User Asks a Question
Example: "Which department has the worst competency gaps and what does the original report say about them?"
Vanna Generates SQL
Converts the question to a precise SQL query, executes it against PostgreSQL, and returns structured data with department scores, gap values, and employee counts.
EdgeQuake Searches the Graph
Finds related entities in the knowledge graph — connected employees, reporting chains, competency relationships — providing contextual understanding.
PageIndex Searches Documents
Reasons over the hierarchical index of uploaded documents, navigates to the most relevant sections, and extracts evidence with specific citations.
AI Synthesizes the Answer
Gemini LLM combines data from all three sources — numbers from Vanna, context from EdgeQuake, evidence from PageIndex — into a comprehensive, data-driven response with charts.
Platform Features
Dashboard
Executive KPI overview with competency metrics, gap analysis, and trend indicators
Analytics
3D competency map, department heatmaps, sub-area gap analysis, workforce intelligence
Employees
3D workforce map, performance rankings, gap distribution, grade analysis
AI Chat
Ask any question — powered by Vanna, EdgeQuake, and PageIndex working together
Recommendations
Auto-generated action items: training needs, succession risks, development priorities
Benchmarking
Side-by-side comparisons of departments, divisions, and job grades
Scenarios
What-if modeling with sliders to project competency outcomes
Knowledge Graph
Interactive 3D force graph of HR entity relationships
Upload
Upload Excel, CSV, PDF, Word, image, audio, and video files for analysis
Technology Stack
Frontend
- Next.js 16
- React 19
- Tailwind CSS
- Three.js / 3D Force Graph
- Recharts
Backend
- Node.js
- Drizzle ORM
- Flask (Python)
- Gunicorn
AI / LLM
- Gemini 2.5 Flash
- Vanna AI
- EdgeQuake
- PageIndex
- LiteLLM
Infrastructure
- PostgreSQL + Apache AGE
- Redis
- Docker
- Traefik (SSL)
- SSH Tunnels
Bintulu Port Holdings Berhad · HR Analytics & AI Assistant Platform
Capability Development Framework Pilot Project