This website uses cookies to ensure you have the best experience. Learn more

The Xyz Ltd Booking Information System Website

1547 words - 7 pages

The XYZ Ltd Booking Information System website was then created to simulate the train ticket booking process and used this relational database to insert records into other tables. This website can be seen as an example of online transaction processing (OLTP) system, often simply referred to as transactional systems. They are designed to process small, quick, interactive workloads for which users expect a fast response time. (Root, R., & Mason, C., 2012)


Figure 3.1: Screenshot of XYZ Transport Limited’s website

3.4 DATA ETL (EXTRACTION, TRANSFORMATION AND LOADING)
ETL as a BI concept means Extract, Transform and Load. In an ETL process, data is firstly extracted from a number of multiple systems which is usually unstructured. The extracted data is then transformed into a structure ideal for analysis and reporting processes. Data is then loaded into the cube(s) for visualization. (Passionned Group., 2014)

• Extract:
As mentioned before for OLAP the data is entered through the online booking website, data is saved in an SQL Server database, The data was extracted from the database to an excel file as raw data:
As below a query was run and then saved the results as an excel file:
OLAP (On-line Analytical Processing): In the OLAP process there is a high level of data transformation and aggregation. This usually consists of complicated formulas and queries to produce the relevant required data. (Data Warehouse, 2009)
• Transform:
After the data was extracted from the database to excel we transformed it and assigned a specific page for each route.
For example the figure below shows the data of Sheffield – Manchester route,

When all the data routes are transformed to an excel page, OLAP process is launched to be applied by manipulating the data using complicated formulas as to obtain the upper layer of aggregated data.
For example: As the figure above, in column N, an IF formula was used to obtain the week split from the date of travel field: =IF(D3>41719,"Week4",IF(D3>41712,"Week3",IF(D3>41705,"Week2","Week1")))
The same formula is used in column O to obtain the week day from the date of travel field: =IF(E3>0.75,"SHIFT4" &"_DAY"& DAY(D3),IF(E3>=0.5,"SHIFT3"&"_DAY"& DAY(D3),IF(E3>=0.25,"SHIFT2"&"_DAY"& DAY(D3),"SHIFT1"&"_DAY"& DAY(D3))))
After aggregation of the data to obtain the higher level, the results for the route (in our example Manchester - Sheffield) was positioned in a standard area of the route page like below:

Figure 3.4: Result of MS excel Transformation

As seen from the above figure, we obtain the total income, no of passengers and No of confirmation for the route Manchester – Sheffield on a Monthly, Weekly, Daily and Hourly basis. This is repeated for all the six routes.
• Load
The transformed data for each route (each page) was combined in one central page, which will be our operation room from which we load our BO Xcelcius for visualization purposes, as below:

With the record or data of the employees productivity and...

Find Another Essay On The XYZ Ltd Booking Information System Website

Information Management in Industry: The Case of Hitachi Transport System

713 words - 3 pages three basic activities: input, processing, and output. From Business point of view, an information system prove to be a solution to a problem or challenge facing a firm and provides real economic value to the business. INFORMATION MANAGEMENT IN HITACHI TRANSPORT SYSTEM (M) SDN BHD Hitachi Transport System (M) SDN BHD is one of the branches of main Headquarter in Japan called Hitachi Transport System, Ltd. Hitachi Transport System (M) is a

Evaluate the contribution of Management Information System to Organisations

1507 words - 6 pages psychology. "An organization is a stable, formal social structure that takes resources from the environment and processes them to produce outputs." (Laudon, 2002,P87) This essay will be evaluating the contribution of Management Information System to Organisations. Like as What relationship between information and manager's job; computer network's importance for management information development; different types of management information systems

Making Informed Decisions Based on the Regional Information System

1020 words - 4 pages Making Informed Decisions Based on the Regional Information System Many criteria go into making a decision of where to teach. Initially, a better salary is the primary enticement for any teacher. However, there is much more than salary to be considered and more thoroughly researched for accuracy before considering any career moves. The internet is a great place to begin the research of potential locations of interest. Yet, can all the data

Creating a Customer Information System for the York Bikes Company

2100 words - 9 pages Business Scenario: A bike company called York bikes wants to create a customer information system for its company. York Bikes is a company that designs custom bikes and sells custom bikes which is a niche market, both at its business establishment and over the company’s web site. In the custom bike market one which is growing rapidly, Markham Bikes is one of York Bikes’ main competitors. (Purcell) Using the 5P’s of meeting in the SDLC stages of

