Designing a Business Intelligence System for Decision Support: A Case Study of Lancaster Hotel and Spa
Added on 2023-04-24
12 Pages3171 Words99 Views
Introduction
Information and communication technology and information science are becoming increasingly
important and prevalent in business because of the age of digitalization and digital transformation.
Picot and Loebbecke (2015).
Companies must have access to timely, high-quality information to gain a competitive edge in the
modern business environment. To achieve well-informed tactical and strategic decisions, managers
require precise information. According to Alzghoul et al. (2022), companies all over the world invest
in and use business intelligence systems to meet their knowledge demands. Alzghoul et.al (2022)
Technology capabilities to assist decision-making with trustworthy information and analytical insights
are provided by business intelligence. Buxmann and Kowalczyk (2015)
Organizations may use information to grow better, perform wiser, and make better choices. The
information value chain, which is the method used to extract value from information and information
from data, is at the centre of business intelligence. Top management in organisations of all sizes may
use BI to make well-informed decisions concerning everything from long-term company plans to
marketing, research and development, and/or financing. Data may be used in business intelligence to
generate worth. It focuses on data discovery and the potential applications of information. .Bhatiasevi
(2018)
BI tools are programmes and other products that enable users to build queries, carry out data analysis
using techniques including online analytical processing (OLAP), data mining, statistical analysis, and
forecasting. Bhatiasevi (2018). As well as connecting BI with specialised databases that already exist
in the form of data warehouses and data marts, many types of reports may also be produced using BI.
Elbashir et.al (2008).
Along with a competition, BI offers businesses several additional advantages, like precise and timely
data reporting, improved decision-making skills, improved customer service, higher revenue, and cost
reductions in non-IT sectors. Many companies, including SAS, IBM, Microsoft, Qlik, Oracle, Tableau,
and Hadoop, offer business intelligence (BI) technologies. Bhatiasevi (2018)
Here we are going to design the business intelligence system for decision support for Lancaster
hotel and spa.
Lancaster hotel and spa meeting a point of modern design which is situated on the site of
Brunel University. It is located just 20 minutes from Uxbridge station and 5 mile from
Heathrow airport. It consist of 70 high en-suits and 30 twin double rooms and 40 single
rooms. Each rooms have free view TV ,Tea and coffee making , free Wi-Fi ,Gym, 24hrs check
in .Lancaster also have La carte restaurant and modern bar & lounge .There are 3 fully
equipped luxury boardroom .There are spa which consists of steam room, sauna, plunge
pool and spa pool . In the present time there is a great rush in hotels, as these have become
the necessity for accommodation in new place. People stay or go to Lancaster hotel for
function ,meeting, and refreshments .
Information and communication technology and information science are becoming increasingly
important and prevalent in business because of the age of digitalization and digital transformation.
Picot and Loebbecke (2015).
Companies must have access to timely, high-quality information to gain a competitive edge in the
modern business environment. To achieve well-informed tactical and strategic decisions, managers
require precise information. According to Alzghoul et al. (2022), companies all over the world invest
in and use business intelligence systems to meet their knowledge demands. Alzghoul et.al (2022)
Technology capabilities to assist decision-making with trustworthy information and analytical insights
are provided by business intelligence. Buxmann and Kowalczyk (2015)
Organizations may use information to grow better, perform wiser, and make better choices. The
information value chain, which is the method used to extract value from information and information
from data, is at the centre of business intelligence. Top management in organisations of all sizes may
use BI to make well-informed decisions concerning everything from long-term company plans to
marketing, research and development, and/or financing. Data may be used in business intelligence to
generate worth. It focuses on data discovery and the potential applications of information. .Bhatiasevi
(2018)
BI tools are programmes and other products that enable users to build queries, carry out data analysis
using techniques including online analytical processing (OLAP), data mining, statistical analysis, and
forecasting. Bhatiasevi (2018). As well as connecting BI with specialised databases that already exist
in the form of data warehouses and data marts, many types of reports may also be produced using BI.
Elbashir et.al (2008).
Along with a competition, BI offers businesses several additional advantages, like precise and timely
data reporting, improved decision-making skills, improved customer service, higher revenue, and cost
reductions in non-IT sectors. Many companies, including SAS, IBM, Microsoft, Qlik, Oracle, Tableau,
and Hadoop, offer business intelligence (BI) technologies. Bhatiasevi (2018)
Here we are going to design the business intelligence system for decision support for Lancaster
hotel and spa.
Lancaster hotel and spa meeting a point of modern design which is situated on the site of
Brunel University. It is located just 20 minutes from Uxbridge station and 5 mile from
Heathrow airport. It consist of 70 high en-suits and 30 twin double rooms and 40 single
rooms. Each rooms have free view TV ,Tea and coffee making , free Wi-Fi ,Gym, 24hrs check
in .Lancaster also have La carte restaurant and modern bar & lounge .There are 3 fully
equipped luxury boardroom .There are spa which consists of steam room, sauna, plunge
pool and spa pool . In the present time there is a great rush in hotels, as these have become
the necessity for accommodation in new place. People stay or go to Lancaster hotel for
function ,meeting, and refreshments .
DATA FLOW DIAGRAM
Visually map your system or process so you can find areas for increased efficiency and
effectiveness. A data flow diagram will simplify any work, including system improvement and
new process implementation. Nym, (2022)
DFD Level 0
DFD Level 0DFD Level 0
An alternative term for it is a context diagram. It will be an abstract view with the system portrayed
as a single operation and external parties. Using incoming/outgoing indicators that display input and
output data, the whole structure is shown as a single bubble. Nym, (2022)
The system's contact with external entities is highlighted in the data flow diagram level 0 and the
diagram also views the entire system as a single operation. The rest of the system is shown as a
single process in the context diagram (level 0 DFD). Level 0 data flow diagrams show a single process
node and its connections to external entities. In DFD Level 0, we may register a hotel in Lancaster,
where the administrator has full client information as well as confirmation of the reservation,
making their duty easier because they know who made the reservation for which day. Nym, (2022)
DFD Level 1
Visually map your system or process so you can find areas for increased efficiency and
effectiveness. A data flow diagram will simplify any work, including system improvement and
new process implementation. Nym, (2022)
DFD Level 0
DFD Level 0DFD Level 0
An alternative term for it is a context diagram. It will be an abstract view with the system portrayed
as a single operation and external parties. Using incoming/outgoing indicators that display input and
output data, the whole structure is shown as a single bubble. Nym, (2022)
The system's contact with external entities is highlighted in the data flow diagram level 0 and the
diagram also views the entire system as a single operation. The rest of the system is shown as a
single process in the context diagram (level 0 DFD). Level 0 data flow diagrams show a single process
node and its connections to external entities. In DFD Level 0, we may register a hotel in Lancaster,
where the administrator has full client information as well as confirmation of the reservation,
making their duty easier because they know who made the reservation for which day. Nym, (2022)
DFD Level 1
The key sub-processes that make up the whole system are all listed in the System level 1 DFD. One
way to conceptualise a level 1 DFD is as a "detonated perspective" of the context diagram. Level 0
data flow diagrams show a single production node and the relationships between it and outside
entities. While level 1 DFDs are more in-depth than context diagrams, they nevertheless offer a
general perspective. In a level 1 data flow diagram, the context diagram's single process node is
divided into sub processes. Nym, (2022)
It is quite apparent and simple to see how Lancaster may utilise customer information management,
reservation records management, reservation status monitoring, and transaction management
between user and admin as shown in DFD Level 1. And it was simple for the consumer to get all the
booking information. Nym, (2022)
The created graphic depicts four distinct situations. The first source of data is the hotel staff, guests,
and administration. The system then accommodates the transaction. This concept was inspired by the
Lancaster hotel booking procedures. Nym, (2022)
Here we are going to do essential data management of Lancaster hotel and spa using ENTITY
RELATIONSHIP DIAGRAM
In Lancaster hotel entities can be consider room , room type , guest , booking bill , employee.
To create ERD we can consider following fact:
Number of rooms hotel have
How many rooms customers can reserve
How many beds each room contain what are the prices for room with extra beds .
Hotel consist of 70 high specification en-suite bedrooms, 30 twin double rooms and 40 single rooms.
ROOMS
RESERVATION
GUEST
DATE
CHECK IN
GUEST NAME
ROOM TYPE
PRICE
VIEW NAME
PHONE NO
EMAIL
ADDRESS
way to conceptualise a level 1 DFD is as a "detonated perspective" of the context diagram. Level 0
data flow diagrams show a single production node and the relationships between it and outside
entities. While level 1 DFDs are more in-depth than context diagrams, they nevertheless offer a
general perspective. In a level 1 data flow diagram, the context diagram's single process node is
divided into sub processes. Nym, (2022)
It is quite apparent and simple to see how Lancaster may utilise customer information management,
reservation records management, reservation status monitoring, and transaction management
between user and admin as shown in DFD Level 1. And it was simple for the consumer to get all the
booking information. Nym, (2022)
The created graphic depicts four distinct situations. The first source of data is the hotel staff, guests,
and administration. The system then accommodates the transaction. This concept was inspired by the
Lancaster hotel booking procedures. Nym, (2022)
Here we are going to do essential data management of Lancaster hotel and spa using ENTITY
RELATIONSHIP DIAGRAM
In Lancaster hotel entities can be consider room , room type , guest , booking bill , employee.
To create ERD we can consider following fact:
Number of rooms hotel have
How many rooms customers can reserve
How many beds each room contain what are the prices for room with extra beds .
Hotel consist of 70 high specification en-suite bedrooms, 30 twin double rooms and 40 single rooms.
ROOMS
RESERVATION
GUEST
DATE
CHECK IN
GUEST NAME
ROOM TYPE
PRICE
VIEW NAME
PHONE NO
ADDRESS
To create a very well database, data needs may be carefully analysed using the ER model. The ER
Model depicts actual people, things, and the connections among them. Before deploying your
database, it is recommended that you create an ER Model in a DBMS. Peterson, R. (2022)
ERD will assist the Lancaster Hotel in showcasing the entity model for the hotel management system.
The hotel management system's entity relationship diagram displays all the visual components of the
database table as well as the relationships between the rooms, payments, hotel, and customers,
among other things. The link between the structured data group of Lancaster hotel management
system features was defined using structure data. The hotel, rooms, services, payments, bookings,
and clients are the essential components of the hotel management system. Peterson (2022)
ACCESS
Model depicts actual people, things, and the connections among them. Before deploying your
database, it is recommended that you create an ER Model in a DBMS. Peterson, R. (2022)
ERD will assist the Lancaster Hotel in showcasing the entity model for the hotel management system.
The hotel management system's entity relationship diagram displays all the visual components of the
database table as well as the relationships between the rooms, payments, hotel, and customers,
among other things. The link between the structured data group of Lancaster hotel management
system features was defined using structure data. The hotel, rooms, services, payments, bookings,
and clients are the essential components of the hotel management system. Peterson (2022)
ACCESS
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Data Handling and Business Intelligencelg...
|8
|1740
|93
Augmented Analytics Power Point Presentation 2022lg...
|11
|713
|21
Assessment 1 Data Handling And Business Intelligencelg...
|7
|1687
|285
Laboratory for Intelligent Systems and Analyticslg...
|8
|645
|19
Business Intelligence: Trends, Impact, and Practical Applicationslg...
|7
|1711
|275
Business Intelligence System for Improved Performance and Customer Satisfactionlg...
|14
|3488
|106