Implementation of Data Mart using OLAP with University Fact Constellation Schema

Abstract

Business Intelligence, the process of gathering, storing and analyzing data, building knowledge from the analysis and taking action based on the knowledge is the single most powerful success factor in business today. Organizations are forced to make decision and the urgency of data becomes significant. A data mart is a set of subject areas organized for decision making support based on specific needs of a group of business users or department. The common analysis and report could be performed to the data mart for multi-dimensional analysis and reporting.A stand-alone data mart focuses exclusively on one subject area and it is not designed in an enterprise context. Our system tends to provide fast, consistent and interactive access to information of OLAP University independent Data Mart using fact constellation schema.