What I want from an ai tool is strong "inferences" or some "understanding" of the data. Say I have a table with stock data and for this example it just has the following columns, ticker, close, volume_traded, eps_from_last_report, shares_outstanding. Some questions I should be able to ask are
1. What is the market cap of ticker X?
2. What is the 52 week high of ticker Y?
3. Which week had the most growth for ticker Y compared to the least growth for ticker X?
4. What is the pe ratio for ticker Z end of last quarter?
I hope you get my point, if it's a case where I have to fill in some data/formulas to guide it on what I expect that's fine as well but a pass thru to gpt with a subset of the data in the prompt won't hold up outside of toy cases or limited data. If you can solve that use case reliably then you're miles ahead of the pack.