This master’s thesis is focused on creating an application for survey analysis. In the first section are theoretical foundations of a direct marketing and Business Intelligence. The next chapter focuses on available tools for data analysis and BI. Analysis and preparation of input data are also included in this part. Finally, the solution proposal is presented.

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’s thesis will look into the use of data mining in the area of segmentation and the prediction of onboarding candidates of a recruitment agency. The obtained results should serve to make company processes more effective concerning the processing of orders, and should also facilitate a more personal approach to candidates. The first chapter includes imperetive theoretical bases from the studies of Business Intelligence, data warehouses, data mining and marketing. Thereafter an analysis of the current state is presented with a focus on the capture of the key processes in processing and order. The last chapter looks at the proposed solution and implementation on the platform Microsoft SQL Server 2014. To conclude there are proposals of utilizing data mining in direct marketing.

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 paper deals with data warehouses and OLAP. These technologies are defined and described here. Then an introduction of the architecture of product MS SQL Server and its tools for work with data warehouses and OLAP folow. The knowledge gained is used for creation of sample application.

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 Master's Thesis deals with the integration of Business Intelligence tools into an information system. There are concepts of BI, data warehouses, the OLAP analysis introduced as well as the knowledge discovery from databases, especially the association rule mining. In the chapters focused on practical part of the thesis, the design and implementation of resultant application are depicted. There are also the applied technologies like i.e. Microsoft SQL Server 2005 described.

No description available.