A multinational oil and gas company uses PowerBI to implement an audit compliance process.
SITUATION
Our client was dealing with fragmented and inconsistent analytics and business intelligence support for business units without one version of the truth. There were over 1,000 customer users who needed access to this data to comply with internal and external audits. Select subject matter experts were developing PowerBI reports in an ad hoc, reactive manner. This led to unreliable support for important decisions, technical debt, and a lack of progress toward efficient, enterprise solutions. Their software development team did not have the capacity to absorb that workload, so they leveraged Apex to provide a compliance platform solution.
Supported over 1000 System Users
To implement an enterprise power platform solution, we provided a team utilizing Agile methodology based in our Mexico Delivery Center. Our team consisted of a business intelligence technical lead and four business intelligence engineers. The team’s skill sets spanned design thinking, customer centricity, UI/UX, software development, automation, database design, product management, and business analytics. The team:
- Designed the business process to be implemented in the solution.
- Designed and implemented the database, automation, and reporting architecture using Power Apps, Power BI, and Power Automate.
- Implemented Agile methodology working by sprints to constantly adjust the direction of the solution to fit the business need.
In addition to delivering Power Platform assets that enabled the business, the team established permanent infrastructure supporting a continuous analytics lifecycle, including a DevOps pipeline, standardized ETL patterns, automated processes in Jira, and ServiceNow integration for the customer.
RESULT
In the span of three months, the team deployed a Power Platform solution to production. This solution, the attestation app, ensures that customers have the correct users, security, updates, and data while helping customers maintain ownership of databases to establish one version of the truth. Senior client employees are now freed up from creating solutions on an ad hoc basis and thus can proactively solve client problems. The solution is now capable of supporting the over 1,000 users who need to comply with audit processes. Both the client sponsor and the users have explicitly communicated their satisfaction with the team’s work and development, placing emphasis on the working methodology and quality of the job.
