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.

The aim of this thesis is analysis of data of the Czech Statistical Office concerning foreign trade. At first, reader familiarize with Business Intelligence and data warehousing. Further, OLAP analysis and data mining basics are explained. In next parts the thesis deal with describing and analysis of data of foreign trade by the help of OLAP technology and data mining in MS SQL Server including selected analytical tasks implementation.

This Diploma Thesis deals with analysis of the current processes in small software company. On the basis of the weakness evaluation, the new extensions of the information system are designed. The first extension is new module for on-line sale and cashless on-line payment. The second one is integration of Business Intelligence tools to help streamline marketing strategies of this company.

This master’s thesis concerns about the use of data mining techniques in banking, insurance and shopping centres industries. The thesis theoretically describes algorithms and methodology CRISP-DM dedicated to data mining processes. With usage of theoretical knowledge and methods, the thesis suggests possible solution for various industries within business intelligence processes.

This thesis deals with the design and implementation of a dynamic user-definable dashboard. The user will be able to define conditions dynamically, which will filter out and save only the data he needs. The application will support the changing of the condition definitions and the display of the graphs after they were created. The current implementations available on the internet are usually solutions designed to fit only one type of project and are not designed to meet general guidelines for a dashboard. The dashboard is designed for a smooth cooperation with high load databases and therefore not to slow down the whole solution.

The overall purpose of this project is to create a tool that will be able to generate reports for measurements and calculations performed by the Perception system. At present, this is a manual procedure that is both time-consuming, inefficient, and increases the risk of error. Since Perception is developed in C#, the reporting tool will be developed in ASP.NET Core with C# based on the MVC pattern and all data will be stored in Microsoft's SQL server. Transfer of data between systems will be handled by export files that Perception can generate as well as a self-developed import function in the reporting tool. With a few simple settings and options, the operators will be able to generate reports for the selected project and then copy them to the final report. Initial work with design and usability, based on the existing graphic profile, will result in an application that significantly facilitates the work of producing test reports. To make the design appealing, Bootstrap and self-written CSS will be used and to make the user experience as good as possible, JavaScript and AJAX will be used together with jQuery and thus be able to provide relevant information without the need of page reload. Focus will be placed on validating imported data to ensure that correct information is available and stored in the database. To further help the users, relevant messages will show status both in case of problems but also in case of successful procedures. / Det övergripande syftet, för detta projekt, är att skapa ett verktyg som ska kunna generera rapporter för mätningar och beräkningar utförda i systemet Perception. I dagsläget är detta ett manuellt förfarande som både är tidskrävande och ineffektivt vilket också ger en ökad risk för felkällor. Eftersom Perception är utvecklat i C# kommer rapportverktyget att utvecklas i ASP.NET Core med C# baserat på MVC-mönstret och all data kommer lagras i Microsofts SQL server. Överföringen av data mellan systemen kommer att ske med hjälp av de exportfiler som Perception kan generera samt en egenutvecklad importfunktion i rapportverktyget. Med några enkla inställningar och val ska operatörerna kunna generera rapporter för valt projekt och sedan kunna kopiera dem till slutrapporten. Ett inledande arbete med design och användbarhet, som grundar sig på den befintlig grafisk profilen, ska mynna ut i en applikation som väsentligt underlätta arbetet med att producera testrapporter. För att göra designen tilltalande kommer Bootstrap och egenskriven CSS att användas och för att användarupplevelsen ska bli så bra som möjligt kommer JavaScript samt AJAX att användas tillsammans med jQuery och på så vis kunna ge relevant information utan att sidan behöver uppdateras. Stort fokus kommer att läggas på kontroller av importerad data för att säkerställa att rätt information finns representerat samt sparas till databasen. För att ytterligare underlätta för användarna ska relevanta meddelanden ge status både vid problem men också vid lyckade procedurer.

The purpose of this work is in analytical tool supporting manager decision making. The goal was to develop a reporting system which simplifies company customer's orientation in key performance indicators. As implementation environment has been used .NET Framework 3.5 with C\# language and database server Microsoft SQL 2008 with Analysis Services extension, for web interface has been used ASP.NET.

<p>När det gäller fakturering av ett företags tjänster har det visat sig att den manuella hanteringen ofta är tidskrävande och att det lätt blir fel. Därför har det tagits fram många faktureringssystem för olika datorsystem. Detta examensarbete går ut på att ta fram en prototyp av ett automatiskt rapportsystem baserat på utvald användarinformation i Active Directory, informationen ska sedan användas som faktureringsunderlag. Informationen sammanställs i en databas där användaren på ett lätt sätt ska kunna ta fram en sammanställning av kundernas användning av diverse tjänster för en specifik domän.</p> / <p>When it comes to invoicing a company’s services it has become evident that the manual handling very often is time-consuming and easily becomes wrong. Therefore many developers have developed different invoicingsystems for different computersystems. This diploma work is about developing a prototype of a fully automatic reportsystem based on Active Directory-information. This information will later on be used as basic data for the invoice. The information will be put together in a database where the user easily can retrieve a compilation about a customer’s usage of different services.</p>

När det gäller fakturering av ett företags tjänster har det visat sig att den manuella hanteringen ofta är tidskrävande och att det lätt blir fel. Därför har det tagits fram många faktureringssystem för olika datorsystem. Detta examensarbete går ut på att ta fram en prototyp av ett automatiskt rapportsystem baserat på utvald användarinformation i Active Directory, informationen ska sedan användas som faktureringsunderlag. Informationen sammanställs i en databas där användaren på ett lätt sätt ska kunna ta fram en sammanställning av kundernas användning av diverse tjänster för en specifik domän. / When it comes to invoicing a company’s services it has become evident that the manual handling very often is time-consuming and easily becomes wrong. Therefore many developers have developed different invoicingsystems for different computersystems. This diploma work is about developing a prototype of a fully automatic reportsystem based on Active Directory-information. This information will later on be used as basic data for the invoice. The information will be put together in a database where the user easily can retrieve a compilation about a customer’s usage of different services.

Model View Controller (MVC) software architecture is widely spread and commonly used in application’s development. Therefore generation of data layer for the database model is able to reduce cost and time. After research on current Object Relational Mapping (ORM) tools, it was discovered that there are generating tools like Data Access Object (DAO) and Hibernate, however their usage causes problems like inefficiency and slow performance due to many connections with database and set up time. Most of these tools are trying to solve specific problems rather than generating a data layer which is an important component and the bottom layer of database centred applications. The proposed solution to the problem is an engineering approach where we have designed a tool named Generated Intelligent Data Layer (GIDL). GIDL tool generates small models which create the main data layer of the system according to the Database Model. The goal of this tool is to enable and allow software developers to work only with object without deep knowledge in SQL. The problem of transaction and commit is solved by the tool. Also filter objects are constructed for filtering the database. GIDL tool reduced the number of connections and also have a cache where to store object lists and modify them. The tool is compared under the same environment with Hibernate and showed a better performance in terms of time evaluations for the same functions. GIDL tool is beneficial for software developers, because it generates the entire data layer.