I need a conversational AI data analyst dedicated to our e-commerce sales database. The chatbot must understand raw transactional data, run on demand queries, and return clear insights about revenue trends. Its core focus is two metrics: • Month-over-month growth rate • Revenue broken down by product category A typical interaction would be: “Show me the growth in March vs February” or “Which categories were above average last quarter?” The bot should reply with concise text explanations plus optional charts or tables, ready for copying into reports or dashboards. Data will arrive in CSV or through a direct connection to our existing store platform; the solution should comfortably handle either method. Python with pandas, SQL, or a similar stack is fine as long as the response time stays near real-time. Feel free to integrate an LLM or retrieval-augmented generation layer so the conversation feels natural and follow-up questions are understood in context. Deliverables • A working chatbot deployed to a simple web interface or Slack channel • Source code and environment setup instructions • Brief documentation covering data schema assumptions, query examples, and how to extend the bot to additional analytics (product performance, customer behavior) in the future The project is complete when I can upload or connect the latest sales data and immediately ask the bot for monthly growth or category revenue without manual preprocessing.