Data connection
Business Central, SAP Business One, Sage, SharePoint workbooks and bank files read into one semantic model, refreshed on a schedule.
Power BI in Mauritius
Power BI that your management actually opens.
Dashboards built on a reconciled data model, with access by role, for companies that run on an ERP and a stack of Excel workbooks.
What we build with Power BI.
A dashboard is the last step. Most of the work is the model underneath it.
Reconciliation before publication
Every page is checked against the figures finance already trusts, such as the board pack or the trial balance, before anyone sees it.
Access by role
Row-level security by entity, cluster or hotel, and separate published apps for operations and the board.
Training so the team owns it
Bonsaï Camp runs a Power BI Analytics and AI programme so your analysts can extend the model without us.
When Power BI is enough, and when it is not.
We use Power BI when it is the right tool, and we say so when it is not.
It is enough when
You mostly need to read figures from one or two sources, the audience is internal, and nobody has to approve, correct or enter anything in the same tool.
It is not enough when
The work needs data entry, approval workflows, alerts assigned to a named owner, or a check that stops a bad import. That is a custom application or a Business Cockpit.
Often it is both
Power BI for the board view, an application for the operational side, fed by the same data. Read how we decide.
Systems we have built
Real systems, in production or in delivery. Client names are withheld.
Five-entity group cockpit
Management no longer waits weeks for an assembled board pack. Consolidated P&L, budget and working capital, live from the ERP.
Constraint. Five entities, an on-premises ledger and a board pack assembled by hand after month end.
Dynamics 365 Business Central (on-premises)SharePoint OnlinePower BI Service
Read the case
Manufacturing executive cockpit
Sales, margin, cash and supply chain read nightly from SAP, from the P&L waterfall down to each product range.
Constraint. Figures lived in SAP and in forecast workbooks and were assembled by hand each month.
SAP Business OneExcel forecast workbookPostgreSQL (Supabase)
Read the case
City hotel group cockpit
Each morning, management knows where the month will land against budget, from one set of figures reconciled with accounting.
Constraint. Hotels reported on separate timetables and group figures were assembled afterwards.
Oracle Opera CloudPower AutomateMicrosoft Dynamics 365
Read the case