Using our expertise, we were able to automate the consolidation of multiple cross site reports using a combination of Azure Logic Apps flows and Microsoft Outlook rules.
Our client is an environmental engineering company that specializes in cleaning of hazardous environments. One of their systems needs its performance monitored by independent laboratories. Each lab provides their analytical results via email, and each lab does so in different formats.
They needed a solution that was capable of ingesting the multiple lab reports and consolidating them into one format to enable reporting that allowed for cross site reporting. They also required the process to be fully automated and able to accommodate new sites.
The client was using PowerBI to monitor one of their projects and wanted to build on the existing reporting and be able to include other current and any future projects within the same report. This would allow the ability to compare site performance, create benchmarks and detect anomalies.
The client currently had a SharePoint Site to collect data for the current project and was looking for an alternate solution that could support their growth in projects. They had used PowerAutomate to capture the projects data files from a shared mailbox but needed to extend the solution.
Using our expertise, we were able to automate the data processing using a combination of Azure Logic Apps flows and Microsoft Outlook rules. It moved the email attachments to an Azure Blob Storage location to provide better scalability. By fully automating this process, it allows the Power BI file to consistently ingest new data as it is being received, removing the risk associated with a manual process.
Through careful data modelling we were able to configure the Power BI file to ingest multiple different data file formats from multiple countries in different languages. This data is consolidated into one central data source that drives all reporting
The client now has a solution that:
Through the application of our Enterprise PowerBI strategy methodology and tools, we will design an approach for your organisation that will deliver value in alignment with your corporate strategy.
This process will also analyse your technology options and provide initial recommendations on appropriate capabilities and architectures.
Our data platform specialists are equipped with the tools, methodologies, and experience that help to enhance and expand your platform in a structured approach. We work with data platforms from design to implementation across all key technical components such as Data Lakes, Databases, ETL processes, Cubes and Reporting.
We provide clear timelines and expectations for what can be delivered and when, and what interactions are needed between the business and the technical team.