|
|
Corporate Performance Management Based on Business Intelligence
Křepinská, Veronika ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Nowadays, corporations run their business on dynamic markets with really harsh competition. If they want to survive, they need to manage their business effectively and increase corporate performance. Management is today highly supported by information and communication technologies that develop and bring new solutions and technologies continuously. One of these new solutions is Corporate Performance Management based on Business Intelligence technologies that enables complex and integrated view of business performance and its management. This thesis is devoted to this new developing approach in IS/ICT. Readers will become familiar with its basic principles, advantages, particular components and process of implementation. After this more theoretical part, follows the practical issue - realization of this solution for an existing organization in order to get expected results and effects. The solution is designed for a company that provides consulting and software development in Business Intelligence technologies. According to the cycle of CPM, firstly, a Performance Management method is chosen, after that the corporate strategy and concrete KPIs as they enhance the goals and strategy achievement. Afterwards data sources are identified and optimized as needed. On these data sources, all the visualization tools for Performance management are developed. In this case we are talking about interactive scorecards and dashboards. After this phase, the solution is ready for the developers to create it in the concrete application. In this case the Microsoft Office PerformancePoint Server 2007.
|
|
|
Data quality, data integrity and consolidation of data in BI
Dražil, Michal ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis deals with the areas of enterprise data quality, data integrity and data consolidation from the perspective of Business Intelligence (BI), which is currently experiencing significant growth. The aim of this thesis is to provide a comprehensive view of the data quality in terms of BI, to analyze problems in the area of data quality control and to propose options to address them. Moreover, the thesis aims to analyze and assess the features of specialized software tools for data quality. Last but not least aim of this thesis is to identify the critical success factors in the field of data quality in CRM and BI projects. The thesis is divided into two parts. The first (theoretical) part deals with data quality, data integrity and consolidation of data in relation to BI trying to identify key issues, which are related to these areas. The second (practical) part of the thesis deals at first with the features of software tools for data quality and offers their fundamental summary as well as the tools breakdown. This part also provides basic comparison of the few selected software products specialized at the corporate data quality assurance. The practical part hereafter describes addressing the data quality within the specific BI/CRM project conducted by Clever Decision Ltd. This thesis is intended primarily for BI and data quality experts, as well as the others who are interested in these disciplines. The main contribution of this thesis is that it provides comprehensive view not only of data quality itself, but also deals with the issues that are directly related to the corporate data quality assurance. This thesis can serve as a sort of guidance for one of the first implementation phases in the BI projects, which deals with the data integration, data consolidation and solving problems in the area of data quality.
|
|
|
Reaction to errors and alerts in ETL
Klimt, Roman ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This work deals with information systems called Business Intelligence (BI). Especially, it focuses on one part, whose task is to extract data from primary information systems. This stage is known as extract, transform, load (ETL). ETL is one of the most important stage in BI solutions because the quality of data depends on this stage. These data are used for all analyses and created reports. The goal of this work is to suggest solution for active projects, which are short of automated controlling mechanism. This mechanism should inform users of BI solutions about errors in data. If data from primary systems are in such bad state that ETL process is not able to match primary keys to them, the data are stored in special tables and are not used for future analyses. This is a very serious problem because analyses and reports based on the data may be misrepresentative. This problem must be solved by repairing the data in primary information systems. The administrator of primary information system has to know about the incorrect so that the data could be repaired. Therefore, an automated e-mailing system has been designed to inform about the incorrect data.
|
|
|
Change management of the SW projects in the small and medium business
Targa, Jan ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
The bachelor thesis focuses on SW projects, ways of their management and mainly change management in the small and medium business. This thesis is devided into two parts. Author deals with SW projects and most common mistakes during their development in the theory part. The main aim of this part is to refer to these mistakes the reader, who is interested in SW projects. Next, there is a comparision of the two famous methodics, which are well-known in the SW development. These are ITIL and RUP. Author will choose the one, which will be more acceptable for the Cleverdecision. At this time, Cleverdecision has no change management and every change during the SW development is managed by contracting condition. That is why author formulates the ways of change management in the practical part. This will be based on the chosen methodics from the theory part. This formulation is the main aim of this thesis. The contribution of the thesis is in the definition of the change management workflow and in the proposition of the templates for setting the change requests. These templates are sufficient for unification concepts and easier specification of the change requests. Insertion of the change management into the contract is part of the thesis as well.
|
|
|
Practical Use of Data Mining Technologies
Uhlíř, Radek ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This bachelor's thesis maps available technologies of extracting knowledge from the raw data. These methods are globally known as Data Mining. Some of these methods are implemented in the second part - proof of concept of Data mining support in sales department. The aim of this work is to identify and implement suitable technologies for answering analytical questions and getting knowledge from data owned by business companies. It should help to improve and optimize business processes and resource utilization. Customer segmentation support and association rules identification are also expected. In the second part are identified possible weaknesses and problems during the process of implementation and deployment of these systems. The work should propose optimal methods of solving these problems or at least modifications in process of implementation to eliminate some vulnerability. The work is divided into two parts -- first is theoretical and maps available methods and second part is about implementation of project in pharmaceutical company. This solution was built using Microsoft SQL Server platform.
|
|
|
Project management in BI
Vacek, Antonín ; Pour, Jan (advisor) ; Zajíc, Jan (referee)
Project management as a branch is nothing new, that doesn't mean that there is not the possibility of improvement or implementating of new methodics in this field. The goal of the opening theorethical section of this work is to explain the problematic of the project management in IS/ICT in general as well as partially in the BI enviroment. In this section the reader is going to learn from which activities project management consists, what documents or templates in which stage of the project are commonly used, as well as some practical examples from project management practice. The rest of this work is then focusing on implementing the theoretical knowledge from the opening section into the practice of the real project in SYSTIXT, ltd. (the name of the company is made-up, the real one wished not to be named in this work). The main output from this section is the concept of the project management plan of this project (some of the parts are done in MS Project 2007). Very important output of this practical section is also creating of some templates for project management that will suit the forementioned company needs. A part of this section is also evaluation of current practices in project management in the SYSTIXT ltd. and the proposal of some changes in this field.
|
|
|
Design and creation of BI systems documentation
Andrle, Ondřej ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This work deals with the different kinds of documents and documentations accompanying an implementation of Business Intelligence Systems. The character and structure of this work is influenced by cooperation with the Cleverdecision company. This company has enabled analytic work with data from medical registers by implementing the BI solution into the medical sphere. The implemented BI solution is in this work documented in two directions. First documentation is certain specification of the BI solution including architecture, descriptions of single components and applied hardware and software. This documentation is mainly a demonstration of the description of possibilities of the BI system and it is put after the theoretical part. The Theoretical part is about document types, which originates at the projecting of BI systems. The second documentation is intended for end users of the systems and it is put in the enclosure. It explains the possibilities of work with pivot tables in Microsoft Excel backgrounds that are used for analytic work with data. By the help of this documentation the user will be able to connect to multidimensional cube and draw up quality and predicative outputs. These two documentations are the main aims of the work. This work also mentions different end users groups and their abilities to work with the reports. In the end of the work there is an analysis of the single periods and principles of formulation of the user documentation.
|
|
|
Master Data Management
Jakoubek, Jiří ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Master Data Management (MDM) represents relatively newly emerging domain. The main objective of the MDM program is to provide policies, procedures, and infrastructures that support organization, exploitation and distribution of the enterprise master data. The work is divided into two elemental parts. Goal of the first part is to answer the principal questions related to the MDM. It deals with reasons of the origin of MDM and with explanation of master data and master data management. It determines the relations between MDM and other enterprise information systems (ERP, SCM, CRM etc.), describes contributions that can bring the implementation of MDM into the enterprise and shows some indicators of the data quality in the way of MDM. There is also specified who is interested in the implementation of MDM into the enterprise and who participates in this implementation. The end of the first theoretical part shows and describes MDM component and service model. The objective of the second, practical part is to project a technique of the administration of master data in practice. It describes technologies that help in achieving this goal and it also shows an example on the representative table of master data. This part is based on the practical experience on real project that was made in cooperation with CleverDecision, s.r.o.
|
|
|
Critical Success Factors of Business Intelligence Implementation in the Non-commercial Sector
Jelínek, Petr ; Novotný, Ota (advisor) ; Zajíc, Ján (referee)
The main objective of this thesis is to create a list of critical success factors (CSF) of Business Intelligence implementation in the non-commercial sector and check this list in practice on real projects. Part of the thesis is also the summary of all specifics and differences of BI implementation in public sector and the view of usage possibilities of BI in this sector in relationship on already implemented projects in the Czech Republic so and abroad. The thesis is composed of theoretical and practical part. Theoretical part is focused on problems related to this area, especially analyses the present state of BI in public sector and features specifics and differences related to BI implementation in this area. Further also describes all significant critical success factors of BI implementation in general. Practical part is then aimed on particular verification of Business Intelligence CSFs on real projects realized in non-commercial sector inside of the Czech Republic. As a main tool for obtaining needed and objective information were used managed interviews with competent deputies of submitter (customer) and supplier of particular BI solution. The main contribution of this thesis is determination of differences, but also consistent components of Business Intelligence implementation in non-commercial sector compared to private sector with emphasis on critical success factors. Significant is also the comprehensive view of possibilities and advantages of BI usage in public sector, created by analysis of already implemented projects. These achieved results can be utilized by future (and contemporary) suppliers and submitters of BI projects, but also of other projects from information science area.
|
|
|
Documentation of the Reporting system project, ETL standards proposal
Ptáčník, Tomáš ; Slánský, David (advisor) ; Zajíc, Ján (referee)
První část této diplomové práce je zaměřena na vymezení základních aspektů Business Intelligence a její popis, který může být určen k prostudování, jakožto úvod pro jedince této problematiky neznalé. Základní myšlenky a principy jsou vysvětlovány na názorných obrázcích. Ideje zde přednesené ale mohou dále sloužit jako ?jiný? pohled určený k dalšímu uvažování o těchto základních otázkách. Následně se práce zabývá implementací Business Intelligence v organizaci a některými souvislostmi v projektu Business Intelligence. Shrnutí doporučení uváděných v literatuře a nejen z nich vyúsťující návrhy ETL standardů jsou poslední teoretickou částí. Práce je uzavřena dokumentací k projektu Reportingového systému, resp. především části ETL, kterou autor v době psaní textu zpracovával (neveřejná část práce)
|
guest ::
RSS feed.