Skip to main content
Dubai · Power BI · Direct Lake

The dashboards your Operations Director
actually opens.

Power BI consultant in Dubai for mid-market manufacturers, FMCG distributors selling into Lulu and Carrefour, and JAFZA / KIZAD 3PLs. Direct Lake, governed semantic models, Power BI Copilot, RLS, deployment pipelines — built once, scales.

The Problem

Patterns we see in every engagement

Most Power BI in Dubai is built by analysts, not Power BI engineers. The dashboard looks fine in the demo. Three months later the gateway times out, the semantic model has 40 measures named Measure 1–40, and operations is back on Excel. These are the four patterns we close.

01

Import models that have outgrown the overnight refresh.

Your fact table crossed 50 million rows. The 4-hour refresh fails twice a month. Morning leadership review opens yesterday's data — or worse, a broken refresh state.

02

Semantic models nobody owns.

The Power BI workspace has 27 datasets, 8 of them duplicates of each other, all with different OEE / OTIF / fill rate definitions. Leadership reviews argue about whose number is right.

03

Customer DIFOT scorecards have no internal counterpart.

Lulu, Carrefour, Spinneys publish vendor scorecards monthly. Your internal OTIF is 5–7 points higher. The chargeback dispute lands with no evidence.

04

Power BI Copilot enabled on a workspace nobody cleaned up.

Copilot works in production now — for clean semantic models. On a workspace with Measure 1 through Measure 40, it confidently produces wrong answers. We clean before we enable.

What we build

What we build for Dubai clients

Eight engagement shapes that map to UAE mid-market industrial reality.

01

Power BI on SAP S/4HANA Public Cloud / SAP ByD

Replaces

SAP Embedded Analytics reports that nobody outside SAP-trained users can open.

  • Native connectors via Fabric Data Pipelines
  • Refresh-free with Direct Lake — current data, no overnight window
  • Power BI semantic model over SAP — measures named for business users, not SAP fields
  • Embedded into Power Apps where the workflow needs both data and action

SAP data becomes usable outside SAP-trained team. Operations and finance see the same number.

02

DIFOT dashboards for UAE retail customers

Replaces

The customer chargeback dispute that lands monthly with no internal data to defend.

  • DIFOT per customer per SKU — Lulu, Carrefour, Spinneys, Choithram, Geant
  • Reconciled monthly to the customer-published scorecard
  • Root cause Pareto — stock, production, paperwork
  • Auto dispute pack — evidence per disputed order

Dispute success rate rises. Customer scorecard becomes a managed metric.

03

OEE dashboards for KIZAD, Hamriyah, JAFZA, RAK plants

Replaces

The plant-by-plant OEE Excel that takes a week to consolidate.

  • Real-time OEE via OPC-UA to Fabric Real-Time Analytics
  • Six Big Losses Pareto per shift, per line
  • Mobile shift-handover view
  • Cross-plant benchmark with consistent OEE definition

Operational best practice transfers between sites. Group sees plant-level performance comparably.

04

AED multi-currency reporting

Replaces

The month-end Excel that restates statutory and management numbers manually.

  • Base-currency normalisation in the semantic model
  • Statutory and management reporting from one source
  • Audit trail per FX conversion
  • VAT-aware reporting for UAE corporate tax and KSA Zakat

Month-end close drops. Finance and operations work from one source.

05

RLS for multi-plant / multi-region

Replaces

Per-report security hacks that break when someone publishes a copy.

  • RLS at the semantic model layer — every report inherits
  • Plant-level, region-level, customer-account-level scoping
  • Dynamic RLS via Entra ID — joiner-mover-leaver handled by user attributes
  • Audited regularly so drift is visible

One model, every report secured. Sensitive data stays scoped.

06

Migration from Tableau, Looker, Qlik to Power BI

Replaces

The Tableau renewal that costs 3× Power BI for the same operational reporting.

  • Audit existing Tableau / Qlik estate via usage analytics
  • Re-platform the 20 dashboards driving 80% of views first
  • Rebuild semantic model on Fabric Direct Lake
  • Train internal team to maintain — handover, not lock-in

Tableau or Qlik retired. Operational reporting consolidates onto the Microsoft stack.

07

Power BI Embedded inside Power Apps

Replaces

The dashboard that lives in one workspace and the operational form that lives in another.

  • Power BI Embedded inside a Power App or custom portal
  • Single sign-on via Entra ID
  • Filter context inherited from the host app — drill matches the workflow
  • Mobile-first design where shop-floor or field-team is the user

Dashboard lives where the work happens. Adoption rises because there is no separate place to log in to.

08

Performance tuning — fix slow Power BI

Replaces

The 40-second visual everyone has accepted as 'how Power BI works'.

  • DAX measure audit and rewrite
  • Aggregation tables and composite models where Direct Query is the right shape
  • Capacity load analysis
  • Gateway performance review

Slow visuals become usable. 4-hour refresh becomes 12 minutes by fixing the model, not the gateway.

How we work

From onsite audit to first production model in 6 weeks

We start with the existing estate. Most Dubai clients have a Power BI workspace; the question is what to keep, what to rebuild, what to archive.

01

Discover — onsite Power BI estate audit

Two weeks. Onsite at your Dubai / Sharjah office. Power BI estate audit: every workspace, every dataset, every gateway. We use Power BI's own activity logs — most clients do not know that data exists.

02

Prototype — production semantic model on Direct Lake

Two weeks. Build one production-grade semantic model on Direct Lake plus two reports. Parallel-run against the existing estate for 2 weeks.

03

Deploy — domain by domain

Three to five weeks. Move the chosen domain. Set up deployment pipelines, RLS, ownership. Train the named model owner. Continue domain by domain.

Technology stack

Power BI

Power BI Direct LakeSemantic ModelsPower BI CopilotPaginated ReportsPower BI Embedded

Platform

Microsoft Fabric F-SKUOneLakeAzure UAE NorthDirect Lake

Authoring

DAX StudioTabular EditorDeployment PipelinesTheme JSON

Governance

Row-Level SecuritySensitivity LabelsEndorsementPurview

ERP

SAP S/4HANA Public CloudSAP ByDesignMicrosoft Dynamics 365NetSuite

GCC-specific

AED base currencyArabic RTLGCC working weekLulu / Carrefour scorecards

Common questions

What buyers ask us

How many Power BI projects have you actually shipped?

150+ projects across 13+ years, with 50+ clients. Named UAE/GCC clients on request after the NDA — typical references include Hollandia Dairy and Tetra Pak (consented for marketing use).

Can you start in 2 weeks?

For Discover, usually yes. For Prototype, depends on data access readiness from your end.

What about Microsoft Direct CSP licensing?

We work alongside your existing CSP partner for licensing. Our work is the build and delivery.

What if we already have a Power BI estate but it is a mess?

Most engagements are exactly this. We audit first (Discover), then plan the rebuild or consolidation. We do not recommend a full rebuild unless the existing estate is structurally broken.

How much does it cost?

Discover USD 12,000–18,000. Prototype USD 25,000–45,000. Deploy USD 60,000–160,000 depending on domain count and migration scope. Senior Power BI Developer retainer from USD 8,000/month (10 days) to USD 14,000/month (20 days). Billed in USD or AED.

Ready to move

Book a 30-minute Power BI diagnostic in Dubai

30 minutes with Amit. No slides. No pitch deck. No obligation to proceed. We walk through your existing Power BI estate and where the next move lands.