A major facilities management corporation implements a Power BI dashboard to replace manual data processing.
SITUATION
Our client was creating reports in PowerPoint and pulling data from Business Objects into an MS Access Database for email distribution. Due to the time-consuming process, the client needed a partner to redesign the reports and build them in Power BI over the existing Data Warehouse.
SOLUTION
To complete the effort, we provided a project team including a UI/UX designer, Delivery Lead, and Data Engineer. Additionally, we leveraged two Power BI developers based in our Mexico Delivery Center (MDC). The project team completed the following activities:
Wrote User Stories including visualization recommendations and metrics to tell the right data story
- Implemented a schema in Power BI with nightly data flow refresh from the client Data Warehouse
- Built 23 report pages packaged inside a Power BI application with navigation
- Provided Project Management, Testing, and Implementation in Non-Production and Production environments
RESULT
The final solution was delivered within a seven-week timeframe. The client was pleased with the Power BI dashboard and associated reports that were delivered. The data is refreshed nightly and has replaced the cumbersome, time-consuming manual process with an easy-to-use visual reporting solution that shows the KPIs the company is most concerned about from the viewpoint of many departments.
In addition, the team delivered a DevOps pipeline that creates workspaces, adds AD groups, and uploads files. We provided documentation and knowledge transfer on how to make changes and update to production.