The Workforce Analytics Dashboard is a fully responsive, cloud-hosted analytics platform that enables organizations to monitor, analyze, and optimize their workforce data through interactive KPIs, visualizations, and CRUD (create, read, update, delete) operations. This full-stack project was built to demonstrate my applied skills in software engineering, cloud deployment, multi-tier architecture, and modern development lifecycles. Fully deployed and accessible live via Azure App Services.
| Layer | Tech Used |
|---|---|
| Frontend | ASP.NET Core MVC, Bootstrap 5 |
| Backend | ASP.NET Core 8 ( C# ), Entity Framework Core |
| Database | PostgreSQL (Hosted on Railway) |
| Hosting | Azure App Service |
| DevOps | Azure DevOps, GitHub Projects |
| Deployment | CI/CD Pipeline via GitHub Actions |
| Version Control | Git, GitHub |
| Architecture | Classic 3-Tier MVC (Model/View/Controller) |
✅ Full CRUD operations for employee management
✅ KPI dashboards with calculated business metrics (e.g. turnover rate, tenure, average salary)
✅ Dynamic filtering, sorting, and XML exporting
✅ Responsive UI for mobile & desktop
✅ Live production deployment on Azure with CI/CD pipelines
✅ Full SDLC project board for transparent software lifecycle management
✅ PostgreSQL relational database integration
✅ Modular and scalable backend API structure
🌐 Access the Live Dashboard here
Fully functional live version with CRUD functionality enabled for demo purposes.
📅 View full project development board on GitHub Projects
Includes all tracked SDLC phases:
Clone, build, and run the project locally to explore the full source code.
- .NET 8 SDK
- Visual Studio 2022 (with ASP.NET & web development workload)
- PostgreSQL (local instance or cloud-hosted)
- Railway account (optional for managed DB)
git clone https://github.com/adampodolak/workforce-analytics-dashboard.gitcd workforce-analytics-dashboard🔑 Configure Database Connection 1️⃣ Create a local or cloud PostgreSQL database. 2️⃣ Update the connection string inside appsettings.json:
{
"ConnectionStrings": {
"DefaultConnection": "Host=your_host;Port=5432;Database=your_db;Username=your_user;Password=your_password"
}
}For production deployment, connection strings are injected via Azure App Service configurations.
🏗️ Apply EF Core Migrations
dotnet ef database update(Ensure EF Core tools are installed: dotnet tool install --global dotnet-ef)
🚀 Run the Application
dotnet runThe app will launch at: https://localhost:5001/
This project demonstrates hands-on experience with full-stack .NET development, cloud deployment pipelines, SQL database design, and practical application of SDLC methodologies.