NOVUM ONLINE – THE
IT MANAGEMENT MAGAZINE OF NOVENTUM CONSULTING
News from the information technology, current trends in the IT industry, concrete projects of noventum consulting and its partners, dedicated comments and interesting events from the everyday IT Management.
Digital Transformation, Digitalisierung, HR-IT-Management
Growth, mergers, and other large changes quite often present challenging tasks to HR departments. Frequently, the requirements posed to modern personnel management processes as well as to analysis and planning functionalities can no longer be accomplished by simple means. The nobilia company was faced with such as challenge as well. Traditionally, working with Excel, various databases, and e-mail, HR management established a technologically state-of-the-art foundation for its work with the PERSIS personnel management software. With their extensive PERSIS know-how, the HR management consultants of noventum consulting were able to decisively contribute to the project’s design.
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.
The outsourcing market already reached ever new record levels in the past, both domestically and internationally. The number and complexity of provider agreements keeps increasing, so do the challenges for the IT procurement department. Not only does the latter have to master shorter sourcing cycles, but ever more frequently said department is also taking on the role of provider management. In the future, the IT procurement department – as central bearer of know-how – will decisively co-determine what’s going on in sourcing in the company. Whether or not the department assumes the leading role will, to a certain extent, depend on who within the company is one step ahead in terms of specialist knowledge.
Quite often, SharePoint projects are conceptualised and set up to mirror their technical capabilities. In many companies, the initiative for such projects originates from the technical department which considers SharePoint no different from any other software product and rolls it out. In this, questions regarding the “why” and “what for” are often asked too late. As such, failure over the short or long term is pre-programmed, given that the SharePoint technology is considerably meshing with the internal communication and collaboration processes. That, however, requires the support of all parties involved, from the responsible manager all the way to the user side.
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.
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.
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.