Tag Archives: metastudio

Airlines. Centralized Customer File.

Building and implementation of Central Index of Contractors – integration of sale systems data, customer service and CRM.   „We have a wealth of information about our clients but... we don't know much about them. Sometimes it is hard for me to tell which data are about which customer.” This in not a rare case…
Continue reading

Utilities. Customer data cleansing.

  With over six million customer records, manual verification was out of the question, all the more so given that manual data correction does not guarantee full correctness. It was necessary to develop automatic data quality improvement mechanisms. One of the main challenges faced by our Client, a leading electricity distributor in Poland, in introducing…
Continue reading

Finance. Operational Data Store.

Creation of the Operational Data Store (ODS) layer of a Data Warehouse in a financial institution – a leading debt collection and restructuring corporation. The purpose of this project, in addition to the creation of a central operational data repository for analytical and reporting purposes, was to build mechanisms of automatic generation of data loading…
Continue reading

Banking. Metadata management.

Delivery of Metastudio - a solution for the management of reference data, dictionaries and rules for the purpose of control of quality and completeness of data in a corporate Data Warehouse. The client is a leading financial institution – a universal bank listed on the Warsaw Stock Exchange.
Continue reading

Banking. Data cleansing.

  Sanmargar completed a project involving comprehensive and automatic improvement of the quality of data of the Bank’s customers, including master data and identification data, ID document data, address and phone details, data on links and relations between customers, and classification data. The number of bank customer data records involved in this project was more…
Continue reading

Banking. Metastudio.

Delivery of Metastudio - a solution for the management of reference data, dictionaries and rules for the purpose of control of quality and completeness of data in a corporate Data Warehouse. The client is a leading financial institution – a universal bank listed on the Warsaw Stock Exchange. Thanks to the use of Metastudio, the…
Continue reading

Coal Mining. Analytical Platform.

Sanmargar created a controlling data warehouse and an analytical and reporting platform for our Client – Europe's biggest producer of coking coal. The delivery of an effective reporting and data analysis tool to Controlling responded to the needs of the new operational controlling concept. It significantly expanded the scope of data of interest to the…
Continue reading

Telco. Metastudio.

A project involving the delivery and implementation of a Metastudio reference data management solution at a media and telecommunication consortium. In the first phase of the project, the solution will be used in the management of Data Warehouse dictionaries and data processing processes. #metastudio #referencedata
Continue reading

Media. ERP data migration.

Our consultants took part in a project involving the migration of historical data from many different single-area systems to a newly implemented ERP-class system. The client was a media concern listed on the Warsaw Stock Exchange. Sanmargar was responsible for the development of the processes for the extraction of data from the systems that were…
Continue reading

Coal Mining. Planning and Budgeting.

Sanmargar implemented a system of operational controlling support in the area of planning and budgeting processes for the EU's biggest coking coal producer. The implementation involved the design of a complex planning model, describing complex processes involved in coal mining and processing, as well as its creation using Oracle Hyperion Planning technology. Our work reflected…
Continue reading