Greg Beaumont's Data & Analytics Blog
Data, Analytics, AI, Business Intelligence posts and videos
recent posts
- NoDAX (Not Only DAX) query patterns with Fabric Data Agents
- Use M365 Copilot to improve Power BI semantic models, power query, and report speed
- Strategic Data Replication Enhances a Single Source of Truth Architecture for Analytics & AI
- Fabric Data Agent for Semantic Model added to our free Fabric Github Repo
- Snowflake, Fabric and Power BI Integration Options
about
- June 2026
- March 2026
- February 2026
- January 2026
- November 2025
- September 2025
- August 2025
- April 2025
- January 2025
- November 2024
- October 2024
- September 2024
- June 2024
- April 2024
- February 2024
- January 2024
- December 2023
- November 2023
- August 2023
- April 2023
- August 2022
- July 2022
- May 2022
- January 2022
- August 2021
- June 2021
- April 2021
- March 2021
- February 2021
- December 2020
- April 2020
- March 2020
- February 2020
- November 2019
- October 2019
- January 2019
- April 2018
- February 2016
- January 2016
- June 2015
- January 2015
- December 2014
- November 2014
- October 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- April 2013
- March 2013
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- May 2011
- February 2011
- December 2010
- June 2010
Category: Artificial Intelligence
-
What if you could combine decades of historical analysis with live, real-time data in one seamless AI chat experience? Traditionally, analyzing large volumes of past data (Analytics / Business Intelligence) has been a separate architecture, or has at least required separate toolsets, from monitoring what’s happening right now (real-time, IoT, etc). With Fabric Data Agents,…
-
Slow and inefficient Power BI reports are a widespread cause of low customer satisfaction, bloated costs, wasted compute capacity, and increased total cost of ownership. Fixing these issues often requires a significant time investment and a high level of domain expertise in business intelligence data modeling, Power Query ETL design, and DAX runtime expression optimization.…
-
When working in the field of data and analytics, have you ever heard concerns about maintaining a single source of truth? How about strategic data replication causing many sources of truth? In this video I attempt to explain the history of these misconceptions and lay out a strategy for a data ecosystem that is highly…
-
For the past two years I’ve been working with my colleague Inder Rana to build out a GitHub repo that can be leveraged by Fabric users for training and testing purposes. In the most recent update we have added a new Fabric Data Agent that works with the semantic model using Direct Lake mode. The…
-

We are currently experiencing a generational surge in AI use cases and transformation. But will AI be able to connect directly to your raw data, perform all the necessary transformations, apply business-friendly names to fields, and add accurate logic to solutions? Does data engineering and architecture still matter? The video embedded at the bottom of…
-

For many years, SQL Saturday conferences around the world have provided fantastic educational opportunities for professionals specializing in Microsoft tools such as Fabric, Power BI, and SQL Server. SQL Saturday Minnesota is coming up on September 27, 2025 and I was fortunately selected to be a presenter. I’ll be presenting on best practices for Fabric…
-
I’ve been sharing insights on data technologies through blogs, videos, and podcasts for over 15 years. Over time, my content has been published across a variety of platforms, some of which have since become outdated or difficult to access. To make things simpler, I’ve created this new blog as a centralized hub where you can…
-
Query Fabric Data Agents from Azure AI Foundry for Agentic Solutions One of the early criticisms of Large Language Models (LLMs) was an inability to do good math when answering questions. Newer LLMs can do great reasoning and mathematical tasks, but at a high compute cost and the query times can be slow. Microsoft Fabric…
-
Interested in trying out the new Microsoft Fabric AI Skill? Fabric AI Skill is a new Generative AI capability in preview for Fabric that functions as the basis for a SaaS AI Agent in Fabric using natural language to query your data. An AI Skill module has been added to the GitHub repo created along…
-
What if students and lifelong learners could have an AI chat bot simulating a historical figure for educational conversations? This video is a synthetic podcast using Microsoft Azure OpenAI and Azure AI text to speech to create an AI simulation of Benjamin Franklin in the form of a podcast. With Azure AI, tools exists for…