At SAPIENCE™ consulting, we follow “data warehouse bus methodology” to implement reliable and cost effective Data warehouse solutions. The methodology includes movement along the following phases.

• Data warehouse analysis/Business Requirements
• Data warehouse design/Dimensional Modeling
• Meta data management
• Integration Strategy
• Development
• Testing
• End user acceptance/Project reviews

Design level
At the design level, we follow the ‘coordinated data marts’ approach based on iterative and incremental subject area marts coordinated through ‘shared dimensions’ approach.