The XYZ Reservation Information System Ltd 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 an online transaction processing (OLTP) system, often referred to simply as transactional systems. They are designed to process small, fast, interactive workloads for which users expect fast response times. (Root, R., & Mason, C., 2012) Figure 3.1: Screenshot of XYZ Transport Limited website 3.4 DATA ETL (EXTRACT, TRANSFORM AND LOAD) ETL as a BI concept means Extract, Transform and Load. In an ETL process, data is first pulled from a number of multiple systems that are usually unstructured. The extracted data is then transformed into an ideal structure for analysis and reporting processes. The data is then loaded into cubes for visualization. (Passionned Group., 2014)• Extracted: As mentioned above for OLAP, data is entered via the online booking website, data is saved in a SQL Server database, data has been extracted from the database into an Excel file as raw data: As below a query was executed and then the results were saved as an Excel file:OLAP (Online 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 path. For example, the following figure shows the data of the Sheffield - Manchester route, when all the data routes are transformed into an Excel page, the OLAP process is started to be......half of the sheet......Rudin , K., & Cressy, D. (2003). Will the true analytic application endure? DM REVIEW, 13, 30-41.Schulte, M. F. (2006). Business Object Dashboard Manager. DM Rev, 16(2), 49.Sychevskiy, M., & Makad, R. (2013) Future perspective of business intelligence and SAP HANA. [Online] Available from: http://www.infosys.com/industries/aerospace-defense/Documents/future-BI-SAP-HANA.pdf. [Accessed: 8 April 2014].TechTarget. (2014) How SAP BW and HANA will merge over time and why it is important that they are available. [Online] Available from: http://searchsap.techtarget.com/feature/How-SAP-BW-and-HANA-will-merge-over-time-and-why-it-matters. [Accessed: April 8, 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.