What are the approaches of the Business Dimensional Lifecycle?

There are various approaches of Business Dimensional Lifecycle which are as follows −

Project planning − Project planning addresses the description and scoping of the data warehouse project, such as readiness evaluation and business justification. These are the tasks because of the high visibility and costs related to data warehouse projects.

Project planning targets resource and skill-level staffing requirements, coupled with project task assignments, continuation, and sequencing. The resulting integrated project plan recognizes all tasks related to the Business Dimensional Lifecycle and the parties included. It can deliver as the foundation for the ongoing administration of the data warehouse project. Project planning is vulnerable to the business requirements, as indicated by the two-way arrow between these activities.

Dimensional Modeling − The description of the business requirements decides the data required to address business user’s systematic requirements. Designing data models to provide these analyses needed multiple approaches than that used for operational systems design.

It can start by constructing a matrix that defines key business processes and their dimensionality. The matrix provides a scheme to provide that the data warehouse is extensible across the organization over time.

Physical Design − Physical database design targets representing the physical architecture necessary to provide the logical database design. The component of this process includes representing naming standards and setting up the database environment. Preliminary indexing and partitioning methods are also decided.

Data Staging Design and Development − The data staging design and development process is generally the most neglected data warehouse project task. The data staging process has three steps are extraction, transformation, and load. The extract process continually reveals data quality problems that have been covered within the operational source systems.

Product Selection and Installation − Using the technical structure design as a framework, specific architectural elements including the hardware platform, database management system, data staging tool, or data access tool will be required to be computed and selected.

A standard technical computation process is represented along with specific computation elements for each architectural element. Because the products have been computed and selected, they are set up and thoroughly tested to provide appropriate end-to-end integration within the data warehouse environment.

End-User Application Specification − It is representing a group of standard end-user applications because not all business users required ad hoc access to the data warehouse. Application specifications define the document template, user-driven parameters, and required computations. These specifications provide that the development team and business user’s have a frequent understanding of the applications to be delivered.

Deployment − Deployment defines the convergence of technology, data, and enduser applications available from the business users desktop. Extensive planning is needed to provide that these puzzle pieces fit correctly.