Business Intelligence Systems Analysis for Hotel Chain Report

This report analyzes the application of business intelligence (BI) systems within a hotel chain, focusing on how data warehousing, data mining, and intelligent agents can enhance competitiveness. The report begins by discussing the creation of a data warehouse for a supermarket chain, detailing how data mining supports product ordering, budget preparation, and expense monitoring. It then identifies issues related to the use of ETL tools in transferring data to a data warehouse, such as challenges in change data capture and data processing inefficiencies. The report further explores how data is stored in the database and data warehouse of a decision support system within a hotel chain. The benefits of using intelligent agent systems to search the websites of other hotels are also examined, with a focus on how these agents collect data to inform pricing strategies and improve services. The report highlights how intelligent agents can help hotels gather market intelligence, track competitor pricing, and ultimately improve customer satisfaction and profitability. Finally, the report provides the references used.

Business Intelligence Systems
1

Contents
Question-3........................................................................................................................................3
Question-4........................................................................................................................................4
4.3 Describe that how data collected by intelligent agent system that assists in making this
hotel more competitive in terms of sport, restaurant facilities and its pricing............................5
REFERENCES................................................................................................................................7
2

Question-3
3.1 Discuss how creation of data warehouse for supermarket that assists data mining for
supermarket chain. How data mining that can assists in product ordering, budget preparation,
expense monitoring for supermarket chain.
A data warehouse is based on the database designed to support decision making in the
organization. It assists that data mining for collecting large amount of information or data related
customer details, product and services (Adler, 2020). By utilizing data warehouse, supermarket
chain embark on customer specific strategies such as segmentation, profiting and cross-selling.
Data mining is based on the concept that collected by supermarket chain grows by rounds
and leaps. There are large amount of data increasing year after year. It may pay offs in
uncovering hidden information behind the data. It is way to gain the market intelligence by
handling different operations such as product ordering, budget preparation and expense
monitoring entire supermarket chain (Ahmad, Miskon and Tlili, 2020). Data mining is mainly
deals with structured data organised in database that are collected within data warehouse. It
assists that data warehouse allows to process, analysing the customer buying preference, time,
overall budget cycles. In order to improve the uncover anomalies, exceptions, irregularities and
trends which providing the better service to customer.
Monitoring and budget preparation is key important factor that always supports for
identifying an appropriate information. Afterwards, it has been reduced to the wastage in hotel
enterprises.
By using example, it can easily clarifying the actual use of data mining within retail
supermarket chain. Data mining is its use in supermarket chain of sales department. If store or
collect and track the purchase of customer and notice that client purchase products (Wieder and
Ossimitz, 2019). Therefore, data mining system will make correlation between customer and
product where sales department will look at information and may begin direct mail marketing.
3.2 identify the issues related to use of data transformation tools ETL for transferring data from
supermarket to data warehouse.
Extraction Transformation loading software is based on the tool or platform that transforms
the data and finally load into data warehouse system. In supermarket chain. ETL process can be
performed the specific role where data is extracted from source system into different areas
(Ahmed, Amroush and Maati, 2019). Irrespective of tool used, extraction should not affect on the
3

overall performance which response time of source systems. In supermarket chain, it
automatically control the live production databases and slow down, locking the retail bottom
line. There are different issue and problem related to the use of ETL tool in supermarket chain.
 The challenge the way change data that are captured for constantly update, loaded
without becoming overloaded (Wieder and Ossimitz, 2019). Therefore, ETL cover lack
of sematic when processing entity resolution for data stream.
 Another issue is that when large amount of data carried into data warehouse after
transformation which become similar and inefficient processing. In this way, it directly
affects on the overall performance of supermarket activities (Mola, Rossignoli and
Giangreco, 2020).
 In supermarket chain, it has increased the issues when overlap occurred while loading
and mitigate impact from OLAP internal inconsistency (Wieder and Ossimitz, 2019). If
task overlapped in data warehouse, it would cause the performance of degradation. In
order to generate wrong query result or outcome.
Question-4
4.1 Discuss that how data required to be stored in database and data warehouse of decision
support system within hotel chain.
The hotel chain is continuously collect or gather variety of data from outside such as
occupancy rate/price, customer satisfaction feedback and booking details. Therefore, the data
ware house collected data which analysed to generate information that would be managed by
decision support system. It provide the facilities and services where customer select new hotels,
allocating advertising spending geographically (Wieder and Ossimitz, 2019). Sometimes, it is
able to track the market share and setting prices. Data ware house support for maintaining
customer information system which allows the chain to pull together about the preference,
demands.
On the other hand, data warehouse also records the marketing information of hotel chain
and accelerating the growth of business in global marketplace. A data warehouse is based on the
centralized database that consolidates hotel chain from variety of business operational system
(Wieder and Ossimitz, 2019). In some situation, it allows for Decision support system to check
the review of customer, employee and then after taken important decision related business
growth.
4

