Clients
Successful cases
Since 2012, the Ministry of Planning, Budget and Management is investing in the area of Governance and Data Management, in order to provide integration between its various systems, synchronization of numerous metadata catalogs throughout the Federal Government and the construction of a Business Intelligence layer. For this, the Ministry of Planning, Budget and Management opted for the acquisition of the ETL tool Talend Enterprise Data Quality and the use of other tools already acquired previously. Products built by Splenda provided to the Ministry of Planning, Budget and Management centralization, integration, synchronization and easy manipulation of data and metadata.
In 2014, the National Terrestrial Transport Agency (ANTT) decided to invest in building a Business Intelligence layer, in order to provide greater autonomy and flexibility in decision-making of their managers. To this end, ANTT chose to use Talend Open Studio, an open source ETL tool, and Oracle Business Intelligence Enterprise Edition (OBIEE), OLAP software. The product built by Splenda has provided users with a centralized visibility of key Agency issues such as: Railway Transport (concessions), Road Transport (passengers, permittees, chartering, OTM, fleet) and River Ports.
In 2011, the seat of federal power in Porto Alegre decided to build a business intelligence layer, in order to provide greater autonomy and agility to the judges and parties involved in a particular lawsuit. To this end, the TRF4 chose to purchase the following software: Talend Enterprise Integration (ETL), MicroStrategy (OLAP) and Netezza Appliance (Storage). The product built by Splenda provided a centralized and homogeneous integration of physical and electronic processes of the first and second degree. Thus, the TRF4 began to receive information in consultations in a more effective way at various levels, accurately and updated.
In 2011, the seat of executive power of the municipality of São Bernardo do Campo decided to build a business intelligence layer, in order to equip its directors, secretaries and advisors data and information relevant to decision making. To this end, PMSBC chose to purchase the ETL tool Talend Enterprise Integration and to use the OLAP tool, Oracle Business Intelligence Enterprise Edition (OBIEE). The product built by Splenda has provided users with centralized visibility of all the affairs of the Municipality, such as expenses, revenues, treasury, workforce, payroll, supplements and cancellation, among others.
Services provided
-
Analysis and mapping of data sources.
-
Synchronization of metadata catalogs.
-
Dimensional and relational modeling.
-
Preparation of ETL processes.
-
Management and monitoring of ETL processes.
-
Training for analysts in the ETL tool.
Services provided
-
Analysis and mapping of data sources.
-
Creation and configuration of the infrastructure.
-
Dimensional modeling of the modules.
-
Creation of Data Warehouse (DW).
-
Preparation of ETL processes.
-
Construction of reports, dashboards, and more.
-
Training for analysts in OLAP tool.
Services provided
-
Analysis and mapping of data sources.
-
Creation and configuration of the infrastructure.
-
Dimensional modeling of the modules.
-
Creation of Data Warehouse (DW).
-
Preparation of ETL processes.
-
Construction of reports, dashboards, and more.
-
Creation of users in the OLAP tool.
-
Training for analysts in OLAP tool.
Services provided
-
Analysis and mapping of data sources.
-
Creation and configuration of the infrastructure .
-
Dimensional modeling of the modules.
-
Creation of Data Warehouse (DW).
-
Preparation of ETL processes.
-
Construction of reports, dashboards, and more.
-
Creation of users in the OLAP tool.
-
Training for analysts in OLAP tool.