Project Draft Business Intelligence

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.