Comprehensive Data Warehousing

Data-Core was responsible for a comprehensive data warehousing project for one of its premier clients. It involved the creation of a data warehouse, a datamart, and prefabricated reports. As a result of this implementation, end users were able to build ad hoc reports.

Study and Systems Analysis

As in any SDLC, the first step involved Requirement Analysis. This Client has an intermediate team, the Functional Team, which interfaces with end users to gather and document business requirements. Data-Core Systems’ analysts created the functional specifications as an end result of this exercise.

Detailed Design

The detailed design phase involved:

Specific Functionalities


Defining the OLAP Analysis Requirements

Data architecting & data modeling

Validation & activation of MDG Hub

Designing Datamart

For effective Datamart design, Data-Core used the Dimensional Analysis Document, Measures, Prefabricated Reports requirements and foreseeable future enhancements. The deliverables included dimension table design, a definition of slowly changing dimensions to maintain history, fact table design (measures are stored in fact tables), the Datamart Model in Snowflake Schema, the table keys, constraints and relationships, and the security model with embedded data which is required for secure transactions.

Project went live within 3 months

20% Saved in labor effort

Timely implementation & development