I want to turn my raw market-trends data into clear, action-ready insights with the help of a custom AI assistant. The core requirement is data analysis: the system should ingest whatever format I send—usually CSV and Excel dumps, occasionally a direct database export—and automatically clean, analyse, and visualise the material so that I can spot patterns, outliers, and emerging opportunities at a glance. I expect the workflow to be fully automated once a file is dropped into a designated folder (or a table is updated). Behind the scenes you can rely on Python, pandas, scikit-learn, or similar tooling; as long as the final solution is reproducible and easy for me to extend, the choice of libraries is up to you. I’m comfortable running scripts locally, but a lightweight web dashboard (Streamlit, Dash, etc.) that shows key charts and summary sentences would be ideal. Acceptance criteria – the assistant is complete when it: • Ingests new market-trends data without manual preprocessing • Generates a concise written summary plus interactive visualisations (trend lines, YoY comparisons, anomaly flags) • Saves both the summary and the visuals to a dated folder for future reference • Provides clean, commented code and a short README so I can tweak parameters myself If you have experience building analytical pipelines that turn messy data into straightforward stories, your approach will fit perfectly here.