The Data Massagist The Data Massagist by Pablo Junco

Filter by

Last 12 Articles from Pablo Junco


Agent-of-Agents: Why AI Future Is Recursive

Agent-of-Agents: Why AI Future Is Recursive

This edition of The Data Massagist explores the rise of agent ecosystems as the next evolution of enterprise AI. Instead of isolated copilots or chatbots, organizations are moving toward Multi-Agent Systems (MAS) where specialized AI agents collaborate, delegate tasks, and consume the outputs of other agents to execute end-to-end workflows. The article explains why this shift is happening now and how enterprises are adopting coordinated intelligence patterns such as triage (intake and prioritization), routing (dynamic task delegation), and orchestration (workflow execution and control). It highlights how industries like telecom, healthcare, manufacturing, and energy are already applying these models, and why the future of AI will depend on building scalable, governed ecosystems of interacting agents rather than standalone tools.

Read it on LinkedIn

Data Agents Databricks MS Fabric MS Foundry Newsletter

Understanding AI Costs in Microsoft Fabric & Monitoring Usage

Understanding AI Costs in Microsoft Fabric & Monitoring Usage

Microsoft Fabric uses a unified, token-based AI billing model where all AI features — including Copilot for Power BI, Copilots in Fabric, Data Agents, and Operational Agents — consume Capacity Units (CUs) from the organization’s Fabric capacity. Instead of separate AI licenses or per-prompt fees, costs are calculated based on input and output tokens, with output tokens typically driving higher consumption. The article explains how AI workloads are monitored through the Fabric Capacity Metrics App, Admin Portal, and Activity Logs, giving organizations visibility into token usage, CU consumption, and workload spikes. It also clarifies licensing considerations for Power BI Copilot and highlights the difference between Data Agents (AI that answers) and Operational Agents (AI that acts autonomously). Ultimately, the model provides predictable, transparent, and centralized AI cost management within Microsoft Fabric.

Read it Now

Data Agents MS Fabric

Your Data Estate Is Slowing Down AI — Fix It!

Your Data Estate Is Slowing Down AI — Fix It!

This edition of The Data Massagist explores two critical forces shaping enterprise AI readiness: governance and data modernization. First, it clarifies how Microsoft Fabric and Microsoft Purview complement each other, highlighting that Fabric includes strong built-in governance capabilities such as OneLake cataloging, lineage, security, and policy enforcement—making it sufficient for many scenarios without requiring Purview. However, as organizations scale across hybrid and multi-cloud environments, Purview becomes essential to extend governance across the entire data estate. Second, it addresses the growing reality that legacy data platforms are becoming a bottleneck for AI adoption. With most AI initiatives dependent on AI-ready data, modernizing databases is now a strategic requirement rather than an IT upgrade. The edition outlines how modern cloud databases support vector search, semantic querying, and AI-native capabilities, and why Azure provides a comprehensive foundation for this transformation. The core message: AI success depends less on models and more on modern, well-governed, and AI-ready data foundations.

Read it Now

MS Fabric MS Purview Newsletter

Scaling Databases Is Easy. Architecture at 100TB Is Not.

Scaling Databases Is Easy. Architecture at 100TB Is Not.

Modern data architecture is shifting from isolated systems to converging platforms. While every cloud provider can scale beyond 100TB, the real differentiation is how organizations achieve that scale—without redesigning applications, adding complexity, or creating technical debt. Enterprise architectures typically fall into three models: operational scale (single-database abstraction like Azure SQL Hyperscale), distributed scale (Cosmos DB-style partitioned systems), and analytics/AI platforms (Microsoft Fabric, ADLS, Synapse), which are not transactional databases but data platforms for intelligence at petabyte scale. Microsoft is increasingly unifying these layers through Fabric’s emerging database capabilities, while the industry is converging in parallel, with players like Databricks extending into operational workloads via Lakebase. The core shift: boundaries between operational, distributed, and analytics systems are disappearing, and architecture—not scale alone—now defines business success.

Read it Now

MS Fabric MS SQL

Governing AI Responsibly in Modern Analytics Platforms

Governing AI Responsibly in Modern Analytics Platforms

AI adoption is accelerating—projected to reach 1.3B agents by 2028—making siloed approaches ineffective. Chief Data Officers (CDOs) are key to enabling responsible, scalable AI built on modern platforms like Microsoft Fabric, Snowflake, and Databricks, which now serve as both data and AI foundations. While Snowflake and Databricks offer flexibility, they require strong governance; Fabric emphasizes built-in control and compliance. As AI agents grow more autonomous, CDOs must expand from data governance to full AI governance, including models, prompts, and actions. Microsoft Purview emerges as a unified, cross-platform governance layer, enabling visibility, control, and risk management. Ultimately, responsible AI depends on architecture and governance by design—not just principles.

Read it Now

Data Governance Databricks MS Fabric MS Purview Newsletter Responsable AI Snowflake

PBI Dataflows Gen1 Is Over. What Comes Next?

PBI Dataflows Gen1 Is Over. What Comes Next?

Power BI Dataflows Gen1 is entering a legacy, maintenance-only phase, signaling a broader architectural shift rather than a simple product update. Gen1 was designed for a BI‑centric, self‑service era, optimized for report preparation with limited reuse, governance, and scalability. As data platforms evolve to support multiple personas, AI, and shared data assets, these design constraints become structural limitations. Microsoft Fabric and Dataflows Gen2 introduce a different model: centralized transformations, OneLake‑based storage, and reuse across analytics, engineering, and AI workloads. Gen2 is not a drop‑in replacement but part of a unified, Fabric‑native architecture. Migration should therefore be treated as a strategic modernization effort, not a lift‑and‑shift exercise, to improve reuse, governance, performance, and AI readiness.

