Project: Football-Analysis-Copilot

[erincon01]

Project Name

Football-Analysis-Copilot

Description

We have used public data from statsbomb, that is a company that shares football insights to Football Cloubs. This data is exposed in Json format, that is not prepared for RAG and AI models.

We have:

• loaded the data into Azure Postgres Flexible database in Azure.
• calculate the embeddings for 4 different LLMs.
• implemented a RAG pattern in pyhon where we add as extra sauce tabular data.
• built a chatbot application where user can tune/adjust most of the parameters like tokens, temperature, system message, search algorigithm.

The front-end is built in streamlit, that is a great framework for data analysis. We didn't deploy the application in Azure Web Apps because of the credits.

The process is documented here: https://github.com/erincon01/RAG-Challenge/blob/main/README-process.md

Streamlit app is here with lots of screenshots: https://github.com/erincon01/RAG-Challenge/blob/main/README-streamlit.md

Readme with full details: https://github.com/erincon01/RAG-Challenge/blob/main/README.md

Questions for testing created for Football domain: https://github.com/erincon01/RAG-Challenge/blob/main/questions.json

Log of the queries results: https://github.com/erincon01/RAG-Challenge/tree/main/data/scripts_summary/Answers

Sample summary of the data converted from Json to Postgres Flexible: https://github.com/erincon01/RAG-Challenge/tree/main/data/scripts_summary

We have really enjoyed this journey. This technology is great, and very easy to use!

Technology & Languages

• [ ] JavaScript
• [ ] Java
• [ ] .NET
• [X] Python
• [ ] AI Studio
• [ ] AI Search
• [X] PostgreSQL
• [ ] Cosmos DB
• [ ] Azure SQL

Project Repository URL

https://github.com/erincon01/RAG-Challenge

Deployed Endpoint URL

No response

Project Video

https://github.com/erincon01/RAG-Challenge/blob/main/RAG-Challenge_Sabados_Tech.mp4

Team Leader

erincon01

Team Members

EugenioSerrano, JoseMarianoAlvarez, eric-net, erincon01

[erincon01]

I have updated the members list to 4 acording to the rules, and I have added me as Team Leader.

[erincon01]

btw, if you need to test the app, contact me and I'll switch on the container for a few hours.

[multispark]

Hello @erincon01, thank you for participating in RAG Hack!

The team is working hard to distribute badges. Please have each team member fill out this form: aka.ms/raghack/badge-dist

Thank you!