to-do.md

1. include graphs/charts
2. include tables
3. fix viz insights section
4. Allow users to download the report as PDF or TXT.
5. split the code into functional modules:
   • data_loader.py → Handles dataset loading (CSV, Hugging Face)
   • sql_tools.py → Contains SQL-related tools and database setup
   • agents.py → Defines agents and their goals
   • app.py →
6. tab 1 -- Answer to the query + visualization specific to the query asked; tab 2 -- all the visualizations for the uploaded CSV/dataset.

final report should consist of: overview, [yearly salary trends, location + remote work impact, company size consideration] + visual insights, conclusion)

---

# Agent for generating the main report (without Conclusion)
report_writer = Agent(
    role="Technical Report Writer",
    goal="Summarize the analysis into a structured report with Introduction, Key Insights, and Analysis. DO NOT include any conclusion or summary.",
    backstory="Markdown report excluding Conclusion and Summary.",
    llm=llm,
)

# agent for generating ONLY the Conclusion
conclusion_writer = Agent(
    role="Conclusion Specialist",
    goal="Summarize findings into a clear and concise Conclusion/Summary section.",
    backstory="An expert in crafting well-structured and insightful conclusions.",
    llm=llm,
)