The challenge
- HR teams needed faster access to data without navigating complex Power BI reports.
- Nontechnical users faced barriers when accessing analytical information.
- More requests were being directed to HR analysts, reducing decision-making efficiency.
- The solution had to maintain strong security and Row-Level Security (RLS) permissions in Azure.
The solution
Aspecta designed and implemented an AI chatbot using Microsoft Azure and Azure OpenAI (GPT‑4 Turbo/4.5). The chatbot provides a natural-language interface to HR reporting, allowing users to ask questions directly. Responses are generated from SQL/DAX queries over the HR database while fully respecting Row-Level Security (RLS) and Object Security policies. Technologies used:
- Frontend: MS Teams, the existing working environment for ST/TMCZ
- Backend: Python, LangChain, CrewAI, Teams‑AI SDK
- AI Model: Azure OpenAI (GPT‑4 Turbo/4.5)
- Data: HR cube in the ST Azure Cloud tenant, accessed through a read‑only schema
- Hosting: Azure App Service (Docker image), Azure AI Foundry
The chatbot analyzes the user request, translates it into a SQL query, and uses a RAG approach to interpret the response in the context of HR metrics. Integration with MS Teams makes the solution readily accessible to managers, HR business partners, and analysts.
Implementation
The project was delivered in two phases:
- Feasibility Study (Q1/2024): Validation of AI capabilities, security, and Row-Level Security (RLS) access.
- Production pilot (Q2/2024): Deployment in Azure, integration with MS Teams, and testing with selected HR teams.
The project was carried out in close cooperation with IT security, HR, and BI teams to support compatibility with internal processes and compliance policies including GDPR, ISO 27001, and SOC 2.
Results and benefits
- – 70% less time needed to retrieve HR information.
- + 85% user satisfaction, with the strongest response among HR business partners.
- 200% increase in HR data usage compared with the previous BI solution.
- Automation and intuitive querying contributed to reducing requests to HR analysts by more than half.
“The AI chatbot allows us to respond quickly to management requests and access relevant HR data directly in the environment we already use every day. It is a real change in how HR works with data.” HR Business Partner, Slovak Telekom
Conclusion
The project demonstrated Aspecta’s experience in AI solutions and Azure integration and its ability to deliver secure, practical tools for working with data. By combining technical know-how with measurable value for HR teams, Aspecta helps organizations simplify access to data, accelerate decisions, and support a data-driven culture.
Experience from enterprise environments and a strong focus on security requirements allow Aspecta to combine new technology with reliable delivery. The AI chatbot is an example of a solution that provides immediate value to users while respecting strict data protection requirements.
