|
Comparison of Business Intelligence implementation using open source solutions for middle size companies
Schmidt, Róbert ; Maryška, Miloš (advisor) ; Sládek, Pavel (referee)
The main goal of master thesis is to analyze and propose possible low cost Business Intelligence solution with open source technologies and comparison of available tools for implementation in middle size company. We compare Pentaho and Jaspersoft tools implemented on local hardware and cloud environment with Microsoft Azure services. The theoretical part focuses mainly on understanding the business intelligence and its architecture, because architecture is an important part of the work. Actual tools are designed as stand alone modules for specific activities in the business intelligence lifecycle. Low cost tools are often connected with open source technologies and cloud computing. This part of the work contains explanation of these terms and their advantages and disadvantages for our chosen target group of companies. The analytical part includes defined parameters by which it is conducted analysis of tools and their comparison. Business Intelligence solutions are divided according to arcitectural layers. The evaluation criteria are divided into financial, technical and user category. In conclusion, chosen tools are compared and evaluated. The main contribution of this thesis is comparison of open source business intelligence tools for implementation in middle size company. According to the EU directive, middle size company does not exceed 250 employees or profit is less than 50 million euros. The reader can compare the different solutions and their pitfalls or shortcomings that could be critical for the implementation.
|
|
Renewable energy legislation
Kučerová, Veronika ; Štěpánek, Petr (advisor) ; Černý, Pavel (referee)
This master thesis discusses current legislation in the field of supported and renewable energy sources. At the beginning of the thesis are defined renewable energy sources from the perspective of Czech legislation and of professional view. The second part is focused on legislation regarding renewable energy sources in the European Union and the Czech Republic. Follows an overview of the support tools and legislation regarding renewable energy sources in other member states of the European Union and the current status of the set objectives related to the share of energy from renewable sources in gross final energy consumption, which have been established by Directive 2009/28/EC. At the end is summary, along with an overview of the most successful and least successful countries in terms of achieving the objective.
|
|
Legal position of Liechtenstein in European Economic Area
Havlová, Berenika ; Grmelová, Nicole (advisor) ; Spirit, Michal (referee)
The thesis defines legal status of Liechtenstein in the European Economic Area. It is divided into three consecutive chapters. The first chapter consists of two parts - general and economic characteristics of Liechtenstein. The general characteristic is based on the author's experience supported by scientific literature, while economic subchapter is based largely on statistical data. The second chapter focuses on the legal status of Liechtenstein and its position on international scene. The position is viewed from two perspectives, which affects it the most. First, from the perspective of participation in selected international organizations and second, the influence of close relationship with Switzerland. The last chapter analyses international litigation to which Liechtenstein is a party. The aim of this thesis is to define the legal relations of Liechtenstein, which forms its position, using the methods of analysis.
|
|
Analysis of drawing EU Structural funds in the Czech Republic with a detailed focus on OP PIK
Procházka, David ; Svobodová, Ivana (advisor) ; Schön, Kateřina (referee)
Since the third and possibly the last grant period for the Czech Republic in the framework of drawing the European Funds is underway, it is assumed that businesses successfully and efficiently draw funds with allocated resources for the Czech Republic. Agencies should also help to the effective implementation, however, their activities do not reflect the market and clients requirements properly. To confirm that, the Czech Republic was in previous years, one of the worst states in terms of efficiency of drawing on funds of the EU structural funds, which was caused by an improperly formed grant system by management authorities, as well as misconduct on the part of applicants and potential beneficiaries and agencies with their erroneous philosophies. Author task was to analyse the causes of drawing funds inefficiency with a detailed focus on Operational Programme Enterprise and Innovation and Entreprise and Innovation for Competitiveness used mainly for businesses. Diploma thesis not only analyses the current grant situation in which entrepreneurs can submit their project applications but also proposes possible solutions how to help entrepreneurs in drawing on funds.
|
|
Dietary supplements and iodine supplementation for children 11-12 years in the Czech Republic
HALÁSZOVÁ, Monika
Bachelor Thesis called "Dietary supplements and iodine supplementation for children 11-12 years in the Czech Republic" deal with the intake of dietary supplements containing iodine and intake of other significant dietary sources of iodine in relationship to saturation with iodine in the monitored group of 300 children aged 11-12 years . The thesis is divided into theoretical and practical part. Theoretical part deal with established issues in light of current situation and uses the knowledge of specialized literature in these areas: iodine and his dietary sources, influence of deficient or excessive intake of iodine on thyroid gland and its function, and also the solution to iodine deficit in Czech Republic. The thesis also deals with dietary supplements and nutrition of school-aged children. Practical part is focused on quantitative research. This research was done on selected group of children who had low level of ioduria (iodine in urine) according to State health institution. Statistical file included 300 children of both gender in age from 11 to 12 who live in Czech Republic. The reason why children of this age were chosen is because of importance of optimal intake of iodine in period of physical and sexual evolution. The children were divided into two groups. One group had ioduria up to 300ug/l and the second group had ioduria over 300u/l. Data were collected through questionnaire. Because of age of respondents, the questionnaire was filled in presence of at least parent. The questionnaire should have also served to parents as information about iodine importance for their children. The individual evaluation of ioduria and questionnaire was given to parents upon their request. Collected data were evaluated in Microsoft Excel. In practical part, two main goals and two research questions are set. Their task is to determine the rate of usage of dietary supplements with iodine and to find out what significant sources of iodine the children with ioduria over 300u/l take in. The milk and milk products, salt with iodine, salted delicacies, sea products and dietary supplements with iodine were observed as probable main sources of iodine intake. The first goal was to find out the amount of iodine intake from dietary supplements for previously mentioned group of children. The second goal was to find out if the dietary supplements with iodine (or any other combination of food rich on iodine) are used by observed individuals with ioduria over 300u/l. The results of research show if the respondent's level of ioduria is affected by in taking the dietary supplements or food with significantly higher content of iodine. My own research proved relatively frequent (but irregular) intake of dietary supplements with iodine by whole examined population. On the other hand, usage of dietary supplements with iodine is probably not correlated with usage of table salt without iodine or with thyroid gland illness by individual respondent or in his family. The milk and milk products and table salt with iodine proved to be the main source of iodine. According to research, children with excessive ioduria consume sources of iodine as frequent as other children. Deeper insight into results shows that reason for excessive saturation with iodine is combination of intake of dietary supplements as well as other significant food sources of iodine, especially milk and its products. By several respondents, the higher level of ioduria can be caused by higher consummation of sea products or by usage of dietary supplements with iodine in last two days. The need for better awareness about suitable rate of iodine dietary supplements intake as well as medical importance for lowering the amount of (iodine) table salt in food was discovered by research. The optimal supply of iodine by higher percent of observed population could be also achieved by optimizing the content of iodine in milk.
|
|
Implementation of European legislation into the legal order of the Czech Republic
Pelc Vostrá, Nelly ; Zemánek, Jiří (advisor) ; Král, Richard (referee)
AAAAbstractbstractbstractbstract The main purpose of my thesis is to analyse how Czech legal order deals with the obligation to implement European legislation, and also, how it is affected by the process of implementation. The thesis consists of two major parts. Part One describes the European law system from the point of view of its effects on a national law; the direct effect as well as the obligation to implement the EU law into national legal acts are considered. Part Two is divided into six chapters; each chapter deals with a different aspect of Czech obligation to implement and apply the EU law. Czech government is the main legislative initiator and has developed detailed rules for preparing government bills. However, the praxis is far from ideal. Both chambers of Czech Parliament are affected by serious lack of interest in the process of implementation. The Constitutional court provides a constantly growing judicature of open-minded interpretation of the national law with respect to the EU law. On the other hand, it shows a surprising reluctance to refer for a preliminary ruling at the Court of Justice of the European Union. Czech courts have to deal with principles of application of the EU law. With respect to a principle of damages for failure to fulfil the member state's obligations under EU law,...
|
|
Lifelong Education as a Part of the Social System
Neckařová, Jana ; Šrédl, Karel (advisor) ; Hana, Hana (referee)
The diploma thesis discusses about education of adult population, while pointing out necessity of education in any age. This thesis explain importance of education of the adult population, mention forms and possible methods which are used in this type of education the most. Besides the theoretical outcome there is practical aspect included as well in form of questionnaires. Investigation in form of research was focused directly on employees, who as well as on employers whose employees attended the program. In summary both parties consider adulthood gained knowledge as a great benefit to employee as well as employer. In any case, people with higher level of education have better chances of getting a possible job than those with no or low level of education.
|
|
Evaluation of the European Cohesion Policy in Selected Region
Podzimková, Ivana ; Tomšík, Karel (advisor) ; Pavel, Pavel (referee)
The diploma's thesis is aiming to evaluate European policy of social cohesion and its growth options in the selected region. The evaluation is connected to the Elbe cycle route and it is based on analyses.
The theoretical part of the thesis introduces the subject of European policy of social cohesion while defining its legislation and framework of the legislation. It also defines the embodiment of regional politics within legislation of the local government i.e. the Czech Republic.
Analyses of the development of the selected project i.e. the Elbe cycle route and its impact on Hradec Kralove district will be dealt with in the practical part of the thesis. Business results of entities participating on the Elbe cycle route project will be gathered and used in order to evaluate selected indicators. Final assessment will be based on benchmarking. Method of comparison, analyses and syntheses will be used to evaluate gathered data. Applicable data will be gathered by research of related literature. Information will be also provided by the executive entities connected to the project, regional websites focussed on cycle tourism and by the town of Smiřice. Data gathered by the entities that cooperate on supervision of the Elbe cycle route project will be used for the statistic assessment.
|
|
The Wine Market in the Czech Republic and the Politics of Wine
Vlašicová, Eliška ; Tomšík, Karel (advisor) ; Malý, Michal (referee)
The dissertation thesis is focusing on the wine market in the Czech Republic. The aim is to identify weaknesses in the wine sector in order to formulate recommendations for improving a current situation in the sector. The Common Agricultural Policy of the European Union and the Common Market Organisation for Wine was presented in the theoretical part of the thesis, where also theoretical aspects of a market including supply and demand were described, as well as an agri-food market and its specifics, wine commodity chain, determinants of demand, supply and prices of wine. In the following chapters an analysis of the wine market, especially with emphasis on the production potential of vineyards in the Czech Republic was created, and demand, supply and price of wine including a price transmission in the commodity chain of wine were modelled based on a regression analysis. The significant influence on demand of wine have had previous values of wine consumption and wine prices, substitutes consumptions (prices of substitutes were not a significant factors), household income and salary, a quality of the wine and awards in international competitions. Significant factors of the side of supply including the price of wine grapes, the price of wine, vineyard area, production of wine grapes, some aspects of weather and certain subsidies. A climate change, which is in progress, may result to the expansion of viticulture and winemaking in the Czech Republic and also to a change of varieties in vineyards. Demand has in the commodity chain of wine greater impact than the supply. It can have a negative effect on growers or winemakers. Planting of vines is not sufficient to maintain current levels of a production potential of vineyards in the Czech Republic. The ideal amount of annual planting vines should be about 655 ha. A related issue is financing a vineyards renewal, which is costly. Based on a financial analysis of small and medium-sized wine companies, it was found that these businesses cannot afford the renewal of vineyards from its own resources and will require grant assistance of the state, eventually EU.
|
|
Freezing technology of bull sperm in relation to its survivability and fertilization ability
Doležalová, Martina ; Stádník, Luděk (advisor) ; Jiří, Jiří (referee)
The aim of optimalization the insemination doses production is to provide the highest fertilization ability of spermatozoa during the demanding proces of processing fresh semen and its subsequent cryopreservation. Temperature changes causes spermatozoa damage during the cooling and freezing. Spermatozoa is exposed to cold shock and many others limiting factors, which leads to cell death and therefore to decline of fertilization ability of thawed insemination doses. For increasing spermatozoa resistance, exactly the plasma membrane resistance against cold shock was fraction of egg yolk LDL cholesterol (low density lipoprotein) at various concentrations into the comercially produced diluents added. It is believed that LDL acts possitively to plasma membrane and helps to maintain the fertilization ability of spermatozoa after thawing. Following step in the proces of insemination doses production is slow cooling of diluted semen and equilibration, when the straws are store at cooling box for 30 minutes to 240 hours. This period is necessary to penetrate of certain diluent components into the spermatazoa also maintain the balance between their intracellular and extracellular concentration. Also important is subsequent freezing temperature gradient of insemination doses. The most suitable freezing method is based on computer controlled temperature decline in freezing chamber which allows the precise control of ice crystals formation that could tear and kill the cell.
During 2012 to 2016 was repeatedly collected semen from the group of breeding bulls (n = 27, Holstein and Czech Fleckvieh breed) at AI centre. Semen which fulfill the standard entrance conditions in first step was evenly into several parts divided. For dilution the three types of comercially diluents AndroMed, Bioxcell and Triladyl with and without LDL addition were used. Into the diluents AndroMed and Bioxcell the concentration of LDL 4 %, 6 % and 8% into the dilent Triladyl 6 %, 8 % and 10 % was added. Diluted semen was filled into the glass capillares with volume 0,1 ml and temperature +4 °C. Subsequently the sample was placed to cold bath (0°C) for 10 minutes. Then the volume of capillare with physiological solution (37 °C) was mixed and for next 120 minutes was incubate. The effect of cold shock to proportion of live spermatozoa was evaluated by using Eosin and Nigrosine staining technique during heat test of spermatozoa survivability after spermatozoa heating and after 120 minutes of incubation.
The more suitable semen diluents which provide the higher spermatozoa resistance against cold shock were AndroMed and Bioxcell. Together the possitive effect of LDL addition into the diluents to lower decrease of proportion of live spermatozoa during heat test was found (P<0.05). The most suitable LDL concentration which had a favorable influence at spermatozoa resistance against cold shock was 6 % in diluent Bioxcell. Values of the proportion of live sperm were higher at the beginning of the heat test (+1.31% to + 3.2%) and after 120 minute incubation (+5.82% to +8.41%) compared to other diluents with and without addition of LDL.
In the next step the process of equilibration was optimized, is an important part of insemination doses production. The effect of the length of equilibration for subsequent fertilization ability of spermatozoa was evaluated using spermatozoa motility based of CASA and proportion of live spermatozoa after thawing and during heat survival test lasting 120 minutes (37 ° C). Suitable semen was diluted by comercially used diluent AndroMed based on soya lecithin, filled into the straws (0.25 ml), cooled and equilibrated in cooling box for 30, 120 and 240 minutes and freezed in programmable freezing box applying four types of freezing curves differing in temperature rate decline. There was used standard and by producer recommended 3. phase freezing curve, then 2. phase freezing curve, and 3. phase freezing curve with slower as well as rapid decline of temperature rate in freezing chamber, compared with standard freezing curve. The highest spermatozoa motility was found using 240 minutes of equilibration by +2.72% and +4.58% compared to other lengths of equilibration (P <0.05 to 0.01). The highest proportion of live spermatozoa was found using 120 minutes of equilibration (+6.87 % and +8.68 %). The highest average spermatozoa motility during heat test after thawing was achieved by using 2. phase freezing curve (from +2.97% to +10.37%, P <0.05), also in the proportion of live spermatozoa (from + 4.37% to +8.82%, P <0.01). When evaluating interaction between the length of equilibration and freezing curve (standard 3. phase and 2 . phase freezing curve), the highest average spermatozoa motility and proportion of live spermatozoa using 240 minutes of equilibration by both freezing curves was reached, there was no statistically significant differences. As well as, in all evaluated parts of this study the individual differences between ejaculate of bulls and within semen from one bull (P <0.05) as secondary effect were found.
To maintain good fertilization ability of semen during cryopreservation is necessary to increase the spermatozoa resistance against cold shock using addition of correct concentration of LDL into the commercially used diluents AndroMed and Bioxcell. Subsequently the fertilization ability of insemination dose is influenced by cooling, the length of equilibration and freezing. The length of equilibration 120 minutes and more as well as gentle way of freezing according to freezing curve, which ensures a gradual decrease of temperature in freezing chamber provided the higher average spermatozoa motility and proportion of live spermatozoa.
|
guest ::
