The main objective of the thesis is to propose complex business intelligence and data warehouse architecture on the Oracle platform respecting current best-practice and recommendations. Part of the thesis is focused on selecting the right components for data warehousing and business intelligence, as well as on evaluating their suitability within the proposed business intelligence architecture and incorporating of these components into the complex business intelligence architecture. My thesis consists of four parts. The first part is dedicated to more general description of business intelligence and data warehousing subject and it represents entry level specification of BI on the Oracle platform. The second part describes individual software and hardware components of business intelligence solution based on the Oracle platform. In the third part I am proposing a complex business intelligence solution, based on particular Oracle components. There I also compare some individual components, determine their suitability in respect of proposed architecture and introduce some other recommendations. The last part of my thesis briefly describes economic and non-economic benefits of business intelligence solution based on the Oracle platform.

This dissertation titled Designing Project Business Intelligence focuses on data warehouse in a medium-sized company. The theoretical portion of the thesis describes the topic of data warehouse and dimensional modeling. In the first theoretical chapter, I compare and contrast two approaches to datawarehouse building - Bill Inmon's and Ralph Kimball's. Then, basic terminology used in the field, principles of dimensional modeling and various approaches of database use will be described. Furthermore, the thesis illustrates the role of the Mondrian system as a mediator between the relational database and the OLAP server. Possible uses of the MDX language in working with multidimensional databases are outlined. The theoretical portion of the thesis ends with a description of the applicational interface XMLA, which can be used for facilitation communication between applications and the OLAP server. The practice-oriented portion of the thesis includes a complete design of the Business Intelligence project. The project is divided into the following parts: Feasibility Study, Project Planing, Business Requirements, Design and Development, and Deployment and Maintenance. The entire project operates exclusively on Open Source Software. Consequently, the project shows that small and medium-sized companies can afford to run a fully operating Business Intelligence system.

The Evangelist Marketing of the CloverETL Software diploma thesis aims at proposing a new marketing strategy for an ETL tool - CloverETL. Theoretical part comprises chapters two and three. In chapter two, the thesis attempts to cover the ETL term, which - as a separate component of the Business Intelligence architecture - is not given much space in literature. Chapter three introduces evangelist marketing, explains its origins and best practices. Practical part involves introducing the Javlin, a.s. company and its CloverETL software product. After assessing the current marketing strategy, proposal of a new strategy follows. The new strategy is built on evangelist marketing pillars. Finally, benefits of the new approach are discussed looking at stats and data - mostly Google Analytics outputs.

The Deepwater Horizon blowout occurred on April 20th, 2010, releasing 4.9 million barrels of Louisiana crude oil into the Gulf of Mexico (GoM). Subsequent to the Deepwater Horizon blowout, sediment cores revealed oil on the northern GoM seafloor and abnormal skin lesions were seen in GoM fishes. Exposure to polycyclic aromatic hydrocarbons (PAHs), a component of crude oil, in fish has been associated with many sublethal effects, including cancer and population-level effects. Using a biomarker of exposure to PAHs, this thesis evaluates inter-species, temporal and spatial differences in exposure to hydrocarbon contamination between three species of fish with varying levels of association with the sediment, that were potentially exposed to Deepwater Horizon crude oil: golden tilefish (Lopholatilus chamaeleonticeps), king snake eel (Ophichthus rex) and red snapper (Lutjanus campechanus), and examines patterns in these data using life history, behavior and environmental data. In 2011, 2012 and 2013, bile samples and biometric data were collected from fish via demersal longlining and bile was analyzed for three PAHs, naphthalene, phenanthrene and benzo[a]pyrene and their metabolites, using high performance liquid chromatography with fluorescence detection (HPLC-F). Bile of golden tilefish had significantly higher concentrations of naphthalene and phenanthrene metabolites, compared to red snapper and king snake eel. For biliary naphthalene metabolites, golden tilefish had an average concentration of 240 ug g-1, compared to 61 ug g-1 for red snapper and 38 ug g-1 for king snake eel, for the year 2012. Biliary naphthalene metabolite concentration has decreased 8% in golden tilefish samples, between 2012 and 2013, indicating continuous exposure to petrogenic pollution, while naphthalene metabolites decreased 49% over time for red snapper and 37% for king snake eel, indicating episodic exposure to elevated petrogenic pollution prior to 2011. The concentration of naphthalene metabolites measured in golden tilefish in this study are some of the highest concentrations measured in the GoM and internationally, while naphthalene metabolite concentrations for red snapper and king snake eel are similar to 1990's GoM data. In contrast, concentrations of benzo[a]pyrene metabolites were statistically similar for all three species, suggesting a difference in the disposition of or exposure to benzo[a]pyrene contamination. Concentrations of benzo[a]pyrene metabolites are relatively low when compared to other GoM and international data, for all three species. This study has identified a species of GoM fish, golden tilefish, that is exposed to a present-day source of petrogenic PAH pollution and certain fish species that were episodically exposed, in the years following the Deepwater Horizon blowout. With residual Deepwater Horizon oil still found in GoM sediments, coastal marshes and beaches, there is a need to identify these chronic exposures to persistent PAH pollution, monitor PAH concentrations in over time and evaluate the resulting sublethal effects to better understand the impacts of the Deepwater Horizon blowout on marine resources such as GoM fisheries.

