Sep 2026 - Oct 2026

Employee Insight Hub (HR BI + AI assistant)

Employee Insight Hub (HR BI + AI assistant)
Code source privé

À propos de ce projet

An end-to-end HR business-intelligence platform. Python ETL loads HR sources into a PostgreSQL data warehouse (constellation schema built with dbt), orchestrated by Airflow. ML scripts predict attrition and workload, detect anomalies and segment employees. A Next.js dashboard shows the KPIs (with embedded Power BI), an ETL Studio designs and runs flows visually, and a LangGraph assistant answers HR questions through SQL tools.

Points clés

  • Verified run: 89 dbt tests passing, 297,953 rows loaded, full Airflow pipeline in 2 min 38 s
  • dbt warehouse: staging, intermediate, 9 dimensions/facts and 8 KPI marts (turnover, payroll, presence, training…)
  • LangGraph HR agent with tools for leaves, departments and presence, streamed answers and an eval test suite
  • Visual ETL Studio (React Flow): catalogue, connections, pipeline editor, runs and scheduling

Technologies utilisées

PythondbtAirflowPostgreSQLscikit-learnLangGraphFastAPINext.jsTypeScriptPower BIBetter AuthDocker

Captures d'écran

Employee Insight Hub (HR BI + AI assistant) · 2Employee Insight Hub (HR BI + AI assistant) · 3Employee Insight Hub (HR BI + AI assistant) · 4Employee Insight Hub (HR BI + AI assistant) · 5Employee Insight Hub (HR BI + AI assistant) · 6

Zied AI Assistant

Start a conversation

Ask me anything about Zied's skills, projects, or experience