This master thesis deals with an analysis of reporting in business and its technological coverage by Microsoft Business Intelligence portfolio. The main objective of this work is to analyze the individual organization's requirements on reporting and coverage options. This work can serve as a tool for implementation of reporting in a company or for increasing the efficiency of reporting. The first part is theoretical. It deals with Business Intelligence as an environment for reporting. It also defines the basic concepts. The next part covers the area of reporting. This section provides an insight into the history, definition of outcomes and detailed classification of reporting from different perspectives. Furthermore, the definition of users reporting and the reporting standards in companies is also covered. At the end of this chapter, there is the definition of the benefits of reporting for companies. The main part of this master thesis is an analysis of the requirements for reporting in companies. The chapter defines five key perspectives which are described in a greater detail. The methods how companies should methodically approach these requirements are also discussed. The chapter further looks at the requirements for a concrete report. An output of this chapter is an effective template for gathering requirements for a specific report. The last chapter focuses on reporting portfolio analysis of Microsoft and defines the concept of Microsoft. It provides detailed information about reporting products that Microsoft offers. An analyses and a mapping of the individual characteristics of the products and the requirements is defined in this thesis.

The thesis is primary focused on the integrated data warehouse, particularly on a subset -- dependent data marts. The main objectives of this thesis are design the methodology of development and maintenance of dependent data marts and verification methodology usefulness in the real organization. The first part deals with the theoretical definition of terms. It focuses particularly on the definition of terms from Business Intelligence area especially data warehousing and data marts. Each of the terms is described in detail in separate chapters. Business Intelligence area puts emphasis on description of individual components. In data warehousing area are described the data warehouse concepts and content of layers in a data warehouse. Finally, the data mart area is designed to describe dependent and independent data marts and also "special "cases of data marts, likely the semantic layer, and a sandbox. The second part focuses on the design methodology itself. At the beginning of this part is analysis of the existing methodologies and assess their usefulness with connection to designed methodology. The following part describes the current situation in the approach to the development and maintenance of dependent data marts in the organization. At the end of the second part is designed own methodology, which is based in part on the analysis methodology and in part on the analysis of current situation. The third part focuses on usability and usefulness evaluation of methodology in the organization. Evaluation is based on the methodology of criticism from employees in the organization who are directly engaged in designing and maintaining dependent data marts. Finally, the fourth and final part will focus on the description of an alternative solution that could be considered as one of the ways to sustainable development of data warehouse in the organization. It's about comparison architecture based on utilization of semantic layer as oppose to the "three layers" concept of data warehouse by Bill Inmon, which is implemented in the organization. The output evaluates alternative solutions to the current solution.

The thesis is concerned with application of Decision Support Systems and Business Intelligence as a tool for decision-making support into processes of operational risk management in insurance company to improve them and reach a higher corporate performance.The goal of the thesis is to analyze a theory for a support of a process improvement design with the mentioned reach and to develop a design of improved operational risk management processes in a particular insurance company. The mean to reach goals is through-out a literature and articles research regarding a process improvement, decision-making, models and technologies of DSS and BI, and risk management. The theoretical framework is then used as back-bone for implementation of a practical part of innovated processes design. The thesis offers the analysis of an area of risk management processes improvement via DSS and BI in an insurance company that has been researched relatively little, but whose principles can be used for improvement projects in different areas too. A department of operational risk management in a certain insurance company obtains a complete design of innovated processes including DSS / BI application support specification which respects modern techniques of process improvements involving specific methods of decision-making quality. For the same department a part of the design was implemented -- Knowledge management system, that can be fully used. Introductory part of the thesis is concerned with techniques of business process improvement and its alignment with corporate performance. The next chapter describes specifics of operational risk management processes. In the third one models, techniques, information technologies of Decision Support Systems and Business Intelligence disciplines are analyzed. The practical part of the text starts with strategic analysis of the insurance company, proceeds with operational risk management processes analysis and reaches the design of innovated processes involving DSS and BI application support. Benefits of designed processes' changes are verified. In the conclusion a certain process change is accepted for the implementation and its results are described.

