- All categories
- Automation
- TechNotes
- Digitization
- Digital Transformation
- Cloud Computing
- IT Mergers & Acquisitions
- IT Quality Improvement
- SAP-Processes & Systems
- IT Technology Consulting
- HR-IT-Management
- IT-Outsourcing
- IT Cost Reduction
- Business Intelligence
- Agility
- SharePoint
- IT Processes and Organisation
- IT-Strategy
- Corporate Culture
- noventum

How companies can use composite models in Power BI as a game-changer for self-service business intelligence
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 or IT departments in order to provide the business departments with new freedoms and capabilities while taking their governance guidelines into account.

From Microsoft Gold Partner to Solutions Partner in the Microsoft Cloud Partner Program
On the third of October 2022, the "Microsoft Partner Network" was replaced and switched to the new "Microsoft Cloud Partner Program" (MCPP). In future, IT companies will be able to demonstrate their expertise in six areas of competence. Three different "Partner Capability Scores" are available for this, in which companies must prove themselves: Performance, qualification and customer success.
Read more … From Microsoft Gold Partner to Solutions Partner in the Microsoft Cloud Partner Program

Analysis platform CLAIR achieves 2nd place at the "Best Data Project Award"
The project team of the analysis platform "CLAIR" of our long-standing customer Zentrale Stelle Verpackungsregister (ZSVR) has been awarded 2nd place in the category "SME" for the "Best Data Project Award" at the VOICE ENTSCHEIDERFORUM 2022 in Berlin.
With more than 400 members, VOICE - Bundesverband der IT-Anwender e. V. is considered the largest community of digital decision-makers in the German-speaking world, serves as a network for CIOs of leading companies from a wide range of industries and promotes professional exchange and the strengthening of IT user interests.
Read more … Analysis platform CLAIR achieves 2nd place at the "Best Data Project Award"

The WSW way to data preparation and analysis in HR Controlling
In future, the Wuppertal public utility company will use the noventum HR-Analytics analysis software for its HR controlling. The benefit of the software for the HR controllers is that they can analyse complex interrelationships with minimal effort and make targeted recommendations for action.
Read more … The WSW way to data preparation and analysis in HR Controlling

TOGETHER FOR HR CONTROLLING OF TOMORROW
Thorsten Schmidt, Director for Business Intelligence at noventum consulting, and Thomas Schauer, Managing Director of CoPlanner, have worked together side by side for several years at noventum on the topics of Business Intelligence and Corporate Performance Management. These days, the two met in the port of Münster for a strategy meeting to discuss further cooperation between noventum and CoPlanner.

Felix Möller new noventum-Lead Microsoft Intelligent Data Platform
As "Director Senior Azure Analytics Architect", Felix Möller has worked for the technology group Avanade for the past five years and has now returned to noventum consulting to contribute his experience to the consultancy. In his last role, Felix Möller worked as an architect and project manager in large Azure Data Platform projects for German corporations. In the future, he will increasingly lead noventum BI customers into the cloud and bring the experience from the corporate world to SMEs.
Read more … Felix Möller new noventum-Lead Microsoft Intelligent Data Platform

noventum HR-Analytics - the cloud hybrid architecture for recruiting
Recruiting new employees is one of the most important pillars for sustainable success for every company - and at the same time one of the biggest challenges. noventum HR-Analytics creates the prerequisite for the comprehensive analysis of the recruiting process with a cloud hybrid architecture consisting of Microsoft Azure and SQL Server components.
Read more … noventum HR-Analytics - the cloud hybrid architecture for recruiting

noventum HR-Planning at consulting expert Drees & Sommer
A precise view of its own human resources today and in the future is part of Drees & Sommer's success. The leading European planning and consulting company has now expanded and improved its system landscape with noventum HR Planning powered by CoPlanner. The system allows a daily forecast of FTE development based on employee master data and planned assumptions. This information is available to stakeholders in the company. In addition, the system can be used to create a well-founded personnel cost plan at any time.
Read more … noventum HR-Planning at consulting expert Drees & Sommer

