I have been lately extending my data knowledge with AI-related learning. First I familiarized myself with the basic concepts and architecture of AI and agentic AI. Then I decided to focus on Azure AI Foundry, because it seems to be quite popular among Finnish customers.
As usual, after some learning, I wanted to build something by myself and write a blog post about it. Actual interface / dialogue box is at the end of the post, so you have to scroll through the whole post to be able to test it 😊. Ok, you can also jump directly to the assistant from here:
Jump to the NHL Data Assistant ↓
I created an Azure AI Foundry AI agent to analyze NHL game data, which I had uploaded into Google BigQuery. I wanted to demonstrate how we can use our own internal data as a source for an AI agent.
I used ChatGPT Codex to help me code this solution and have to admit, it was really good help. Actually, I was quite impressed how much of the development Codex could do for me, especially when I got to the web application part later.
Creating the Foundry project
First I created an Azure AI Foundry project. It does not require any special configuration for this simple experiment.
