Reports & Comments
Generation Based on Cloud & GenAI
About the Project
This project enhances fully automated dashboards using Google Cloud Platform (GCP) by integrating Generative AI (GenAI) models to improve comment generation and trend analysis. The main goal is to automate the insights extraction process and generate relevant, insightful comments based on extensive and multi-sourcing datasets from the Europe Digital Transformation Program of a Telecom company.
Industry: Telecom company / Digital Transformation Program (Europe level).
Target Users: High level managers team.
Problem to Solve
Manual data collection, trend analysis, and comments generation in dashboards were time-consuming, error-prone, and lacked scalability. The project addresses the need for:
Fully automated data collection from multiple years and countries.
Scalability in processing large datasets.
Centralize data into an accessible storage by many departments of a big company.
Automated and consistent comment generation for KPIs.
Key Features / Highlights
Fully Automated ETL Pipeline: Serverless computing to handle data collection, processing and AI interaction.
Cloud Centralized storage: Integrated GCP storage for data lake architecture and BigQuery as a data warehouse, enabling structured data storage and scalable analysis.
Automated Comment Generation: Dynamic AI-generated comments based on KPI trends and comparisons using custom prompt engineering.
Azure OpenAI Integration: GPT-3.5-Turbo used for generating insights via REST API calls.
Data Visualization: Looker Studio to build the KPI dashboards and scorecards.
Results & Impact
Increased Efficiency: Automated insights reduced manual reporting time by over 70%.
Enhanced Scalability: Processed large datasets spanning years & countries without performance delay.
Actionable Insights: Delivered real-time KPI trends and comments, improving decision-making for stakeholders.
Cost Optimization: Leveraged AI effectively without requiring extensive model fine-tuning.
