Subscribe to DSC Newsletter

Avesh Dhakal's Blog (8)

Success factor of the data warehouse and business intelligence implementation

Data warehousing project is a complicated task that demands goals and resources from both business and technical departments. It is expensive but normally a basic project. If it is done by non experts and non skilled support, it can be an expensive and may cause project failure. Several business analysts believed most of the data warehousing projects are unsuccessful to meet their proposed objectives (Furlow, 2001).

Hwang and Xu (2007) have chosen eleven success…

Continue

Added by Avesh Dhakal on June 16, 2014 at 2:30am — No Comments

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

Dimensional Modelling

There isn’t any specific standard to model data warehouse. It can be built either using the “dimensional” model or the “normalised” model methodologies. Normalised model normalises the data into third normal form (3NF) whereas dimensional model collects the transactional data in the form of facts and dimensions. Normalised model is easy to use as we can add related topics without affecting the existing data. But one must have good knowledge of how data is associated before performing…

Continue

Added by Avesh Dhakal on May 29, 2014 at 4:12am — No Comments

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

Business Intelligence Architecture

According to the Asghar et al. (2009), Business Intelligence (BI) is divided into two main parts: (a) BI dimension and (b) BI process. Knowledge, functionality, technology, business and organisation are categorised under BI dimension. The performance of data sources, data warehousing, ETL, OLAPS and other related tools are categorised under BI process. Basically, dimensions and processes are interrelated to form a complete life cycle of BI system…

Continue

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

Benefits of Data warehouse and Business Intelligence

The prime benefit of data warehousing is simplicity. The presentation of data in data warehousing is a single image. This single image is made by collecting data from different department of the organisation. Due to this, time for production and operation of data reduces and thus simplifies the decision making as well. This reduction of time to access data also leads to increase in production and effectiveness. Data warehouse will also help to enhance the function of operational systems. It…

Continue

Added by Avesh Dhakal on May 4, 2014 at 9:30pm — No Comments

Business Intelligence Value Chain

BI is a group of concepts, methods and procedures for making better business decisions using information from several sources and applying knowledge and presumptions to build up a precise understanding of business. It gathers, manages and analyse the raw data for making good understanding/understandable information for…

Continue

Added by Avesh Dhakal on April 28, 2014 at 9:00am — No Comments

Business Intelligence and Data Warehousing

In the modern era, business environment is changing rapidly. They are seeking for valuable business information as being essential assets which will not only lead organisation towards the path of success but also help to sustain business in a competitive environment. Business Intelligence (BI) is a model which relates managerial values, and a tool which is used in an organisation to handle and filter information in order to make healthy business decisions. It refers to the appropriate…

Continue

Added by Avesh Dhakal on April 18, 2014 at 9:30pm — No Comments

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

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