| |
|
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.
|
|
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.
|
|
Occurrence of PBDE compounds and Bisphenol A in rivers with the occurrence of cryfish
Svobodová, Kateřina ; Vach, Marek (advisor)
The thesis deals with result evaluation of a project under the auspices of the EAA and Norway Grants, which ran from 2015 to 2016. The project's goal was to evaluate water quality at sites with native and invasive crayfish. The project also included monitoring organic substances such as Polybrominated diphenyl ethers (PBDEs). I mainly focused on a subset of PBDEs, the brominated flame retardants (BFRs). These substances have been monitored since the 1970s, when food was accidentally contaminated leading to the contamination of the nearby area in the US. What is alarming is their persistence in the environment, which leads to their constantly increasing levels. Information about the transformation and biodegradation of PBDEs in the environment is still limited and is continually analyzed in new studies. These substances are poorly volatile and insoluble, which makes dust and particles arising from the products containing BPAs the main sources of contact. Another agent, whose presence in the environment of the Czech Republic I analyzed, is Bisphenol A (BPA). BPA is used in the production of epoxy resins and polycarbonate plastics. BPA is a toxic substance with the ability to disrupt hormone function. Baby feeding bottles have been confirmed to contain these compounds. In April 2004, the Czech government approved a (program to reduce pollution of surface waters by dangerous harmful substances). In August 2004, the EU enacted a ban on the sale and use of penta-BDE and octa-BDE in all fields. Since 2011, Bisphenol A may not be used in the manufacture of baby feeding bottles. The goal of this thesis is to analyze and evaluate the amount and possible consequences of these substances in our environment, which are alarming even after full or partial bans on the use of these substances.
|
|
Use of urban greenery for lecturing on biology, forestry and environment
Šlechta, Rostislav ; Kuneš, Ivan (advisor)
This thesis aims to develop the concept of use of urban greenery in Znojmo for lecturing on biology, forestry and environment. Perform basic records of trees selected in urban green area; identify the target group of pupils and suggest appropriate topic fieldwork in accordance with the content of the curriculum taught. Choose a suitable, safe excursion route, develop a concise educational materials for teachers and propose a method for testing the effectiveness of fieldwork.
|
|
Constitutional rights for a favorable environment and it´s enforcement in modern Czech Republic
Tauchmanová, Renata ; Kadlecová, Eva (advisor) ; Uhlík, Milan (referee)
The thesis provides the most comprehensive summary of the legal protection
of the environment in the Czech Republic from the perspective of the justice and it is application in the Czech judiciary. Especially in regards to laws on the protection
of the right to a favourable environment within the Constitution of the Czech Republic,
I have tried to concentrate on the jurisprudence of the Constitutional Court, as to the court, whose decisions are very crucial for the interpretation and further application of the law
to the favourable environment in the practice.
The goal of my thesis is to show the evolution of the legal / legislative environment
in the Czech Republic and to approach the practice of the international law, especially european law in the field of the environmental protection. The thesis outlines available trial impalements, which uses the czech judiciary in the field of the law for a favourable envi-ronment and also represents the rights and obligations of the czech citizens related to this topic.
|
|
Analysis of the company in a competitive environment
Tužilová, Martina ; Šrédl, Karel (advisor) ; Hana, Hana (referee)
The thesis themed ´Analysis of the company in a competitive environment´ deals with the competitive market matters in the area of energetics located in the Pilsen Region.
The theoretical part describes the characteristics of the company and the competition which is detailed eliminated in other problems of competitiveness and competitive environment. The next theoretical bases of this thesis is the environment analysis of the company. Analyses of the internal environment are described here but also analysis of the external environment is detailed classified. The theoretical part is completed by the SWOT analysis.
The aim of the practical part is the analysis of the competitive environment applied to the company Plzeňská teplárenská, a.s. On the basis of predermined work hypotheses happen the analysis of single matters. At the beginning of the practical part is the description of researched company and further the analysis of the internal and external environment of Plzeňská teplárenská, a.s. In the next phase the description of main products of the company is drawn up. The SWOT analysis that also helps detailed analysis of predermined work hypotheses is made.
|
|
Analysis of environment in CR regions
Serafínová, Petra ; Svatošová, Libuše (advisor) ; Jaroslav, Jaroslav (referee)
The environment is an important part of human life, which greatly affects the quality of human health and the entire population. On the quality of the environment is given ever greater emphasis, since there is an increase in the negative anthropogenic effects. To avoid these impacts or reduce their consequences should protect the environment. The important part is sustainable development in order to keep a full-fledged environment to future generations.
In this thesis I analyze the main pollution by pollutants in the years 2000-2013 from all stationary sources in the district of Karvina, and from mobile sources of the Moravian-Silesian Region. Based on the statistical data of the Czech Hydrometeorological Institute, I processed an analysis of time series methods, has chosen trendy model with a forecast of future progression. For the years 2014 - 2016, I calculated the prediction of emitted pollutants.
|
|
The Benefits of Green Spaces
Těťálová, Zuzana ; Souček, Josef (advisor) ; Marek, Marek (referee)
This diploma thesis with the theme of The benefits of green spaces deals with the benefits of green space and their value.
The main part of the thesis is a literary review summarizing the theme of the benefits of green space and the methods of their evaluation. The first part of the review focuses mainly on the identification of the functions of green spaces in an urban environment and a closer look at their effects, utility and functioning. In this section the effects of the phenomena that occur in urban environments and which are suppressed thanks to green spaces are also analyzed. The second part of the review is devoted to the importance of evaluating green spaces and their benefits and further to methodologies, which are discussed in detail.
The following section analyzes the evaluation methodologies and their positive and critical points are identified. This section also divides the methodologies according to their relevance in the Czech environment, which is specific and the methodologies developed in the Anglo-Saxon context cannot be applied without modification. This chapter also compares data sources needed to develop a methodology for evaluating the benefits of green spaces.
In the fifth chapter of the thesis, a methodology for calculating the economic value of the benefits of green spaces in the city is created, based on the knowledge gained in the literature review. The methodology combines methods from various sources and adjusts them to the Czech context. It also examines the data sources needed in order to set up the whole balance sheet.
The sixth part deals with the discussion, in which is the summary of the data, which arise from the assembled methodology and compares them with the literature and the application of similar methodologies in other territories.
The conclusion summarizes the information obtained in the research and suggests other possibilities of their future use.
|
|
Cloud computing technology framework and reducing risks
Akrir, Khaled Ali Ahmed ; Havlíček, Zdeněk (advisor) ; Macák, Tomáš (referee)
The thesis investigates, in a qualitative way, the vectors that contribute to cloud computing risks in the areas of security, business, and compliance. The focus of this research is on the identification of risk vectors that affect cloud computing and the creation of a framework that can help IT managers in their cloud adoption process. Economic pressures on businesses are creating a demand for an alternative delivery of the model that can provide flexible payments, dramatic cuts in capital investment, and reductions in operational cost. Cloud computing is positioned to take advantage of these economic pressures with low cost IT services and a flexible payment model, but at what risk to the business? Security concerns about cloud computing are heightened and fueled by misconceptions related to security and compliance risks. Unfortunately, these security concerns are seldom, expressed quantifiably. To bring clarity to cloud computing security, compliance, and business risks, this research focuses on a qualitative analysis of risk vectors drawn from one-on-one interviews with top IT experts selected. The qualitative aspect of this research separates facts from unfounded suspicions, and creates a framework that can help align perceived risks of cloud computing with actual risks. The qualitative research was done through interviews with experts and through the survey to measure risk perceptions about cloud computing using a Likert scale. The decision-making model and the framework created by this research help to rationalize the risk vectors on cloud environments and recommend reducing strategies to bring the IT industry one step closer to a clearer understanding of the risks-tradeoffs implications of cloud computing environments.
|
guest ::
