{"id":16242,"date":"2025-05-28T10:47:00","date_gmt":"2025-05-28T14:47:00","guid":{"rendered":"https:\/\/www.rochester.edu\/coe\/?p=16242"},"modified":"2025-06-04T11:20:52","modified_gmt":"2025-06-04T15:20:52","slug":"macroxstudio-data-analysis-assistant","status":"publish","type":"post","link":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/","title":{"rendered":"MacroXStudio: Data Analysis Assistant"},"content":{"rendered":"

\"AI-Powered<\/p>\n

Team Members: Abhishek Sharma, Jayant Patil, Bhargav Sai Bhuvanagiri, Aashrith Maisa<\/em><\/p>\n

This goal of this project was to develop a data analysis tool for finance professionals, particularly portfolio managers who lack coding skills. The goal was to enable these professionals to analyze financial data and generate insights through natural language interactions. Students applied various techniques, including the integration of Large Language Models (LLMs) like GPT-4 and LLaMA, natural language processing, and vector similarity searches to identify relevant data columns and efficiently perform analyses. The final workflow achieved response times of under one second for simple tasks, balancing both accuracy and speed. This solution empowers non-technical users to perform sophisticated analyses, improves decision-making efficiency, and bridges the gap between complex data analysis and financial expertise.<\/p>\n","protected":false},"excerpt":{"rendered":"

Team Members: Abhishek Sharma, Jayant Patil, Bhargav Sai Bhuvanagiri, Aashrith Maisa This goal of this project was to develop a data analysis tool for finance professionals, particularly portfolio managers who…<\/p>\n","protected":false},"author":162,"featured_media":16252,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[112,132],"class_list":["post-16242","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fall-2024-projects","tag-finance","tag-macroxstudio"],"yoast_head":"\nMacroXStudio: Data Analysis Assistant - Center of Excellence in Data Science and Artificial Intelligence<\/title>\n<meta name=\"description\" content=\"The team developed a natural language tool for finance professionals using GPT-4 and LLaMA. The assistant helps users perform fast, accurate financial analyses without coding, bridging the gap between data and decision-making.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MacroXStudio: Data Analysis Assistant - Center of Excellence in Data Science and Artificial Intelligence\" \/>\n<meta property=\"og:description\" content=\"The team developed a natural language tool for finance professionals using GPT-4 and LLaMA. The assistant helps users perform fast, accurate financial analyses without coding, bridging the gap between data and decision-making.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/\" \/>\n<meta property=\"og:site_name\" content=\"Center of Excellence in Data Science and Artificial Intelligence\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-28T14:47:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T15:20:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required-1200x630.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Hsin-I Liu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hsin-I Liu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/\"},\"author\":{\"name\":\"Hsin-I Liu\",\"@id\":\"https:\/\/www.rochester.edu\/coe\/#\/schema\/person\/853fca58e2468cfc8d27b9369fef1993\"},\"headline\":\"MacroXStudio: Data Analysis Assistant\",\"datePublished\":\"2025-05-28T14:47:00+00:00\",\"dateModified\":\"2025-06-04T15:20:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/\"},\"wordCount\":128,\"image\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg\",\"keywords\":[\"Finance\",\"MacroXStudio\"],\"articleSection\":[\"Fall 2024 Projects\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/\",\"url\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/\",\"name\":\"MacroXStudio: Data Analysis Assistant - Center of Excellence in Data Science and Artificial Intelligence\",\"isPartOf\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg\",\"datePublished\":\"2025-05-28T14:47:00+00:00\",\"dateModified\":\"2025-06-04T15:20:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/#\/schema\/person\/853fca58e2468cfc8d27b9369fef1993\"},\"description\":\"The team developed a natural language tool for finance professionals using GPT-4 and LLaMA. The assistant helps users perform fast, accurate financial analyses without coding, bridging the gap between data and decision-making.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage\",\"url\":\"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg\",\"contentUrl\":\"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg\",\"width\":1920,\"height\":1080,\"caption\":\"AI-Powered Finance Analysis\u2014No Coding Required\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rochester.edu\/coe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MacroXStudio: Data Analysis Assistant\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rochester.edu\/coe\/#website\",\"url\":\"https:\/\/www.rochester.edu\/coe\/\",\"name\":\"Center of Excellence in Data Science and Artificial Intelligence\",\"description\":\"University of Rochester\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rochester.edu\/coe\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rochester.edu\/coe\/#\/schema\/person\/853fca58e2468cfc8d27b9369fef1993\",\"name\":\"Hsin-I Liu\",\"sameAs\":[\"https:\/\/www.rochester.edu\/coe\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MacroXStudio: Data Analysis Assistant - Center of Excellence in Data Science and Artificial Intelligence","description":"The team developed a natural language tool for finance professionals using GPT-4 and LLaMA. The assistant helps users perform fast, accurate financial analyses without coding, bridging the gap between data and decision-making.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/","og_locale":"en_US","og_type":"article","og_title":"MacroXStudio: Data Analysis Assistant - Center of Excellence in Data Science and Artificial Intelligence","og_description":"The team developed a natural language tool for finance professionals using GPT-4 and LLaMA. The assistant helps users perform fast, accurate financial analyses without coding, bridging the gap between data and decision-making.","og_url":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/","og_site_name":"Center of Excellence in Data Science and Artificial Intelligence","article_published_time":"2025-05-28T14:47:00+00:00","article_modified_time":"2025-06-04T15:20:52+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required-1200x630.jpg","type":"image\/jpeg"}],"author":"Hsin-I Liu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hsin-I Liu","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#article","isPartOf":{"@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/"},"author":{"name":"Hsin-I Liu","@id":"https:\/\/www.rochester.edu\/coe\/#\/schema\/person\/853fca58e2468cfc8d27b9369fef1993"},"headline":"MacroXStudio: Data Analysis Assistant","datePublished":"2025-05-28T14:47:00+00:00","dateModified":"2025-06-04T15:20:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/"},"wordCount":128,"image":{"@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg","keywords":["Finance","MacroXStudio"],"articleSection":["Fall 2024 Projects"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/","url":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/","name":"MacroXStudio: Data Analysis Assistant - Center of Excellence in Data Science and Artificial Intelligence","isPartOf":{"@id":"https:\/\/www.rochester.edu\/coe\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage"},"image":{"@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg","datePublished":"2025-05-28T14:47:00+00:00","dateModified":"2025-06-04T15:20:52+00:00","author":{"@id":"https:\/\/www.rochester.edu\/coe\/#\/schema\/person\/853fca58e2468cfc8d27b9369fef1993"},"description":"The team developed a natural language tool for finance professionals using GPT-4 and LLaMA. The assistant helps users perform fast, accurate financial analyses without coding, bridging the gap between data and decision-making.","breadcrumb":{"@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#primaryimage","url":"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg","contentUrl":"https:\/\/www.rochester.edu\/coe\/wp-content\/uploads\/2025\/05\/AI-Powered-Finance-Analysis\u2014No-Coding-Required.jpg","width":1920,"height":1080,"caption":"AI-Powered Finance Analysis\u2014No Coding Required"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rochester.edu\/coe\/macroxstudio-data-analysis-assistant\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rochester.edu\/coe\/"},{"@type":"ListItem","position":2,"name":"MacroXStudio: Data Analysis Assistant"}]},{"@type":"WebSite","@id":"https:\/\/www.rochester.edu\/coe\/#website","url":"https:\/\/www.rochester.edu\/coe\/","name":"Center of Excellence in Data Science and Artificial Intelligence","description":"University of Rochester","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rochester.edu\/coe\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.rochester.edu\/coe\/#\/schema\/person\/853fca58e2468cfc8d27b9369fef1993","name":"Hsin-I Liu","sameAs":["https:\/\/www.rochester.edu\/coe\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/posts\/16242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/users\/162"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/comments?post=16242"}],"version-history":[{"count":5,"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/posts\/16242\/revisions"}],"predecessor-version":[{"id":16582,"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/posts\/16242\/revisions\/16582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/media\/16252"}],"wp:attachment":[{"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/media?parent=16242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/categories?post=16242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rochester.edu\/coe\/wp-json\/wp\/v2\/tags?post=16242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}