The challenge
The college runs construction programs with internal teams, general contractors and subcontractors. Construction, financial and compliance data sat in separate project-management, ERP, spreadsheet and payroll-compliance systems. Leadership needed current dashboards, and access had to be controlled by role and contractor level, including student-privacy considerations.
What we did
Delivered by Logic Intelligence®, the team behind every Data Arcade package.
- Ran requirements sessions with cross-functional stakeholders and delivered in agile sprints.
- Integrated the source systems into one standardized analytics model.
- Designed data governance and role-based security.
- Automated approvals, data refreshes and exception handling.
- Moved legacy reporting to cloud services and trained staff in self-service reporting.
The solution
A reporting and compliance solution on Microsoft Power Platform. Power BI semantic models and dashboards cover budget tracking, cost analysis and compliance, with row-level security by role, project and contractor level. Power Automate runs scheduled refreshes, approval workflows for change orders and compliance submissions, and alerts for missing or invalid data. A Power Apps compliance application with validation rules lets staff and contractors manage compliance data directly, with auditability kept.
Built with
- Power BI
- Power Automate
- Power Apps
- Row-level security
- Data dictionary
Outcomes
What the client has now.
- Fewer manual steps, with approvals, refreshes and exception handling automated.
- More accurate and accessible financial and compliance data.
- Stronger governance over sensitive data.
- Self-service reporting and compliance tools for staff and contractors.
Buy this as a package
The same kind of work, as a fixed-scope package with a published price range.