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.
Business Intelligence, IT Processes and Organisation
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.
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.