Microsoft's Data Formulator 0.7 Streamlines Enterprise AI Analytics

Microsoft Research's Data Formulator 0.7 offers an open-source, AI-powered solution for enterprise data analytics, simplifying complex workflows with integrated connectivity, agent assistance, and interactive visualization.

Daniel Singer

Editor, StartupHub.ai

May 28 at 4:08 PMUpdated Aug 22, 20263 min read

Screenshot of the Data Formulator 0.7 interface showing data connections and an AI agent interaction. — Data Formulator 0.7 integrates data connectors, an agent chat interface, and an interactive visualization canvas.· Microsoft Reesarch

Visual TL;DR

Fragmented Enterprise DataDriver

data scattered across databases, warehouses, BI systems, object stores, and files

From the article 2 mentionsMicrosoft Research has launched Data Formulator 0.7, an open-source AI-powered system designed to tackle the complexities of enterprise data analytics.

Iterative RefinementContext

interactive visualization for continuous improvement

From the article 2 mentionsThe system combines robust data connectivity, intelligent agent-guided exploration, and iterative visualization refinement within a shared workspace.

Data Formulator 0.7Core

Microsoft Research's open-source AI-powered analytics system

From the article 9+ mentionsContext-aware AI agents form the core of Data Formulator.

Data ConnectorsCore

From the article 9+ mentionsA key feature, Data Connectors, offers governed and reusable connections to diverse data sources including databases, warehouses, BI systems, object stores, and local files.

Agent-Assisted AnalysisCore

context-aware AI agents guide exploration and insights

From the article 2 mentionsThis approach aims to democratize data analysis, making it accessible to teams without requiring deep SQL or programming knowledge.

Streamlined AI AnalyticsEffect

simplifies complex workflows for enterprise data

From the article 2 mentionsTeams developing analytics workflows can leverage this project as a foundation for their own systems, building on the capabilities demonstrated by Microsoft Research Data Formulator, similar to advancements seen in small language model optimization.

Democratized Data AnalysisOutcome

accessible to teams without deep technical skills

From the article 2 mentionsThese agents operate within the full analysis workspace, leveraging connected data, prior charts, and user objectives to reason and act.

Contents(4)

Microsoft Research has launched Data Formulator 0.7, an open-source AI-powered system designed to tackle the complexities of enterprise data analytics. This new release addresses the fragmentation of data across various storage systems and tools, a common hurdle for businesses relying on AI for insights.

StartupHub data

Companies working on this

Profiles of the companies named in this story, with funding and a one-liner from our database.

Microsoft

A global technology leader providing software, cloud services, AI, and devices for individuals and businesses.

Microsoft Research

Microsoft's fundamental research division, driving innovation across AI, computing, and more.

The system combines robust data connectivity, intelligent agent-guided exploration, and iterative visualization refinement within a shared workspace. This approach aims to democratize data analysis, making it accessible to teams without requiring deep SQL or programming knowledge.

Connecting Fragmented Data

A key feature, Data Connectors, offers governed and reusable connections to diverse data sources including databases, warehouses, BI systems, object stores, and local files. This significantly reduces the integration burden on platform teams, allowing users to access centrally managed data rather than relying on manual uploads.

Agent-Assisted Analysis

Context-aware AI agents form the core of Data Formulator. These agents operate within the full analysis workspace, leveraging connected data, prior charts, and user objectives to reason and act. They can inspect data, write and run code, generate visualizations, and explain results with intermediate steps, asking clarifying questions when requests are ambiguous.

This agent capability enables complex workflows like aligning analyses with user goals, transforming data, suggesting follow-up questions, and generating verifiable code for reproducible results. It's a significant step beyond simple chatbot interactions, offering persistent access to enterprise data and workflow history.

Data Formulator features a multimodal interface designed for open-ended analytical workflows. The 'Data Thread' provides a structured chat log of questions, findings, and charts, ensuring navigability and context retention over long sessions. Users can revisit, branch, and compare analyses side-by-side.

An interactive canvas complements the Data Thread, allowing direct editing of visualizations. Users can refine charts by adjusting settings, redesigning them, or describing changes in natural language for the agent to implement. This iterative process, detailed in the announcement, empowers teams to move from exploration to communication seamlessly. Teams developing analytics workflows can leverage this project as a foundation for their own systems, building on the capabilities demonstrated by Microsoft Research Data Formulator, similar to advancements seen in small language model optimization.

© 2026 StartupHub.ai. All rights reserved. You may not republish this article in full without a license. Search engines and AI research tools may crawl and summarize for reference. Bulk reproduction or model training requires a license. See our terms.

#Data Formulator 0.7 #Microsoft Research #AI #Data Analytics #Enterprise Software #Open Source #Machine Learning

Written by