noventum HR-Analytics wins the HR Software Award 2021
For 22 different tools, the aim was to determine the most popular HR software manufacturers in the categories of customer satisfaction, usability and price-performance ratio. Over a period of three months, votes were diligently cast in the social media and in newsletters of the independent comparison portal, resulting in over 3,000 individual evaluations for almost 100 HR software providers in the course of the HR Software Comparison Award 2021. Based on this data, an overall winner was then determined for each tool.
Read more … noventum HR-Analytics wins the HR Software Award 2021

Staff requirements and inventory planning at the noventum HR Analytics Data Mart at LBS West
Planning and controlling with personnel data is complex even in large companies, if this data has to be merged from different systems and this means recurring large expenditures without automation. Thanks to noventum HR-Planning and noventum HR-Analytics, LBS Westdeutsche Landesbausparkasse is now able to manage resource and personnel planning with little effort.

noventum HR-Analytics as Single Point on Truth for personnel data
Personnel controlling is repeatedly faced with the task of producing valid analyses from heterogeneous data. Data acquisition and preparation make up a significant part of the effort that they have to invest. HR reporting and analysis often fall short of their capabilities because of technical and time restrictions. Many companies lack a connecting solution.
Read more … noventum HR-Analytics as Single Point on Truth for personnel data

How digital change is transforming human resource management
Experts from the human resources sector were invited to pursue the question of what digitalization does to work, how it questions values, orientations and solutions and turns them upside down. Until late in the evening the participants of the conference discussed New Pay, AI in the handling of personnel data, modern personnel requirements planning and agile methods. In three parallel series of topics CULTURE CHANGE, HR MANAGEMENT and HR CONTROLLING, experts presented their approaches and projects and faced interested professionals for discussion.
Read more … How digital change is transforming human resource management

The Power BI report server is the on premises alternative
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.
Read more … The Power BI report server is the on premises alternative

HR cost control and forecasting in a highly dynamic market
A lot of companies have to rely on data of the most diverse origin and quality for their HR concerns when said data is needed for controlling and planning purposes. A lack of data quality and laborious processes are the result. The internationally successful eCommerce company shopware, a large manufacturer of online shopping systems in Germany, has implemented the noventum HR-Analytics software solution for its human resources activities.
Read more … HR cost control and forecasting in a highly dynamic market

Strategic positioning of HR work with proactive and intuitive analyses
The requirements for reports and analyses in the HR segment are growing with the technical possibilities. Until now, People Analytics has been the innovation topic du jour, whereas Predictive Analytics is the current promise. Today, the objective of a lot of Human Resources departments is to proactively and strategically support and advise the different areas of their company. The inquiries range from quick collection of relevant HR indicators to requests for intuitive analyses of possible correlations and conspicuous trends. Such requirements cannot be fulfilled with HR data that are stored in various, non-interconnected sources and which can only be combined with a lot of manual effort. The dm-drogerie markt retail group has addressed this situation with the “noventum HR-Analytics” standard solution which is based on an HR data warehouse and a BI solution based on Microsoft SQL Server and MicroStrategy. With its HR-Analytics application, noventum consulting has been able to consolidate the technical situation as well as the data basis of dm, and to significantly improve the situation of reporting within HR.
Read more … Strategic positioning of HR work with proactive and intuitive analyses

How microsoft is attuning business intelligence to the GDPR with SQL server
The EU has developed a new privacy / data protection law, the “EU General Data Protection Regulation”. It has been in full force since May 2018 and there is still uncertainty among a lot of companies and their data protection officers as to what is actually required by the new regulations and what kind of impact they will specifically have on their data processing processes. Especially in the big data and business intelligence environment, fundamental conflicts of interest arise and widely spread paradigms regarding data retention and analysis will potentially have to be put into question.
The following article provides an overview regarding the fundamental requirements of the GDPR and the obligations arising for companies and for the data protection officers, and outlines a possible approach to comply with these requirements. In addition, the impacts of the regulation are discussed in the business intelligence context and it is shown, based on the example of the Microsoft SQL Server platform, how the requirements of the new EU Directive can be covered by features of modern database management systems.
Read more … How microsoft is attuning business intelligence to the GDPR with SQL server

