Workforce Analytics Dashboard

A full-stack .NET web application simulating an HR dashboard with actionable insights into workforce trends using real-time KPIs and visualizations. Structured for future integration with enterprise tools and reporting workflows (e.g., Oracle HCM and OTBI).

👥 Employees Page

A sortable, filterable employee directory built with ASP.NET Core MVC and server-side SQL logic using Entity Framework. Each employee record supports XML export.

📊 Analytics Page

Displays workforce metrics such as average salary, turnover rate, and most common roles using KPI cards and interactive charts. This view emulates operational dashboards found in enterprise platforms like Oracle OTBI.

🛠️ Technologies Used

  • ASP.NET Core MVC with Razor Pages (C#)
  • SQL Server with Entity Framework Core (connected via Railway PostgreSQL)
  • Chart.js for data visualization
  • Bootstrap 5 for responsive UI
  • XML exporting
  • Deployed via Microsoft Azure Web App Services
  • CI/CD pipelines implemented using GitHub Actions
  • Agile development simulated with GitHub Projects and issue tracking

This project demonstrates hands-on experience with full-stack development, data querying, export formatting, and UI reporting — aligning with real-world enterprise workflows and development practices.