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.
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.
The detailed design phase involved:
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.
Data-Core carried out the following in this stage of the project: