Business intelligence reimagined: smart reporting for BearingPoint
BearingPoint GmbH – Business intelligence reimagined: smart reporting for BearingPoint.
BearingPoint is recognised worldwide as an independent management and technology consultancy. Its business areas include consulting, products, capital and the Arcwide joint venture – and most of its work is strictly data-based. To make such data-based decisions even faster and more efficient, reporting needed to be taken to the next level. The solution? Microsoft Power BI. Bechtle developed an innovative reporting setup – with a customised concept and in-depth Power BI service monitoring report. New dashboards, a flexible self-service concept and a powerful monitoring system now ensure greater speed and transparency. And thoroughly smart reporting.
Project details.
Trade / Service
ITC / Media
Microsoft
250 – 1,500 employees
Challenge.
How can data be used more quickly, flexibly and intuitively? BearingPoint also asked itself this question, because data and analysis form the basis of the management consultancy's business model. The company was looking for a solution that would facilitate data-based decisions, accelerate processes and be easy to use. Instead of spending hours on reporting, they wanted to wait only seconds. This required a system that was powerful, scalable and user-friendly. And a system that could be easily integrated at BearingPoint.
Bechtle helped us switch to Power BI and set it up. Bechtle also continues to support us – from strategic issues to technical implementation. This close collaboration enables us to use the new technologies in a targeted manner and to continuously develop our reporting. Bechtle is proactive and flexible throughout the entire process, providing us with valuable insights for future developments. The quality of their work and the personal exchange make the collaboration with Bechtle particularly valuable.
Philipp Uihlein, firm-wide IT, BearingPoint
Solution.
Bechtle made exactly that possible: faster analyses, more flexible reporting, full control. The basis? A modern Power BI platform with over 30 tables – built on a well-designed data model, refined with calculation groups and Tabular Editor. Power BI Desktop connects data from the on-premise SQL servers and Azure SQL Managed Instance. The integration? Fully automated via PowerQuery, Azure Data Factory and PowerShell. Robust, reusable, efficient. Bechtle didn't just adopt dashboards. They were completely redesigned: interactive, intuitive, visually powerful – with Zebra BI Visuals and optimised for every purpose. The new self-service concept also brought about a turning point. Specialist departments now get their insights directly from the reports instead of having to prepare data manually. Rights, roles, gateways, update schedules? Everything is managed directly in the Power BI Service Workspaces.
Bechtle developed a pure cloud setup for monitoring – with Azure Functions, stored procedures and Data Factory pipelines. This allows BearingPoint to see exactly which reports are being used and which need to be further developed. The solution also sets standards in terms of mobility: a specially developed Power BI app replaces the old application – tailored to smartphones and tablets. One highlight is the integration of Microsoft Office 365 content into reports. This is integrated via Microsoft Graph API, Azure Functions and data pipelines – either via Azure SQL or in Microsoft Fabric with lakehouse structures. And there's more. Bechtle provides ongoing support with new analysis functions and genuine innovations.
Business benefits.
Better performance: Ensures more efficient report calculation and short waiting times.
Microsoft integration: Ensures a uniform platform and look – usable from anywhere.
Mobile ready: Thanks to the reporting app for smartphones and tablets – available anywhere, anytime.
Self-service reporting: Makes it easier to create custom reports for specialist departments.
Tidy dashboard appearance: Displays everything neatly and quickly, can be used interactively with filters.
Wide range of connectors: In Microsoft Power BI, these allow more databases to be integrated.
Optimised reports: Thanks to analysis and improvement of previous reporting.
Smart monitoring system: Records authorisations, usage and access data.