|
|
Possibilities of data presentation in business intelligence applications
Tůma, Martin ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This diploma thesis deals with the possibility of presentation data in business intelligence (BI) applications. The aim is to develop a methodology for reporting and data visualization using Microsoft SQL Server 2008 Business Intelligence Development Studio and Microsoft Excel 2010. Evaluate and identify opportunities for data display using the perception of information at a subconscious level in the above mentioned tools. Identify market trends from the perspective of business intelligence data visualization. In the first part thesis focuses on the analysis of the current BI market with regard to trends in data visualization. In the following part options of perceptions on a subconscious level are examined, which are then reflected in the establishment of a methodology reporting. Similarly, it is investigated the human perception of color. Presented are appropriate and inappropriate data visualization forms, at the most commonly used graphic forms. The work describes a method to ensure that the data will not be displayed tendentiously or distorted. My contribution is creating a reporting methodology that respects the life cycle of the report, as well as a logical follow-up steps to project management.
|
|
|
Basic Physical Practice Coursebook
MITTASCH, Marek
The diploma thesis presents basic concepts of measuring, physical quantities, units of measurement and Physics instruments. There are instructions how to realize the measuring in practice and an introduction of measuring deviation. There are examples showing processing of measured values including use of some Microsoft Excel functions.
|
|
|
Possibilities of using VBA in business practice
Urban, Pavel ; Benáčanová, Helena (advisor) ; Rybka, Čestmír (referee)
This bachelor thesis describes the possibilities of Visual Basic for Applications programing language in real business cases. The goal of the thesis is to develop an application in VBA, that will save the users time and it will awake their interest into automation tools. The application is used to demonstrate the possibilities of VBA. The first part of the thesis analyses the situation and how much the automation tools are used in the HR department of the company the application was developed for. The second part describes the application and its components. There the functionality is explained, the process of development and the users point of view for each component. The last part describes the launch of the application and users feedback.
|
|
|
Portfolio optimization
Arzumanov, Eduard ; Šindelářová, Irena (advisor) ; Chýna, Vladislav (referee)
Nowadays, when the financial sector influences directly or indirectly nearly every part of person's life, when inflation is taken as a normal phenomenon, when we are witnessing bankrupts of different companies, banks and other financial institutions almost on a daily basis due to the incorrect managing of the financial assets or due to the incorrect estimation of overall economic development, more and more often one should consider how to manage his funds to prevent their depreciation or even how to use them to increase its value. For these reason investment into securities has become one of the most common ways of increasing the value of one's financial funds. Particularly -- one way of investment is becoming more and more popular nowadays - financial portfolio investment. That is why this thesis not only will introduce the basic principles and rules of portfolio investment, diversification and the concept of risk (in theoretical part), but will also demonstrate how is the diversification of a portfolio done in practice. The example of portfolio optimization is done using multi-criteria decision analysis applied to a model, designed in MS EXCEL with help of VBA environment.
|
|
|
Logical puzzles and brainteasers as optimization problems
Lukesová, Kristýna ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
This thesis applies classical optimization problems such as assignment or set-covering problem on logical puzzles or brainteasers. Listed in the first part are mathematical model, description and typical example of each optimization problem used in this thesis. The second part contains these models applied to the particular brainteasers for example Sudoku or Einstein's Puzzle. Exercises are divided into simpler and more complex ones. There is specification, source and a described method of solution stated for each of them. The calculation examples use Lingo or MS Excel or both. The aim is to show the possibility to address logical puzzles and brainteasers with the use of optimization problems, and thus confirm the wide possibilities of using these models. These examples can clarify and diversify the curriculum.
|
|
|
Optimization in MS Excel using VBA
Lhoták, Petr ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
There are available various professional applications for the solving of optimization problems. This thesis deals with comparison of these optimization systems and simplicity of their connection with MS Excel through VBA. Problem of designing model together with his calculation in MS Excel or other systems connected via VBA, like MPL for Windows or LINGO, is demonstrated on concrete examples. Application in Visual Basic for Applications was created for this purpose. This application is easy to use and it is solving Knapsack Problem, Distribution Problem and also Quadratic Assignment Problem. Finally, comparison of these systems is made using Multi-criteria evaluation.
|
|
| |
|
| |
|
|
Probability calculator in MS Excel
Ginzl, Michal ; Malá, Ivana (advisor) ; Vrabec, Michal (referee)
The main aim of this thesis is to perform analytical methods for estimating the most commonly used survival distributions. There are introduced the maximum likelihood estimates of the parameters for the exponential, log-normal, gamma, logistic, Gumbel and Weibull distributions without data censored. For some distributions are mentioned probability plotting and how to estimate parameters with method of least squares or by method of moments. There are discussed tests of goodness of the best fitting distribution. Two tests are based on log-likelihood function and another on test of hypothesis. Practical part of this paper forms application programmed in VBA in MS Excel. Main part of this application includes: module for probability calculations, graphs editor and module for data analysis.
|
|
|
Support of teaching computer courses for seniors
Janečková, Hana ; Benáčanová, Helena (advisor) ; Seghmanová, Michaela (referee)
The purpose of this bachelor thesis was to create an e-Learning study material on the subject of MS Excel and to explain the steps of its creation. To achieve these aims it was used not only theoretical materials, but also the results from the questionnaire filled by participants of courses at the University of the Third Age. The thesis is divided into theoretical and practical parts. The theoretical part deals with the question of e-Learning, its definition, its characteristics, its advantages and disavantages. Next, it focuses on the question of seniors education. Special emphasis was put on the practical part, in which the connection between seniors and the program MS Excel was analysed. Then their demand was respected during the creation of e-Learning study material. The contribution was in the creation of study material and in the posibility of utilisation in education.
|
guest ::
