Knowledge Base
Foundational ARF articles organized by layer. All content is product‑agnostic and designed for consistent AI‑ready modeling.
Semantic Integrity
View layerWhy Multiple Measures for the Same Metric Break AI Answers
Multiple measures for the same metric create conflicting answers and undermine trust.
Canonical Metrics: One Definition, Many Views
Canonical metrics standardize meaning while allowing flexible reporting views.
Semantic Drift: How Definitions Quietly Change Over Time
Semantic drift happens when metric meaning changes without clear communication.
Naming Measures So Humans and AI Agree
Consistent naming helps AI select the right measure and reduces ambiguity.
Measure Singularity: Reducing Metric Sprawl Without Losing Flexibility
Measure singularity keeps one true metric while allowing controlled variants.
Units, Currency, and Time: The Hidden Semantics That Cause Bad Answers
Units, currency, and time basis are often implicit, but AI needs them explicit.
Default Aggregation: When SUM Is the Wrong Assumption
Default aggregations can distort results when a sum is not meaningful.
Business Definitions vs Calculation Logic
A metric is not just a formula; it is a business definition with boundaries.
Dimensional Grain: Preventing Apples-to-Oranges Comparisons
Grain defines the level of detail; without it, AI compares incompatible data.
Measure Branching Done Right: Reuse Without Confusion
Branching keeps complex measures readable and consistent when done carefully.
Calculation Groups Without Chaos
Calculation groups can simplify models, but they need clear rules and naming.
A Lightweight Metric Dictionary That Actually Gets Used
A simple metric dictionary helps teams align without heavy governance overhead.
Context Stability
View layerWhy AI Answers Change When Your Data Didn’t
Inconsistent context, not data changes, often causes fluctuating AI answers.
Filter Context in Plain English
Filter context determines what data a calculation sees; it must be predictable.
Context Volatility: Hidden Interactions Between Slicers and Measures
Volatile context is caused by slicer interactions, hidden filters, and ambiguous paths.
Ambiguous Relationships: The Silent Context Killer
Ambiguous relationships create multiple filter paths, leading to unpredictable answers.
Many-to-Many Relationships and AI: What Can Go Wrong
Many‑to‑many relationships can produce unexpected filter behavior for AI queries.
Inactive Relationships and USERELATIONSHIP: When Intent Gets Lost
Inactive relationships require explicit activation, which AI often misses.
Bidirectional Filtering: Convenience vs Predictability
Bidirectional filters can make models easier to use, but less predictable for AI.
Role-Playing Dimensions: Dates, Regions, and Other Multipliers
Role‑playing dimensions require clear naming and explicit usage to avoid confusion.
Row-Level Security and AI: What You Must Validate
RLS affects AI answers and must be validated with realistic AI queries.
Time Intelligence: Why ‘Last Month’ Is Harder Than It Sounds
Time intelligence depends on clean date tables and clear definitions of time.
Deterministic Slices: Designing Questions AI Can Ask Reliably
Deterministic slices constrain questions so answers stay consistent and explainable.
A Context Test Harness for Power BI Models
A test harness validates that key questions return stable results.
Analytical Explainability
View layerYour Model Can Calculate, But Can It Explain?
Explainability requires more than calculations; it requires drivers and context.
Lineage: Tracing a Number Back to Its Sources
Lineage makes every number auditable by tracing it to sources.
Drivers vs Correlations: Explaining Without Overclaiming
Drivers explain causes; correlations only show association. AI must distinguish them.
Contribution Analysis: Turning Totals Into Reasons
Contribution analysis breaks totals into components that explain change.
Variance Decomposition for Business Users
Variance decomposition explains changes using business‑friendly components.
Cohorts and Segmentation: Explainability at the Right Level
Segmentation and cohort analysis provide context for why metrics move.
Outliers and Null Semantics: When ‘Missing’ Means Something
Outliers and nulls can be meaningful; AI must interpret them correctly.
Narrative-Ready Models: Designing for Text Explanations
Narrative‑ready models provide the context and structure AI needs for clear explanations.
Assumptions and Caveats: Making Answers Trustworthy
Explicit assumptions and caveats keep AI answers honest and reliable.
Explainability Metrics: Consistency, Coverage, and Confidence
Measure explainability to track progress and reliability over time.
From KPI to Story: A Repeatable Explanation Template
A consistent template makes AI explanations easier to generate and trust.
A Practical Explainability Checklist for Power BI
A checklist to ensure AI explanations are reliable and auditable.
AI Readiness & Interoperability
View layerAI-Readable Schemas: What It Means in Practice
AI‑readable schemas have clear names, relationships, and metadata.
Metadata Density: Why Descriptions Matter More Than You Think
Metadata density makes models interpretable by AI and humans.
Semantic Contracts: Setting Expectations for Questions and Answers
Semantic contracts define what questions are valid and how answers should be interpreted.
Grounding: Preventing Confidently Wrong Answers
Grounding anchors AI answers in model facts and metadata.
Retrieval Patterns for BI: Getting the Right Context to the Model
Retrieval patterns define which metadata and filters should be provided to AI.
Prompting vs Modeling: Where to Fix the Problem
Most AI answer issues are model issues, not prompting issues.
Tooling Interfaces: SQL, DAX, and the Translation Layer
Different tools expose different query layers; AI must align with them.
Governance for AI Analytics: Change Control for Semantics
Governance ensures semantic changes are intentional and traceable.
Evaluation: How to Test AI Answers Against Your Model
Evaluation compares AI answers against expected model outputs to detect errors.
Security and Privacy: What Not to Expose
AI access must respect security boundaries and avoid exposing sensitive data.
Interoperability: Aligning Power BI With the Rest of Your Stack
Interoperability ensures consistent semantics across BI, data platforms, and AI tools.
An AI Readiness Scorecard You Can Run Monthly
A simple scorecard tracks progress across metadata, context, and explainability.