|
|
Methods and forms of presentation of Business Intelligence solutions to potential customers
Křemenák, Jakub ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
In my work I deal with forms and methods of reaching potential clients. It is mainly about ways to reach potential customers and how they take to start thinking about buying our products and services company. This work is theoretical and is divided into three parts. The first part discusses specific ways to reach potential clients. The second section describes how to behave and act when we are in contact with the client, or when presenting for a wider audience. The last section is devoted to the benefits of BI systems, and describe people with whom we come into contact in the sale of information systems, and who decide about purchase our product or not.
|
|
|
Design of methodology for BI solutions testing
Jakubičková, Nela ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
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.
|
|
|
Methodology of solving analytical tasks in BI
Masagutov, Dmitry ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
All big and important decisions come through analysis. The main aim of the analysis is to examine or investigate more complicated problems by decomposing them into simpler ones whereas we come to certain conclusions on the basis of a detailed recognition of particularities. This diploma thesis is dedicated to analytic tasks solving techniques in Business Intelligence which would describe and support the whole process of analysis, its needs and premises in real surrounding environment. During the project I cooperated with Clever Decision company and took part in the real project. This company deals with Business Intelligence solutions/applications development and this project is meant to set the method of how to treat the development of the solutions. My work consists in designing a template of BI analysis method which is a part of a complex technique. The aim of this diploma thesis is to introduce my own method of Business Intelligence solution analysis, to introduce its basic components and common work instructions for this method. I reached my aim by analyzing documents and reports provided by Clever Decision company and other methods and suggestions. The main contribution of my diploma thesis is that the method works as a draft for assistance and standardizing the process of Business Intelligence solution analysis in Clever Decision company. This draft can nevertheless work as a basis for creating a wholly new method. My work consists of three parts. The first part, a theoretical one, deals with recapitulation of basic terms and methods I worked with. The second part represents properties, components and general working instructions for this method. It moreover presents main outputs, more precisely documents that are practical attachments to the method itself. The third part introduces the method itself including presentation of outputs/document drafts designed by me.
|
|
|
Operations and maintenance methodology of BI systems
Matiášek, Tomáš ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This diploma thesis is focused on operation and maintenance of BI systems based on Microsoft's SQL Server 2008 R2 platform. This work covers regular activities related to BI system management that means monitoring, performance tuning, maintenance, administration, backup and recovery tasks. System management is based mainly on SQL Server's native management tools along with Microsoft's applications System Center: Essentials and System Center: Data Protection Manager. The main goal of this work is to create BI system operations and maintenance methodology in cooperation with Clever Decision which is specialized in BI area. Partial goals are to design a way of monitoring components of BI system, including to outline backup and recovery posibilities, maintenance and performance tuning of the SQL Server platform. Each chapter contains methods, best practices, summary tables and appropriate tools which help DBA to achieve the specified goals. The main contribution of this work is operations and maintenance methodology created according to Clever Decision's needs. Among the other contributions of this thesis also belongs the definition of using tools for monitoring and maintenance and their relations to the SQL Server's components. The work also contains simple backup and performance tuning methodology for SQL Server. At least, this diploma thesis represents comprehensive material which is strictly focused on OLAP databases operation and maintenance.
|
|
|
Analytické úlohy v business intelligence
Šindelář, Radek ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
The main aim of this bachelor thesis is the analysis and design of business intelligence solution in chosen company engaged by the automotive industry. The work is divided into two parts. The theoretical part includes the idea and mission of the dimensional modeling. The practical part involves implementation into practical solution of business intelligence to fulfill their functions. We will fulfill introduction of business intelligence on the basis of ordering document a data base, which we have got. From the base point of view is possible to realize business intelligence solution in the form that will suit to target users. It is possible to display data at a level and in such form, that the company will suit from to point of economic and user perspective view.
|
|
|
Visualization of Data Quality in Business Intelligence
Pohořelý, Radovan ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis deals with the area of Business Intelligence and especially the part of data quality. The goal is provide an overview of data quality issue and possible ways the data can be shown to have better and more engaging informative value. Another goal was to make a proposal solution to the visualization of the system state, particularly the section of data quality, at the concrete enterprise. The output of this thesis should provide a quideline for the implementation of the proposed solution.
|
|
|
Master Data Management and its usage in practice
Kukačka, Pavel ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This thesis deals with the Master Data Management (MDM), specifically its implementation. The main objectives are to analyze and capture the general approaches of MDM implementation including best practices, describe and evaluate the implementation of MDM project using Microsoft SQL Server 2008 R2 Master Data Services (MDS) realized in the Czech environment and on the basis of the above theoretical background, experiences of implemented project and available technical literature create a general procedure for implementation of the MDS tool. To achieve objectives above are used these procedures: exploration of information resources (printed, electronic and personal appointments with consultants of Clever Decision), cooperation on project realized by Clever Decision and analysis of tool Microsoft SQL Server 2008 R2 Master Data Services. Contributions of this work are practically same as its goals. The main contribution is creation of a general procedure for implementation of the MDS tool. The thesis is divided into two parts. The first (theoretically oriented) part deals with basic concepts (including definition against other systems), architecture, implementing styles, market trends and best practices. The second (practically oriented) part deals at first with implementation of realized MDS project and hereafter describes a general procedure for implementation of the MDS tool.
|
|
|
Methodology for solution of transformation part of BI (ETL)
Cimbaľák, Michal ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Extract, Transformation, and Load (ETL) system is responsible for the extraction of data from several sources, their cleansing, conforming and insertion into a data warehouse. The thesis is focused on building ETL methodology to better understanding of ETL process and its application in the real environment. I've worked on project "BI Cookbook" with Clever Decision, a software consulting company that specializes in Business Intelligence. The aim was to create ETL part of the BI methodology. This methodology has been designed to provide ease of use, flexible and extensible material for the purpose of building ETL solution. The main goal of this work is to introduce created ETL methodology, all of its components and the way in which it could be used. Following goal is to discuss options of its implementation and modification for the wide range of use. The main contribution of this work is to provide ideas of creating and implementing ETL methodology or ideas for creating methodology in general. The thesis is divided into three parts. The first theoretical part deals with basic definition, architecture and implementing of ETL system. The second part presents the proposed methodology. The last part contains of the possible options for implementation a modification of the methodology.
|
|
|
Implementation of Microsoft SharePoint Server 2010 into a small company
Jakoubek, Jiří ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Today's world is globally connected by various IT or ICT technologies. There is a plenty of information around the world. People that are able to work effectively with the information have really big advantage. This is mainly the reason why many products are being made only with one purpose -- to make this process more effective, easier and faster. One of them is Microsoft SharePoint Server 2010. The work is all about this product and its implementation into a small company. An introduction discusses basic reasons that can lead to implement SharePoint. The first logical part of the work describes functionality of the portal and is divided into six groups of functions. For better illustration, there are also examples based on real scenarios. The second part of the text focuses on individual phases of the process of implementation of SharePoint Server 2010 into the company and it also includes an example of real installation. The last part of the work is focused on design of the project collaboration web for the specific company. In individual chapters, the reader gradually learns about the possibilities of practical use of SharePoint functionality and also about the implementation of this software into the company environment. In both parts author uses his practical experience which he gained by working with the technology in a real environment.
|
|
|
Standardization of data structures of a financial BI solution
Chaloupecký, Stanislav ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
In this diploma thesis I concentrate on analysing the possibilities of standardization of financial Business Intelligence solution. The objective is firstly to assess whether it is useful to create a so-called standard model, i.e. a solution model, which could be used repeatedly in independent BI project implementations. The objective is to analyse whether there are similarities among the implemented BI projects in terms of content requirements (measures and dimensions), or what are the differences. The objective is then to design a standard solution model (design relational and dimensional model for data structures). Another objective is to create a functional prototype solution based on the designed model, i.e. to create the actual data structures and fill them with data. A part of this prototype solution should be a set of demonstrative reports. The objectives will be achieved first of all by analysing the theoretical foundations, which provides the literature, and by analysing available real project documentation. Considered BI projects have been implemented within several non-financial commercial institutions. That means that the outputs of this thesis are applicable primarily in non-financial enterprises environments. In the next step, the dimensional modelling techniques will be used to create the schema. Then, leveraging the knowledge of BI solution development techniques on Microsoft SQL Server platform, the prototype solution will be deployed. Reports will be developed using the Microsoft Excel client tool. The benefit of this thesis consists in the model added value, which can be used as the core of newly developed financial BI solutions. The implementation process should by this spare some time. Another benefit of the thesis is the possible use of the prototype solution as a tool for customized demonstration of the financial BI capabilities to potential customers.
|
guest ::
