The business teams needed to have a detailed and strategic dashboard to allow the ICT top managers (CIO and first business levels) to monitor data and information coming from multiple sources, with the aim of having full control, through a single point of access, over the activities performance, contracts spending and the ICT area overall. In particular:
Different ETL procedures and a Data Quality process have been realized on the backend side. Thanks to that, heterogeneous and fragmented data, coming from different data sources, have been integrated. Data have been cleaned up, normalized, filtered and reorganized in order to make them homogeneous and transform them into a proper storage format/structure for the business intelligence analysis. Data flows have been stored into data structures within the Corporate Data Warehouse, a cloud and distributed Database.
The design and the implementation activities for the data warehouse structures and the application involve:
• The developed application is responsive and mobile oriented: it allows you to browse easily through the different reports and pages having the ICT big amount of data just a click away.
• It can be reused in different context, regardless the industry. It tracks data and KPIs common to all IT departments.
• It is strategic: it provides the quickest overview that decision makers need to monitor the health and opportunities of the business.
• It offers a user-friendly interface that facilitates analysis of data correlations: through the drill down functionality you can navigate to lower-level data and access to additional information on the managed applications.