Comprehensive adjustment and optimization of the Power BI report
Project Description
For our customer Atlas Copco, we were tasked with optimizing the existing reporting. We focused on reviewing the relevance and volume of processed data, reducing loading delays, and enhancing the visual design of the final report.
1
optimized Power BI report
1
more efficient data warehouse
40%
data volume reduction
90%
reduction of monthly Azure operating costs
User activity tracking originally relied on an insufficient standard report in SharePoint. Additionally, data was stored in various locations, including SharePoint lists and a data warehouse on Azure technology. We resolved issues with incorrect source data and made significant adjustments to the report to display more information in the same space and improve its clarity.
In the second phase of our collaboration, we identified weaknesses in the existing Azure data warehouse infrastructure, which was burdened by the transfer of an unnecessarily large volume of incomplete data. After our intervention, the data warehouse operation was optimized, data loading into the Power BI model was simplified, and the overall reporting outputs were accelerated.
Applied technologies
Industry solutions
Solutions
„Even as a minority supplier, we were able to work wonders in collaboration with the customer.“
Satisfied Client
The Intecs team demonstrated a high level of expertise, quickly familiarized themselves with the somewhat chaotic report, and proposed a path leading to a more professional solution. I appreciate their open approach, the quality of their deliverables, and the overall positive collaboration.