Management Intelligence System

Deputy CEO Executive Dashboard
Live · 19 Jun 2026

Management Intelligence System

Executive Report
Government Relations & HR
Prepared for Ashraf Hallal — Deputy CEO
Confidential — generated from live MIS data

Executive Overview to be defined

⭐ Executive Level

This is your top-level executive view. We'll design its content together — e.g., company-wide KPIs, cross-department rollups, alerts summary, and the metrics you most want at a glance.

Investments to be defined

💼 Investments

Content to be designed together.

B.D.D Business Development & Diversification

Agenda Microsoft To Do · synced via Make.com

🗓️ Agenda

Loading…

Updates auto-sync status · Excel → Airtable (cloud)

🔄 Updates

Loading…

Settings — Data Sources where every type of data is stored

F&B — Concepts Analysis live · editable by year

🍽️ F&B

Loading…

Entertainment — Concepts Analysis live · editable by year

🎢 Entertainment

Loading…

Cars Leasing to be defined

🚗 Cars Leasing

Content to be designed together.

Salboukh to be defined

⛰️ Salboukh

Content to be designed together.

Generators to be defined

🔌 Generators

Content to be designed together.

Track Record to be defined

📜 Track Record

Content to be designed together.

GR / Government Relations 👆 click any card or bar for details

Licenses EXPIRED
—
tracked only
Licenses due ≤ 90 days
—
tracked only
Licenses tracked
—
loading…
Cancelled (history)
—
not tracked
Total licenses
—
all records

📄 License status

⏰ Renewal pipeline

📅
Tracked renewals only — live

The cards above pull live from the License Renewal Hub and count Tracked licenses only — cancelled and not-tracked ones are excluded. Click to open the due-soon list.

Personnel preview — figures from Excel, pending live import

ℹ️
Tab scaffolded — ready to go live

These KPIs are read from the Personnel Excel files in Dropbox. Once we run the Personnel importers (Phase 2), this tab refreshes automatically like GR.

Vacation: staff over 50-day balance
310
194 TCC · 94 Eureka
Monthly payroll (May 2026)
KD 553,069
variance watch ±5%
Loan portfolio remaining
KD 862,383
40 dead loans
OT exceeding policy
KD 162,244
period total
Staff tracked (vacation)
1,639
40-month trend

Planned Personnel modules

📦 From existing Excel files

  • Vacation Balance Monitor — alert >50-day balances → dept head
  • Payroll Intelligence — month-on-month variance >5%
  • Loan Portfolio Manager — flag termination with open loan
  • OT & Shift Control — project OT >15% of salary
  • Performance Appraisal Engine — feeds the Staff Performance tab

🔌 How this tab activates

1. Personnel files already sit in 03-HR-Intelligence/02-Personnel/
2. Run the Personnel importers → Airtable bases
3. Make.com snapshot feeds these cards live
4. Charts mirror what's in the Excel sheets

Finance

💰 Finance department — not yet activated

This is how every new department joins the system. The dashboard is modular — adding a department is a drop-in, no rebuild.

1 · Add folder
Create 03-Finance/ in Dropbox + Uploads
2 · Build base
Airtable base from the Excel files
3 · This tab fills
KPIs + charts mirror the sheets

Staff Performance Review live · appraisal history 2014–2024

📈
Historical appraisal data loaded — the baseline we build on

Annual appraisal scores (2014–2024) for all HR/GR staff are below, straight from the appraisal workbook. System KPIs (task completion, on-time %, resolution speed, escalations) layer on top automatically as the Tasks engine runs.

Grouped by division. Click a row for full year-by-year history · click the status to mark a person Active / Services ended.

KPI definitions (proposed)

⚙️ System-tracked (automatic)

  • Task completion rate — closed ÷ assigned
  • On-time % — closed by due date
  • Avg resolution time — assign → done
  • Escalations triggered — items breaching threshold
  • Responsiveness — time to first action

📝 Manual / appraisal

  • Annual appraisal score (existing 10-yr history)
  • Quality rating on corrective actions
  • Deputy-CEO discretionary score

Team Analysis strengths & training needs across all active staff

📊 Team average by subject (/5) — strongest → weakest

Open ⚙ Staff sync to load appraisal data.

💪 Strengths

⚠️ Needs attention / training

📈 Team overall performance trend (%)

Tasks & Directives your instructions, auto-assigned & tracked

🔔 Awaiting your review

Click ⚙ Staff sync (top) and paste your token to load tasks staff have submitted for approval.

✅
How directives flow

Open any detail view → ＋ Add directive → it's created in Airtable and emailed to the assignee. When they click Done, it appears above as Submitted for your Approve / Reject — only your approval marks it truly complete.

📋 All directives

Click ⚙ Staff sync (top) to load directives from Airtable.

＋ Assign a directive