|
Implementation of Business Intelligence solution in TN Biofaktory company
Kocfelda, Jan ; Maryška, Miloš (advisor) ; Novak, Viktor (referee)
The thesis describes implementation of Business Intelligence solution in mid-sized company which produces and sells animal nutrition products. Currently the company uses basic tools for reporting, mostly Excel application. Considering the data growth, that solution is about not to be sufficient. In the first part of the thesis, the Business Intelligence principals are introduced to the reader, so one is provided with enough knowledge to understand the issue of data processing, transforming and storing. Basics of data visualization used for decision making in the company are introduced as well. At the end of the chapter, there is a list of general rules for creating a dashboard. The secord part describes the Trouw Nutrition Biofaktory s.r.o. company, where the implementation of new Business Intelligence solution is going to take place. The reader will learn about the company size, structure and history. The last part contains a new procedure how to process data for reporting purposes. The design includes data loading to MS SQL 2012 database server and further processing for analytical purposes. In addition, OLAP cube is created as well as three monthly dashboards.
|
|
BI Tools in MS Excel 2013 for eCommerce
Šleis, Jakub ; Pour, Jan (advisor) ; Šedivá, Zuzana (referee)
This thesis deals with the Microsoft's self-service business intelligence tools and it's used for eCommerce. The main goal of this work is to analyze and design metrics and applications for effective management of eCommerce using PowerPivot and Power View. Metrics are based on balanced scorecard approach and applications are based on MBI reference model. This thesis is supposed to help eCommerce managers and administrators to implement a custom self-service business intelligence solution.
|
|
Využití moderní self-service BI technologie v praxi
Buyankhishig, Agiimaa ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
Abstract This diploma thesis treats about the latest technologies in the field of self-service BI from Microsoft Corporation. The main goal of this work is to analyze the Microsoft self-service BI solutions, to describe the benefits and advantages of this technology and to show examples with real data in Microsoft self-services BI tools. To achieve the goal, the internet resources, recommended literature, and the software applications PowerPivot and PowerView (Excel 2013) are59 used. In its first part this thesis describes the basic characteristics and technology of classical BI solutions. The second part examines the actual self-service BI solution and its usability. And then analyzes the advantages and benefits compared to conventional technologies. Finally, in its last section describes self-service BI solutions, the DAX language used in PowerPivot and shows example reports with real data from banking sector. The key benefit of this diploma is the verification of the usability and advantages of self-service BI by using Microsoft self-service BI products and tools.
|
|
Implementation of VBA for processes automation in university environment
Dušek, Jakub ; Benáčanová, Helena (advisor) ; Fortinová, Jana (referee)
This bachelor thesis brings a description of application development that optimizes and automates certain operations at IT Help desk at University of New York in Prague. MS Excel and programming language Visual Basic for Application (VBA) are used for development of aforementioned application The first part of the thesis is focused on environment description and inner factors. Thanks to the extensive description of relevant processes it was possible to identify its bottlenecks and optimize them with the developed application. The second part is dedicated to solution of this application. Here I describe its usage by means of screenshots. I also introduce important parts of the source code which is described subsequently.
|
|
Self service BI in the marketing department of a telecommunications company
Prchal, Tomáš ; Pour, Jan (advisor) ; Stecenková, Marina (referee)
This bachelor thesis describe ways of dealing with self-service business intelligence in the marketing department of a telecommunications company. The main objective of this thesis is to introduce technologies for self-service business intelligence, which are part of the program Microsoft Excel 2013 and demonstrate their potential use for the needs of the marketing department. The first part describe the theoretical side of the business intelligence with the division on the classic approach and on self-service. It is later complemented by the introduction of tools for self-service business intelligence contained in Excel. The second part is devoted to practical solutions. Firstly, dimensional model of the available data and secondly, build self-service solutions using the tools in Excel. These are the PowerPivot and Power Query, which is used primarily for the acquisition and management of source data, but also offer a basic visualization. For outputs are then used tools Power View, which allows a clear view of the required information and add-on PowerMaps, which displays the source data on a map. The output is then specific self-service solutions created according to specifications from employees of the marketing department, showing the required information through self- service tools.
|
|
The development of business intelligence based on Microsoft: comparison of traditional BI and self-service BI
Buřil, Marek ; Přibil, Jiří (advisor) ; Zelená, Veronika (referee)
The first aim of this thesis is map the Microsoft development tools for business intelligence systems. This goal devide the tools for develop BI into two groups: tools for traditional BI systems and tools for self-service BI systems. The second aim of this thesis is a critical evaluation of approaches based on the criteria and scenarios focuse on selected business areas. This thesis answers the question if some of the approaches is a better solution for business intelligence systems, or whether one approach is more suitable for business intelligence solutions to some business areas.
|
|
Use of VBA in business practice
Nagrant, Richard ; Benáčanová, Helena (advisor) ; Fortinová, Jana (referee)
My diploma thesis is dedicated to the issue of data mining, its part of predictive analysis and then process that is used in HP for different prediction. The introductory part describes the concept of data mining, its role and benefits. To one of its tasks fall predictive analysis, where I discussed the principles of its use. Then follows framework HP, which uses one of the tasks of predictive analysis. In the practical part, I applied the use VBA to automate one part of the process of converting text to numerical data, assuming different rules. The result is a set of macros support, system sheet and the new ribbon for data transformation.
|
| |
|
Self-service BI a PowerPivot
Černý, Ondřej ; Pour, Jan (advisor) ; Horčička, Jiří (referee)
This thesis deals with the extension of Office application Microsoft Excel -- PowerPivot program. First, the thesis focuses on the topic of the actual Business Intelligence (BI) and compares the classical BI approach and self-service BI approach. In the first part are dis-cussed current trends in BI. The second and main part is focused to the PowerPivot. Grad-ually are mentioned benefits and news in PowerPivot on the examples compared to classical analysis in Excel. In the initial description of the features are also instructions for installing the program and its news in version 2013. An important chapter is focused to the DAX expressions and all the calculations that can be implemented in PowerPivot. Separate chapters are devoted to data import and connection with MS SharePoint Server. As an ex-ample, is introduced the calculation of the ABC analysis to classify products, used mainly in logistics. The last part deals with implementation of applications in PowerPivot for MBI model (Management of Business Informatics).
|
|
Application for work simplification of the study officer in entrance exams
Marek, Lukáš ; Benáčanová, Helena (advisor) ; Sedláčková, Jana (referee)
This bachelor thesis describes the realization of development of application, which extends the functionality of Integrated study information system on the University of economics in Prague. First part of this thesis is mainly focused on the analytical part of the application. Main topic is the work, practice and experience of a study officer in entrance exams. This part is also focused on the specification of input and output data. And these specifications are used to describe the new functionality requirements of the application. Second part is mainly about the development of the application. The development is seen and described from it experts point of view and also from users point of view. Each algorithm, procedure and function is explained and the solution of problems is well covered. In the users point of view part there is a simple user guide about how to use this application.
|