Product // Project Management

ReqWise

A project management system tailored for construction teams and complex organizations.

BACK_TO_PROJECTS() OPEN_DEMO_UI()
FEATURES
RBAC, teams, projects, checklists
BACKEND
SQLite or Neon Postgres
UX
Dashboard, tables, activity log

Introduction

ReqWise brings together projects, teams, and detailed checklists with role-based access to keep delivery predictable and auditable.

Objectives

  • Give managers a clear, high-level view of projects and workload.
  • Enable team leads to organize tasks and checklists across projects.
  • Let members focus on assigned items and progress updates.

Initial Data Review

Core Entities

  • Users and roles: manager, lead, member
  • Teams and project-team links
  • Projects with milestones and checklists
  • Checklist items with status and assignees
  • Activity log for important events

Demo Dataset

The demo ships with a seeded construction company (80+ people, multiple divisions) so you can explore realistic scenarios immediately.

First Steps

After installing dependencies and setting up the database, I seeded the Hudson Valley Construction Co. dataset and verified access levels across roles.

Observations

  • Managers see all projects and teams; leads see their teams and linked projects.
  • Checklist progress becomes a quick proxy for project health.
  • Activity logs provide a lightweight audit trail.

User Interface

The UI focuses on clarity and speed: a dashboard for top-level metrics and tables for projects, teams, and tasks.

ReqWise Dashboard (Projects) ReqWise Checklists

Architecture

The backend is built with FastAPI and SQLAlchemy (SQLite/Neon Postgres). A Streamlit UI is included for rapid iteration and demos, plus a static read-only UI for quick embedding.

  • API: FastAPI + SQLAlchemy
  • UI: Streamlit (interactive) and static HTML (read-only demo)
  • Auth: simple local auth with roles for the demo

Results & Next Steps

The demo provides a complete tour of project/teams/checklists with realistic sample data. Next steps include richer reporting, Gantt-style timelines, and more granular permissions.

  • Enhance analytics and exports
  • Add timeline views and dependencies
  • Refine per-project RBAC and invitations