Microsoft's Data Formulator 0.7 connects fragmented enterprise data with AI agents
Open-source tool eliminates data integration headaches for analysts with context-aware AI agents.
Microsoft has released Data Formulator 0.7, an open-source AI-powered data analytics system designed to unify fragmented enterprise data workflows. The tool addresses common challenges like establishing governed connections, managing permissions, and building data pipelines across multiple systems. A key feature is Data Connectors, which provide persistent, reusable connections to databases, warehouses, BI systems, object stores, and local files, reducing integration work for platform teams and eliminating repetitive manual uploads.
Context-aware AI agents form the core of the system, operating within the full analysis workspace. They have access to connected data sources, loaded tables, prior charts, and user objectives. Agents can inspect data, write and run code in isolated environments, generate chart specifications, and explain results with intermediate steps. The interactive workspace includes a Data Thread that records all questions, findings, and charts, enabling users to revisit earlier steps, branch into alternative analyses, and compare them side by side. This combination makes sophisticated data analysis accessible to domain experts without coding expertise.
- Data Connectors support governed, reusable connections across databases, warehouses, BI systems, object stores, and local files.
- Context-aware agents inspect data, write and run code, generate visualizations, and explain results with intermediate steps.
- Interactive workspace with Data Thread records all analysis steps, allowing branching and comparison without losing context.
Why It Matters
Empowers non-technical analysts to perform complex data analysis without coding or SQL expertise.