📊 Workforce Analytics Dashboard

---

🚀 Summary

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.

---

🛠 Tech Stack

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)

---

🎯 Key Features

✅ 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

---

📈 Live Demo

🌐 Access the Live Dashboard here
Fully functional live version with CRUD functionality enabled for demo purposes.

---

🗂️ Full Project Board (SDLC)

📅 View full project development board on GitHub Projects
Includes all tracked SDLC phases:

---

🏗️ Architecture Overview

---

🖥️ Installation & Local Development

Clone, build, and run the project locally to explore the full source code.

⚙️ Prerequisites

• .NET 8 SDK
• Visual Studio 2022 (with ASP.NET & web development workload)
• PostgreSQL (local instance or cloud-hosted)
• Railway account (optional for managed DB)

🔧 Clone Repository

git clone https://github.com/adampodolak/workforce-analytics-dashboard.git

cd 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 run

The 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.