African Alliance wanted to move beyond the usual data-aggregation and reporting tools and see what emerging AI could do for them. The classic problem was Excel in, Excel out: pulling numbers together from different report formats by hand, then losing time to the manual work instead of the analysis.
02
The approach
We worked with African Alliance’s AI Centre of Excellence to find a use case worth backing, then deployed a company-grounded assistant in about two months using our template-based RAG framework on Azure AI Services. It does two jobs. It answers questions on company policy and procedure, and it takes existing Excel reports in different formats and rebuilds them into consolidated accounts against the group standard, all through natural language. Everything runs in African Alliance’s own Azure tenant, with Entra ID handling authentication. An intent-routing layer in an Azure-hosted Web API picks the right tool or model from the Azure AI Foundry catalogue, retrieves from the knowledge base with Azure AI Search, and stores conversation history in Cosmos DB.
03
The outcome
As an early adopter of generative AI, African Alliance is driving real efficiencies. People get quick, grounded answers from the knowledge the company already holds, and the Excel-in, Excel-out grind becomes a natural-language request instead of a manual chore. It also sets up future work, such as querying live market data, pricing and customer records.
Summary & benefits
Quick, grounded answers drawn from company policy and procedure.
Existing Excel reports consolidated into standard accounts on request.
A foundation for querying live market data, pricing and customer records.
Similar work in Financial Services
More customer stories like this one.
Bringing home-office inverters into view with IoT and AI
A low-cost device that retrofits to home-office inverters and, with generative AI on top, gives a financial services firm a live view of agents’ backup power and battery health.
A custom ESP device that retrofits to thousands of basic 24V inverters, giving WFS live visibility of its remote backup-power fleet and an AI tool to interrogate the data.
A personalised colleague portal that lives inside Microsoft Teams, giving the bank’s staff across Africa one place to find news, company services and the people they work with.