Generate data warehouse matrix

Apply for Business Intelligence Certification Now!!

Data warehouse design is never a simple concept. A data warehouse is composed of several databases, which contain highly secure and crucial data for an organization. One of the important features of data warehouse is that it is central. That means, if your organization is spread into different geographical locations, then might be every office has its own database, but the organization needs a central database to establish communication between all the offices and to keep in synchronized to serve all their business requirements. The scope of data warehouse is not limited. It can also be used to provide the detailed analysis report as listed in business requirements.

The architecture of data warehouse is composed of four interlinked components

  • Application
  • Data
  • Security
  • Process of an organization.

The graphical representation of these components is shown below.

generate-data-warehouse-matrix

Fig 10.1: Data warehouse design

http://www.vskills.in/certification/Certified-Business-Intelligence-Professional

Go back to Tutorial

Share this post
[social_warfare]
Hardware and Software Selection
Dimensional modeling and ETL

Get industry recognized certification – Contact us

keyboard_arrow_up