Stationery Sales Analysis Using OLAP

Abstract

Today, business organizations need to know what’s going on in the market, and make the right foreseeing decision. To overcome this requirement, this system implements useful tools to analyze the Stationery Shop sales records on multidimensional database and data cube by using on-line analytical processing (OLAP) that can view or browse information from different angles. Data mining tools can analyze enormous sets of data and then extract the meaning of the data and the resulting information can provide for the decision making process. A data warehouse, a repository of long-term storage of data from multiple data sources, organized sources as to facilitate management decision making. It makes better and faster decisions and expected to present right information in the right place at the right time with the right cost to make the right decision. It can present implementation of data warehouse for stationery shop. OLAP is a methodology that support analysis and decision support system with aggregate values extract from daily transaction database. Data cube will be used for faster reports since they store the pre-computation of count of the transactions.