In today's data-driven business world, data-driven decision making is crucial for global organisations. Sonepar Deutschland GmbH recognises the relevance of this approach and relies on Microsoft Power BI as an effective reporting and analysis tool. As a long-standing partner of Sonepar, noventum consulting already successfully helped to redesign and consolidate the company's central data warehouse in 2018. We have now taken the next step in our collaboration: the implementation of Power BI to improve reporting and analyses.
Companies are increasingly recognising the inevitability of Self Service BI (SSBI), but not infrequently they fail to implement it and therefore cannot fully exploit its potential. With this contribution we want to answer the following question: Which factors must be fulfilled so that the cooperation between the central BI organisation and users in the specialist areas - the so-called "power users" - works and both sides benefit from each other?
With Composite Models, Microsoft significantly expands the application spectrum of Power BI for business departments in companies. At the same time, a very powerful tool for self-service BI is created for the central business intelligence and IT departments in order to give the departments new freedoms and possibilities while taking their governance guidelines into account. The article is therefore aimed at both responsible and advanced users of Power BI Desktop in Controlling as well as those responsible in central IT or Business Intelligence. Used correctly, composite models open up a new world for self-service BI.
At noventum, we very often deal with the connection of SAP systems to Microsoft-based data platforms. Both on Azure with ADF and Azure SSIS or locally with SSIS and often with XtractIS from Theobald.
The supreme discipline of data extraction from SAP is the connection of data via SAP BI Content Datasources.
Microsoft Power BI has been on everyone's lips for several years now under the keyword "Self-Service BI" and contributes significantly to the perception of the Microsoft Data Platform as a leading analytics and business intelligence platform. In order to maintain and expand its leading position, Microsoft is making significant investments in the further development of the platform and is constantly increasing the range of functions via short, sometimes monthly release cycles.
An intelligent analysis of customer and online user data enables targeted and customer-oriented marketing. The prerequisite for this is that the implemented data structures and selected analysis methods and BI tools are coordinated with each other and fit together well. A medium-sized publishing company used the DWH and BI architecture introduced in 2013 to expand its data-based marketing activities. As in the previous BI projects, noventum's consultants were also responsible for developing a data model for marketing, which will also serve as a central basis for future analytics requirements.
