Performance Management with Fabric: The Next Frontier of Organizational Intelligence
Description
This session will explore how the principles behind "Performance Management IQ"—an analogy inspired by Microsoft’s new "Work IQ," "Fabric IQ," and "Foundry IQ" products—can be realized using Fabric as the central data platform for AI-ready insights. Finance, operations, and HR data become harmonized in Fabric to enable powerful performance management insights for analytics, data science, and AI.
Key Takeaways
- BDO Recommendation: A defined KPI blueprint needs to blend the
- Data Readiness is Critical to AI Evolution
- your data must be
- Orchestrating human and digital capital through dynamic structures enables seamless
- With a proper data and AI platform configured, you can measure critical KPIs like
- Recommended KPIs for Professional Services
- A good attribution model will ensure that KPI measurement
My Notes
Action Items
- [ ]
Resources & Links
Slides
Rich Lamorena
Principal, Data & AI Practice Leader
BDO USA
Noah Mattern
Data & AI Solution Director
BDO USA
Performance
Management
THE NEXT FRONTIER OF
ORGANIZATIONAL INTELLIGENCE
Unlocking insights with Microsoft
Fabric, Copilot, and Foundry.
Imagine a Future…
Humans and AI agents seamlessly
driving company results with
consistent, measurable criteria
SECTION 1
Introduction to
Frontier Firm Vision
“The Year the Frontier Firm Is Born”
MICROSOFT 2025 WORK TREND INDEX
Reveals the emergence of “Frontier Firms” — organizations that
successfully integrate AI agents into daily workflows
Based on a global study of 31,000 professionals across 31
countries
Frontier Firms are outperforming peers: 71% report thriving,
compared to 37% of other companies
Highlights a four-stage AI adoption journey
Emphasizes the new role of “agentic” leaders who manage AI
agents to drive results
82% of business leaders say 2025 is a make-or-break year to adopt
AI strategically
Offers insights for companies looking to scale, stay agile, and
redefine productivity in the AI era
BDO Recommendation: A defined KPI blueprint needs to blend the
performance management of both humans and AI against established
business targets.
Source: 2025: The Year the Frontier Firm Is Born
SECTION 2
Business Case For
Performance
Management
WHY NOW?
Real and Growing Impact of AI
MARGIN PROTECTION
PRODUCTIVITY & EFFICIENCY
Stay ahead of competitors
Reduce process waste
Be resilient to evolving business
environment
Reduce costs of doing business
Drive new revenue opportunities
EMPLOYEE EXPERIENCE
Reduce risks of tenured staff leaving
Attract new generation of workers
Improve experience and elevate talent
Boost efficiency and cost savings
Better integrations with existing systems
Enhance your human capital
BUSINESS
VALUE
QUALITY & INSIGHTS
Improve accuracy and quality of
information
Get timely insights and 360 views
Improve ability to quickly plan and reforecast
AI Adoption is Rising, Boosting
Productivity and ROI
$3.7x
for every $1 a company invests in a successful
generative AI deployment, the ROI is $3.7x.3
70%
of transformations fail to achieve their desired
results due to change management challenges.2
75%
of knowledge workers
around the world use
generative AI at work.1
- AI at Work Is Here. Now Comes the Hard Part
- Boston Consulting – How to Create a Transformation that lasts.
- IDC’s 2024 AI opportunity study: Top five AI trends to watch - The Official Microsoft Blog
Data Readiness is Critical to AI Evolution
DATA ALIGNS TRUST BETWEEN HUMANS AND AI
Through 2025, 30% of generative AI (GenAI) projects will be abandoned after
proof of concept due to poor data quality, inadequate risk controls, escalating
costs or unclear business value.
AI-ready data means that
your data must be
representative of the use
case, key patterns, errors,
outliers and unexpected
emergence that is needed to
train or run the AI/ML models.
Data readiness for AI is not
something that is build once
and for all – it is a process,
and a practice based on
availability of metadata to
align, qualify, and govern the
data, supported by right
integrations and modern data
platform setup.
Evolving State of AI’s Impact on Organizations
TRANSFORMING TEAMS AND ORG STRUCTURES THROUGH THE DEPLOYMENT OF AI
Increasing Value and Impact
AI transformation begins by empowering individuals and advances through team-based process improvements being
driven by organizational outcomes. The result is a more agile and dynamic workforce and ultimately creating scale.
401 – AI OPERATING MODEL
Orchestrating human and digital capital through dynamic structures enables seamless
processes that drive business outcomes
301 - TEAM AUGMENTATION
Deploys AI capabilities alongside human team members to deliver outcomes
201 – INDIVIDUAL ASSISTANCE
AI works alongside the individual to support simple processes
101 - INDIVIDUAL EMPOWERMENT
Accelerates individual productivity with AI-powered search, summarization, analysis, and content creation
Maturity Timeline
KPI Blueprint: Attribution Process
MEASURING COMPANY PERFORMANCE IMPACTS ATTRIBUTED TO PEOPLE AND TECHNOLOGY
With a proper data and AI platform configured, you can measure critical KPIs like
sales, revenue, and profitability. Take it one step further by attributing those KPIs
to people, organizational initiatives, and technology investments where ROI can
be directly reviewed.
Prerequisite: Business alignment to track, govern, and measure KPIs
Define KPIS
Define the specific hard
and soft KPIs based on
company goals and
availability of data to
measure.
Initiation
Set Goals and Targets
Set targeted goals (by
people, teams,
departments, job
functions, and AI
innovations).
Periodically
Review and Manage
Measure and drive
performance
continuously utilizing
actual KPI results.
Continuously
ATTRIBUTION
With the right level of invested
configuration in your data & AI
platform, measure and
associate/attribute company
KPIs like invoiced revenue and
profitability to the following
corporate investments:
Individual team members
Teams (by organizational
structure like departments
or “virtual” teams of
people)
Sales strategy initiatives
Marketing initiatives
Digital and AI tool
investments
KPI BLUEPRINT
Recommended KPIs for Professional Services
Below is intended to be a starting point and will need to be tailored to your firm:
Top Line Measures
Pipeline
Sales Revenue
Billed Revenue
Invoiced Revenue
YoY Growth
AR Aging
Marketing
Attribution
Bottom Line
Measures
Gross Contribution
EBITDA
Expense Alignment
Forecast Accuracy
Rates and Pricing
Average Rates
Pricing and
Realization
Service Line
Profitability
Utilization
Billable Hours/
Available Hours
Capacity and
Headcount
Seasonal Forecasts
vs. Actuals
Talent Acquisition
Time to Fill
KPI BLUEPRINT
Governed Measurement
of KPI Goals
This dashboard shows comprehensive performance details
for an individual team member, business initiative like
marketing campaign, team performance, or AI initiative.
The right summarizes hard KPI performance expectations
vs. attainment to date.
A good attribution model will ensure that KPI measurement
(like revenue) follow the firm’s established rules. It shows
the role performed during the KPI goal attainment (for
example an individual who leads a sales deal closure vs. an
AI agent that is utilized to support the sale).
This section shows soft KPI attainment (in this example
positive survey feedback), to provide additional context on
the performance.
KPI BLUEPRINT
Detailed Context of KPI
Attainment
Analyze KPI actuals for an individual, team, marketing
campaign, or AI initiative. Color coded indicators show
areas of performance enhancement or attention required.
Analyze details like the individual leader accountable or
other supporting context to identify where to follow up.
Toggle between different views of hard KPIs vs. soft KPIs,
so you get specific lenses on performance context.
Filter or drill into details like employee, team, service line,
client, geographic region, industry, or AI initiative for
further business context and planning.
Guiding Advice
FABRIC: AI READY DATA
AI DEVELOPMENT MINDSET
It’s okay to move quickly and build one-off
Low Code – for rapid delivery and early end
But to build long term intelligence for humans
Pro Code – to fully control what you build and
operational reports
and AI, your enterprise data fabric matters
• Descriptive analytics and semantic models
• Data science and advanced analytics
• Leveraging evolving Microsoft Fabric IQ,
Foundry IQ, and Work IQ
user feedback
customize
SECTION 3
Microsoft Fabric Central Data
Intelligence
Fabric Data
Platform
Native support for
semantic models
Unified, lake-centric
architecture
Platform
Capability
TOOLS &
TECHNOLOGY
Seamless access across domains
(finance, ops, people)
Medallion Architecture
Silver
Bronze
Raw, uncurated source
data from ERP, SPA, HRIS,
ATS, LMS, etc.
Maintains traceability
and auditability for
finance and HR data
Enriched, conformed
data
Standardize formats,
filter data, fix source
errors, remove
duplicates, add lineage
attributes, join data
from multiple systems
for MDM
Gold
Dimensional modeling
and aggregation
Data aligned with
business entities with
human-readable
table/column names
Business rules applied
and views created for
semantic model/
reporting
Semantic Model
Logical description of
analytics domain with
metrics and business
friendly terminology
Unify sources to compute
project margin,
contribution margin,
employee utilization,
bench time analytics etc.
Fabric Architecture
Compute
Scheduling and
Orchestration
Sources
Ingestion
Storage
Presentation
Finance
Lakehouse
Lakehouse
Lakehouse
Silver
Gold
Operations
Warehouse
Bronze
People
Operations
Source Control
Deployment
Governance
Monitoring
Secrets
Fabric Architecture Demo
SECTION 4
Advanced Analytics
and Data Science
RISK ANALYSIS
Data Clustering
Data Extraction
Aggregate metrics by
PM and Consultant
Hours
Revenue
Client volume
Time since hire
Data Preparation
Normalize features
with StandardScaler
function in Python for
clustering
Clustering Analysis
K-Means elbow
analysis and
segmentation into
clusters for PMs and
Consultants
Visualization
t-SNE 2D plot of data
to reveal distinct
clusters, trends, and
outliers
Business Labeling
Assign labels to each
PM and Consultant
cluster, and load data
into Fabric lakehouse
for creating
PM/Consultant risk
matrix
RISK ANALYSIS
Deployment
Checklist
Dev, test, and production workspaces are setup in Fabric to support multiple environments
Entra ID security groups are created by environment to control access to the workspaces and
resources within
The risk analysis clustering model uses data from the gold layer of the medallion architecture
that lives in a Fabric lakehouse
CI/CD pipelines in DevOps are used for deployment of resources within the solution between
environments:
The lakehouse that has the gold layer data and any shortcuts
A series of notebooks that performs clustering of PMs and consultants and then creates a
matrix of those clusters for visualization
The notebooks are setup to process and apply the clustering model to data from the
current year by default to identify revenue leakage risks. They can easily be updated to
analyze data for prior years through a notebook parameter.
The CI/CD pipeline replaces GUIDs for lakehouses (and their workspace) that the
notebooks are attached to based on the environment
The lakehouse that stores the clustered data and matrix for visualization
Semantic model built on top of the processed data combined with other gold layer tables
Risk analysis dashboard in Power BI
A data pipeline that orchestrates the execution of notebooks and refreshes the semantic
model and the schedule it executes on
RISK ANALYSIS
Demo
RISK ANALYSIS
Demo
RISK ANALYSIS
Demo
RISK ANALYSIS
Demo
SECTION 5
Data Agents
DEMO
Fabric Data Agents
Generative AI Trends
93%
61%
Organizations are experimenting
with multiple models1
People are wary about trusting AI systems3
50%
30%
Enterprises using generative AI will
launch agentic AI pilots by 20272
Or fewer generative AI experiments
moved to production4 - 16 Changes to the Way Enterprises Are Building and Buying Generative AI | Andreessen Horowitz
- Autonomous generative AI agents | Deloitte Insights
- Trust in artificial intelligence – 2023 Global study on the shifting public perceptions of AI, KPMG
- GenAI and the future enterprise | Deloitte Insights
Fabric Data Agent Demo
DEMO
Copilot Studio
COMPLETE TECH STACK TO BUILD YOUR GENERATIVE AI SOLUTIONS
Copilot and AI Stack
Copilot Studio
Azure AI Foundry
Data
Visual Studio
+
Azure
Infrastructure
Cloud to Edge
GitHub
Trustworthy AI
Copilot Studio Demo
DEMO
Foundry
Azure AI Foundry
Model Catalog
Copilot Studio
Visual Studio
Azure AI
Foundry SDK
Foundational models
Azure
OpenAI Service
Evaluations
Open-source models
Azure
AI Search
Task models
Azure AI
Content
Safety
Azure AI
Agent Service
Customization
Governance
Industry models
Azure Machine
Learning
Monitoring
Observability
Foundry Demo
The Next AI
Platform Is Here
TO
FROM
Simple POCs
Platform Shift
Single model
Multi-model
Automated Workflows
Continuous improvement
Point-in-time ROI
Innovate with Azure AI Platform
ESSENTIALS FOR GETTING AI READY
Adopt financial best practices
Pricing
Skilling
Migrate and modernize workloads and data collocation
Platform landing zone
Trustworthy AI: security, privacy and transparency
Architectural guidance
Generative AIOps
Data governance
Monitoring and security
Management and optimization
Architectural assessments and remediations
Manage
and
Optimize
Readiness
and
Foundation
Design
and Govern
SECTION 6
Emerging AI Features
In Fabric and Foundry
Emerging Features - Foundry
Move from prototype
to production in
hours, not weeks:
The new Microsoft
Agent Framework and
Hosted Agents let you
build, test, and
deploy multi-agent AI
systems with
enterprise-grade
security—no
Kubernetes or
container headaches.
Orchestrate any
model, anywhere:
Model Router and BYO
Model Gateway let
you mix and match
thousands of models
(including Claude,
GPT, and your own)
with unified
governance and
compliance—no code
changes required.
Ship agents to Teams
and M365 with
one click:
New low-code/nocode tools, templates,
and deployment
channels make it easy
to launch and scale AI
agents for your users.
Build smarter, more
reliable workflows:
Multi-agent
orchestration,
persistent memory,
and deep Microsoft
365 integration enable
robust, context-aware
solutions for complex
enterprise scenarios.
Access the best
models in one place:
Azure is now the only
cloud with both
Anthropic’s Claude
and OpenAI’s GPT
models—choose the
right tool for
every job.
Emerging Features - Fabric
Fabric IQ
Ontology
Anomaly Detection
New semantic foundation
within Microsoft Fabric.
Fabric IQ is not a
replacement for your data
estate; it's a force
multiplier for every
investment you’ve
already made.
Lets you define entity
types, relationships,
properties, and other
constraints to organize
data according to your
business vocabulary.
With a no-code interface,
automatic model
selection, and flexible
alerts, tracking changes
and unexpected events
is easy.
Create Embeddings in
Eventhouse with built-in
Small Language Models
Built-in Small Language Models
(SLMs) in Eventhouse can
generate text embeddings
locally using ai_embeddings
plugin (preview), enabling
semantic search, RAG pipelines,
and high-volume embedding
generation without external
endpoints, callout policies, or
per-request costs.
SECTION 7
Conclusion – Realizing
the Frontier Firm
Evolving State of AI’s Impact on Organizations
TRANSFORMING TEAMS AND ORG STRUCTURES THROUGH THE DEPLOYMENT OF AI
Increasing Value and Impact
AI transformation begins by empowering individuals and advances through team-based process improvements being
driven by organizational outcomes. The result is a more agile and dynamic workforce and ultimately creating scale.
401 – AI OPERATING MODEL
Orchestrating human and digital capital through dynamic structures enables seamless
processes that drive business outcomes
301 - TEAM AUGMENTATION
Deploys AI capabilities alongside human team members to deliver outcomes
201 – INDIVIDUAL ASSISTANCE
AI works alongside the individual to support simple processes
101 - INDIVIDUAL EMPOWERMENT
Accelerates individual productivity with AI-powered search, summarization, analysis, and content creation
Maturity Timeline
Guiding Advice
FABRIC: AI READY DATA
AI DEVELOPMENT MINDSET
It’s okay to move quickly and build one-off
Low Code – for rapid delivery and early end
But to build long term intelligence for humans
Pro Code – to fully control what you build and
operational reports
and AI, your enterprise data fabric matters
• Descriptive analytics and semantic models
• Data science and advanced analytics
• Leveraging evolving Microsoft Fabric IQ,
Foundry IQ, and Work IQ
user feedback
customize
Sound off.
The mic is all yours.
Influence the product roadmap.
Join the Fabric User Panel
Join the SQL User Panel
Share your feedback directly with our
Fabric product group and researchers.
Influence our SQL roadmap and ensure
it meets your real-life needs
https://aka.ms/JoinFabricUserPanel
https://aka.ms/JoinSQLUserPanel
How was
the session?
Complete Session Surveys in
for your chance to WIN
PRIZES!