Method and system of data warehousing and building business intelligence using a data storage model

A data migration, data integration, data warehousing, and business intelligence system comprising:

• a profiling process area;
• a cleansing process area;
• a data loading process area;
• a business rules and integration process area;
• a propagation, aggregation, and subject area breakout process area;
• and
• a business intelligence and decision support systems process area.

A data migration, data integration, data warehousing, and business intelligence system comprising:

• a staging area;
• a data vault;
• a data mart;
• a metrics repository;
• and
• a metadata repository.

A method of implementing a data migration, data integration, data warehousing, and business intelligence system, the method comprising:

• providing an implementation team, wherein the implementation team includes
• a project manager whose function is to manage the implementation of the data migration, data integration, data warehousing, and business intelligence system at client sites,
• a business analyst whose function is to interface with end-users, collecting, consolidating, organizing, and prioritizing business needs of the end-users,
• a systems architect whose function is to provide a blueprint for the hardware, software, and interfaces that defines the flow of data between components of the data migration, data integration, data warehousing, and business intelligence system,
• a data modeler/data architect whose function is to model and document source systems and business requirements of the end-users,
• a data migration expert whose function is to determine and develop the best solution to migrate and integrate data from the various sources systems, and
• a DSS/OLAP expert whose function is to determine and develop the best reporting solution or DSS based on end-user business requirements and to implement any OLAP tools selected for use in the data migration, data integration, data warehousing, and business intelligence system;
• allowing the members of the implementation team to perform the function they are trained to perform in a specialized manner;
• providing mentoring, cross-training, and support through the course of implementing the data migration, data integration, data warehousing, and business intelligence system;
• and
• leaving the end-users with documentation and deliverables for maintaining and expanding the data migration, data integration, data warehousing, and business intelligence system.

A data storage device for housing data from functional areas of an enterprise, the data storage device comprising:

• at least two hubs, wherein each of the at least two hubs includes a primary key, a stamp indicating the loading time of the primary key in the hub, and a record source indicating the source of the primary key;
• at least two satellites, wherein each of the at least two satellites is coupled to at least one of the at least two hubs in a parent-child relationship, further wherein each satellite includes a stamp indicating the loading time of data in the satellite and a business function;
• a link to provide a one-to-many relationship between two of the at least two hubs;
• and
• a detail table coupled to at least one of the at least two hubs, wherein the detail table includes attributes of the data from the functional areas of the enterprise.