Live local analytics · no page reload
EXECUTIVE ANALYTICS · AUGUST 2026

Integrated Service Activity Dashboard

Visits, pharmacy, laboratory, referrals and dental/other orders — analyzed together while preserving each source's definition.

Period: 01–31 Aug 2026Monthly visits: 2,689Detailed attended encounters: 2,602Privacy: aggregated / hashed patient tokens

Daily attended encounters

Detailed CMO source · current filters

Executive insights

Calculated from current filtered data

Clinic mix

Where attended activity is concentrated

Provider workload

Detailed attended encounters by practitioner

Weekday × hour pressure

Attended encounters by scheduled start time

Management recommendations

Evidence-linked review points, not assumed causes

Monthly appointment no-show summary

Separate monthly summary source; not inferred from attended-only CMO rows

Visit type mix

Detailed attended encounters

Practitioner no-show comparison

Clinic → specialty → practitioner · reconciled from the three monthly visit reports

All medicine items

Complete order-line frequency · current filters

Dispensing status

Line-level status distribution

August chronic-patient census

Unique patients across the full August pharmacy report · not affected by dashboard filters

Monthly patient counts use unique Patient ID across all Chronic = Y pharmacy lines. Diabetes / hypertension grouping is medication-based because the pharmacy source does not contain a diagnosis field. A patient receiving both recognized diabetes and hypertension therapies is counted once in the combined group, not again in either single-disease group.

Chronic medication profile

Patient-level segmentation from chronic-flagged pharmacy lines · medication-based classification

Chronic groupPatientsShareLinesQuantity
Classification is derived from chronic-flagged medicines, not from a diagnosis field: diabetes-only = recognized antidiabetic therapy without recognized antihypertensive therapy; hypertension-only = the reverse; both = both therapy groups; other chronic = chronic medicines outside those two recognized groups.

All chronic medicines

Complete chronic medicine list · current filters

Chronic patients by clinic

Unique chronic-medication patients · current filters

Chronic pharmacy activity by practitioner

Chronic order lines · all practitioners

Chronic dispensing status

Dispensing completion for chronic lines

Medication summary report cross-check

Separate HTML-exported XLS summary; retained for reconciliation

The source reports Cost Price far above Selling Price. This is likely a field-definition, unit, or export issue; margin is therefore not calculated.

All laboratory tests

Complete order-line frequency · current filters

Laboratory status

Resulted vs in-process / ordered

Referral destination specialty

Most frequent referred specialties

Referral destination facility

Concentration by receiving facility

Referral appointment status

Visited, yet to visit, cancelled and no-show

Dental / other procedures

All completed treatment/procedure orders

Procedure workload

Orders by practitioner

Data quality & methodology

What was used, excluded, and not assumed

By Dr. Ehab Diab / Technical Support Officer at Bahr El-Baqar Al-Qadima Family Medicine Center
بواسطة د. ايهاب دياب / مسئول الدعم الفنى فى مركز طب اسرة بحر البقر القديمة