Sep 2026 - Oct 2026
Employee Insight Hub (HR BI + AI assistant)

الشيفرة المصدرية خاصة
حول هذا المشروع
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.
أبرز النقاط
- 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
التقنيات المستخدمة
PythondbtAirflowPostgreSQLscikit-learnLangGraphFastAPINext.jsTypeScriptPower BIBetter AuthDocker




