Business Intelligence concepts

1)   Benefits of Implementing EDW at Isle

Overview

Enterprise Data Warehouse (also known as Data Warehouse) is a collection of databases of a business establishment, collected from various sources and operational branches of the said business, and available in a standard format so that it can be analyzed, and used up for preparing reports. (Rahman (2016).

Implementing EDW at Isle

Isle of Capri Casinos was one of the largest publicly traded gaming companies of the United States. Its headquarters were located at Creve Coeur, St Louis, Missouri. The company was founded in 1992 and went defunct in May 2017. Isle found a way to make its hospitality and entertainment aspect more than what customer might anticipate. Before implementing EDW, the casino managers had to wait for next month to review the monthly data of the previous month. This time gap made it difficult for the casinos to identify which actions were suitable to provide customer appeal (Taneja (2016).

Advantages

After the implementation of EDW, it had the following advantages:

• Managers had access to monthly, weekly and daily reports instead of the five-week-old reports
• The reports had the data categorized, which made it easier for the managers to focus on a particular problem and find out the reason for it.
• Comparing the performances of the properties became easier
• Managers could submit a query and receive rely within minutes on upon
• The company could offer incentives to customers which they value

Other potential benefits

Earlier, gaming establishment managers had the same amount of information about the customer of that establishment which their competitors had. EDW enabled Isle to gain more knowledge than others, and as a result, all the other competitors suffered losses. Furthermore, the management of the company became more equipped in anticipating the future needs of the business as compared to others.

2) Relational Online Analytical Processing (ROLAP)

ROLAP is an analytical processing method that deals with the relational databases and does not require previous computations for it. Relational tables and new table are created to hold the information whereas the base data and the dimension tables are stored. The query response time and the data processing time is usually slower in this process.

Multidimensional Online Analytical Processing (MOLAP)

MOLAP is an analytical processing method which enables the division and a copy of its source information which is saved in a multidimensional operation in the analysis services after the separation process is complete. Aggregations can be used to reduce the query response time in this process.

Hybrid Online Analytical Processing (HOLAP)

HOLAP is an analytical processing method which has the combined attributes of ROLAP and MOLAP. It enables the aggregation of the division and allows it to be stored in an SQL server analysis. Usually, the queries take a shorter time, but the queries which seek to access the source record takes more time.

Differences from Online Analytical Processing(OLAP)

OLAP is a process of answering multi-dimensional analytical queries quickly in computing processes. OLAP is mainly used in business reporting, budgeting, forecasting processes, financial reporting, management reporting and others. OLAP accesses multidimensional data from a different perspective, and unlike ROLAP, MOLAP and HOLAP involve the aggregation of data that can be computed in one or more dimensions. ROLAP generally stores the data in the form of relational tables, whereas MOLAP stores the data in a multidimensional array. (Nanda, Gupta and Vijrania (2019)

References

Nanda, A., Gupta, S., & Vijrania, M. (2019, June). A Comprehensive Survey of OLAP: Recent Trends. In 2019 3rd International conference on Electronics, Communication and Aerospace Technology (ICECA) (pp. 425-430). IEEE.

Rahman, N. (2016). Enterprise data warehouse governance best practices. International Journal of Knowledge-Based Organizations (IJKBO), 6(2), 21-37.

Taneja, N. K. (2016). Opportunities for Overcoming Hurdles. In The Passenger Has Gone Digital and Mobile (pp. 209-238). Routledge.