|
|
Automation and visualization project boards in the specific company
Vancl, Jakub ; Slánský, David (advisor) ; Pour, Jan (referee)
The aim of the work is create and describe solution of automation and visualization of project boards in the specific manufacturing company. Methods and tools of Business Intelligence are used in this process. Project board is arranged summary of information, which is part of the monitor, in this context. There is for example information about produced pieces, the cost of poor quality, project Scorecard, downtime analyses, bottleneck of project, and so on. The theoretical part is dealing with description methods and components of Business Intelligence and serves to explanation basic principles on the basis of which are formed data staging area, data warehouse, OLAP cubes and dashboards. The main emphasis is on the practical part, in which is detail describe process of data elaboration from source data, which are taken primarily from MS Excel files, till data visualization in the form of dashboard. As software workspace were selected Microsoft products, specifically SQL Server Management Studio, Visual Studio and Excel which has been mentioned before. The main output is solution that will gradually fully replace paper project boards. This solution also brings both financial and time savings in the creation and managing project boards, because this process is automated.
|
guest ::
RSS feed.