GovernmentInternal operational system

Dhabt

Certified executive dashboards for building-inspection data

Context

Leadership in the building-inspection sector makes decisions based on reports arriving as ever-changing Excel files — no documented source for any figure, and no way to return to a previously approved version.

Problem

Leaders need reliable numbers on building supervision requests, but the data arrives in changing Excel files with no clear history.

Solution

A system that imports and checks Excel files, then saves every approved version with its date. It shows key numbers in a leadership dashboard and includes a meeting view, a printable summary, and a record of every change.

Highlights

  • Saved versions with the ability to return to the last approved one
  • A meeting view and a summary printed from the browser
  • A record showing every important action and who performed it

Implementation

  1. 1

    Check files before accepting them

    The system checks the Excel file's structure and values before import and shows a clear reason when it finds a problem.

  2. 2

    Save every approved version

    Each approved file is stored as a separate dated version, so meeting participants know where the numbers came from and can return to an earlier version.

  3. 3

    Present information clearly to leaders

    The dashboard shows key numbers and sectors, with a full-screen meeting mode and a one-page summary that can be printed.

  4. 4

    Record every important change

    The system records who imported a file, who approved it, and when the team returned to an earlier version.

Stack

Next.js 16PrismaPostgreSQLDockerRecharts

Results & numbers

100%
of important actions recorded in the change history
1
approved data version for each leadership meeting
A4
executive summary printed straight from the browser