Author Archives: Cristina Klein

About Cristina Klein

SpagoBI Communications, Technical Innovation and Research Division, Engineering Group.

SpagoBI in Mindscape – Sales Datamart

Smile, a French IT company specialized in projects based on open source software has deployed SpagoBI for Mindscape, a leading editor of Casual video-games. SpagoBI allows top managers to analyse figures and dashboards based on the sales datamart. Data is extracted from the corporate ERP, aggregated with data from other information systems, and several calculation are performed to obtain new figures and analyses. The business intelligence portal with SpagoBI includes financial reports performed with BIRT, hypercubes based on Mondrian/JPivot, and a security management to authorize Continue reading →

Spago BI for the Healthcare. Budget Cards for ASL3 of Turin (Italy)

ESEL company of the Engineering Group, supplier on the market of Healthcare and Local Public Administration, has used SpagoBI at ASL 3 of Turin (Italy) for the innovation of the distribution system of the budget cards towards all the operative units of the hospital garrisons and territorial districts, enriching these with detailed information on the allocated services and carried out admissions. The solution imposes a significant behavioural model for outlining the users of various sections (Management and Quality Control, Informative System, Operative Departments and Units Continue reading →

SpagoBI for SGAR Midi-Pyrénées – LOLF: managing the financial indicators

ALTIC, the French open source software integration company, has implemented using SpagoBI a new application for SGAR Midi-Pyrénées (Public Administration Sector). The goal of SpagoBI LOLF is to manage the performance indicators of the administration. Under the European directives and the new financial law (LOLF: Loi organique relative aux lois de finances), the French administration must manage and follow the expenses and the budget with the performance indicators. Since these indicators do not always exist in information systems of the enterprises, it is necessary to Continue reading →

SpagoBI in Veneto Region – A DWH to support management policies of Veneto Region

The aim of the Veneto Region was to provide itself with an infrastructure to extract, transform and load data in order to feed datawarehouses and specific datamarts for analysis and reports. Looking for the technological solution, the Administration paid special attention to open source software solutions choosing in the end SpagoBI, the Business Intelligence platform. The application has been realized using a full open source stack; in fact, in addition to SpagoBI, operating system Linux RedHat, application server JBoss and DBMS PostgreSQL have been used. Continue reading →

SpagoBI for LemonOLAP – The statistical tool for LemonLDAP

ALTIC, the French open source software integration company, has implemented using SpagoBI the analytical tool for LemonOLAP. LemonOLAP provides a log parser based on regular expressions permitting to scan all kinds of logs. It is used with LemonLDAP, a webSSO that centralizes all requests from users to Web Applications, playing different roles : user authentications, access authorizations and secure data transfer (encryption via HTTPS). LemonLDAP is already used by 200.000 users everyday in the French Public Administration (e.g.: Gendarmerie, Ministry of Finance). Since it is Continue reading →

SpagoBI in Emilia Romagna Region – DWH for the monitoring of the regional labour market

SpagoBI is the platform chosen by Emilia Romagna Region to develop the monitoring model for the regional labour market, starting from data provided by the local information systems. Analysis are focused on the following working situations: employment (start, termination, transformation, extension of the job relationship) redundancy unemployment. The information distributed in the nine districts is collected by means of an ETL process, which fills up the regional data warehouse. Thanks to the virtual portals enabled by eXo Portal (the open source portal environment developed by Continue reading →