Subscribe to DSC Newsletter

Avesh Dhakal's Blog Posts Tagged 'OLAP' (2)

Modelling a Data Warehouse

When designing a model for a data warehouse we should follow standard pattern, such as gathering requirements, building credentials and collecting a considerable quantity of information about the data or metadata. This helps to figure out the formation and scope of the data warehouse. This model of data warehouse is known as conceptual model. General elements for the model are fact and dimension tables. These tables will be related to each other which will help to identity relationships…

Continue

Added by Avesh Dhakal on June 8, 2014 at 7:54am — 1 Comment

Data Warehouse Architecture

According to Weisensee et al., Data warehouse architecture follows following principles:

  • Data Sources
  • Data Warehouses
  • Data Marts
  • Publication Services

Extraction, Transformation and Loading (ETL):

ETL process is the foundation of BI. Success and failure of BI projects depends upon ETL process. It plays a vital role to integrate and enhance the worth of data. After the extraction, cleansing and arrangement…

Continue

Added by Avesh Dhakal on May 20, 2014 at 12:30am — No Comments

Monthly Archives

2014

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service