Management Intelligence System

Deputy CEO Executive Dashboard
Live ·

⏳ loading red flags…

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

🏦 Qnb-Turkey

Content to be designed together.

💼 InvestCorp

Content to be designed together.

💰 Wafra Invest.

Content to be designed together.

🏬 Commercial Real Estate

Content to be designed together.

tom Wellness App

Content to be designed together.

🗓️ Agenda

Loading…

🔄 Data Sources

Loading…

Settings — Data Storage where every type of data is stored

Settings — Staff MIS Control Hub → Staff table (name, email, division, status)

Dictionary Arabic → English · chart & label translations

📖 Dictionary

Loading…

🍽️ F&B

Loading…

🎢 Entertainment

Loading…

🚗 Cars Leasing

Content to be designed together.

⛰️ Salboukh

Content to be designed together.

🔌 Generators

Content to be designed together.

📜 Track Record

Content to be designed together.

⏳ loading…

⏳ loading…

⏳ loading…

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…

🏖️ LEAVE BALANCE⏳ loading…
Staff over 50-day balance
—
click to list
Staff tracked
—
vacation file
Vacation-days liability
—
all companies

⏳ loading live data…

📈 Over-50 balance — monthly trend (group)

💰 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

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 average by subject (/5) — strongest → weakest

Open ⚙ Staff sync to load appraisal data.

💪 Strengths

⚠️ Needs attention / training

📈 Team overall performance trend (%)

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