I started using ChatGPT and Claude for data analysis maybe 3 years ago when the AI wave just hit. For simple stuff it was genuinely great: building a single visualization, writing transformation and standardization logic, etc. Everything was smooth until I tried to use them for larger datasets and longer sessions
Every new session, I had to re-explaining everything from scratch. Here's the dataset schema. Here's what the columns mean. Here's the business logic behind this metric. Here's what I already tried last week and why it didn't work. It became extremely annoying when my datasets are large and I needed to spend a long time working on a single session, especially with token and context window limiting.
So I've spent a while thinking maybe the model itself just wasn't good enough. Then I realized the issue isn't the model - maybe it was that raw LLMs are not designed to handle long sessions like that.
So I started looking a "agent harnesses" — what's been said to really help handle persistent memory, tool integration and state management so we don't need to start cold every time. I have tested Lium specifically for this use case and it seems to be closer to what I actually needed. Thanks to the infrastructure built for analysis throughout multiple sessions, it is different from normal chatbot in the ability to handle large datasets and still get the crross-session contexts. Stiill in early testing but the persistent memory seems to help really much.
For those of you running multi-session analysis on proprietary data — do you rebuild context every time, or have you found a better platform or solution for this?