|
|
Principles of function and the possibility of BI in small and medium enterprises
Tříska, Aleš ; Pour, Jan (advisor) ; Plach, Marek (referee)
Business intelligence is an effort to better understanding of company processes and business consequences in which company occur. The main goal of this thesis is to characterize the principles and possibilities of implementation and application Business intelligence in small or medium enterprise. This goal should be achieved by description of general needs which small or medium enterprise, looking forward to use business intelligence, has. This includes evaluation and universal description of information technologies in small and medium enterprises, as well as what data are used for managerial decisions and how are they made. In order to implement BI into the small or medium enterprise, it is necessary to imply how the Business intelligence work and on what principles. The application part of this thesis describes real procedures in preparation of BI implementation, impact on company and evaluation of the meaningfulness of this solution.
|
|
|
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.
|
|
|
Methodology of development and deployment of Business Intelligence solutions in Small and Medium Sized Enterprises
Rydzi, Daniel ; Jandoš, Jaroslav (advisor) ; Vlček, Radim (referee) ; Slánský, David (referee)
Dissertation thesis deals with development and implementation of Business Intelligence (BI) solutions for Small and Medium Sized Enterprises (SME) in the Czech Republic. This thesis represents climax of author's up to now effort that has been put into completing a methodological model for development of this kind of applications for SMEs using self-owned skills and minimum of external resources and costs. This thesis can be divided into five major parts. First part that describes used technologies is divided into two chapters. First chapter describes contemporary state of Business Intelligence concept and it also contains original taxonomy of Business Intelligence solutions. Second chapter describes two Knowledge Discovery in Databases (KDD) techniques that were used for building those BI solutions that are introduced in case studies. Second part describes the area of Czech SMEs, which is an environment where the thesis was written and which it is meant to contribute to. This environment is represented by one chapter that defines the differences of SMEs against large corporations. Furthermore, there are author's reasons why he is personally focusing on this area explained. Third major part introduces the results of survey that was conducted among Czech SMEs with support of Department of Information Technologies of Faculty of Informatics and Statistics of University of Economics in Prague. This survey had three objectives. First one was to map the readiness of Czech SMEs for BI solutions development and deployment. Second was to determine major problems and consequent decisions of Czech SMEs that could be supported by BI solutions and the third objective was to determine top factors preventing SMEs from developing and deploying BI solutions. Fourth part of the thesis is also the core one. In two chapters there is the original Methodology for development and deployment of BI solutions by SMEs described as well as other methodologies that were studied. Original methodology is partly based on famous CRISP-DM methodology. Finally, last part describes particular company that has become a testing ground for author's theories and that supports his research. In further chapters it introduces case-studies of development and deployment of those BI solutions in this company, that were build using contemporary BI and KDD techniques with respect to original methodology. In that sense, these case-studies verified theoretical methodology in real use.
|
|
|
Use of MS EXCEL for analyzing data from OLAP databases
Majzlík, Tomáš ; Benáčanová, Helena (advisor) ; Lorenc, Miroslav (referee)
This bachelor thesis describes functions of MS Excel 2010 to work with analytical databases. Emphasis is placed on improvements and new features over previous versions of Excel. The work is intended more for the reader who already knows something about the topic and wants to know what are the news. Yet in the introductory section is described the concept and meaning of OLAP databases. The next section describes the new features of pivot tables. Then is described the Powerpivot application. The work ends with a reflection on the use of analytical databases.
|
|
|
Business Intelligence in MS Dynamics AX 2009
Hubáček, Filip ; Pour, Jan (advisor) ; Derfler, Václav (referee)
The subject of the diploma thesis entitled "Business Intelligence in Microsoft Dynamics AX" is to analyze the functionality of the ERP system Microsoft Dynamics AX 2009 in the area of Business Intelligence and Reporting with the reflection of the current market position of the company. The goal is to set the basic definition of the relationship between ERP and Business Intelligence systems, further defining the possibilities of MS Dynamics AX in BI in the terms of their practical use and also to describe the fundamental technological aspects. The aim of the work is evaluation and definition particular steps during implementation based on methodology MS Sure Step 2010 together with description of deployment process. As a reflection of insufficient coverage of some of the areas is mentioned solution of the company Circon Circle Consulting. Also is realized proposal for BI for AX cost accounting module, including designing data mart, ETL and report with respect to specifics, such as the parent-child hierarchies and many-to-many relationship between fact tables and dimensions. The contribution of this work is mainly evident for the consultants of the system, to who is provided insight into the important and for users attractive functionality and also is offered possible implementation process. Technically oriented readers may appreciate the solutions for Cost Accounting and potential approaches to the concept of data mart or other areas where they meet the above-mentioned aspects.
|
|
| |
|
|
Implementace BI ve firmě Haguess a.s.
Bendák, Martin ; Novotný, Ota (advisor) ; Bláha, Jiří (referee)
The subject of this thesis is a pilot project of the implementation of the BI (Business Intelligence) solution in the company Haguess, a. s. The project is concerned with the analyses of data stored in a database -- DataBase Management System (DBMS) -- which is used as a data source by the web application Customer Support Center (CSC). Haguess primarily uses CSC as a helpdesk for its clients and partners, but also uses it for internal purposes. The main use of the CSC application is to support information systems delivered by Haguess. There were two motives for the choice of this subject: BI software tools had not previously been used by Haguess, and the company management was keen to get data analyses from the CSC application. That's why I decided to do these analyses. My goal was to create a practically useful solution which would be an incentive for Haguess to use BI software tools for other purposes. This thesis has two main goals. The first one is the realisation of the pilot BI solution, which would outline the possibilities for analysis of data from the CSC application using BI software tools. This involved the following activities: multidimensional analysis and BI solution design -- i.e. design of data pipelines, OLAP (On-Line Analytical Processing) cube/cubes, and user tools in MS Excel calculator. The second goal was to select the proper software tools for a future complex realisation and running of the BI solution. The first objective was achieved by doing the following: proper analysis of the CSC application data model, definition of user requests for output analysis and its comparison with the data model analysis. Based on this comparison, the basic subjects of output analyses were determined. These basic subjects were the starting point for the implementation of the BI solution. The second objective was achieved as follows: on the basis of the implementation results, basic demands (criteria) for BI software tools features were determined, bearing in mind the possible future complex realisation and running of a BI solution. Research determined which BI software tools were available on the market. The most suitable BI software tool was selected following a comparison of available options, and the criteria mentioned above. The primary outcome of this thesis is the creation of a practically usable BI solution.
|
|
| |
|
|
Analysis and concepts of Business Intelligence solutions and applications (in AMATI - Denak, Ltd.)
Hnilička, Václav ; Pour, Jan (advisor) ; Štípek, Jiří (referee)
The main object of this bachelor thesis is to analyze particular medium-size company and on the basis of this analysis to suggest Business Intelligence solution for needs of senior management. Whole thesis is divided to two basic parts. The first is focused on teoretical approach of Business Intelligence solution, components, from which the final form of solution may consist and its location in information system of organization. The purpose of second part is the analysis of company from which we get the strategic goals and from them to continue to plan the project whereby the preliminary analysis can be made. Based on processed analysis there was a proposal adopted of different components of Business Intelligence's solution. Everything is taking place over the company's given data. The main benefits of this thesis are in made analysis of company and elaboration of project of Business Intelligence introduction. Although the project is made in limited conditions, the senior management is providing a Business Intelligence technology overview and its possibilities of utilization. Another benefit is the possibility of utilizing the procedure by implementing of similar solutions in companies of the same focus.
|
|
|
Use of MS EXCEL for analyzing data from OLAP databases
Černý, Ondřej ; Benáčanová, Helena (advisor) ; Lorenc, Miroslav (referee)
This bachelor thesis describes theoretical basis of OLAP (OnLine Analytical Processing) databases and focuses primarily on a practical use of Microsoft Office Excel 2007 for analysis of the data stored in OLAP databases. The aim of thesis is to describe, what possibilities Excel provides for the work with OLAP databases, and what is the working procedure of such work. Work of Excel with OLAP databases is demonstrated on sample database. This thesis can be used as an user's guide for beginners with no experience in analysis of OLAP databases in Excel.
|
guest ::