This diploma thesis deals with the possibility of presentation data in business intelligence (BI) applications. The aim is to develop a methodology for reporting and data visualization using Microsoft SQL Server 2008 Business Intelligence Development Studio and Microsoft Excel 2010. Evaluate and identify opportunities for data display using the perception of information at a subconscious level in the above mentioned tools. Identify market trends from the perspective of business intelligence data visualization. In the first part thesis focuses on the analysis of the current BI market with regard to trends in data visualization. In the following part options of perceptions on a subconscious level are examined, which are then reflected in the establishment of a methodology reporting. Similarly, it is investigated the human perception of color. Presented are appropriate and inappropriate data visualization forms, at the most commonly used graphic forms. The work describes a method to ensure that the data will not be displayed tendentiously or distorted. My contribution is creating a reporting methodology that respects the life cycle of the report, as well as a logical follow-up steps to project management.

Diploma thesis deals with comparison of commercial and Open Source Business Intelligence (BI) reporting tools. The main aim of the thesis is to provide a list of BI reporting tools and their further comparison. Evaluation is based on a set of criteria. Every criterium has its assigned value that represents the importance of the criterium in a given group. The same procedure is applied on the groups. The final evaluation is based on defined values of these groups. The output of the thesis is a table structured into five parts according to defined groups of criteria. The second part of the thesis walks the reader through the practical showcase of implementation one of the selected tools that is SAP Business Objects Enterprise 4.0. At the beginning, there is a description of report proposal that contains graphical design and functionality requirements. Next part shows the whole process in detail.

The aim of the thesis on the topic of High-Performance Analytics is to gain a structured overview of solutions of high performance methods for data analysis. The thesis introduction concerns with definitions of primary and secondary data analysis, and with the primary systems which are not appropriate for analytical data analysis. The usage of mobile devices, modern information technologies and other factors caused a rapid change of the character of data. The major part of this thesis is devoted particularly to the historical turn in the new approaches towards analytical data analysis, which was caused by Big Data, a very frequent term these days. Towards the end of the thesis there are discussed the system sources which greatly participate in the new approaches to the analytical data analysis as well as in the technological solutions of High Performance Analytics themselves. The second, practical part of the thesis is aimed at a comparison of the performance in conventional methods for data analysis and in one of the high performance methods of High Performance Analytics (more precisely, with In-Memory Analytics). Comparison of individual solutions is performed in identical environment of High Performance Analytics server. The methods are applied to a certain sample whose volume is increased after every round of executed measurement. The conclusion evaluates the tests results and discusses the possibility of usage of the individual High Performance Analytics methods.

Fast evolving digital technologies lead to a rapidly changing environment where decisions have to be made in a short time. The promised solution is data-driven decision making and business intelligence. However, business intelligence has until now only been available to executives and managers whereas many of the workers' wishes for their own business analytics could not be fulfilled. The concept of self-service business intelligence (SSBI) opens the gates to democratized business intelligence for everybody. Yet the implementation of SSBI tools is proving to be extremely difficult and has led to the consequence that many SSBI projects remain unsuccessful. This thesis therefore examines the influence of self-service business intelligence on organizational structures and business processes. Furthermore, assumptions made by contemporary industry studies and best practice reports are evaluated. The case study of the Power BI implementation project at a German medical and safety technology manufacturer successfully identifies real-life challenges. Moreover, the thesis stresses the importance of data governance and data infrastructures in the context of SSBI.

