The first executive dashboard
One view across 12 business areas, on a shared data model that every production report uses.
I'm Ahmed. I build Power BI reporting on live ERP data and AI automation that a person signs off.
Open a working dashboard
I turn ERP data into one view for leadership, with every metric defined once. Then I automate the work around it, and a person approves every change.
Two ways I work, step by step. Tap a step to see what happens there, with a real example.
I start with the decision, not the chart. Who reads the report, what they decide, and which number tells them.
Leadership needed one view of the business. The first executive dashboard covers 12 business areas.
See the caseReports run on live ERP data, the company’s core business records. No exports pasted by hand.
Leadership had been reviewing sales data up to 5 days old. The report now runs on live ERP data.
See the caseOne shared data model holds the business definitions. Every report reads from it, so a metric means the same everywhere.
Every production report now uses one shared model. Standard metric names ended conflicting numbers between departments.
See the caseThe first page answers the question. Each figure shows where it stands against plan, and the detail sits behind it.
10+ Power BI dashboards and reports, from sales and invoicing to inventory and production.
Open the dashboardsBefore a report goes out, its totals are checked against SQL on the source data. Numbers get checked before they get published.
The monthly sales meeting report went from 3 to 4 days to under an hour, checks included.
See the caseThe report is there for a decision. It shows the gap, who owns it, and what to fix first.
The inventory risk analysis flagged 26% of raw material items as high risk, with ~25M AED of stock at risk, early enough to act.
See the caseWork starts from a normal request. No special format and no form to fill in.
The pricing engine starts from customer change requests on modified HVAC units, such as a bigger fan or a new casing.
See the caseAI reads the request and proposes what to change. It never does the fixed math.
A review found 37 contradictions in the method documents. The old AI handled about 70% of fixed calculations unreliably.
See the caseEvery calculation runs in Python. Automated tests check the rules each time the code changes.
The pricing engine now runs on 446 automated tests. It closed a ~97K AED material costing gap.
See the caseThe proposal goes to a person, who approves or rejects it. Anything a person must confirm is flagged.
AI use stays inside company security rules: approved connectors, tools that run locally, and a person signing off every change.
See the caseRecurring work runs on a schedule. Data pull, checks and the finished output, every time.
The monthly sales meeting report runs as a scheduled AI workflow. Prep went from 3 to 4 days to under an hour.
See the caseEach run ends in an Excel workbook anyone can audit. Anything a person must confirm is flagged in it.
Manual costing work became 10 AI automations. They pull live ERP data, build Excel workbooks anyone can audit, and flag anything a person must confirm.
See the caseA shared data model on ERP data, the company’s core business records. Every production report now uses it.
See the case10+ Power BI dashboards and reports on ERP data, from sales and invoicing to inventory and production.
Open the dashboardsThe company’s first executive dashboard: 12 business areas in one view.
Open the dashboardNet sales sit 4.2% below target, to 30 September.
Checked against SQLDemo data: Bean & Brew, a made-up coffee chain. Bar heights are illustrative. Open the full report
Every calculation runs in Python, backed by 446 automated tests.
See the caseIllustration of the method. The real tool is internal.
Pick a change request. See what the AI proposes, what validation rejects, and how the quote moves when you approve.
Open the demoCan machine learning spot a late order on the day it is entered? Measure, explain, predict, then warn planners early.
Proposal defended, November 2026Read about the researchFive working rebuilds of reports I build. Change the period, tap a figure, open an area.
Which of 12 business areas are off target?
OpenWill orders and invoicing reach the yearly plan?
OpenIs each plant on plan and on time?
OpenWhich stock is at risk, and who owns it?
OpenWhy are sales below target, and what to fix first?
OpenAll data is made up. The real dashboards are internal.
Monthly sales meeting report. Data pull, checks and the finished deck run as a scheduled AI workflow.
See the caseOne Power BI report build, using AI-assisted development I brought to the team.
See the caseSales performance report on live ERP data. New views ship in hours.
See the caseAutomated tests behind an AI pricing tool I rebuilt. A review had found 37 contradictions in its method documents.
See the caseAt-risk stock surfaced early enough to act, from 100,000+ inventory, financial and operational records.
See the caseOne view across 12 business areas, on a shared data model that every production report uses.
An AI pricing tool rebuilt so tested code does the math and a person confirms every change. ~97K AED costing gap closed.
Prep for the monthly sales meeting went from 3 to 4 days to under an hour, checks included.
Leadership now reviews live sales data, not numbers up to 5 days old.
Surfaced ~25M AED of at-risk stock early enough to act.
Reads a full Power BI model, writes its documentation and checks it against 17 review rules.
10 AI automations for costing work, and AI-assisted Power BI development that cut one report build from two weeks to three days.
An offline Windows tool that turns tables in PDFs and scans into Excel. 100% of cells right on a real catalog page’s original PDF, 96.7% on an office copier scan.
Nothing matches. Try one of these:
I run sessions for colleagues, and I am open to freelance training with institutes.
The software behind the dashboards and automations on this page. Tap a tool to see where it shows up on this site.
Dashboards and reports on live ERP data, as the BI Analyst since Feb 2024.
Where it shows up
The measures inside my Power BI models.
Where it shows up
Data preparation steps before the data reaches the model.
Where it shows up
Pulling ERP data, and checking report totals before release.
Where it shows up
The shared production data model, with SQL.
Where it shows up
Pricing automation in Excel VBA as a Cost Engineer, from Nov 2022. Now the audit workbooks my AI automations build.
Where it shows up
Every fixed calculation in my AI tools, and my own Table Extractor.
Where it shows up
Automated tests, such as the 446 behind the pricing tool.
Where it shows up
Version control for my code.
Where it shows up
No public example on this site yet.
AI-assisted Power BI development, and the AI coding agents I direct.
Where it shows up
A standard way to connect AI to tools, inside company security rules.
Where it shows up
Scheduled runs for recurring work.
Where it shows up
No public example on this site yet.
SQL databases besides SQL Server.
Where it shows up
No public example on this site yet.
Valid to Sep 2027.
Credential ID 3C0CC0631A059C0E
Timed exam on RAG (AI that answers from your own documents), vector search and data modelling.
Employee of the Quarter, Q1 2025SKM Air Conditioning
SKM Air Conditioning, Sharjah, UAE One of the UAE’s largest HVAC (air conditioning) manufacturers, serving projects across the GCC (the six Gulf states).
Technical documentation and 3D models, plus a tool that generates drawings automatically.
Priced 100+ HVAC projects across the GCC. Automated pricing in Excel VBA, cutting proposal turnaround by 30 to 40%.
The only BI person on the team, serving directors and managers across the business. Power BI on live ERP data, and AI automation a person signs off.
See the workDownload my CV