Code Interpreter is great for "quick and dirty" data analysis & visualizations. I've seen it struggle with larger datasets (not sure what the current limit is) but I can certainly see this sort of stuff replacing basic BI at organizations.
Microsoft is working on embedding this sort of stuff into what they call Fabric - which is essentially meant to be PowerBI on steroids. I know in the current preview, you can interact with data using a chat-like interface ("Show me our revenue for the last 12 months sorted by customer") .
One large use case is certainly data analysis. But one big challenge with analytics is: you always get a result.
Wrong filter, wrong aggregation function, wrong table or wrong join can all still result in plausible but wrong results.
Hallucinations take the form of arbitrary logic.
Disclaimer: I'm a cofounder at getdot.ai. We are starting to solve that with a semantic layer, but for now it is limited to business reporting (sales per territory, etc.). PowerBI will imo make it even easier for people to create visuals (NL vs drag n drop), but right now fails at the consistency part.
Microsoft is working on embedding this sort of stuff into what they call Fabric - which is essentially meant to be PowerBI on steroids. I know in the current preview, you can interact with data using a chat-like interface ("Show me our revenue for the last 12 months sorted by customer") .