This master thesis deals with the software support of one Financial and Property Analysis of Municipalities (FAMA). The co-author of this method is Doctor Petr Toth from the Institute of Public Administration and Regional Development at University of Economics in Prague. The method is supported by Microsoft Access database application and two C++ applications ArisDestiller and Prognoza at present time. The aim of this thesis is to evaluate the present software support of Financial and Property Analysis and implement an alternative solution based on Business Intelligence tools. Chosen part of analysis is implemented in the pilot project using Microsoft SQL Server 2005 environment. The thesis focuses mainly on using integration tools for XML data. The contribution of the thesis is to implement data warehouse, which uses the municipalities'annual bills in XML format from the database of Ministry of Finance of the Czech Republic. The Financial and Property Analysis method and the current software support are discussed in the first half of this thesis. The other half of the work is dedicated to the Business Intelligence pilot project. Both means of software support are reviewed and compared from various perspectives in the conclusion.

This thesis deals with Business Intelligence and its testing. It seeks to highlight the differences from the classical software testing and finally design a methodology for BI solutions testing that could be used in practice on real projects of BI companies. The aim of thesis is to design a methodology for BI solutions testing based on theoretical knowledge of Business Intelligence and software testing with an emphasis on the specific BI characteristics and requirements and also in accordance with Clever Decision's requirements and test it in practice on a real project in this company. The paper is written up on the basis of studying literature in the field of Business Intelligence and software testing from Czech and foreign sources as well as on the recommendations and experience of Clever Decision's employees. It is one of the few if not the first sources dealing with methodology for BI solutions testing in the Czech language. This work could also serve as a basis for more comprehensive methodologies of BI solutions testing. The thesis can be divided into theoretical and practical part. The theoretical part tries to explain the purpose of Business Intelligence use in enterprises. It elucidates particular components of the BI solution, then the actual software testing, various types of tests, with emphasis on the differences and specificities of Business Intelligence. The theoretical part is followed by designed methodology for BI solutions using a generic model for the BI/DW solution testing. The practical part's highlight is the description of real BI project testing in Clever Decision according to the designed methodology.

This thesis deals with the issue of the project management, project portfolio management and environment settings for the management and portfolio analysis in a fictional organization. In the theoretical introduction there is outlined the situation of the education of the project portfolio management at universities in the Czech Republic, Europe and worldwide, in summary form of founded courses that deal with this issue. Some basic principles of PMI methodology follow to introduce the reader to the project and portfolio management. As a practical part of this thesis there has been project management solution software implemented as a support for the portfolio management education. Microsoft Project 2010 has been selected for this purpose. This part of the thesis guides reader through practical topics like how to set up the whole environment including all utilities and contains a description of services settings. As example there were also sample roles and resources of the company set up, which were subsequently assigned to fictional projects so that the business portfolio analysis based on set of business goals and prioritization of individual projects could have been performed. The contribution of this work can be found mainly in the possibility of portfolio management education and training by using one of the leading software tool that are successfully implemented in a real production environment, and to try out the various acts and practices and also to clarify the various processes in the context of specific projects within the portfolio. Prepared fictional organization and sample data can be especially used as a model for handling various assignments in the upcoming educational courses at VŠE.

This work deals with the modifications of project MeDiMed, which ceased to meet the requirements it imposed. In the first part the main objectives, targets and methods to achieve them are defined. The second part deals with the theory that is needed to understand the issue. In the practical part, which is based on the theory is prepared SWOT analysis and the modified HOS-8 analysis of the current state, whose results are then analyzed. The next section presents design of new solution. The conclusion summarizes all the proposed solutions and knowledge that have been achieved in this work.

This work deals with the modifications of project MeDiMed, which ceased to meet the requirements it imposed. In the first part the main objectives, targets and methods to achieve them are defined. The second part deals with the theory that is needed to understand the issue. In the practical part, which is based on the theory is prepared SWOT analysis and the modified HOS-8 analysis of the current state, whose results are then analyzed. The next section presents design of new solution. The conclusion summarizes all the proposed solutions and knowledge that have been achieved in this work.

The task of this project is to build application for managing of multimedia data in enclosed wireless networks and to present this data to the user. In model case it can be for example city guide - on position given by GPS are presented information about surrounding scene. Application must be capable of downloading data into Pocket PC - PDA and present them to the user as user friendly application.

Data collecting and analysis are commonly used techniques in many sectors of today's business and science. Process called Knowledge Discovery in Databases presents itself as a great tool to find new and interesting information that can be used in a future developement. This thesis deals with basic principles of data mining and temporal data mining as well as with specifics of concrete implementation of chosen algorithms for mining periodic patterns in time series. These algorithms have been developed in a form of managed plug-ins for Microsoft Analysis Services -- service that provides data mining features for Microsoft SQL Server. Finally, we discuss obtained results of performed experiments focused on time complexity of implemented algorithms.

This master's thesis is focused on knowledge discovery from databases, especially on methods of mining sequential patterns. Individual methods of mining sequential patterns are described in detail. Further, this work deals with extending the platform Microsoft SQL Server Analysis Services of new mining algorithms. In the practical part of this thesis, plugins for mining sequential patterns are implemented into MS SQL Server. In the last part, these algorithms are compared on different data sets.

This thesis deals with association rules mining over data warehouses. In the first part the reader will be familiarized with terms like knowledge discovery in databases and data mining. The following part of the work deals with data warehouses. Further the association analysis, the association rules, their types and mining possibilities are described. The architecture of Microsoft SQL Server and its tools for working with data warehouses are presented. The rest of the thesis includes description and analysis of the Star-miner algorithm, design, implementation and testing of the application.

With the increase of demands for the speed and availability of the information technologies, the process of optimization gains more and more importance. Concerning search engine optimization, optimization of operating systems or application optimization (source code), the goal is to gain faster, smaller and more maintainable solution. In my thesis I deal with optimization of database systems, which includes low level of database tuning - physical organization of data and indices, database management system tuning and query optimization. I focused on optimization of Microsoft SQL Servers 2005 in enterprise environment.