How LLMs and AI Agents Transform Unstructured Data Analysis