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