Microsoft BI SSAS Tabular: on the power of DAX Measures
Data Analysis Expressions (DAX) is a query and modelling language for SQL Server Analysis Services (SSAS) Tabular, Power-BI, and Excel Power Pivot. Calculated columns, tables, and user-defined Measures can be created at a very sophisticated level.
How useful DAX is in business practice is impressively illustrated by a development in the area of the Development in Pay Act. This relatively new law provides employees with the right to demand valid proof from their employer for the commensurability of their own remuneration in comparison to employees with similar activities. With the help of the HR-Analytics solution of noventum, which also relies on the DAX formula language, companies can comply with this obligation.
Read more … Microsoft BI SSAS Tabular: on the power of DAX Measures

noventum HR-Analytics – Projected data to support in-house elections
Due to the oftentimes extensive available data space, the areas of application of HR-Analytics are varied and range from reports and analyses to human resources master data, staffing structure and movement, as well as human resources measures all the way to analyses of time management and salaries. As reporting and analysis tool, HR-A traditionally conduces to human resources management. However, report recipients are also increasingly located at all levels of management and in other areas of the company: from production, via logistics and commerce, all the way to internal marketing and PR departments. As such, the increasing technical possibilities are turning noventum HR-Analytics (HR-A) into a future-oriented analysis and planning instrument.
Read more … noventum HR-Analytics – Projected data to support in-house elections

SQL Server 2016 upgrade significantly improves data warehouse at BRITA
The family-owned company BRITA, based in Taunusstein, Germany, is a leader in the field of drinking water optimization and is represented on all five continents. It operates a complex data warehouse to meet its diverse commercial requirements. By upgrading its SQL Server software to the latest version of 2016 SP1, the company is now able to use the various new functions of the Standard Edition and to remain technically up to date with justifiable effort.
Read more … SQL Server 2016 upgrade significantly improves data warehouse at BRITA

Microsoft Business Intelligence Architecture creates new marketing potential
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.
Read more … Microsoft Business Intelligence Architecture creates new marketing potential

Cloud computing as a sourcing option?
Today, most companies have already had experience with the cloud: applications, IT capacities or individual processes are sourced from a wide range of cloud providers. Agility, innovation, cost reduction, flexibility and scalability are the most common reasons for moving to the cloud. The practical questions are: which provider has the right services? Which parts of the corporate IT are suitable for outsourcing? How does a migration into the cloud actually work? How does it pay off and are the costs the only trigger for moving to the cloud? The question is usually no longer, "are we going into the cloud?" Rather, it is about questions such as "when and how?" or "which services are possible?". Not only beginners in the cloud topic ask themselves the question of the correct procedure.
Using the concrete example of the relocation of an HR analytics application to a cloud environment, some special features of cloud computing in the BI environment are presented here.

Advancing digitalisation with new data warehouse architecture
From the construction of the first prototype in their own garage to becoming one of the world market leaders for combined heat and power plants (CHPs) – that's the interim balance of the 2G Group from the Münsterland region. The rapid growth and increasing internationalisation bring along new challenges for control and operation, as well as, in particular, for the Controlling specialist department. In order to also satisfy all future requirements in this dynamic environment efficiently, the company started the enterprise data warehouse project "2G-Facts" in late 2014 with the support of the IT management consulting firm noventum consulting GmbH. Today, 2G is already using the new business intelligence platform in select application cases in various commercial and technical specialist areas and is therewith excellently positioned also for future requirements and for increasing demand for information.
Read more … Advancing digitalisation with new data warehouse architecture

Microstrategy Symposium: noventum presents HR-Analytics, the solution for personnel reporting
MicroStrategy® Incorporated, leading provider of enterprise software platforms worldwide, invited to Cologne (Germany) on April 6th 2017 for a one-day symposium. In addition to the new functions of MicroStrategy 10.7, which has been available since March, as well as industry-specific and discipline-specific solutions, best practices application of customers and partner companies were also presented at the symposium. noventum consulting, partner and sponsor of the event, introduced its analysis and presentation platform "HR-Analytics" for management, designed for executive management and HR department.

