The XYZ Ltd Booking Information System Website

875 Words2 Pages
bulb-icon

Recommended: Relational database

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 ...

... middle of paper ...

...
Rudin, K., & Cressy, D. (2003). Will the Real Analytic Application Please Stand Up?. DM REVIEW, 13, 30-41.

Schulte, M. F. (2006). Business objects dashboard manager. DM Rev, 16(2), 49.

Sychevskiy, M., & Makad, R. (2013) Perspective future of business intelligence and SAP HANA. [Online] Available from: http://www.infosys.com/industries/aerospace-defense/Documents/future-BI-SAP-HANA.pdf. [Accessed: 8th April 2014].

TechTarget. (2014) How SAP BW and HANA will merge over time and why it matters available. [Online] Available from: http://searchsap.techtarget.com/feature/How-SAP-BW-and-HANA-will-merge-over-time-and-why-it-matters. [Accessed: 8th April 2014].

Yigitbasioglu, O. M., & Velcu, O. (2012). A review of dashboards in performance management: Implications for design and research. International Journal of Accounting Information Systems, 13(1), 41-59.

Show More
Related

  • Nt1330 Unit 6 Case Study

    626 Words  | 2 Pages

    This preprocessing step is done before the considered two cases of not split table traffic amounts and the split table traffic amounts. It includes the network topology design as follows:

    Read More

  • Tableau Software Executive Summary

    1966 Words  | 4 Pages

    Traditional business intelligence tools are being replaced by data discovery software. The data discovery software has numerous capabilities that are dominating purchase requirements for larger distribution. A challenge remaining is the ability to meet the dual demands of enterprise IT and business users.

    Read More

  • The Mayo Clinic: A Performance Management Assessment

    2102 Words  | 5 Pages

    Tapinos, E., Dyson, R.G. & Meadows, M. (2005). The impact of performance measurement in strategic planning. International Journal of Productivity and Performance Management, 54(5/6), 370-384.

    Read More

  • Premier Inn Case Study

    1047 Words  | 3 Pages

    Accommodating customer requirements in most supply chain arrangement requires a forecast to drive the process. (book page 133) When looking into the definition of forecasting which is projecting what is going to be sold (units, seats, rooms etc) it is also important to take into consideration where and when in order to reach the future goals. (book page 133) Since it is argued that effective supply chain and logistical capacity is an important competitive advantage. (Christopher 2005) Where maximizing the revenue is the key element in hospitality sector and for hotel industry there is an increased attention on effective demand management and forecasting for reservation systems. (http://www.sciencedirect.com/science/article/pii/S0169207002000110)

    Read More

  • Create a New Program to Extract Purchase Order Information From Oracle System

    591 Words  | 2 Pages

    Generate an extract audit report in Oracle system. This report will show the total number of records extracted from the Oracle purchase Order tables. (Header and Detail)

    Read More

  • Are The Pervasive Characteristics Of Organisational Performance Management Essential For Ensuring Organisational Effectiveness?

    1279 Words  | 3 Pages

    ‘If you can’t measure it, you can’t management it’, [Dan vesset and Brian, M. 2009]. Performance management is concerned with the measurement of results and with studying progress to achieving objectives base on the results. Managing performance can tell you what you’re doing well in, and also reveal areas where you need to make adjustments. Measuring performance tells you how far you’ve gone achieving your ultimate

    Read More

  • HR Metrics and Analytics

    1123 Words  | 3 Pages

    Managers are most frequently found by their subordinates unable to demonstrate a much cooperative stance in terms of telling them what information they need, using the HR metrics information included in existing reports, or even acknowledging receipt of the reports. These perceptions actually comprise the basic concern in organizations and their utilization of metrics and analytics as most managers view metrics and analytics as a simple regular task in a management policy to compute and report more metrics. There is obvious lack of communication and information regarding the assessment and report of HR metrics and the positive results in better organizational performance. Information systems help managers make different and better decisions which also include...

    Read More

  • Global Leader of Hospitality: Hilton Hotels and Resorts

    1944 Words  | 4 Pages

    “Using PM System doesn’t improve the performance of an organization. PM system incorporates of not only evaluating performance appraisals but also rewards. As quoted by Sheridan (2009) and Latham (2005), “the cultural maturation of performance based can take decades to implement and requires the organizations to allocate the required resources”. Technology plays a pivotal role in future of PM systems where e-monitoring of performance of employees in Hilton and other entities respectively can change the evolution of performance management thus bringing necessary and important changes to stay competitive in the market as well increasing an individual’s productivity in the company (Sheridan & Latham, 2005)”.

    Read More

  • Business Intelligence

    340 Words  | 1 Pages

    First of all, business intelligence analysis requires the capturing of information and storing in a single location for effective data analysis. Currently, data analysis is supported by transactional systems, business specific data marts, and other ad-hoc processes. Information is distributed making it difficult and time-consuming to access. Business teams have adapted to this environment by creating user maintained databases and manual “work-arounds” to support new types of reporting and analysis. This has resulted in inconsistent data, redundant data storage, significant resource use for maintenance, and inefficient response to changing business needs.

    Read More

  • The Effects of Technology on the Hospitality Industry

    1289 Words  | 3 Pages

    The powerful system of Reach by NAVIS, generates targeted email lists from data housed on separate systems. NAVIS Reach is based on 25 years of experience in the lodging industry. The system captures guest information and lead data from multiple sources that include the property management system, external lists, the NAVIS Narrowcast solution, and or other sources. Reach cleans and de – dupes the names, removes pre booking and automatically groups people into households in real time. Once the data is captured, NAVIS Reach provides easy to use tools to generate lists from the combined

    Read More

  • Business Intelligence and Data Science

    1145 Words  | 3 Pages

    For the past couple of decades the majority of businesses have wanted to construct a data-driven organization or company. Furthermore, companies around the world are considering harnessing data as a basis of competitive advantage over other companies. As a result, business intelligence and data science use are popular in many organizations today. The increase in adoption of these data systems is in response to the heavy rise in communications abilities the world over. Which, in turn ,has increased the need for data products. Indeed, the Data Scientist profession is emerging to be one of the better-paying professions due to the urgent need of their labor. This paper is going to discuss what business intelligence is all about and explain data science that is usually confused to be similar to business intelligence. I will tackle a brief overview of data scientists and their role in organizations.

    Read More

  • Statistical Investigation

    2980 Words  | 6 Pages

    The data of the test scores was given to me in excel format. On it

    Read More

  • Technology in Transportation

    3216 Words  | 7 Pages

    The transportation industry (airline, railway, bus transit, automobile rental agencies) has undergone enormous changes in the way its customers purchase tickets and place reservations. The continuing popularity in e-commerce combined with the widespread increase in the number of people with internet access has caused an explosion in the number of...

    Read More

  • Business Intelligence

    1331 Words  | 3 Pages

    The dynamics of our society bring many challenges and opportunities to the business world. Within the last decade, hundreds of jobs have emerged particularly in the technology sector to help keep up with the ever-changing world and to compete on a larger and better scale than the competition. Two key job markets and the basis of this research paper are business intelligence or BI and data mining or DM. These two fields play a very important role in small to large companies and are becoming higher desired sectors within the back offices of the workplace. This paper will explore what the meaning of BI and DM really is, how they are used and what we can expect as workers and learners of the technology and business fields for the future.

    Read More

  • SAP Implementation in a Company and its Benefits

    1437 Words  | 3 Pages

    SAP implementation is a huge undertaking for any company, big or small. The one thing that every company wants to see during and after this implementation is benefits to their business. The biggest result they are looking for is a tangible or measurable benefit as these are easily identifiable and make the task of proving the reason for the hefty investment in SAP much easier. The question becomes how does a company go about seizing the benefits of SAP? There are several keys to seizing this benefit and those include discovering the hard dollar benefits, avoiding common pitfalls in a SAP implantation, and finding the intangible benefits.

    Read More

More about The XYZ Ltd Booking Information System Website

Open Document