4.2 determine the benefits of using intelligent agent system to search website of other hotels.
The intelligent agent system is based on the modern technology that are used the computer
system to deliberate intelligence. It is one of AI application which help for recognized as fastest
growing area of next generation.
The benefits of intelligent system where provide facilities of person that can use
smartphone, to access information through internet. In order to identify variety of hotels and their
services. There are various hotel chain enterprise uses modern technology to explore their
business capabilities in marketplace (Mola, Rossignoli and Giangreco, 2020). The intelligent
agent technology has emerged with hotel industries in term of problem-solving computational
entities. It capable of effective operation in both dynamic as well as environment.
Another benefit is that when existing customer can access information to check the
booking status and location of hotel, sport and restaurant facilities and room prices in other
hotels. In order to find out the best hotel at reasonable price (Mola, Rossignoli and Giangreco,
2020). In this way, intelligent agent system to track various website of hotel so that it become
easier for customer to find out best one. Moreover, the overall process flow of intelligent agent
based on search and secure room booking which has been shown in the form charts. In this way,
user can easily access the application from mobile phone and other hardware devices over
internet.
4.3 Describe that how data collected by intelligent agent system that assists in making this hotel
more competitive in terms of sport, restaurant facilities and its pricing.
An intelligent agent is a software program that supports more users with accomplishment
of some different task or activity. It is mainly collecting large amount of information or data over
internet. In order to establish the communication with other agent but it’s depending on the
program.
Intelligent system that assists in making this hotel more competitive in terms of sport,
restaurant facilities and its pricing. So that they can collect the information about the sales to
track the demand of product and service (Mola, Rossignoli and Giangreco, 2020). In order to
know about market share, engage in the competitive knowledge mining. Afterwards, Hotel chain
will obtain the more knowledge through collaboration from buyer agents. Furthermore,
intelligent agent system help hotel enterprise in term of electronic environment to gain the
5

intelligence on market. Afterwards, it will create the intimate relationship with existing potential
customers.
Apart from that hotel provide the facilities of sport, restaurant services in order to gain
competitive advantage. Therefore, pricing plays huge role in the customer business but especially
when hotel increase their profitability and productivity in global marketplace. Intelligent agent
track the price details of another hotels and then afterwards setting the price strategy for business
expansion (Mola, Rossignoli and Giangreco, 2020) . For Example- in hotel industry, intelligent
agent system always supports for identifying the booking rates, price of another hotel they can
adjusting and managing the revenue on the basis of customer demand. Moreover, sales record
should be representing the complex situation whereas improve the business performance and
efficiency in proper manner. This will be monitored and tracked by intelligent agent system in
hotel chain enterprise.
6

REFERENCES
Book and Journals
Adler, R.M., 2020. Business Intelligence, Analytics, and Their Discontents. In Bending the Law
of Unintended Consequences (pp. 95-105). Springer, Cham.
Ahmad, S., Miskon, S.and Tlili, I., 2020. Towards Sustainable Textile and Apparel Industry:
Exploring the Role of Business Intelligence Systems in the Era of Industry
4.0. Sustainability. 12(7). p.2632.
Ahmed, B.S., Amroush, F. and Maati, M.B., 2019. The Intelligence of E-CRM Applications and
Approaches on Online Shopping Industry. In Advanced Methodologies and Technologies
in Digital Marketing and Entrepreneurship (pp. 70-82). IGI Global.
Mola, L., Rossignoli, C. and Giangreco, A., 2020. Business intelligence system design and its
consequences for knowledge sharing, collaboration, and decision-making: an exploratory
study. In Information Diffusion Management and Knowledge Sharing: Breakthroughs in
Research and Practice (pp. 382-402). IGI Global.
Wieder, B. and Ossimitz, M.L., 2019. The Role of Business Intelligence/Analytics Systems in
Translating ‘Finance Transformation’Efforts into Higher Accounting Information Service
Levels.
7