AI Research
Preferred on Google
Google News

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.

4 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(3)

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.

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.

Iterative Exploration and Refinement

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. Do not enter, scrape, copy, reproduce, or republish this article in whole or in part. Use as input to AI training, fine-tuning, retrieval-augmented generation, or any machine-learning system is prohibited without written license. Substantially-similar derivative works will be pursued to the fullest extent of applicable copyright, database, and computer-misuse laws. See our terms.
#Data Formulator 0.7#Microsoft Research#AI#Data Analytics#Enterprise Software#Open Source#Machine Learning