Read it Now

Migration MS Fabric Power BI

Building a Fabric Data Agent with On‑Premises SQL Server Data

Building a Fabric Data Agent with On‑Premises SQL Server Data

Organizations can keep on-premises SQL Server systems while enabling modern AI by using Microsoft Fabric. Data is continuously mirrored into OneLake, avoiding complex ETL and enabling real-time analytics without disrupting operations. A key requirement is building a strong semantic layer that defines business meaning, ensuring accurate, governed AI insights. Fabric Data Agents then provide natural-language access to this curated data via tools like Copilot. This architecture separates operational and analytical workloads, improves scalability, and enforces governance. The result: faster insights, reduced maintenance, and trusted AI-driven analytics—while preserving existing systems and modernizing incrementally.

Read it Now

Data Agents MS Fabric MS SQL

From SAP Modernization to AI‑Frontier Firms

From SAP Modernization to AI‑Frontier Firms

The Microsoft–SAP alliance goes beyond infrastructure modernization — it enables full business reinvention. By combining SAP’s mission-critical systems with Microsoft Azure and Microsoft Fabric, organizations can securely migrate workloads while unlocking the value of their data. Microsoft Fabric provides a unified data platform that connects SAP and non-SAP data into a single, governed foundation (OneLake), enabling real-time analytics, AI, and intelligent automation. This allows enterprises to move beyond “lift-and-shift” toward a three-step journey: migrate, unify, and transform with AI. The real value comes from activating AI on top of unified data — empowering human-agent collaboration, faster decision-making, and scalable innovation. Organizations that embrace this approach evolve into AI-Frontier Firms: data-driven, AI-powered enterprises that continuously reinvent how they operate, compete, and deliver value.

Read it Now

MS Fabric SAP

100+ Articles, One Hub and, FabCon Recap

100+ Articles, One Hub and, FabCon Recap

Edition #8 of The Data Massagist marks two milestones: the launch of thedatamassagist.com and key takeaways from FabCon / SQLCon Atlanta 2026. The new website centralizes 100+ articles from LinkedIn, Forbes, and other platforms into a curated, category-driven experience with AI-generated summaries—built as a hands-on coding project with the author’s 11-year-old son. FabCon/SQLCon highlighted a strategic shift toward convergence: Microsoft Fabric as the data and AI control plane, Azure Databricks as a complementary execution engine, Purview as the governance backbone, and SQL as a modern, AI-ready foundation. The core message: fewer platforms, stronger integration, and architecture focused on outcomes, trust, and intelligence.

Read it Now

Databricks MS Fabric MS SQL Newsletter

Designing AI‑Ready Analytics with Microsoft Fabric Data Agents

Designing AI‑Ready Analytics with Microsoft Fabric Data Agents

As organizations adopt AI-driven analytics, exposing trusted data to Copilot and Fabric Data Agents requires strong architecture—not just enablement. Microsoft Fabric Data Agents add conversational analytics over governed data, but report-embedded semantic models create fragile AI behavior, unclear cost ownership, and governance risk—especially as customers migrate from Power BI Premium to Fabric capacities. Through two Contoso case studies, the article shows why extracting reusable, standalone semantic models is essential for AI readiness. By combining governed semantic models with Fabric Mirroring for Oracle, organizations achieve predictable AI costs, stable and explainable AI responses, centralized security (RLS/OLS), and scalable foundations for Data Agents and future Copilot experiences. The key takeaway: AI succeeds when semantics are treated as first-class data products.

Read it Now

Data Agents MS Fabric Power BI

Planning in Fabric IQ, why it matters now

Planning in Fabric IQ, why it matters now

Fabric IQ brings enterprise planning and forecasting directly into the Fabric platform, eliminating the traditional separation between analytics and planning tools. Budgets, forecasts, targets, and scenarios now sit on top of governed Fabric data, shared semantic models, and OneLake, using open formats like Delta and Iceberg. This is especially transformative for agentic AI: by unifying actuals, plans, and scenarios in a single semantic layer, AI can reason about intent and future outcomes, not just historical data. The result is a move from passive reporting to AI‑driven decision intelligence.

Read it Now

MS Fabric

The Economics of Modern Data Platforms

The Economics of Modern Data Platforms

This is Edition #7 of the newsletter, focused on how pricing really works in modern data platforms like Microsoft Fabric and Azure Databricks. It explains how compute consumption (CUs vs DBUs) is the main cost driver and why architecture—not pricing tables—ultimately determines spend. The article explores the impact of storage, data movement, and query behavior on total cost, highlighting hidden inefficiencies. It also compares both platforms’ approaches to scalability and performance. Finally, it provides practical strategies for cost optimization through better design, observability, and FinOps discipline.

Read it Now

Databricks MS Fabric Newsletter

Article summary by M365 Copilot


Let’s talk!
Let's have cafecito together.

If you’re a Chief Data Officer (CDO), a data leader, or simply someone who believes in the power of preparing data for AI—you’re already a Data Massagist.

Whether you have an idea, a challenge, or just want a fresh perspective, let’s connect. I’m always open to collaborating, learning, and helping others move forward.

You can find me on LinkedIn (feel free to connect and send me a message), or book time with me directly for a virtual coffee (or "cafecito").