The quality and reliability of the products play an increasingly important role in the production nowadays. This manifests itself radically in the field of energy production in the case of turbines operated in power plants. This new application, about which I wrote in this thesis, tries to help to decrease the number of defective product, thereby reduce the time spent to improve/repair them, produce less scrap, also help to select better suppliers that achieve/meet the quality standards.
To achieve these goals in the first step I transform the data, collected during the quality assurance process, to a usable form, store it in a data warehouse, and finally I present it in reporting web application – developed by me.
With the implemented dashboards, summaries, trends, reports I would like to make the errors occurring during production and the processes to correct these errors get more transparent, measurable, and optimisable.
In the first chapter of this thesis I presented the technological and theoretical foundations of data warehouses, which, because of the development’s data processing, and reporting aspects, play a very important role.
The user interface segment, which is responsible for the presentation of applications, and which the users will mainly use in their everyday work, is not less important.
So, I try demonstrate with a few examples the key features of the most widely used business intelligence frameworks.
The reporting system is based on data from the fault management systems, I briefly discuss the importance of these systems as well.
After an overview of the theoretical structure of the data warehouse, I describe the steps of the data transfer process. This segment will start with the upper level logical planning and will go towards the detailed data model. After the base layer of the web-based reporting interface I will introduce the frame structure design and finally the implemented key elements of the report templates.
The physical implementation will follow the planning steps. I will describe the development and runtime environment for employees, covering the programming language, programs used, and the details of implementation of the most important functions.
Testing is an important part of the application development life cycle. The application will undergo functional and performance related before deploying to users. I try to present the most important characteristics of the testing with the statistical summation of the results of the tests.
Finally, I will outline my ideas on further development possibilities, which can include integration between systems and expansions of the functions.