In recent years, Business Intelligence is one of the fastest growing software industry according to foreign analyzes. More and more companies realize the importance of tools for Business Intelligence and dashboarding. That is why I chose this topic for my thesis. The main part of this thesis focuses on study support for subject 4IT314 Enterprise Information Systems. This course teaches student how to work with the ERP system Microsoft Dynamics AX. The main shortage of this subject is the lack of feedback to students. Therefore it was decide to integrate BI tools that will be used for dashboarding over database of Microsoft Dynamics AX. In the theoretical part are explains the basic terms essential to understanding BI and dashboarding. On the basis of defined criteria was chose BI tool for integration in to the subject 4IT314. In the practical part of this thesis is described the implementation of this tool and created user documentation, which is used as study materials for students.

Diploma thesis is focused on elaboration of database solution for saving measured data. In theory part analyses database query language and database management system Microsoft SQL Server 2017. Further in theory part is focused on programming environment for application development using C# .NET. Thesis includes database solution for saving measured data, service console application for saving data into the database and user application for creating new measuring, representation of data and user administration.

This diploma thesis deals with electronic information system for recording and tracking service calls on pressing and cutting tools, the injection molds and assembly machines and assembly lines in manufacturing plant of Lear Corporation Czech Republic, s. r. o. in Vyškov.

This master thesis is focused on design and implementation of a web application for a company to show users of this application relevant data in prearranged dashboards using visual elements, such as charts, information cards or tables, depending on the role of the logged in user in the application. The data that will be used by the application are obtained from the QI system in which they are transformed into multidimensional cubes that are automatically uploaded to Microsoft SQL Analysis Services Server.

My independent work has been to modernize a user interface in a 10-year-old MVC Framework application used by Skärblacka mills within the BillerudKorsnäs Group. The concept of modernization also means increasing its quality; to replace older knowledge and technology with new and modern technology such as be able to click on the text of a checkbox that is considered to be more relevant for its time. The framework chosen for the implementation was ASP.NET Core MVC, which is an open source for the most common platforms. The implementation of the porting meant that server code that is well-functioning has been maintained to a large extent. JavaScript is also pretty much the same except in a few places. To get a good and durable structure, the application is layered in the form of 3 layers with Controller, BusinessLayer and Repository. The database with SQL Server is basically the same except that Identity has been introduced. To be able to communicate with the database, ORM EF Core has been chosen, which is a slim version of EF. A lot of what is in the old MVC framework has been redesigned because it is not supported in Core MVC. The application consists of an assembly with a logical development tree that consists of the files included in the application.Ajax has been used to get soft desktop-like updates.The application, which is complex with a lot of complicated things, made time run away. / Mitt självständiga arbete har varit att modernisera ett användargränssnittet i en 10 år gammal MVC Framework applikation som används av Skärblacka bruk inom BillerudKorsnäs koncernen. I begreppet modernisera ligger också innebörden att öka dess kvalité; att byta ut äldre kunskaper och teknik mot ny och modern teknik som t.ex. kunna klicka på texten till en checkbox som anses vara av mer relevans för sin tid. Det ramverk som valdes för implementationen var ASP.NET Core MVC som är ett open sourse för de vanligaste plattformarna. Genomförandet av porteringen innebar att serverkod som är väl fungerande har bibehållits i stora delar. Även JavaScript är i stort sett densamma förutom på några få ställen. För att få en bra och hållbar struktur är applikationen skiktad i form av 3 lager med Controller, BusinessLayer och Repository. Databasen med SQL Server är i stort sett densamma förutom att Identity har införs. För att kunna kommunicera med databasen har man valt ORM EF Core som är en slimmad version av EF. En hel del av det som finns i den gamla MVC framework är omgjort eftersom det stöds in i Core MVC. Applikationen består av en assembly med ett logiskt utvecklingsträd som utgörs av de filer som ingår i applikationen. Ajax har används för att få mjuka desktop liknade uppdateringar. Applikationen som är komplex med en hel del komplicerade saker gjorde att tiden rann iväg.

This master’s thesis deals with the realization of a data warehouse for a selected company. The data warehouse is oriented on the process of translation quality assessment and is created on Microsoft SQL Server. The thesis includes designing a data model, implementation of physical structures and the whole ETL process, which is used for the automatic loading of transformed data.Formula clause:Faculty of Business and Economics of Mendel University in Brno decided to postpone the publication of the final thesis for 3 years. After the period the publication of the final thesis will be piblished in the UIS.

This thesis deals with creating client - server application. Client part of the application is created with a help of the Compact .NET framework and it is running on the mobile facility (PDA). Server part is written on .NET framework and it is running on the desktop computer. In the first part I characterize PDA facility, it's using and also I discuss communication between SQL Servers and PDA facilities. Next part describes .NET platform and advantages, which this platform provides. Also I tried to show differences between client - server architectures, because of understanding in my working. The last part of this work deals with implementation of the client - server application.

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.

This thesis is focused on research of available resources about applicable methods and approaches of implementation of Business Intelligence in sales department of mid-size local company focused on information technologies. The solution is aimed on controlling and performance measurement. Local specifics and company culture of innovation and creativeness are considered during the whole work. The next part of the work is analysis of the company environment and appropriable process of implementation matching current maturity level of company. The goal is to define appropriable set of indicators for performance measurement of sales representatives in order to reflect the reality and allow the relative comparison of individuals. This solution is applied in specific company and as a result there are identified issues of this proposal and suggested recommendations for the future modifications. The work is based on research of available resources and identification of the best practices methods of design and implementation of this system. The next part contains detail analysis of the company, application of conclusion of the theoretical part and suggestion for optimal process of successful adaptation. As a result the structure of metrics has been built and it was verified that the detail analysis is required for relevant definition of the scope of the project, identification of risks and preparing the real schedule. It has been verified, that implementation of performance measurement system requires complex changes in company culture and close coordination to other triggered changes in workflow and quality of recorded data in information systems.

Rapporten presenterar skapandet av en produktkonfigurator och flera förslag på hur den kan förbättras. Uppdraget gavs av System Andersson till två studenter på Jönköpings Tekniska Högskola som genomförde detta som sitt examensarbete. Rapporten diskuterar möjliga lösningar på en produktkonfigurator och visar ett resultat som utgår från dessa lösningar. Produktkonfiguratorn i rapporten består av två delar. Dels konfigurationsdelen som hjälper användaren att skapa nya produkter utifrån valda artiklar. Artiklarna sorteras automatiskt av produktkonfiguratorn så att endast kompatibla artiklar kan sättas ihop. Detta sker med ett ”drag and drop” gränssnitt. Dessutom innehåller produktkonfiguratorn en kompatibilitetsdel, vars uppgift är att underlätta vid definierandet av kompatibilitet mellan artiklar. Detta kan göras löpande under tiden en produkt konfigureras om så önskas. Användaren kan välja på två eller flera artiklar som ska vara kompatibla med varandra, eller hela kategorier. Sist i rapporten diskuteras de val som gjorts under arbetets gång och möjliga förbättringar som kan göras på produktkonfiguratorn.