|
|
Data Warehouse Management and MWF Optimization
Matoušková, Barbora ; Maryška, Miloš (advisor) ; Faina, Michal (referee)
This thesis focuses on the data warehouse of an extensive bank intitution from its operational management point of view (for the main part). To grasp the fast overview of the data warehouse the thesis includes the description of its data architecture, transformation processes and the way of presenting data to its users. Besides that the description of systems used for both the business data and for the metadata purposses is also included in this thesis. The thesis also covers operational activities including the identification of weak areas and their improvements. Another part of the thesis is represented by the project of optimization of a scheduling mechanism (Master Workflow) for running transformation processes, that helps to minimalize the metadata load of the Teradata database system. The main goal of this thesis is to describe the environment of the data warehouse in an understandable way. It's critical to understand the environment for both, the operational management personnel and for developers, that can supply the warehouse with higher quality solutions and ease the deployment of new deliveries into the production environment. This goal is achieved by the description of the data warehouse (mainly the description of its data architecture, transformation processes, operational activities and tools used to deploy changes into the production environment). Another goal is to give a feedback on the operational activities from the operational personnel point of view. This helps identify weak spots and can lead to its elimination. The last goal is to improve the scheduling mechanism that controls and runs all transformation processes. This goal is achieved by a project. The thesis describes the starting state, implemented changes, final state and the consideration whether the project was successful or not. The thesis brings several contributions: easier understanding of the data warehouse and the way of managing ETL processes -- for the operational management personnel and developers, which can bring the improvement of new solutions. The possibility of elimination of weak areas in the operational activities. And thanks to the project described there are two changes -- standardization and the metadata load of Teradata decreased. My own contribution to this issue is, besides the useful introduction to the data warehouse, the identification of the weak areas, suggested improvements and also the project of optimization Master Workflow which took about 17 MD. The thesis is devided into chapters based on the topics described: introductory information, theoretical base, characteristics of the main systems, the description of the data warehouse, the description of operational activities including the identification of weak areas, and at the end there is the project of optimization of Master Workflow. In the last chapter there is the final conclusion of the entire thesis.
|
|
|
Corporate Perfomance Management in the company trading IT technologies
Procházková, Katarína ; Pour, Jan (advisor) ; Faina, Michal (referee)
Diploma thesis is focused on the area of corporate performance management in corporation. As the time passes and technology is developing, the amount of information is still increasing. The company has to work with these information and process data based on which it can make decisions in everyday business. It is crucial for the company to know how to process data and create processes and information systems so the data can be used for effective decisions making process. The goal of this thesis is to introduce corporate performance management as the complex system and make the proposal of the concept for the company on Slovak and Czech market trading with information technology. Thesis is divided into two parts. The first one is about introducing principles of corporate performance management (as abbreviation CPM) -- introduction of components, history and also the place of CPM in architecture of the company. It also describes the possible future of importance in the company IT structure. In the end of first part there are introduced 5 principles of integrating CPM into real company life cycle. In the second part, thesis is about application of CPM into the company on Czech and Slovak market. In the first place, analysis was done about the state of each of components of CPM. Afterwards, all components of CPM were again designed so it would be possible to reach the best results. In the second part there is also detailed manual according to 5 principles by Palladino how to implement corporate performance management into this company.
|
|
|
Measurement of Economic Effectiveness of IS/ICT
Čelikovský, Filip ; Maryška, Miloš (advisor) ; Faina, Michal (referee)
The main goal of this thesis is to measure the economic effectiveness of the specific real IS/ICT based on real data, which were provide by the owner of the system. Next goal is to describe how to measure economic effectiveness of IS/ICT, especially based on costs and effects analysis. Complex information about economic effectiveness of IS/ICT issue and also costs and effects analysis of enterprise informatics are made up of knowledge gained by studying professional publications aimed to this and relative topics. Necessary data to measure the economic effectiveness of the chosen IS/ICT was gained by its owner. To reach the main goal, author chose a few commonly used financial indicators and proposed two other metrics. Based on calculations of these indicators and metrics, author estimated that the rated system is economically effective. Author forwarded the results of measurement to the owner of rated system, along with the comment of author. The contribution of this thesis is that shows the universal procedure of economic effectiveness measurement of IS/ITC in clear and complex structure. The thesis can be divided into two logical parts -- the theoretical one and practical one. In the theoretical part, author describes in standalone chapter possibilities in dividing of costs and its identification, severity of this act and also possible ways of the cost evidence. The next chapter speaks about effects of IS/ICT, where author also mention possibilities in dividing of effects, ways of their identification and measurement. This capture also put the accent especially on the hardness of their assignment. The last theoretical chapter imaginarily joins the antecedent chapters because describes a few financial indicators and metrics, suitable for measurement of economic effectiveness of IC/ICT. In that case, this capture speaks about usage data about costs and effects in measurement of economic effectiveness. One whole chapter is devoted to practical part of this thesis, in which author used all defined indicators and metrics from theoretical part and measured the economic effectiveness based on real data. Thus, author used the knowledge from theoretical part in the practical one. The part of measurement is also a discussion of the results.
|
|
|
Collateral Management and its interception and support in information systems, financial institution
Dudek, Tomáš ; Faina, Michal (advisor) ; Zetek, Pavel (referee)
The main objective of this thesis is to capture and support for Collateral Management in the environment of financial institution. The thesis deals with general and practical description Collateral Management, realizaction collateral management, trouble banking institucion implemented through the parent banking institution, and aplicaton design Collateral Management. The main benefits of this thesis I find the introduction of Collateral Management and submitting information on IT application covering the Collateral Management, and a reminders types of financial markets, banking institutions and their risks.
|
|
|
Deploying MS SharePoint Foundation 2010 in a middle-sized company
Kalus, Vilém ; Faina, Michal (advisor) ; Pour, Jan (referee)
This thesis is focused on a portal system Microsoft SharePoint Foundation 2010 which is suitable for medium-sized companies. The goal of this thesis is to provide information about this portal system and to suggest it as a possible solution for content management. This thesis shows the basic function of Microsoft SharePoint in a language school. I have achieved the goal thanks to my personal experience (I work as an IT support specialist in a medium-sized company) and my experience with Microsoft SharePoint Foundation 2010 system. This thesis' contribution lies in an independent and practical use of Microsoft SharePoint Foundation 2010 system in a language school and in gaining experience with this system.
|
|
|
Application of social network services in the company
Dušek, Roman ; Šedivá, Zuzana (advisor) ; Faina, Michal (referee)
This thesis defines and then verifies procedures of establishing a representative and successful representation of a firm on social networks. It also describes the current situation in the Czech Republic and abroad. In the first part, this document examines general and philosophical background of new media and current development of the Internet. Following part describes the history and defines the most important social networks all over the world and in the Czech Republic. Subsequently, Facebook is determined as the most important and relevant social network for business activities in terms of new media. That is why it was used for explanation of basic rules and procedures of successful business activities on social networks. The main ideas are to comply with a reasonable amount, to maintain relevance and information value of messages and to respect opinions and wishes of all users. The following part is focused on user's privacy and information sharing on social networks. The results of the research show that most users limit the range in which they share information and differentiate between different types of the information. Different possibilities of using social networks for businesses and supporting their activities are presented in the last part of the theoretical section. The practical section demonstrates use of the procedures defined in the theoretical part and their specific effects and outcomes through example of Rock for People festival. In terms of social networks, the festival is under the administration of Agency of Social Visage, which provided materials and data for this document. The outcome of the whole thesis is to confirm correctness, considerations and definitions. In the case of Rock for People festival, Social Visage achieved real outcomes using these considerations and definitions.
|
|
|
International comparison of the use of e-business
Janečko, Jan ; Pour, Jan (advisor) ; Faina, Michal (referee)
In the Czech Republic, more than a third of all businesses with 10 or more employees buy their goods or services via computer networks. In contrast, more than a fifth of all businesses sale using at least one form of e-commerce. Common citizen can get this kind of information, for example, from media, newspaper or spoken word, but without wider context they have got only general information value. Electronic business, which e-commerce is part of, is a large area which depends on many factors, such as the legislation of the country, its economic maturity or level of computer literacy. The purpose of this work is to bring the closer look about the various forms of e-commerce and especially to analyze their current state, business sector development in the Czech Republic for the last few years and make a comparison with EU countries. The analytical part of this work is based on data obtained from the database of the Czech Statistical Office.
|
|
|
Systems for managing Enterprise IT
Hrubý, Karel ; Pour, Jan (advisor) ; Faina, Michal (referee)
The topic of this master thesis are the Systems for managing enterprise IT. This paper is divided into three parts, where the first and second part gives a comprehensive view and concentrates existing knowledge from the examined area. The third part consists of my own conclusions based on available resources. For the overall IT Management, it is necessary to manage and measure IT Performance. Therefore, the first part deals with IT Performance Management (ITPM).Performance Management should penetrate the entire organization and ITPM should be part of the overall Performance Management of the organization. It is necessary to manage and measure performance at all levels of the organization (strategic, tactical and operational level). To measure the organizational IT performance, it is necessary to design relevant metrics. To design these metrics it is recommendable to follow a framework, whether ITIL or COBIT. The second part of this paper deals with IT Management frameworks and their support for designing metrics. It deals with the new wave in IT -- ITSM (IT Service Management). The de facto standard for ITSM is ITIL. Furthermore, the second part discusses the de facto standard for IT Governance -- COBIT and IT Balanced Scorecard for clarifying and translating the vision and strategy into specific objectives. The third part describes a specific procedure for designing metrics according to the ITIL framework. In addition, this part describes the software Metricus which enables a centralized management of ITPM and uses a holistic view of the overall ITPM.
|
|
|
Usage of Microsoft SharePoint in small and medium business
Šimek, Jan ; Faina, Michal (advisor) ; Pospíšil, Jaroslav (referee)
This thesis focuses on the possible usage of Microsoft SharePoint in small and medium size companies. The main objective is to introduce a system that came brand new in 2010 and is called the Microsoft SharePoint Foundation and is precisely designed for the given segment of market. The thesis describes the technology with regards to the division of the market, current financial expenses for the company and procedures for obtaining the software. It also contains necessary hardware and software requirements to ensure performance and stability in relation to business processes. Following is the description of a fictitious company in which the system is introduced virtually from the basic product installation, division of the costs needed for training employees to post functionalities suitable for use in a given environment. I find the added value in the practical experience collected during my work on this project. In particular, during installation, set up of rights, simple integration with Active Directory, SQL, and the pre-defined business processes.
|
|
|
Implementation of ITIL into Small and Medium Business
Labská, Julie ; Faina, Michal (advisor) ; Pour, Jan (referee)
This work is initially focused on the general description of ITIL V3 (Information Technology Infrastructure Library) and its five elementary books to enable the reader to become familiar with the essential terms and to get at least an overall view of this approach to the administration of IT services. The section Service Strategy is deeply analyzed on a theoretical level as well as in the practical part of the work. For the needs of this work, the term SMB -- Small and Medium Business is defined, in accordance with the recommendations of the European Commission. For these businesses, the work describes the advantages and disadvantages related not only to their operation, but also to the implementation of ITIL. In the practical part of the work, an analysis of a current state of a sample small business is carried out in the field of service strategy, the result of which is the assessment of its state according to the ITIL principles, pointing out faulty processes or incorrectly defined services, and the decision whether the company would benefit from changing its service strategy.
|
guest ::