This thesis focuses on developing methodics for performance comparison of data warehouse systems. Firstly, the thesis defines data warehouses in various development stages of organization BI and describes knowledge about data warehouses. Methodics developed in the thesis describes architecture of standardized data warehouse, data flow between areas of data warehouse and processes in data warehouse. Understanding of these concepts is crucial for assurance of methodics applicability. Methodics offer logical progression of steps, which start and include testing of data warehouse systems. The contribution of the thesis is in having guide, what needs to be done when organization must do while testing various systems for data warehouses. Also it describes how this testing should be done on middle level detail, which is the absolute minimum level of abstraction that can be done due to wide applicability of methodics. Methodics offers solution to the problem of performance comparison when organization need to answer question - Which data warehouse system should we use in our organization? However, methodics expects already some knowledge about data warehouse content.

The thesis deals with banking data warehouse and the factors which influence their architecture. The goal of the thesis is to analyze the influence by fulfilling the three partial goals -- defining banks' requirements on data warehouses, analyzing a data warehouse in the real banking environment and making a comparison of the Czech banks' data warehouses. First, the thesis briefly introduces elements of business intelligence (BI) and data warehousing. Second, after deducing reasons for BI implementation in commercial banks, the requirements on data warehouse are synthesized and their impacts on the data warehouse architecture are analyzed. Finally, conclusions of the thesis are applied on creation of the survey which enables comparison of the Czech banks' data warehouses. The thesis applies the theory of relationship between BI maturity, requirements on BI and data warehouse architecture and creates a tool for evaluating and comparing the data warehouses of banks with respect to bank's BI maturity and predisposition for a particular architecture. The tool can serve as a basis for a general tool able to compare data warehouses in other branches of economy and can help to better understand relations between organizations' need for information, BI solutions used and underlying data warehouses.

The Diploma thesis discusses Balanced scorecard and Business intelligence solution on universities. Solution is systematically divided into two main units, each with its chapters. First unit focuses on theory of Balanced scorecard and Business Intelligence. There are shown four basic perspectives of the Balanced scorecard and the basics are further enhanced by modifications, focusing on academic environment. Second chapter introduces the basic information readers needs to continue into the most important part of this work, which is pilot implementation of Business Intelligence at the University in Prague. Second unit deals with practical implementation of theoretical knowledge, gained in first unit. The following is specification of University in Prague with proposal of Balanced scorecard for the University in Prague. This is base fo further work, where is implemented pilot Business intelligence solution with basic reports.

This thesis is focused on the design of Business Intelligence solution to the logistics sector. Its main goal is to enable the unnamed central-bohemian company, which deals with truck road transportation, to follow up and evaluate its data better. The theoretical part is focused on the basic principles of Business Intelligence and on the analysis of current market situation. The next section is dedicated to the specifics of this problematic in the logistics field. The practical part deals with the design of Business Intelligence solution to the concrete company. The analysis of company preparedness for Business Intelligence and the specification of requirements on its solution precede the resultant reporting tool. There is the unification of company's data in the form of data warehouse and the design of individual indexes and dimensions, from whose point of view data will be monitored. The main benefit of this thesis is resultant solution in the form of reporting tool, which can company, that is not familiar with the problematic of Business Intelligence, use as its future advantage.

The thesis deals with integration of claim system (APH) into DWH of Česká pojišťovna. Aim of the thesis is characteristic and introduction of all the activities that need to be done to make the claim system integrated. Main goal is to analyze source data, to propose logical model of individual DWH layers, to analyze and to design specific mappings and to test defined transformations. The thesis is divided into three logical parts. In the first part there is the general theoretical definition of BI/DWH. The second part presents methods, principles, tools and techniques used in BI/DWH department of Česká pojišťovna, there is also realized characteristic of claim system, and finally this part is about presentation of the basic characteristics of the project Integration of claim system into DWH of Česká pojišťovna. The last part of the thesis is devoted to integration of the claims into all layers of company´s DWH, this means that there is done an analysis of the source data, design of logical model, analysis and design of specific mappings and testing. Author of the thesis was personally involved in the project, because of the fact that he cooperated on the analytical part of the project. Author´s contribution consists in comprehensive elaboration of the subject of the thesis, but mainly in the presentation of analytical and other activities, which the author implemented by himself, or participated in them.

The aim of the thesis is to automate the process of loading data from particular distributors, make data quality management more transparent - consolidate data from particular distributors - mainly in the area of products and points of sale (pharmacies), process existing reports in modern reporting tool, which enables the creation of new reports, including graphically processed territorial data (map reports), with the possibility of interactive viewing of detailed data.