El presente proyecto tiene como objetivo diseñar una solución de inteligencia de negocios (BI) aplicado a una organización sin fines de lucro; de ahora en adelante llamada ONG. El presente proyecto busca automatizar dos procesos dentro de la ONG. Estos procesos corresponden a la implementación de un proyecto de la ONG llamado 'Lectores de paso'. Así mismo, se busca que el entregable les permita tomar decisiones de manera más ágil y dinámica, dejando de lado cuellos de botella operativos. Para la realización de este proyecto se investigaron soluciones de inteligencia de negocios aplicadas a Pequeñas y Medianas Empresas (PYMEs). Esto debido a su gran similitud con la ONG respecto a términos de tamaño, capacidades y complejidad de la organización. A partir de este punto, se pudo identificar los principales retos y causas que impiden una implementación de este tipo dentro de la organización. La solución planteada emplea herramientas como Pentaho Data Integration Community Edition y Google Data Studio, ambas herramientas de acceso gratuito. Así mismo, empleando datos provistos por la organización se ejecutaron pruebas de concepto que nos permitieron validar la solución. Finalmente, una vez realizada una prueba de concepto, se logró reducir el tiempo operativo en los dos procesos objetivos. Además, se dotó a la organización de un flujo de trabajo que les permita exportar sus datos, tomar mejores decisiones y realizar cambios de alcance a la hora de implementar su proyecto ‘Lectores de paso’. / The current project aims to design a business intelligence (BI) solution applied to a non-profit organization, from now on called NGO. The current project seeks to automate two processes within the NGO. These processes correspond to the implementation of a project of the NGO called 'Lectores de paso'. Likewise, the deliverable wants to allow them to make decisions in a more agile and dynamic way, leaving aside operational bottlenecks. For the realization of this project, we researched business intelligence solutions applied to Small and Medium Enterprises (SMEs). Due to its similarity with the NGO in terms of size, capabilities, and complexity of the organization. From this point, it was possible to identify the main challenges and causes that prevent the implementation of this type within the organization. The solution uses Pentaho Data Integration Community Edition and Google Data Studio as tools, both tools are free of charge. Also, using data provided by the organization, executed proof of concept that allowed us to validate the solution. Finally, once the proof of concept was carried out, it was possible to reduce the driving time in the two target processes. Likewise, now the organization can work with a workflow that allows them to export their data, make better decisions, and make quick changes in scope when implementing their project 'Lectores de paso'. / Tesis

En la actualidad el área de business intelligence de muchos laboratorios médicos no disponen de una adecuada gestión de incidentes sobre los servicios brindados, dando como consecuencia que, en la mayoría de los casos, el personal del área no disponga de un proceso claro para resolver los incidentes presentados, dando como resultado la demora en las atenciones, la poca calidad con la que son atendidos y sin respetar los tiempos de atención por tipo de incidentes. La gran mayoría de incidentes son resueltos, sin embargo, hay muchos que se desconoce cuál es el origen del problema y casi siempre se están realizando diferentes tareas para identificar los problemas que son recurrentes, dando como consecuencia que la credibilidad de la capacidad que tienen los analistas del área se vea impactada negativamente. Es por esta razón que el laboratorio médico está tomando en consideración este trabajo de investigación para que pueda tener su proceso de Gestión de Incidentes acorde a las mejores prácticas que brinda ITIL v 3.0 así como disponer de un Sistema de Información que le ayude a gestionar sus incidentes. / At present, the business intelligence area of ​​many medical laboratories does not have an adequate management of incidents regarding the services provided, resulting in that, in most cases, the personnel of the area does not have a clear process to solve the incidents presented, resulting in delays in the attention, the poor quality with which they are treated and without respecting the attention times by type of incidents. The great majority of incidents are solved, however, there are many that are unknown the origin of the problem and almost always different tasks are being carried out to identify the recurrent problems, resulting in the credibility of the capacity of the Area analysts will be negatively impacted. It is for this reason that the medical laboratory is taking into consideration this research work so that you can have your Incident Management process according to the best practices provided by ITIL v 3.0 as well as having an Information System to help you manage your incidents / Tesis

Diploma thesis presents an evaluation of the current state of the company system, identification of critical areas and areas suitable for improvement. Based on the theoretical knowledge and analysis results, commercial Business Intelligence software is designed to enhance the quality and efficiency of the company's decision-support system and the introduction of an advanced Quality Culture system. The thesis reveals critical locations in the corporate environment and opens up space to design improvements to the system.