Ammar
Dashboards & reporting · Google Sheets + Apps Script
Portfolio · 2026 · Karachi
Thirty dashboards.
Thirty dashboards.
One spreadsheet each.
This is the working portfolio of Ammar — I build business dashboards on Google Sheets and Apps Script, so a business keeps the spreadsheet it already uses and gets a proper screen on top of it. Every demo below is live and clickable: each trade has its own layout, its own measuring units and the six numbers that actually decide its week.
30Trades covered
112,183Sample rows
8Distinct layouts
0Licences needed
Ammar
Dashboards & reporting · Google Sheets + Apps Script
Karachi, Pakistan
Available for new work
Thirty industries, thirty different dashboards
Click any card — it opens the live demo in a new tab, with an industry switcher so you can jump between all 30. Every number comes from a generated spreadsheet of 18 months of trading.
Marketing & sales 3
01
Open live demo →
🎯
Digital Marketing Agency
Pipeline, retainers and cash collection for a growth agency Pipeline ValueActive RetainersMonthly RecurringCollected This MonthOverdue ReceivablesFollow-ups Due 1,250 rows · KPI grid Rs 112.4MPipeline Value
18
Open live demo →
👥
Recruitment Agency
Fill rate, time-to-fill and fees for a contingency recruiter Open RolesFill RateTime to FillFees · This MonthAverage Fee %Invoices Overdue 1,900 rows · Ledger Rs 4.4MFees · This Month
24
Open live demo →
🖨️
Printing Press · Offset
Impressions, waste and machine uptime for an offset press Impressions · MTDWasteMachine UptimeAverage Job ValueJobs in PrepressWork in Progress 826 rows · Ledger Rs 103KAverage Job ValueProperty & design 3
02
Open live demo →
🏠
Real Estate · Karachi
Listings, enquiries and commissions across a Karachi agency Active ListingsPortfolio ValueEnquiries (30d)Commission EarnedAvg Days on MarketAvg Commission / Deal 895 rows · Board Rs 8.19BPortfolio Value
11
Open live demo →
🏗️
Construction Contractor
Project margin, billing and receivables for a contractor Active ProjectsContract BacklogBilled This MonthReceivablesGross MarginOver-budget Projects 1,262 rows · Single column Rs 2.27BContract Backlog
28
Open live demo →
📐
Architecture & Design Studio
Billable utilisation, fees and WIP for a design studio Billable UtilisationFees Invoiced · MTDFee per sqftWork in ProgressReceivables OverdueCollection Days 3,176 rows · Headline KPI Rs 4.6MFees Invoiced · MTDRetail & food 5
04
Open live demo →
🛍️
Retail Boutique · E-commerce
Revenue, margin and repeat buyers for an online boutique RevenueOrdersAverage Order ValueGross MarginRepeat CustomersReturns & Refunds 3,230 rows · Ledger Rs 59.1MRevenue
05
Open live demo →
☕
Restaurant & Café
Daily sales, covers and prime cost for a café or restaurant Revenue (30d)Average CheckFood CostPrime CostDelivery ShareOperating Expenses 946 rows · Instrument strip Rs 7.2MRevenue (30d)
26
Open live demo →
🥖
Bakery & Confectionery
Baked weight, wastage and cake orders for a retail bakery Baked per DayWastageSell-throughCounter Revenue · 30dCake Orders OpenBaked Goods Value 3,078 rows · Daily charts + rail Rs 3.3MCounter Revenue · 30d
19
Open live demo →
💊
Community Pharmacy
Scripts, margins and stock cover for a high-street pharmacy Scripts per DayGross MarginStock CoverBelow ReorderExpiry Risk (90d)OTC Share 1,096 rows · Daily charts + rail Rs 90KExpiry Risk (90d)
21
Open live demo →
⛽
Fuel Station · Retail Pump
Litres, per-litre dealer margin and shop sales for a retail pump Litres per DayDealer MarginFuel Gross Profit · 30dShop Sales · 30dCredit OutstandingGross Profit · 30d 2,616 rows · Board Rs 10.3MFuel Gross Profit · 30dHealth & care 2
09
Open live demo →
🦷
Clinic · Dental
Production, collections and no-shows for a dental practice New Patients (30d)Appointments (30d)No-show RateProduction (30d)Collection RateAR over 90 days 3,082 rows · KPI grid Rs 8.2MProduction (30d)
29
Open live demo →
🐾
Veterinary Clinic
Consults, species mix and vaccination coverage for a vet clinic Consults per DayAverage BillVaccination UptakeReturning PatientsPharmacy StockUnpaid Visits 8,980 rows · KPI grid Rs 6KAverage BillEducation & people 2
03
Open live demo →
🎓
Coaching & Courses
Cohort revenue, attendance and completion for a coaching business Active StudentsCollected RevenueAttendance RateAvg Fee / StudentOutstanding FeesCompletion Rate 3,440 rows · KPI grid Rs 22.8MCollected Revenue
08
Open live demo →
🏫
School · Academy
Enrollment, fee collection and attendance for a school Enrolled StudentsFee CollectedCollection RateOutstanding ArrearsAttendance RateAvg Monthly Fee 5,612 rows · Scorecard Rs 43.1MFee CollectedFitness, beauty & events 3
07
Open live demo →
🏋️
Gym · Fitness Studio
Members, MRR and churn for a boutique fitness studio Active MembersMonthly RecurringMonthly ChurnVisits / Member / WeekRenewals Due (14d)Personal Training 6,880 rows · Headline KPI Rs 3.6MMonthly Recurring
06
Open live demo →
✂️
Salon · Spa · Aesthetics
Bookings, ticket size and rebooking for a salon or medspa Bookings (30d)Revenue (30d)Average TicketNo-show & CancelRebooking RateChair Utilisation 4,760 rows · Daily charts + rail Rs 4.7MRevenue (30d)
12
Open live demo →
📸
Event Photography Studio
Seasonal bookings, package value and delivery pipeline Events (30d)Revenue This YearAverage PackageBooked PipelinePending DeliveriesReferral Share 890 rows · Daily charts + rail Rs 50.3MRevenue This YearTravel & hospitality 2
10
Open live demo →
✈️
Travel Agency
Bookings, GMV and deposits for a travel agency Bookings (30d)Gross Booking ValueCommission EarnedAverage BookingCancellation RatePending Deposits 1,268 rows · Board Rs 545.1MGross Booking Value
16
Open live demo →
🛏️
Boutique Hotel · Islamabad
Occupancy, ADR and RevPAR for a 44-room boutique property Occupancy · 30 daysADRRevPARRoom Revenue · This MonthOutstanding FoliosAverage Length of Stay 5,504 rows · Headline KPI Rs 34KADRIndustrial & trades 5
17
Open live demo →
🏭
Manufacturing Plant · Plastics
OEE, scrap and downtime for a three-line moulding plant OEEAvailabilityPerformanceQualityGood Output · MTDValue Past Due 2,336 rows · Instrument strip Rs 58.5MValue Past Due
25
Open live demo →
👕
Garment Manufacturing Unit
Line efficiency, defects and on-time shipment for a garment unit Line EfficiencyDHURework RateOrder BookOn-time ShipmentPieces · 30 days 1,756 rows · Scorecard Rs 1.75BOrder Book
20
Open live demo →
🐔
Broiler Poultry Farm
FCR, mortality and live weight per flock cycle Feed Conversion (FCR)MortalityAverage Live WeightBirds in ShedFeed Cost / kg GainRealised Rate / kg 785 rows · Scorecard Rs 277Feed Cost / kg Gain
23
Open live demo →
🔧
Auto Workshop & Dealership
Job cards, bay utilisation and parts margin for a service centre Job Cards · MTDBay UtilisationAverage TicketParts MarginVehicles in WIPComeback Rate 10,300 rows · Instrument strip Rs 44KAverage Ticket
30
Open live demo →
☀️
Solar EPC Installer
kW installed, cost per watt and net-metering approvals kW Installed · MTDCost per WattAverage SystemPipelineNet-Metering PendingReceivable 1,250 rows · Board Rs 181MReceivableTechnology & services 5
13
Open live demo →
☁️
SaaS · Software
MRR, retention and support load for a software business MRRNet Revenue RetentionLogo Churn (30d)ARPAMRR Growth (12m)Open Tickets 2,820 rows · Headline KPI Rs 14.5MMRR
22
Open live demo →
🖥️
Managed IT Services · MSP
SLA adherence, first response and endpoint load for an MSP Open TicketsSLA AdherenceFirst Response (median)Avg ResolutionRecurring RevenueEndpoints per Engineer 14,356 rows · Single column Rs 22MRecurring Revenue
14
Open live demo →
🚚
Logistics & Freight
On-time performance, lane profitability and receivables Shipments (30d)On-Time DeliveryRevenue (30d)Cost per ShipmentReceivablesExceptions 2,470 rows · Scorecard Rs 17.6MRevenue (30d)
27
Open live demo →
📦
Courier · Last-Mile Delivery
On-time delivery, COD cash and cost per shipment Shipments · MTDOn-time DeliveryFailed AttemptsCOD in FloatCost per ShipmentOpen Complaints 12,448 rows · Single column Rs 472KCOD in Float
15
Open live demo →
⚖️
Law Firm
Utilisation, realisation and lockup for a law practice Billable Hours (30d)UtilisationRealisation RateCollection RateWIP (unbilled)Receivables 2,971 rows · Ledger Rs 11.6MWIP (unbilled)
About me
I'm Ammar, a dashboard developer in Karachi, Pakistan. Most small and mid-sized businesses in Pakistan already run on a spreadsheet — the register, the order book, the shift log — and most of the reporting pain comes from nobody turning that sheet into a screen the owner can read in ten seconds.
So I build exactly that: one Google Sheet as the database, one Apps Script backend, one HTML page. No Looker Studio licence, no connector fees, no per-seat pricing, and the owner can edit the logic in plain JavaScript afterwards. The 30 demos here are the proof — same codebase, completely different screens because a poultry farm and a law firm do not measure the same things.
- Discovery first. We pick the six numbers your week actually turns on, before any chart is drawn.
- Your sheet stays yours. Loose heading matching means "Invoice No", "Ref" and "Reference" all work.
- Delivered in about a week. Seeded demo first so you approve the screen, then pointed at your live tab.
How a project runs
1 · You pick a demo
Choose the closest trade from the 30 above. We swap the sample data for yours and adjust the six metrics until the first screen answers the question you ask every morning.
2 · I install it
Code.gs, SeedData.gs and Index.html go into your own
Google Sheet's Apps Script editor, deployed as a web app. It runs on your account, not mine.
3 · It updates itself
New rows appear on refresh — no rebuild, no export. You own the file, the sheet and the code, and I stay reachable for changes.