Management Intelligence System

Deputy CEO Executive Dashboard
Live ·

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

Dictionary Arabic → English · chart & label translations

📖 Dictionary

Loading…

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.

Media to be defined

📣 Media

Content to be designed together.

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

Licenses EXPIRED
tracked only
Licenses due soon
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.

🏢 Licenses by company — by status

⏳ loading…

Personnel live · monthly snapshots

🏖️ LEAVE BALANCE👆 click any card or bar for details⏳ loading…
Staff over 50-day balance
click to list
Staff tracked
vacation file
Vacation-days liability
all companies

🏢 Staff over 50 days — by company

⏳ loading live data…

📈 Over-50 balance — monthly trend

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.

+ Add directive → created in Airtable & emailed to assignee → they mark Done → shows as Submitted for your Approve / Reject (only your approval completes it).

📋 All directives

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