Our projects
Explore how we support clients
IBIS
International Business Intelligence Service — is a custom BI solution delivered by Alpha-ICG for Ingérop Group.
Overview
Designed to support financial consolidation and reporting across its international operations, the platform brings together multiple data sources into one structured reporting environment built on Microsoft Power BI, Microsoft Fabric, OneLake, and ETL workflow.
Our Solution
Alpha-ICG designed and delivered IBIS as a tailored BI platform combining dashboard design, data modeling, multi-source integration, validation, deployment, training, and support. The solution is built on a Microsoft data stack including Power BI for visualization, Microsoft Fabric for unified data management, OneLake for centralized storage, and ETL processes to collect, transform, and standardize data from multiple sources. Built within the client’s own environment, IBIS was designed to improve reporting clarity, strengthen consistency, and provide a scalable foundation for decision-making.
Key Capabilities
- Microsoft Power BI dashboards for financial reporting
- Microsoft Fabric as the data platform backbone
- OneLake for centralized data storage
- ETL workflows for multi-source integration and transformation
- Structured financial consolidation reporting
- Scalable and governance-aware BI design
Tech Stack
Microsoft Power BI, Microsoft Fabric, OneLake, Azure Functions, C#, SharePoint, SQL.
Engineered for simplicity. Built for impact.
Nos Buscamos
Pro bono data transformation initiative delivered by Alpha-ICG to support humanitarian search efforts.
Overview
Faced with 355 disconnected PDFs containing thousands of human stories, the NGO Nos Buscamos struggled to access critical information. What should have been a source of insight was effectively trapped in unstructured data — limiting their ability to act quickly and effectively.
Our Solution
Alpha-ICG took on this challenge as part of its pro bono initiative, designing a streamlined data pipeline to unlock and structure the information. The solution focused on simplicity, accessibility, and zero-cost infrastructure.
We developed a Python-based pipeline to extract, normalize, and structure the data, converting 355 PDFs into more than 14 million structured records. The data was deployed into a serverless SQLite cloud database (Turso), eliminating infrastructure costs. On top of this, we built a C# application enabling fast querying and intuitive visualization — making the data instantly usable for the NGO.
Key Capabilities
- Python pipeline for data extraction, normalization, and structuring
- Conversion of 355 PDFs into 14M+ structured records
- Serverless SQLite cloud database (Turso) — zero infrastructure cost
- C# application for fast querying and data visualization
- Real-time access to data from any location
- No dependency on local storage
- Cost-free, scalable architecture tailored for NGO constraints
Key Capabilities
Microsoft Power BI, Microsoft Fabric, OneLake, Azure Functions, C#, SharePoint, SQL
