# 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._
**Published:** 2026-05-28
**Source:** https://www.startuphub.ai/ai-news/ai-research/2026/microsoft-s-data-formulator-0-7-streamlines-enterprise-ai-analytics
---
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.

Fragmented Enterprise DataDriver

data scattered across databases, warehouses, BI systems, object stores, and filesFrom 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 RefinementContextinteractive visualization for continuous improvementFrom the article 2 mentionsThe system combines robust data connectivity, intelligent agent-guided exploration, and iterative visualization refinement within a shared workspace.solvesData Formulator 0.7CoreMicrosoft Research's open-source AI-powered analytics systemFrom the article 9+ mentionsContext-aware AI agents form the core of Data Formulator.featuresData ConnectorsCoreFrom 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 AnalysisCorecontext-aware AI agents guide exploration and insightsFrom the article 2 mentionsThis approach aims to democratize data analysis, making it accessible to teams without requiring deep SQL or programming knowledge.enablesStreamlined AI AnalyticsEffectsimplifies complex workflows for enterprise dataFrom 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.leads toDemocratized Data AnalysisOutcomeaccessible to teams without deep technical skillsFrom the article 2 mentionsThese agents operate within the full analysis workspace, leveraging connected data, prior charts, and user objectives to reason and act.
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](https://www.microsoft.com/en-us/research/blog/data-formulator-0-7-ai-powered-data-analytics-for-enterprise-data/), 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](/ai-news/ai-research/2026/small-language-model-optimization-cracks-complex-business-math).
---
Original analysis from [startuphub.ai](https://www.startuphub.ai), the #1 AI startup directory.