noventum consulting is a Persis partner
noventum consulting has been a partner of the Swabian software producer Persis since 01.01.2017. The modular HR software from Persis supports the personnel management of more than 500 medium-sized companies and groups from the DACH region.
The HRM team of noventum, as a reliable and competent HR management consultant, supports clients in the implementation, adaptation and expansion of their Persis solution. Noventum Persis is a sales partner for Hessen, Rheinland-Pfalz and Saarland.

NWB Verlag publishing house gradually repositions its business intelligence architecture and planning environment
At the end of 2013, the Herne-based publishing house NWB Verlag, too, reached the point of completely rethinking its current BI solution approaches. Jointly with the BI team of noventum consulting GmbH, a fundamental renewal of the BI architecture was achieved in the process. Subsequent to the implementation of an enterprise DWH as basis for reporting and analysis, the quality improvement of the planning processes was scheduled for 2015. Due to the successfully completed project, the comptrollers of NWB Verlag are now able to present more detailed and more flexible planning results that are of higher quality, and can do so at considerably reduced effort.

AGRAVIS expands its human resource management processes with PERSIS HRM standard software
Steady growth and mergers present human resource departments with enormous challenges. On the path from "administrating" to proactive consulting in terms of human resource management, the requirements posed to modern human resource management processes as well as analysis and planning functionalities are growing. As such, AGRAVIS - with the help of noventum consulting - initially started to look for an HRM standard solution with the objective of being able to take care of a large share of current and expected future requirements. Once the fitting solution was found with PERSIS, additional requirements were implemented, for instance with the "digital personnel file", the "employee life-cycle" process, and the integration of processes that are usually foreign to HR. Today, the AGRAVIS human resource department works with a modern solution for the quite often automated mapping of the human resource management processes.

Comprehensive IT governance, risk and compliance increases the quality of the IT infrastructure
The IT infrastructures of companies of different industries - in particular of those in the financial sector - must adhere to an increasing number of internal and external requirements. Among them are requirements from statutory rules and regulations (Sarbanes-Oxley Act), standards (PCI DSS, COBIT), norms (ISO/IEC 27001), and internal requirements. These must be taken into consideration on the strategic level as part of IT governance and have to be implemented via corresponding processes, resources, and guidelines on the operational level.

noventum realises central enterprise data warehouse for BRITA Group
The BRITA family company, headquartered in Taunusstein (Germany), is represented on all five continents as globally active provider in the area of drinking water optimisation, with subsidiaries, shareholdings, and partner companies. Corresponding to the structure of its group of companies, the company needed a central reporting, analysis and - in the future also - planning solution for the quick, automated mapping of the monthly financial statements of the whole group of companies.
Read more … noventum realises central enterprise data warehouse for BRITA Group

Generating ETL processes with BIML
The creation of data warehouses allows for relying on standardised elements at different spots. Depending on the project, there is a high degree of standardisation in some layers while others contain customer-specific business logic throughout. To implement the standardised layers as quickly as possible and in high quality means – for each project – a stable basis and motivation for the often difficult individual aspects that have to be worked on subsequently.

Credit risk reporting
WGZ BANK, Geno Bank Consult and GAD did, with the support of noventum, jointly develop a new solution for credit risk reporting. In this, it was possible to show that an automated data management system and a standardised report template do not necessarily have to represent a contradiction to bank-specific requirements.

The advantages of standardisation in data warehouse projects
„Standardisation in the actual meaning of the word means a unification of metric, types, methods or other things. The objective is the creation of joint standards respectively parameters (for instance in case of tools, production components or software components)." That‘s what Wikipedia has to say. What significance does standardisation have in a highly customer-specific consulting environment such as the setup of business intelligence solutions?
Read more … The advantages of standardisation in data warehouse projects

Challenges in HR reporting and their solutions
In companies, the HR indicators gain more and more importance as a strategic instrument. As such, meaningful strategic indicators are presented to executive management in an appealing fashion. In this, indicator reports are not to be considered compliance documents but rather an organisational communication tool. Only when the recipient received an informative and coherent document can strategic measures be derived therefrom and/or objectives pursued.

