Plataforma Optimizado de Gastos y Consumo

SnowFlare DataBase
Website

Inspiration

We wanted to create a platform that could analize energy, water or transportation data in a single program and create recommendations.

What it does

It takes government public services information and sends it to a Snowflake database where the data is organized and extracted so then it can be fed to a Gemini API so the AI can analize the data and generate recommendations or the viability of the expences.

How we built it

We first started with a Python program that transforms PDF files into json files, then it is sent to Snowflake to create and organize the databases. It is then extracted and fed into a Gemini API where it learns from the data and creates recommendations for optimization. This data can be sent from a website created with HTML.

Challenges we ran into

The Gemini API can be very limited and the learning progress was slow and tedious, but with a lot of iterations we were able to optimize it

Accomplishments that we're proud of

We are proud of the use of the Gemini API and the concept of the idea in itself that can be applied to all services.

What we learned

This project was incredibly challenging with our current knowledge, but we were determined and we were able to understand how to connect databases to python programs and we now are able to feed this data to AI learning how to use machine learning and the processes necessary to connect all this programs to a website.