This work investigates the problem of company not able to handle it’s data analysis using Navision Attain tools alone. A more powerful system is needed, and Microsoft SQL Server OLAP tools are selected as such. The work carried out covers data extraction, transformation and loading (ETL) for analyzing Navision Attain data using OLAP data analysis tools. Different integration architectures, as well as needed transformations and most often encountered problems are covered, together with possible solutions to them.. After completing business process analysis, and identifying user roles and required data, four different data cube were created on data from Navision Attain. Namely cubes for sales analysis, purchase analysis, item inventory tracking and customer debt analysis. In addition, an example schedules for cube updating are created, and wider usage guidelines are provided. The complete system is then optimised to provide efficient performance and low main system load. The optimisation results are compiled into generic suggestions for further analysis system development.
Identifer | oai:union.ndltd.org:LABT_ETD/oai:elaba.lt:LT-eLABa-0001:E.02~2006~D_20060114_121412-78673 |
Date | 14 January 2006 |
Creators | Kepežinskas, Algirdas |
Contributors | Kiauleikis, Valentinas, Stulpinas, Raimundas, Butleris, Rimantas, Maciulevičius, Stasys, Nemuraitė, Lina, Gudas, Saulius, Butkienė, Rita, Lopata, Audrius, Bareiša, Eduardas, Kaunas University of Technology |
Publisher | Lithuanian Academic Libraries Network (LABT), Kaunas University of Technology |
Source Sets | Lithuanian ETD submission system |
Language | Lithuanian |
Detected Language | English |
Type | Master thesis |
Format | application/pdf |
Source | http://vddb.library.lt/obj/LT-eLABa-0001:E.02~2006~D_20060114_121412-78673 |
Rights | Unrestricted |
Page generated in 0.0023 seconds