|
|
Implementace BI ve firmě Haguess a.s.
Bendák, Martin ; Novotný, Ota (advisor) ; Bláha, Jiří (referee)
The subject of this thesis is a pilot project of the implementation of the BI (Business Intelligence) solution in the company Haguess, a. s. The project is concerned with the analyses of data stored in a database -- DataBase Management System (DBMS) -- which is used as a data source by the web application Customer Support Center (CSC). Haguess primarily uses CSC as a helpdesk for its clients and partners, but also uses it for internal purposes. The main use of the CSC application is to support information systems delivered by Haguess. There were two motives for the choice of this subject: BI software tools had not previously been used by Haguess, and the company management was keen to get data analyses from the CSC application. That's why I decided to do these analyses. My goal was to create a practically useful solution which would be an incentive for Haguess to use BI software tools for other purposes. This thesis has two main goals. The first one is the realisation of the pilot BI solution, which would outline the possibilities for analysis of data from the CSC application using BI software tools. This involved the following activities: multidimensional analysis and BI solution design -- i.e. design of data pipelines, OLAP (On-Line Analytical Processing) cube/cubes, and user tools in MS Excel calculator. The second goal was to select the proper software tools for a future complex realisation and running of the BI solution. The first objective was achieved by doing the following: proper analysis of the CSC application data model, definition of user requests for output analysis and its comparison with the data model analysis. Based on this comparison, the basic subjects of output analyses were determined. These basic subjects were the starting point for the implementation of the BI solution. The second objective was achieved as follows: on the basis of the implementation results, basic demands (criteria) for BI software tools features were determined, bearing in mind the possible future complex realisation and running of a BI solution. Research determined which BI software tools were available on the market. The most suitable BI software tool was selected following a comparison of available options, and the criteria mentioned above. The primary outcome of this thesis is the creation of a practically usable BI solution.
|
|
|
Support of using date and time in programming languages
Bendák, Martin ; Pavlíčková, Jarmila (advisor) ; Gála, Libor (referee)
The main object of this bachelor thesis is the support of using date and time analysis in following programming languages: Java, Visual Basic, C++, C, QBasic, PL/SQL, Lisp and Prolog. This thesis is categorized into two logical blocks. First one describes different types of calendarsand differences in the date and time formatting throughout the world. There is a Czech standard ČSN ISO 8601 related to this issue that defines unified dates interpretation in international data exchange. The second block analyses available tools for working with date and time in different programming languages. The bridge between both blocks are criteria defined by main areas (support of: gregorian calendar, 24-hour clock, formatting and other calendar systems).
|
guest ::
