Αυτοματοποίηση διαδικασιών εξαγωγής και διανομής αναφορών Επιχειρηματικής Ευφυΐας (BI) και δυναμική ενημέρωση χρηστών μέσω SQL & Python
Automation of processes for exporting and distributing Business Intelligence (BI) reports and dynamically updating users via SQL & Python
View/
Keywords
Επιχειρηματική ευφυΐα ; Business Intelligence (BI) ; Διοίκηση ανθρωπίνων πόρων ; BI analytics ; Python ; Pandas ; SQL Server ; Αυτοματοποιημένες αναφορές ; SMTP ; AdventureWorksAbstract
This diploma thesis focuses on the design, development, and implementation of an integrated Business Intelligence (BI) system and an automated reporting pipeline within the broader corporate domain.
In the modern business environment, data-driven decision-making is critical, and the analysis of statistical data along with Key Performance Indicators (KPIs) serves as a fundamental pillar for strategic growth.
The core objective of this project is the construction of an automated data pipeline utilizing the Python programming language and the Microsoft SQL Server relational database, evaluated against the extensive corporate schema of the AdventureWorks sample database. The developed application sequentially executes a multitude of complex analytical SQL queries regarding critical KPIs, including organizational structure, salary scales, employee mobility and promotions, departmental and geographical distribution, as well as sales performance and profit levels.
Raw data are dynamically retrieved, cleaned, and transformed into processed data leveraging the Pandas library. Subsequently, the system automatically generates statistical visualizations and renders data tables into structured HTML/CSS code via Markdown parsing libraries. The final stage of the pipeline compiles these components into a dynamic, fully formatted executive briefing and securely dispatches it using the Simple Mail Transfer Protocol (SMTP) over a TLS-encrypted connection directly to senior management.
The findings of this thesis demonstrate that automating business intelligence workflows drastically reduces report preparation time, eliminates human operational error, and provides management with immediate, transparent, and highly reliable insights essential for the optimal management of the entity of business activities.