Information Security System: The Case of Target Corp

1105 words - 5 pages Nowadays, information security is one vital part of a company to develop and maintain its information system. As technology became more advanced in terms of creating and utilizing, the more threats a company’s information system will face. A threat is a person or organization that seeks to obtain or change data illegally, without the owner’s permission and knowledge. In addition, a vulnerability is an opportunity for threats to gain access to

Information Technology and Expansion of the European International System

2860 words - 11 pages Information Technology and Expansion of the European International System "We are at risk. America depends on computers. They control power delivery, communications, aviation, and financial services. They are used to store vital information, from medical records to business plans, to criminal records. Although we trust them, they are vulnerable -- to the effects of poor design and insufficient quality control, to accident, and perhaps most

The Components of a Computer and Information Processing System

975 words - 4 pages The Components of a Computer and Information Processing System In today’s world, computers are everywhere. People use them in a wide range of ways in every aspect of life whether it is interacting with friends, cooking a meal, or transferring funds from one account to another. However, many people do not think about the many aspects of computing and the various devices and software that are part of the information process. Basics of the

the identification and analysis of information system in the business enterprise at each management level, the suitability of information system for the chosen firm, the security of the information...

3968 words - 16 pages REPORT INTRODUCTION: In this modern time, it is impossible to run a business without any information system. Whether the business is small or large, information system is very much needed for the survival of the business. This report will deal with the identification and analysis of information system in the business enterprise at each management level, the suitability of information system for the chosen firm, the security of the

4. An analysis on how the information system can help the organization to gain competitive advantage

736 words - 3 pages information systems to customize and personalize their products and it has given them a very large competitive advantage in the area of personal computers (PCs) and laptops market. For example, Dell has allows their customers to customize their laptops such as the laptops size (14” or 15.6”), laptops body colour (red, white, black), or the laptops software such as laptops system (Window7 or 8), core processor system (i3 or i5). Dell allows their

The Requirements for Developing and Managing a Comprehensive Management Information System

4238 words - 17 pages The Requirements for Developing and Managing a Comprehensive Management Information System The aim of this assignment is to see the requirements for developing and managing a comprehensive Management Information system for an organisation. In today's business environment it is getting harder and harder for organisation’s to not only survive but to compete against other organisation’s. Information technology plays a big part in helping

The Canadian Forces' Material Acquisition and Support Information System (MASIS) Project

7230 words - 29 pages paper will introduce and explain the background for the Canadian Forces' Materiel Acquisition and Support Information System (MASIS) Project. It will explain the status of the Canadian Forces' pre-MASIS resource management system and identify its problems and issues.The paper will outline the requirements for the Canadian Forces' resource management system at several points of contact, starting from the bottom up:•Officers who place orders

Similar Essays

Management Information System: Dewan Farooque Motors Ltd

1922 words - 8 pages drive demand to around 120,000 units per annum.INTRODUCTION OF MIS DEPARTMENTManagement Information System in an organization that includes systems that support business processes of the firm.The IT department of the DFML is very organized and well managed it is because the whole setup is organized by the Korean management.Information is gathered around critical functions of management such as planning, organizing, staffing, controlling and

The Role Geofgraphic Information System Essay

714 words - 3 pages THE ROLE OF GIS The geographic information system (GIS) incorporates software, hardware and data for capturing, observing, analysing, managing and displaying all varieties of geographically referenced information. With GIS, service providers are able to analyse, question, interpret, visualise and understand data that reveals trends, relationships and patterns through maps, charts and reports. This then enables service providers to make

Case Study On The Loan System Of City Bank Ltd

9438 words - 38 pages to observe all the people or user who are using the system and the type of their workflow. Our team visited just one time to their Gulshan branch and observed all sections where most of the loan activities take place.3.3 Questionnaire:Questionnaire is a special purpose document that allows us to collect information and opinions from respondents. It allows us to collect facts form a large number of people while maintaining uniform responses. When

Proposal For Setting Up An E Business As An Extension From An Existing Business. The Proposal Is For An Online Car Hire Booking System

3185 words - 13 pages of all the cars that are available for hire with the usual images and tariffs. What will be new is that the way in which the cars can be booked will be through an online booking system; customers will be able to browse through the selection of cars and obtain a quote for the length of time they require the car. Once happy they will be able to place a booking which will be confirmed instantly and payment can be made through the website. If a car is