Borrowing from Power BI/Fabric. Take the new AI library AI agents and add a method to train them to be data analysts. To be able to train the model based on real natural language questions and a provide a SQL query that answers that question.
This ability would greatly improve the agent's accuracy as it is taught exactly how to query the data that is tailored to each company's unique DOMO architecture. While at the same time creating a much more flexible one stop shop for any user to get their questions answered without needing to request a new card, app or any architecture development
Fabric data agent creation - Microsoft Fabric | Microsoft Learn
