Methodology

CRMT DW/BI Methodology is built as a set of frameworks for different BI projects: data integration (ETL Framework), data warehouse (DW Framework) and Business Intelligence (BI Framework).

By using our Frameworks, you will not only accomplish your projects faster but will also gain its built-in best practice knowledge on building the DW/BI systems.

Advantages of the CRMT frameworks:

•   quicker execution of the project
•   best practices
•   standardized architecture
•   standardized naming convention
•   coverage of the entire system implementation lifecycle, from planning, building, testing to maintenance

Frameworks are built on following features:

ETL Framework

•   Best practices based on technology
•   Vendor products independent
•   Standardized Architecture
•   Data flow (Source, Stage, Data Quality, MDM, DW, Data Mart)
•   Initial and incremental data load
•   Real Time data load
•   Naming Convention
•   Auditing
•   Notification and Alerts (ETL Job status, Missing data)

DW Framework

•   Data analysis (user requirements and data realities)
•   Standardized Architecture (Enterprise Data Warehouse, Data Marts)
•   Naming Convention
•   Best practice multidimensional model based on BI platform (MicroStrategy, Cognos, Business Objects, OBIE)

BI Framework

•   Naming Convention
•   Best practice BI platform configuration (installation and configuration) based on technology (MicroStrategy, Cognos, Business Objects, OBIE)
•   Monitoring BI usage