Technology Park Management Reporting with Power Apps and Power BI
Non-profit education and research organisation, Middle East
In short
How can monthly management reporting move from Excel to Power Apps and Power BI?
Every month, the management report for the technology park was built from an Excel workbook and a PowerPoint deck, and anyone who could open the file could change the numbers. With the dashboard close to launch, the Excel data entry was the weak point. We replaced it with a Power Apps data entry app and a Power BI report, with approvals.
At a glance
- Excel and slide reporting replaced by one app and report
- Directors approve data with one click
- Up to 22 Power BI report pages optimised
The client
The client is a non-profit education, science and community organisation. A science and technology park is one of its units, and the work ran with the client's IT team and Microsoft on a monthly management dashboard.
What it was costing them
- Unsecured numbers: anyone with access to the file could change values, so the report could not be fully trusted.
- Two files, two versions: one deck for current and previous months and one workbook with every month, kept in step by hand.
- Launch risk: the dashboard was almost ready, but unstable Excel data entry could have broken it at go-live.
- Manual typing: figures were keyed and re-keyed between files, which invites errors.
- Slow close: no clear approval step or reminders, so the month-end process depended on chasing people.
What we built
We built a Power Apps data entry app and a Power BI management report that read from the same source, with approval by department directors.
- Data kept safe: a Power Apps canvas app on SharePoint replaces editable Excel files, with access limited to named users.
- Right numbers from the right people: row-level security decides who may enter or see each screen.
- One-click sign-off: department directors approve monthly data in the app.
- No chasing: automatic reminders go out at the start and end of the monthly process.
- Enter once, see twice: data entered in the app appears in the app and in the Power BI report.
- Reports people can use: up to 22 Power BI report pages optimised, with one common layout theme.
- A solid data flow: Azure Data Factory pipelines and an updated data warehouse model feed the report with the app data.
- Tested before launch: user acceptance testing with feedback sessions, a deployment package and end-user training.
Results
- Department directors approve monthly data with one click in the app.
- Automatic reminders mark the start and end of the process, so progress can be followed.
- App and reports are open only to defined users, and only defined users can approve, which secures the data.
- Data is entered once and can be viewed in both the app and the report.
The risk most teams miss
Replacing Excel with an app fixes security, but in month three the questions change: a new KPI is requested, a director leaves and the access list is out of date, or a SharePoint list grows past what the app can read quickly. We scoped one list of fields, one security list and a documented design, and we recommend moving to Dataverse and reviewing access every month.
What we would add today
Improvements we would add on top of what is live.
- Move the data entry from SharePoint lists to Dataverse, with row-level security and audit history on every monthly value.
- Replace the manual reminders flow with Power Automate approvals and Teams adaptive cards for director sign-off.
- Build the report on a Fabric lakehouse and a Direct Lake semantic model instead of a separate warehouse and pipelines.
- Add Copilot in Power BI to write the monthly narrative summary for the management report.
- Deploy through Power Platform pipelines with a service principal owning the connections.
Technology
Power Apps (canvas), SharePoint Online, Power BI, Azure Data Factory, data warehouse, Power Automate.
Tell us which monthly report still lives in Excel and PowerPoint, and we will tell you how it can run in an app with approvals.
Products and capabilities
- Power Apps
- Power BI
- SharePoint
- Azure Data Factory
- row-level security
- management reporting
- data entry app
The service behind this work
Power BIThe service behind this work
Power Platform development
Related use cases
Management and planningProgramme Collaboration Platform on Microsoft 365
A cooperation programme that runs events, registrations, surveys and shared workspaces across many countries cannot do it well with an ageing mail system and separate tools. We built a platform for the programme that puts all of it on Microsoft 365 and Power Platform.
- 78
- tender requirements met
- 65
- programme staff
Copilot and Power Platform Use Case Mapping
Most Copilot projects stall on one question: where does Copilot help, and where does the business need something else? the client had that question across its corporate teams. We turned business problems and role stories into a map that names the Microsoft tool for each, so spend goes to the right place.
- 34
- problems matched to a tool
- 29
- role-based use cases
Grant Management Tool for a Ukrainian Agriculture Programme
When grants, private-sector co-investments and contracts are tracked in different tools, managers cannot see the portfolio, each stage of the grant cycle depends on who holds the file, and money for Ukrainian agriculture moves more slowly than it should. We built one grant management system on Microsoft tools for the client.
- c. 70
- grant system users
- c. 20
- grant managers
Have a Microsoft project in mind?
Tell us what you need built, fixed or supported. A senior consultant replies within one business day.