„CPM Excellence Suite“ webinar
Originally interconnected via the proximity to the MicroStrategy BI tool, the tool provider Thinking Networks and noventum consulting are growing closer and closer together as a homogeneous solution provider. After first joint project successes and a joint presence at MicroStrategy World in Barcelona (Spain) in July of this year, noventum has considerably driven forward the integration of the two best-of-breed tool providers for business intelligence and planning. The result of this activity: the „CPM Excellence Suite“.

Consolidation solutions for small and medium enterprise company groups
A growing number of companies have been integrated into domestic as well as international company group structures. These days, the increased complexity of the business landscape can only be managed properly with automated IT architectures, because the quarterly and/or annual reports of the parent company and those of the subsidiaries as well as the consolidated financial statement of the company group are closely intertwined with one another and must comply with complicated domestic and international regulations.
Read more … Consolidation solutions for small and medium enterprise company groups

CPM Excellence Suite
In certain specialised areas, classic corporate performance management tools successfully perform their duties. For this reason, the current solutions in the marketplace include numerous specialised CPM tools that have been designed to fulfil the requirements of a certain area of specialisation or a specific BI Task.

Strategic partnership for the pharmaceutical industry
The partners have already completed the first successful joint projects, and another prominent IT outsourcing project, in which both companies are involved with their consulting expertise, is currently heading towards completion. Now, Diapharm and noventum consulting have sealed their cooperation with a cooperation agreement.
Read more … Strategic partnership for the pharmaceutical industry

Joint business development in Warsaw
At the end of May, two intense days of joint business development and planning of future activities brought together Thorsten Schmidt and Thorsten Nimbs of noventum consulting with their partners of MicroStrategy and Thinking Networks in Warsaw. The place of the meeting was the Global Delivery Center of MicroStrategy Poland (GDC). Motivated by numerous successful projects, both parties intend to expand and intensify the partnership of many years already.

Challenges of the insurance industry, jointly approached with Business Intelligence
The dibera consulting company, a subsidiary of the LVM insurance company, and noventum consulting have made plans for a consulting partnership for the insurance industry. dibera, which is established in the insurance sector, as well as noventum consulting with its technical and strategic BI consulting approach, want to jointly put their expertise to use in future projects. Uwe Rotermund, managing director of noventum, and Thomas Koschlig, managing director of dibera, emphasised at a meeting the good fit of both companies. Thorsten Schmidt, who has technical responsibility for BI consulting at noventum, is happy about how well the companies complement each other. „At noventum, to date, we have successfully completed very sophisticated and large BI projects. With the intimate insurance know-how of dibera, we are jointly the ideal consultants for the insurance industry.-
Read more … Challenges of the insurance industry, jointly approached with Business Intelligence

Asset management and strategic planning at grid companies (power utilities)
The asset management unit of a power utility bears responsibility for guaranteeing the security of the supply as well as for the long-term development and maintenance of the grid. In this, the focus is, on the one hand, on the development of maintenance and investment strategies that require an assessment of the grid components and a determination of their condition. On the other hand, budgeting and the planning of measures in coordination with the overall business planning comprise the second focal point.
Read more … Asset management and strategic planning at grid companies (power utilities)

noventum Corporate Management Dashboard
Independent of the management system used, the requirements posed to a tool for business management are the same. The purpose always is to support a corporate performance management cycle (PDCA cycle = Plan -- Do -- Check -- Act). The challenge is to ensure an overall picture for executive management.

The system and data world of SAP is facing great challenges
An interview with Carsten Fröning, Thorsten Schmidt and Otto-Jörg Schröder
novum: Mr. Schröder, you have been a part of the management of noventum consulting in the area of SAP consulting since November 2012. What is your specific focus and how does this change the noventum consulting Portfolio?
Read more … The system and data world of SAP is facing great challenges

Strategy of converging networks
The IT of the clinics of the future is faced with substantial challenges. Not only are huge amounts of data generated by new imaging processes, but these also need to be processed, presented, stored and archived. Now, at first glance this might not appear to be anything unusual. Of course, this is true for the data of a patient staying at the University Clinic. However, when the data of this patient is to be stored for the duration of said patient‘s life and if in addition also all the data that was not generated at the clinic is - in our example - to be stored in the patient‘s file, then the whole is becoming a challenge that can only be mastered with great difficulty.

