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.
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.
For most companies the use of cloud services is initially often a step-by-step experiment. Based on individual accounts with one of the major cloud providers, various employees explore the possibilities and get an idea of what might be of interest to their company or department. Even these first explorations are usually subject to a fee. In order to keep an eye on where the journey is going financially, this initial option testing has to be tackled systematically. Such a plan is mandatory for a later widespread use of the cloud. Large providers such as AWS or Azure have usually planned the first steps for new customers diligently. With a Trusted Advisor, such as that found at AWS, the first steps are quickly and safely taken.