|
| |
|
|
Možnosti analytických nástrojů v prostředí MS SQL Serveru
Mazáčová, Markéta
The thesis compares the development time and performance of two types of Microsoft analytical models created in Visual Studio that are deployed on the local analytics servers and the Azure cloud server. Theoretical research will be summarizing business intelligence and data warehouses components, Microsoft tools for business intelligence realization and features using in-memory database technologies. The practical part introduces the AdventureWorks demonstration database,describes the implementation of both analytical models and compares both models with respect to the time-consuming development, performance and suitability of deployment.
|
|
|
Comparison of Self-Service Business Intelligence tools
Blaha, Ondřej ; Maryška, Miloš (advisor) ; Sládek, Pavel (referee)
The objective of my diploma thesis is an analysis and comparison of commercial Self-Service Business Intelligence tools. Publication compares Microsoft Power BI and Tableau software tools. In the first theoretical chapter, which includes overview of publications related to main topic, I explain the Business Intelligence and its architecture in currently used approaches: standard, In-memory and Self-Service. The chapter also explains the pros and cons of changing the current IT environment to Self-Service BI model and the related roles. The analytical chapter covers definition of suitable parameters, which are used for compari-son of chosen tools by multicriterial analysis of different approaches. Parameters and met-rics are grouped by several layers following the BI architecture concept. These layers are data, transformation, presentation, publishing and comunity layer. To set the criteria weig-hts, the Fuller method is used and the results are achieved by weighted sum of acquired values. The main benefit of diploma thesis is a comparison of chosen Self-Service BI tools and their analysis by various criteria. Reader should get the complex picture of Business Intelli-gence topic and will be able to choose the right tool for his needs and be familiar with its pros and cons.
|
|
|
Migration from Oracle DB to SAP HANA
Nejedlý, Jan ; Chlapek, Dušan (advisor) ; Kučera, Jan (referee)
The main topic of this thesis is data migration from database system Oracle to database system SAP HANA. The main goals of this thesis are firstly introduction of basic characteristics of inmemory database systems. Second goal is documentation of steps required to migrate from Oracle DB to SAP HANA and the last goal is to compare these steps from second goal with generic steps for database migration and try to find differences connected with in-memory technology. This thesis is divided into the three main parts. First part describes characteristics of database systems and mainly focuses on in-memory database systems and SAP HANA technology. First part also contains a description of generic steps for database migration which is used in the third part. Second part describes steps required for database migration from Oracle DB to SAP HANA. The last part compares the generic steps for database migration with steps described in second part.
|
|
| |
|
|
Methodology for solving an BI analytical tasks
Žebrák, Miroslav ; Pour, Jan (advisor) ; Jakoubek, Jiří (referee)
The thesis focuses mainly on OLAP technology and its tools using to analyze corporate data. One of the objectives is to define the analytical tools market and provide an overview which shows the current situation concerning those tools on Business Intelligence (BI) market. Another objective is to obtain an overview of some current and future trends in the BI market. The main purpose of the thesis is to create a "methodology" for solving an BI analytical tasks using analytical services in SQL Server 2008 R2 from Microsoft. To achieve these objectives a theoretical analysis of available resources and, in particular consultation with employees of Clever Decision company is used. The main contribution of this work is the development of analytical database itself, which is divided into separate phases where each phase contains best practices and recommendations, including examples.
|
guest ::