SAP BusinessObjects Design Studio
In November 2012, SAP released the first version of Design Studio as the successor to the Web Application Designer (WAD) for customers. With the Design Studio, report applications for web browsers and mobile end devices can be created using an Eclipse-based graphical user interface. After the merger of SAP and BusinessObjects in 2008, the utmost efforts were made to integrate the worlds of SAP BW / Business Explorer (BEx) and BusinessObjects. With the introduction of the BI Platform 4.0 (BIP) and the BI Consumer Services (BICS) interface, a significant breakthrough was achieved. Still, when it comes to tools such as Web Intelligence using the BICS interface the integration with SAP BW leaves a lot to be desired in some areas.

Experience & demand for quality match perfectly
novum: noventum consulting and BOARD Deutschland are living a business partnership. What specifically is the basis of your cooperation?

Developing the optimal DWH scenario
In the implementation and consolidation of data warehouse (DWH) solutions, the decisions regarding a specific architecture, the software to be utilised, and BI governance are of strategic significance. Nevertheless, this issue is often considered very subjectively and the decision is influenced only by a few people – e.g., is software manufacturer ABC market leader in this industry.

SAP HANA – In-Memory-Technology
In-Memory Technology currently is one of the most interesting technical topics in information technology that will surely bring about several changes in the near future. At present, its main area of application is analytical systems that achieve an enormous performance gain from using In-Memory Technology. Additional areas of application are presently being tested and piloted at large manufacturers. Here, SAP is taking a very systematic, innovative path with its In-Memory solution HANA.

Enterprise Data Warehousing on SAP ERP – Where is SAP BusinessObjects positioned?
In 2007, SAP acquired the then market-leading (based on market shares) BI provider „BusinessObjects“, aiming with this at providing its own, high-performance BI solution. But the devil is in the details and the adaptation to the SAP world turned out to be more difficult than expected. It was only in September 2011 that the Walldorf company brought „SAP BI 4.0“ to the marketplace which is considered an important step for the integration of the SAP BusinessObjects BI solutions into the SAP BW world.
Read more … Enterprise Data Warehousing on SAP ERP – Where is SAP BusinessObjects positioned?

From Taylorism to EFQM – Business Control through Indicators
What does a performance measurement system have to do with quality? Anyone who intensely deals with this topic will soon find out: a great deal. Performance measurement system that is the new term for an indicator system. For a long time already, indicators and/or statistical measured values have been the undisputable proof for the quality of a product or process that is specified in advance.
Read more … From Taylorism to EFQM – Business Control through Indicators

Flexibility and Innovation in Indicator Systems – Controlling Profitability Analysis in SAP BW
The Controlling Profitability Analysis provides indicators that traditionally have been utilised for business management. Since companies are in this area also exposed to huge dynamics and an onslaught of information that has to be faced flexibly, traditional methods are increasingly reaching their limits. The question is, what could alternatives look like.

Business Intelligence Maturity Assessment
noventum consulting is conducting Business Intelligence Maturity Assessments based on a methodology that is utilising the Information Evolution Model to identify and measure an organisation’s current level of BI maturity. With this information, you can increase the value driven by Business Intelligence Investments and also achieve a competitive advantage.

Data Centre Cockpit
Interview: Dr. Matthias Rensing and Marco Nielinger (noventum consulting) with Prof. Dr. Gottfried Vossen (WWU)

Data Governance
Business decisions are based on data. It is quite a challenge to manage data cross-departmentally, to protect it, to use it profitably, and while doing so, to adhere to statutory requirements such as Sarbanes-Oxley (SOX), Basel II or HIPAA. According to a 2008 Gartner study, only 10 % of all businesses succeed in their first attempt to implement efficient processes that master this challenge.

noventum Business Intelligence – Spotlight on Current Topics
novum: Mr. Schmidt, let‘s start with one of the biggest challenges, data management in a Business Intelligence context. How are you positioned for this?
Read more … noventum Business Intelligence – Spotlight on Current Topics