Artificial intelligence (AI) has significantly transformed numerous industries in recent years, enhancing efficiency and enabling innovative solutions to complex problems. This study delves into the exciting potential of automating data analysis tasks by integrating advanced natural language processing (NLP) techniques with powerful tools like LangChain and LLm Agent. LangChain plays a crucial role in facilitating effective PDF data analysis by efficiently extracting text, creating meaningful chunks of information, and generating vector stores that organize the data for further processing. On the other hand, LLm Agent leverages conversational interactions to streamline the analysis of structured data formats such as CSV and Excel files, making the process more intuitive and user-friendly. This research thoroughly examines the effectiveness of these innovative tools in significantly improving both the precision and productivity of data analysis tasks. The outcomes reveal notable advancements in automating data analysis procedures, indicating that LangChain and LLm Agent hold great promise for the future of enhancing data-driven decision-making across various sectors. By shedding light on the capabilities of these technologies, this study contributes to the expanding body of research focused on AI-powered automation in data analysis. Furthermore, it provides valuable insights and practical implications for both researchers and industry practitioners seeking to leverage AI for improved analytical processes and outcomes.