| |
|
Design of a methodology for BI solutions in QlikView environment
Judová, Eva ; Pour, Jan (advisor) ; Kunst, Jan (referee)
This master thesis is devoted to a design for methodology of BI projects in QlikView. The main aim is to propose a recommended procedure solutions reflecting the strengths and weaknesses in the development of QlikView applications. Accompanying chapter to the discussed issue is a chapter Business Intelligence which explains the principles, characteristics and reasons for implementation in companies. Part of defining the differences between traditional and self-service solutions serves as a theoretical basis for understanding the increasing attractiveness of self-service solutions and environment of the proposed methodology. The next chapter presents the company Qlik as a market leader in BI and the owner of QlikView. The reasons for its establishment, subsequent development and actual vision are listed to create a comprehensive view of the environment where the described product was created. Along with the chapter focusing on characteristics and main advantages of QlikView a knowledge base is established for the implementation of proposed methodology. Crucial chapter of this thesis is based on the author's experience gained while implementing QlikView projects. The proposed methodology is based on the description of each phase, its activities, inputs and outputs and its concrete application in a demo environment for the area of receivables in manufacturing company. The key contribution of the author is pointing out potential problems during development or warning about critical parts or providing appropriate recommendations and benefits of the proposed procedures. The designed methodology can serve as a useful guide for self-service projects implemented the QlikView environment.
|
|
Integration of Apple Mac computers into corporate environment
Světlík, Martin ; Bruckner, Tomáš (advisor) ; Rathouský, Tomáš (referee)
Corporate informatics has undergone a number of changes in past few years. Used devices are becoming more independent from the OS, they rely more on provided services and the level of security. Cloud technologies are increasingly growing in significance and a large number of companies offer their employees BYOD (Bring Your Own Device). This thesis focuses on integration of Apple Mac computers into corporate environments, based on analysis of contemporary approaches and possibilities of dealing with integration. An important part of this thesis is research of chosen implemented solutions in the Czech republic. From both parts of this thesis it then offers recommendations, which are based on practical experience of companies that widely use and deal with integration of Mac computers.
|
|
Use of Interest Rate Models for Interest Rate Risk Management in the Czech Financial Market Environment
Cíchová Králová, Dana ; Arlt, Josef (advisor) ; Cipra, Tomáš (referee) ; Witzany, Jiří (referee)
The main goal of this thesis is to suggest an appropriate approach to interest rate risk modeling in the Czech financial market environment in various situations. Three distinct periods are analyzed. These periods, which are the period before the global financial crisis, period during the financial crisis and in the aftermath of the global financial crisis and calming subsequent debt crisis in the eurozone, are characterized by different evaluation of liquidity and credit risk, different relationship between financial variables and market participants and different degree of market regulations. Within this goal, an application of the BGM model in the Czech financial market environment is crucial. Use of the BGM model for the purpose of predicting a dynamics of a yield curve is not very common. This is firstly due to the fact that primary use of this model is a valuation of interest rate derivatives while ensuring the absence of arbitrage and secondly its application is relatively difficult. Nevertheless, I apply the BGM model to obtain predictions of the probability distributions of interest rates in the Czech and eurozone market environment, because its complexity, direct modeling of a yield curve based on market rates and especially a possibility of parameter estimation based on current swaptions volatilities quotations may lead to a significant improvement of predictions. This improvement was also confirmed in this thesis. Use of swaptions volatilities market quotations is especially useful in the period of unprecedented mone- tary easing and increased number of central banks and other regulators interventions into financial markets that occur after the financial crisis, because it reflects current market expectations which also include future interventions. As a consequence of underdevelopment of the Czech financial market there are no market quotations of Czech koruna denominated swaptions volatilities. I suggest their approximations based on quotations of euro denominated swaptions volatilities and also using volatilities of koruna and euro forward rates. Use of this approach ensures that predictions of the Czech yield curve dynamics contain current market expectations. To my knowledge, any other author has not presented similar application of the BGM model in the Czech financial market environment. In this thesis I further predict a Czech and Euro area money market yield curve dynamics using the CIR and the GP models as representatives of various types of interest rates models to compare these predictions with BGM predictions. I suggest a comprehensive system of three criteria, based on comparison of predicti- ons with reality, to describe a predictive power of selected models and an appropria- teness of their use in the Czech market environment during different situations in the market. This analysis shows that predictions of the Czech money market yield curve dynamics based on the BGM model demonstrate high predictive power and the best 8 quality in comparison with other models. GP model also produces relatively good qua- lity predictions. Conversely, predictions based on the CIR model as a representative of short rate model family completely failed when describing reality. In a situation when the economy allows negative rates and there is simultaneously a significant likelihood of their implementation, I recommend to obtain predictions of Czech money market yield curve dynamics using GP model which allows existence of negative interest rates. This analysis also contains a statistical test for validating the predictive power of each model and information on other tests. Berkowitz test rejects a hypothesis of accurate predictions for each model. However, this fact is common in real data testing even when using relatively good model. This fact is especially caused by difficult fulfilment of test conditions in real world. To my knowledge, such an analysis of the predictive power of selected interest rate models moreover in the Czech financial market environment has not been published yet. The last goal of this thesis is to suggest an appropriate approach to obtaining pre- dictions of Czech government bonds risk premium dynamics. I define this risk premium as a difference between government bond yields and fixed rate of CZK IRS with the same length. I apply the GP model to describe the dynamics of this indicator of the Czech Republic credit risk. In order to obtain a time series of the risk premium which are necessary for estimation of GP model parameters I firstly estimate yield curves of Czech government bonds using Svensson model for each trading day since 2005. Resulting si- mulations of risk premium show that the GP model predicts the real development of risk premiums of all maturities relatively well. Hence, the proposed approach is suitable for modeling of Czech Republic credit risk based on the use of information extracted from financial markets. I have not registered proposed approach to risk premium modeling moreover in the Czech financial market environment in other publications.
|
|
Proposing the financial performance prediction index for decision support of the hospital management
Hajdíková, Taťána ; Černá, Anna (advisor) ; Lieskovská, Vanda (referee) ; Lazar, Jaromír (referee)
Dissertation thesis deals with the managerial needs in the area of financial health. Managers need a tool to reveal the impending financial failure or to assess the financial quality of the organization. They link their decisions to performance, ability to pay, employee productivity, financial resources and financial risk. In the theoretical part of the thesis it is necessary to explain the non-profit sector and its connection with the hospital environment. It is also necessary to introduce models used both in the Czech Republic and abroad, which share common elements. The basic aim of this thesis is to propose a financial performance prediction index for decision support of the hospital management, the owners of hospitals and insurance companies. To achieve the basic goal, three sub-goals must be accomplished. The first goal is to divide the hospitals into healthy and unhealthy by using the multi-criteria methods. The second goal is, based on an expert approach with the support of statistical methods, the selection of indicators appropriate for the hospital environment and the third goal is to find a suitable method for the determination of weighted representation of individual indicators in the proposed index and to assemble the final form of the new financial index for the hospital environment.
|
|
Communications Intercultural Aspect in Working Environment of a chosen Firm
Jenšovský, Šimon ; Hiršová, Miloslava (advisor) ; Balgová, Dagmar (referee)
The thesis covers cultural differences among employees of a multi-national corporation in relation to communication and task execution. Thesis aims to construct a theoretical framework to map these cultural differences and apply gathered insights in practical research targeting the effect of cultural differences on communication and task execution. Research questionnaire replicates Hofstede's work and also builds on practical application of Hofstede's work by several authors. Research data were gathered via digital questionnaire. Data refinement and evaluation was conducted using frequency description and statistical methods of structure comparison. The thesis provides a set of practical recommendations as a result. These are aimed to help reduce or possibly eliminate negative effects of cultural differences in the workplace.
|
|
Business Plan for Establishment of Trade
Borkovec, Ondřej ; Trachta, Václav (advisor) ; Dvořák, Jiří (referee)
The aim of the thesis is to create a business plan of Kavárna XY operated by independent entrepreneur. The work consists of two parts. The first part is the theoretical framework which focuses on the legal requirements of entrepreneurship and structure of a business plan.The tools like PEST analysis, Porter`s five forces analysis and SWOT analysis are explained. The second part is the application of findings from the theoretical part and focuses on creating the business plan of Kavárna XY. The practical part deals with the definition of competetive advantage, analyzes a company environment and competition, deals with the creation of sales and financial plan and evaluates project risks. An output of the practical part is to create a business plan and prove that the project is feasible and profitable.
|
|
Analysis of the company environment
Hladík, Ondřej ; Dvořáček, Jiří (advisor) ; Strouhal, Jiří (referee)
This bachelor thesis deals with methods of analysing the company environment and then using these methods on a company Travel Service, a.s. The primary purpose is to determine main factors affecting the market position of this company. Methods used for analyzing the company environment are introduced in theoretical part of the thesis. For analysing the macroenvironment is used PEST analysis and Porter five force model is used for analysing the critical factors of macroenvironment. The thesis include SWOT analysis and recommendations for the company based on the collected informations.
|
|
CRM System Optimization
Fučík, Ivan ; Mildeová, Stanislava (advisor)
This thesis is focused on CRM solutions in small and medium-sized organizations with respect to the quality of their customer relationship. The main goal of this work is to design an optimal CRM solution in the environment of real organization. To achieve this goal it is necessary to understand the theoretical basis of several topics, such as organizations and their relationship with customers, CRM systems, their features and trends. On the basis of these theoretical topics it is possible to analyze current CRM solution in the organization. From the data obtained by the methods of observation and controlled interview it was possible to prepare a design for optimal CRM solution. This optimal solution comes also from user and organization requirements. The optimal CRM solution saves time and costs associated with current CRM solution and replaces existing and ineffective CRM tools.
|
|
Prototyping of mobile apps and their testing in real environment
Ornst, Zdeněk ; Sigmund, Tomáš (advisor) ; Michaličová, Alexandra (referee)
This thesis describes process of designing mobile user interface with regard to the context of use. In this context the discipline of prototyping and its utilization for designing is further examined. Next focus is on the principles of user testing of usability in mobile applications. Building on theoretical knowledge the solution for usability testing of prototypes in real environment is proposed. It aims to more effective process of designing mobile applications. The solution is presented on real case with evaluation of its success.
|
guest ::
