Starschema

Data warehouses and the connected data marts are the sources for reliable and consistent data for companies. Contrary to other IT systems, during it's life cycle - which can be even decades, because of legal regulations - data warehouses are expected to adapt many business and infrastructure changes, to keep up the data quality and consistence for current and historical data at the same time.

Data warehousing goals are not just to store and integrate source system (billing, manufacturing, hr, finance, etc.) data, but also to support easy and effective access to reliable and consistent information for every authorized entity of the company, while costs of storing and maintaining the data remains low.

Starschema consultants are ready to provide high class, full scale data warehousing services eg. on the following areas:

• Business need identification, requirement gathering
• Creating data warehouse strategy
• Planning data warehouses, architecture, data and processing model, operational processes
• Source system evaluation, source data mapping
• Data dictionary creation, Maintenance front-end development for DDs
• Design and development data warehouse meta-data management systems
• ETL design and development (for large DW implementations the biggest part of ETL processes we usually generate from meta-data system)
• Source-to-target mapping generation, re-engineering and documentation of black-box data processing systems
• Create or generate documentation for DW systems
• Creation of aggregates or business need specific data marts
• Creation of multidimensional DW solutions (MOLAP, ROLAP)
• Data integration from multiple sources, multiple platforms
• Data processing and structuring from different, non-structured sources (text files, excels, logs, etc.)
• Optimization of DW systems, load window performances, storage areas, operational processes, technology platforms
• Migration of full data warehouse solutions between platforms

We deliver our data warehousing services with the following technologies:

• Oracle
• MS SQL
• SAP BusinessObjects
• Greenplum
• Opensource platforms (PostgreSQL, MySQL, Talend, Jasper, Pentaho)