Power BI dashboard development in Dubai
Executive, finance, sales, operations and HR dashboards for Dubai and UAE businesses, built on a governed model so the numbers hold up before they are made to look good. Fixed price, quoted before work starts.
The dashboard is the last twenty per cent
A dashboard is the visible part of a much larger thing. Underneath it sits a data model that joins your systems, a set of measures that define what revenue, margin and on-time mean, and a refresh that runs every morning without anyone clicking export. The visuals are the last twenty per cent of the work, and they are only trustworthy because of the eighty per cent nobody sees.
We build both. If you already have a governed model, we build on it. If you do not, the dashboard project includes the model, because a dashboard drawn over a spreadsheet extract is a screenshot that goes out of date. This page explains what we build, the rules we apply, what drives the price, and lets you open working demos before you speak to anyone.
Dashboard or report? (and why it matters for the quote)
The words are used interchangeably, but in Power BI they are different objects and they cost different amounts to build well.
A report is a set of pages built on a semantic model. It is interactive: filters, drill-down from a total to the transactions behind it, cross-highlighting between visuals, bookmarks that switch a page between views. Almost everything we build is a report in this sense, and when a client says dashboard they usually mean a report with a summary page at the front.
A Power BI dashboard, strictly, is a single canvas of pinned tiles from one or more reports, with no page structure and limited interaction. It suits a wall screen or a phone glance. It does not suit a monthly review. We build them when a client wants a single glanceable surface, and we say so in the scope, because the effort is small and the interaction is limited.
Mobile layouts are a third thing: a phone-shaped arrangement of a report page, built separately for each page that needs one. Field staff in logistics, property and hospitality use them constantly, so they are scoped as their own line, not assumed.
The quote lists pages and mobile layouts separately for this reason. Ten interactive pages with drill-through is a different job from three summary pages and a phone view.
Dashboards we build
Five families cover most of what a UAE business asks for. Each KPI below carries its definition, because a name without a definition is where reporting arguments start. Every family carries entity and emirate dimensions by default, and every AED figure is shown in the same unit across the report.
Executive and board
One page the leadership team opens on Sunday morning, with the month, the year to date and the comparable period, by entity.
- Revenue: invoiced sales net of VAT and credit notes, in AED, by entity, emirate and month, with the comparable period adjusted for Ramadan and Eid timing.
- Gross margin: revenue less cost of sales, where cost of sales includes landed cost (freight, duty and clearing) for trading businesses, shown as AED and as a percentage of revenue.
- Cash: closing bank balances by entity and currency, converted to AED at the month-end rate, alongside post-dated cheques on hand by maturity month.
- Working capital: receivables plus stock less payables, with days sales outstanding, days inventory and days payable each defined from the same ledger balances.
- Headcount: active employees at month end by entity, department and nationality band, with joiners and leavers in the month.
Finance and FP&A
The month-end pack, refreshed from the ledger rather than rebuilt from it.
- P&L versus budget: actuals from the general ledger mapped to the same account groups as the budget file, with variance in AED and percentage, by entity and cost centre.
- AR ageing including PDC ageing: open invoices bucketed by days past due, with post-dated cheques shown as a separate schedule by maturity date so the two are never mixed.
- AP ageing: open supplier invoices by due date and currency, with the AED equivalent at the booking rate and at the current rate.
- Cash forecast: opening cash plus expected receipts (including PDCs maturing) less scheduled payments, by week, for thirteen weeks.
- VAT payable by return period: output VAT less recoverable input VAT for each return period, by entity, built so the figure can be reconciled to the return filed with the Federal Tax Authority. We are not tax agents; the dashboard shows what the ledger says, and your tax adviser confirms what is filed.
Sales
Pipeline and price, by channel, salesperson and emirate.
- Pipeline: open opportunities by stage, with weighted value (stage probability multiplied by amount) and age in stage.
- Conversion: opportunities won divided by opportunities closed in the period, by source and by salesperson.
- Price realisation: actual invoiced price divided by list price, by product and customer, so discounting is visible rather than buried in margin.
- Sales by channel and emirate: invoiced revenue split by direct, distributor, marketplace and store, and by the emirate of delivery.
Operations
Throughput, service and utilisation on the same list of jobs that finance invoices.
- Throughput: units, orders or shipments completed per day and per shift, against capacity.
- OTIF: orders delivered on the agreed date and in full, divided by all orders due, with the two failure modes shown separately.
- Utilisation: productive hours divided by available hours for fleet, machines or staff, with idle time as its own measure rather than the remainder.
- The logistics analytics Dubai and retail analytics Dubai pages carry the sector-specific versions of these measures, and the hospitality analytics Dubai and real estate analytics Dubai pages the equivalents for hotels, restaurants, developers and landlords.
HR
People measures from the HR system and the payroll file, not from a headcount spreadsheet.
- Headcount and cost: active staff and total employment cost by entity and department, reconciled to the WPS payroll file total for the month.
- Attrition: leavers in the period divided by average headcount, annualised, with voluntary and involuntary shown separately.
- Emiratisation ratio tracking: UAE nationals as a share of the relevant workforce, tracked against the organisation’s own target. This is an explanatory measure built to your definition; the regulatory position is yours and your adviser’s to confirm.
Design rules we apply
These rules are written down before the first page is built and applied to every page after it. They are not a house style; they are what stops a dashboard becoming a wall of charts.
- One question per page. A page answers a question a named audience asks, and the title says which question. If a page needs a legend to explain what it is for, it is two pages.
- Comparable-period logic that knows the calendar. The date table carries Ramadan, Eid al-Fitr, Eid al-Adha and the summer trough as attributes, so a month-on-month comparison can be shifted or flagged, and a hotel or restaurant is not congratulated for a July that was simply less bad than June.
- Consistent number formats. AED in thousands or millions, chosen once per report and never mixed on a page; percentages to one decimal; dates in a single format.
- Colour for meaning only. One colour marks a variance that needs attention; everything else is neutral. No colour is spent on decoration.
- RLS-aware navigation. A user who can see one entity does not see a page full of blanks for the others; the navigation and the visuals respect the security rule.
- Bilingual labels where required. Power BI’s right-to-left support is limited — text direction is supported in some visuals, but the report canvas does not mirror — so where Arabic labels are needed we build display fields in the model and design pages that read correctly in both, and we say plainly what the tool cannot do.
Open the demos
Each demo below is a working Power BI-style layout you can open now; they exist so you can judge the design rules above on a screen rather than in a paragraph.
Logistics and supply chain demo
cost per shipment, OTIF and fleet utilisation by lane. Look for the drill from a customer to the shipments behind a margin figure.
Open the demoReal estate demo
portfolio occupancy, rent roll and collections against plan. Look for the drill from portfolio to building to unit.
Open the demoHospitality demo
occupancy, ADR and RevPAR alongside outlet covers and average cheque. Look for the comparable-period toggle handling the Ramadan shift.
Open the demoRetail and trading demo
margin after landed cost, stock ageing and PDC exposure by customer. Look for the like-for-like toggle and the currency selector.
Open the demoFinance demo
P&L versus budget, AR ageing and a thirteen-week cash view by entity. Look for the entity selector respecting row-level security.
Open the demoHow a dashboard project runs
For a single-department dashboard on one or two sources, the project runs as a sequence of short steps with a review after each. The steps are fixed; the duration of each is written into your scope.
- Requirements and sketch: we agree the questions each page answers and sketch the pages on paper or in a wireframe before anything is built.
- Model: connections, star schema, date table, measures from the agreed definitions, security rules.
- First build: every page built to the sketch, with real data, released to a test workspace.
- Review: the intended users of each page use it for a week and record what is missing, wrong or unclear.
- Refinements: the review list is worked through and the design decisions recorded.
- Acceptance: totals reconciled to the source system for an agreed period; sign-off in writing.
- Training: an owner workshop on the model, a reader briefing for everyone else, and the documentation handed over. The Power BI consulting services Dubai page describes the longer, multi-department version of the same sequence.
Will your team be able to maintain it?
Yes, and the project is designed so that this is true rather than hoped for. Every measure is recorded in a measure dictionary with its definition and its DAX. Every page has a one-page guide. The runbook lists the tasks an owner does each month: check the refresh, add a user, change a security rule, add a measure. The owner workshop, described on the corporate Power BI training Dubai page, is included in every build and runs on your own model, not a sample file.
If you would rather not run it yourselves, the Power BI managed services UAE page describes a fixed monthly fee under which we keep the estate refreshing, fix source changes and make agreed monthly changes. If you would rather hire someone to hold it, the Power BI developer Dubai page explains what to look for.
Two articles go further: CFO dashboards in Power BI on what a finance leadership page should carry, and Automating board reporting with Power BI on replacing the monthly pack. When you are ready, Get started — four quick questions books the first call.
The other services
Six services, one pricing method. Most engagements use one or two of them together.
Power BI Consulting Services Dubai
Power BI consulting services in Dubai
Open the service pageCorporate Power BI Training Dubai
Corporate Power BI training in Dubai, run on your own data
Open the service pagePower BI Managed Services UAE
Power BI managed services for the UAE
Open the service pageExcel Reporting Automation Dubai
Excel reporting automation in Dubai
Open the service pagePower BI Performance Optimisation
Power BI performance optimisation — and when to rebuild instead
Open the service pagePower BI Dashboard Development Dubai — questions people ask
How much does a Power BI dashboard cost in Dubai?
How long does it take to build a dashboard?
What is the difference between a dashboard and a report?
Do you build the data model or just the visuals?
Does it work on mobile?
Can we have Arabic labels?
When should we consider a dashboard project?
Will our team be able to maintain it?
How much does a Power BI dashboard cost in Dubai?
The method is published alongside the numbers, because what drives a figure matters as much as the figure. The diagnostic is a fixed price; a build is quoted against a written scope.
The price of a dashboard is driven by six things, and none of them is the number of charts. They are the number and type of sources; whether a governed model already exists or has to be built; the number of pages and the interaction on each; the number of mobile layouts; the entities, branches and roles that security must separate; and whether Arabic display labels are in scope. A dashboard on an existing model with three pages is a small job. A dashboard that needs a model built across Tally, a warehouse system and a dispatch spreadsheet, with row-level security across four entities, is a larger one, and the price reflects the model far more than the visuals.
A dashboard build starts at AED 15,500, and most fall between AED 15,500 to AED 62,000, depending on where they sit against those six drivers. A three-page report on a model that already exists is at the lower end. A build that has to create the model across several systems, with row-level security separating four entities and Arabic labels in scope, is at the upper. Those are anchors for a conversation, not a quote: the figure for your dashboard is fixed in writing once we have seen your sources.
A short discovery call, no charge
Thirty minutes on GST hours, and a look at your current reports and the systems behind them. We tell you the smallest practical next step, even if it is smaller than you expected.
A written scope
Sources, the model, pages and visuals, users and their security, training and handover, written down. If it is not in the scope, it is not in the quote.
A fixed quote against that scope
One number in writing. The quote is the price; there is no hourly rate underneath it to drift.
Inside scope is our cost; outside scope is quoted first
If we find something worse than expected inside the scope, that is our cost. If you want something outside it, we quote it separately before doing it, and you decide.
Payment stages
Agreed in the scope document, in writing, before work starts.
What it costs
The reporting diagnostic is a fixed AED 4,950. That is the whole amount. Nothing is added at checkout. Builds are quoted rather than sold from a page: they start at AED 15,500, and most land in the AED 15,500 to AED 62,000 range once the sources, the state of the data, the pages and the training are known. The figure in your written quote is the price.
What the scope itemises for this service
Ready to find out what this would take for your business?
Four quick questions tell us the systems you run, the reports you assemble by hand and who reads them. From there, a 30-minute call, no charge, and a written scope if it makes sense to go further.