Inspiration
The overwhelming task related to data in my workplace trigger the idea of having an truly self service data platform that can be use directly by business user without additional technical knowledge.
What it does
This MVP has 2 main feature, query generation for ad-hoc data request and self service report builder
How we built it
- The query generation needs the developer to put their current knowledge about their database into "knowledge bank", the bank will be sent to GPT-4o along side with the user request, and it will generate the query. The query can be executed once the developer think its valid and the result can be delivered directly to the user.
- The self service report builder will generate code (HTML,CSS,Javascript,C#) based on user request and the dataset schema, the generated code will be rendered(data binding) and the result will be sent out to the user.
Challenges we ran into
Making the gpt-4o generate code that can be rendered directly without an error is a hurdle, more experiment needs to be done to minimize the hallucination
Accomplishments that we're proud of
- Managed to built the app while working full time as a solo founder
- Knowing that the idea can be done with current technology
What we learned
- The current gpt-4o still hallucinate when it come to code generation, need to add a framework to minimize the hallucinations
- building some framework around gpt-4o is helpful to reduce the hallucination when it comes to code generation
- Copilot integration with VSCode is really useful
What's next for FORMIS AI
- explore more complex cases especially for the self service report builder
- add sketch2code feature to the reportbuilder
- build a file system like PowerBI Report Server
- build a more advance highlighting mechanism for the report builder
- integrate to existing reporting platform, maybe built feature like "Convert to .rdl/PowerBI/Tableau/etc"
- building a better UI/UX
Log in or sign up for Devpost to join the conversation.