Real-Time Business Intelligence
Bouchelouche, Houd (2018)
2018
Information Technology
Tieto- ja sähkötekniikan tiedekunta - Faculty of Computing and Electrical Engineering
This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Hyväksymispäivämäärä
2018-01-10
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:tty-201712282499
https://urn.fi/URN:NBN:fi:tty-201712282499
Tiivistelmä
Nowadays, terms such as the Internet of Things, Big Data analytic and Business Intelligence are very common among business leaders, managers and analysts. There is no wonder why, acquiring a huge amount of data with the ability to store it, process it and analyze it implies better and more informed business decisions made by corporate decision makers. However, some of these technologies are still maturing. Therefore, a new approach and patterns for designing solutions consisting of such technologies will play an important role in accelerating and improving their implementation.
This thesis work will focus on the study, design and implementation of a real-time BI(Business Intelligence) solution that gets data from operational databases as well as other real-time platforms such as Meter Data Management Systems. The BI will allow end-users to visualize data, view reports and access dashboard for both decision-makers and operational workers.
The developed prototype is able to extract data from disparate data sources and store it into a data warehouse using dimensional modelling. The solution is also able to extract real-time data from an MDMS(Meter Data Management System) to provide real-time analytics for smart meters data. Some tools and technologies that are used in the BI domain were studied, and the selected ones were used for implementing the prototype. Qlik Sense is used for data visualization and reporting. Talend Open Studio is used for the development of ETL process.
This thesis work will focus on the study, design and implementation of a real-time BI(Business Intelligence) solution that gets data from operational databases as well as other real-time platforms such as Meter Data Management Systems. The BI will allow end-users to visualize data, view reports and access dashboard for both decision-makers and operational workers.
The developed prototype is able to extract data from disparate data sources and store it into a data warehouse using dimensional modelling. The solution is also able to extract real-time data from an MDMS(Meter Data Management System) to provide real-time analytics for smart meters data. Some tools and technologies that are used in the BI domain were studied, and the selected ones were used for implementing the prototype. Qlik Sense is used for data visualization and reporting. Talend Open Studio is used for the development of ETL process.