The GeoDAT Data Warehouse - Builder is a tool that supports all phases of data warehouse development starting with data warehouse analysis, creation and final loading processes.
All relevant information during analysis and modelling phases are stored in a meta database. This avoid all media disruption and automatically logs every change within analysis and modelling phases in separate databases.
Every phase can be checked immediately for expected results.
- Central model information’s
- Modelling source data
- Modelling transformations
- Modelling transformed data for the data warehouse
- Modelling the data warehouse
- Milestones / checking results (ETL)
The GeoDAT Data Warehouse - Builder supports spiral development model and cascading development of modifications. Any modelling phase can be repeated at any time, changes and extensions can be incorporated.
All Information can be viewed and edited at any time. No special modelling skills required and extensive programming is avoided. Required test phases are minimized.
The GeoDAT Data Warehouse - Builder leads you through all required phases, displaying source data contents and supports step by step creation of simple or complex models.
For instance a data warehouse with one fact table and dimensions associated as a star scheme can be extended step by step later on, adding fact tables and hierarchical dimensions to build a snow flake scheme.
