Power BI developer in Dubai — build to a fixed scope
This page is for businesses that need Power BI built. If you are looking for a Power BI developer job, we are not advertising one.
Oakwood Group builds Power BI for organisations across Dubai and the UAE: the data model, the Power Query transforms, the DAX measures, the report pages and the deployment, delivered into your own Microsoft tenant against a written scope and a fixed quote. The quote is the price. Work is delivered remotely, working hours 7am–7pm GST, seven days. Delivered in partnership with Roar Data, an Australian Power BI consultancy.
Developer, consultant or analyst — who do you actually need?
The words are used interchangeably in job adverts. They are different jobs, and buying the wrong one is the usual reason a Power BI project produces a report nobody uses.
| Role | What they do | What you get |
|---|---|---|
| Power BI developer | Builds the model, Power Query, DAX, row-level security and deployment. | A working, documented report set in your workspace, refreshing on a schedule. |
| Power BI consultant | Requirements, KPI definitions, architecture, governance, training. | Agreed definitions, a design, a plan and owners who can run it. |
| Data analyst | Uses the finished model to answer business questions. | Analysis, findings and ad hoc reports; not a new model. |
| Managed service | Keeps it running: refresh monitoring, break-fix, small changes, access. | Reports that stay correct and available after the build ends. |
Which one you need usually shows in how you describe the problem.
| If you are saying | You probably need |
|---|---|
| “We know the KPIs. We need it built.” | A developer, on a fixed scope. This page. |
| “We do not agree on the numbers.” | A consultant first, then a developer. Building before definitions are agreed produces an accurate report of a disagreement. |
| “The reports exist, but nobody has time to interrogate them.” | An analyst, or training so your own people can be one. |
| “It works. We need someone to look after it.” | A managed service, with a change budget rather than a build budget. |
We do the developer and consultant jobs, and we say which one you are buying. If a build needs definitions agreed first, we quote a short Power BI consulting in Dubai step before it, rather than folding it into the build and hoping.
What our developer delivers
A fixed-scope build ships as a set of named deliverables, all of them in your tenant. The scope for your build names each one so nothing is assumed.
Not included by default: a data warehouse build, ERP changes, master-data cleansing in the source system, or a training programme. Each has its own scope. Design-led builds sit under Power BI dashboard development; taking over a slow or fragile setup sits under Power BI performance optimisation.
Fixed scope versus hourly
Most Power BI development in the UAE is sold by the hour. The incentives are wrong for a build: the developer is paid more when the work takes longer, and the client carries every unknown, from the source with no clean key to the refresh that fails on the gateway. Estimates drift because nothing forces anyone to find those problems before the clock starts.
A fixed quote forces us to find them. We cannot price a build without opening your sample exports, counting the pages in the report you want replaced and asking how many entities and roles the security has to handle. That reading is unpaid, and it moves the estimating risk from you to us. It also forces a written definition of finished: an hourly engagement ends when the budget does; a fixed-scope build ends when every page meets its definition of done and your numbers reconcile.
What to send us to get a quote in a week
Six things. With all six we can usually return a written scope and a fixed quote within a week; with three or four we will ask questions first.
A list of your data sources, with versions
For example: TallyPrime 3, Zoho Books, SAP Business One on SQL Server, a SharePoint folder of Excel files. The version decides how we connect and whether a gateway is needed.
One exported sample per source
A trial balance, a sales register, a stock list. It need not be complete or current; anonymise it if you need to. Column names, grain and data quality are where most of the estimating risk sits.
The report you want replaced
Screenshots or a PDF of the current management pack or Excel dashboard. Circle the numbers people argue about. Its pages become the page list in the scope.
User count and roles
How many people will open the reports, and which of them should see only their entity, branch or cost centre. This sets the row-level security design and the licence count.
Licence status
Whether you already have Power BI Pro, Premium Per User or a Fabric capacity, and which Microsoft 365 tenant the reports should live in.
The deadline, and what is driving it
A board meeting, a year end, an auditor request, a system go-live. A real date lets us build the part you need first, first.
How development runs
A build is a series of visible weekly increments in your own workspace, not a delivery at the end.
Weekly builds in a shared workspace
Review checkpoints
Definition of done
Acceptance test on your numbers
Technical standards we build to
Written into every scope. They are the difference between a model the next person can maintain and one they have to rebuild.
| Standard | What we do |
|---|---|
| Naming | Business names on every table, column and measure. No tbl_, no SUM_of_Amount2. Technical columns hidden from the report view. |
| Model documentation | A model diagram, a table of sources and grain, and a measure dictionary. Descriptions stored inside the model so they show as tooltips. |
| Measures folder | Measures in a dedicated table, grouped into display folders by subject, with base measures separated from time-intelligence variants so a change is made once. |
| Calculation groups | Used where many measures share the same time variants (MTD, YTD, prior year). Not used on small models, where they add complexity for no gain. |
| Incremental refresh | Set up for large fact tables (transaction lines, stock movements, GL entries) so a refresh loads the recent period rather than the whole history. |
| Gateway design | For on-premises sources such as TallyPrime, SAP Business One on SQL Server or a file share: a data gateway on a server you control, a documented service account, and a refresh schedule that avoids busy hours. |
| Multi-entity model | An entity dimension from day one, even with one entity today. Mainland and free-zone companies, branches and cost centres slot in without a rebuild; row-level security keys off the same dimension. |
| Performance targets | A page-load target written into the scope and measured on the capacity or licence you actually have. Where a source cannot meet it, we say so before building. |
| Version control | Power BI Project (PBIP) files in a Git repository where your tenant allows it, so every model change is diffable and reversible. Otherwise, versioned PBIX files in a controlled library. |
| Display labels | Arabic display names can sit alongside English where the audience needs them. Power BI’s right-to-left support is limited: text direction works in some visuals, but the report canvas does not mirror. We say so up front. |
Embedding Power BI in your portal or app
We build the embed token service, the security model and the reports as one scope. The licensing options behind it are set out on our Power BI in Dubai page.
Power BI reports can be shown inside your own web application or customer portal rather than in the Power BI service. There are two models, and who is looking decides between them. With user owns data, the viewer signs in with their own Microsoft account and licence and sees what their permissions allow; this suits staff portals. With app owns data, your application authenticates on the viewer’s behalf, the viewers need no licence, and row-level security decides what each one sees; this suits customers, tenants, franchisees or suppliers. App-owns-data embedding for external users needs a Fabric capacity (an F-SKU), and the capacity size is part of the scope because it sets both the cost and the performance ceiling.
See the standard of work
The fastest way to judge a developer is to open something they built.
The logistics demo is built the way this page describes: a star-schema model, a measure library and a page per question. Look at how the shipment and cost measures keep their definitions as you filter by lane, customer or period; at the drill from network totals to individual consignments; and at the page load, which a screenshot cannot show you.
Power BI developer Dubai — questions buyers ask
Plain answers to the questions we are asked before a build is scoped.
What does a Power BI developer do?
Do you build the data model or just the visuals?
What is DAX and why does it matter?
Can you embed Power BI in our app or customer portal?
Can you work inside our Microsoft tenant?
How is a fixed scope priced?
Can you take over reports built by a previous developer?
Related reading: When an existing Power BI setup should be rebuilt, not patched.
How fixed pricing works
The method comes first because it is what moves the number. The diagnostic is a fixed price; a build is quoted against a written scope.
A short discovery call, no charge
Thirty minutes on what you need built, and a look at your current reports and systems.
A written scope
Sources, model, pages and visuals, users, security, training and handover, each named.
A fixed quote against that scope
The quote is the price. It does not move because a source was harder than it looked.
Inside scope is our cost; outside scope is quoted first
Something worse than expected inside the scope is ours to absorb. Something outside the scope is quoted separately before we do it.
Payment stages
Agreed in the scope document before work starts.
The reporting diagnostic is a fixed AED 4,950. That is the whole amount. Nothing is added at checkout. It buys a review of the reports and systems you already have, written up as what to fix first.
Development itself is quoted, not bought from a page. Builds start at AED 15,500 and most land in the AED 15,500 to AED 62,000 range, set by the number of sources, whether a governed model exists or has to be built, the pages and security roles involved and how many people are trained. Send the six checklist items above and the quote comes back against your scope, not against a range.
Need Power BI built in Dubai?
Answer four quick questions and book a time, or send the six checklist items and we will come back with a written scope and a fixed quote.