Documentation tool for business intelligence systems : implementing a mechanism to parse BI-related files
Almouayad-Alazem, Roula (2023)
2023
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-202303304446
https://urn.fi/URN:NBN:fi:amk-202303304446
Tiivistelmä
This thesis aims to continue the development of a business intelligence (BI) system documentation tool. The tool should collect data from different BI solution components so that users can relate data warehouse tables accessed and used by the BI solution. The paper focuses on BI solutions implemented in the Microsoft SQL Server using its related tools Microsoft provides. Data warehouses are held in SQL server database engines, and the Microsoft BI tools are SQL server integration services (SSIS), SQL server reporting services (SSRS), SQL server analysis services (SSAS) and PowerBI.
The tool was implemented using the C# language as a console application which executes manually or automatically as scheduled.
The tool parses the physical files of each BI component and inserts collected data into database tables devoted to this purpose. According to the user's preferences, collected data are modelled and analyzed, and eventually, visualized using any reporting tool.
The tool was implemented using the C# language as a console application which executes manually or automatically as scheduled.
The tool parses the physical files of each BI component and inserts collected data into database tables devoted to this purpose. According to the user's preferences, collected data are modelled and analyzed, and eventually, visualized using any reporting tool.