![]() It also enhances operational efficiency by analysing data from various sources and with BI solution. Data warehouse mainly enables to make informed decisions rapidly with key initiatives and thus saving time. These insights provide decision makers with a competitive edge over other and can help in business growth. Customization of data warehouse system is required for making decision as per the customer needs, buying trends, operation efficiency, favourable customer experience, loyalty and retention of customers along with anticipating demand for efficient inventory management, cash management and increasing overall profitability. Even with the availability of some data warehouse products such as Oracle Warehouse Builder, IBM Visual Warehouse, and NCR designed for Walmart stores, it becomes difficult for many growing supermarkets to buy these and access without any language barrier or lack of skill. Typically the storage capacity of traditional DBMS system is in the range of millions and is a major bottleneck for supermarket with huge amount of heterogeneous and decentralized data to store and process as the resources are waste. Computer terminals are mainly set up to process big chunk of everyday data, and this data is significantly increasing day by day. The expansion of supermarket chain at an alarming rate has resulted in a progressively competitive market. Keywords: Data Warehouse, Extraction, Transform, Pentaho, Mondrian, Supermarket ![]() The results provide with the representation of data with respect to four measures considered, namely, actual and original sales, profit and discount with respect to various dimensions. Such a model is necessary for making key decisions and strategic planning for a supermarket. This paper uses Pentaho for analysis and results are generated by modifying the mdx queries using different charts available. The data needs to be cleaned before applying to the analysis tools. The data is modelled in different dimensions. Different products based on their shelf life and stock available is considered. Dataset of customer contains considerable information from various cities of Canada. ![]() In this paper, analysis of profit generated with the sales is provided along with various structures to support the reasoning. ![]() The analysis provides the sales and profit generated by the supermarket based on the data such as product, customer and time. Dhanashri Gujar & Siddhaling Urolagin Department of Computer Science, Birla Institute of Technology and Science, Pilani Dubai, United Arab EmiratesĪbstract – This study represents the design and development of data warehouse for supermarket data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |