Explores semantic layers in data platforms, their role in ensuring metric trustworthiness, and their critical importance for AI agent accuracy.
Explores agentic analytics, an AI-driven approach that replaces passive BI dashboards with autonomous agents for goal-directed data investigation.
Explains what a semantic layer is, its components, and how it provides consistent business definitions for data queries and AI agents.
A step-by-step guide to building a robust semantic layer for consistent data metrics, covering architecture, stakeholder alignment, and implementation.
Explains how a semantic layer enforces data governance by embedding policies directly into the query path, ensuring consistent metrics and access control.
Seven critical mistakes that can derail semantic layer projects in data engineering, with practical advice on how to avoid them.
A software architect's humorous account of a client derailing a professional Power BI dashboard project with a chaotic, self-built data model.
A developer saves their company $4,500/month by replacing an expensive Oracle tool with a free R script for data analysis and visualization.
Provides slides and SQL scripts from a 'Indexing for Dummies' session, focusing on SQL Server database performance.
Explains the fundamentals of data modeling in Microsoft Power BI, covering tables, relationships, and calculated columns/measures for business intelligence.
Presentation slides for a Power BI tips and tricks talk at DataBISummit, available for download.
A comprehensive guide to diagnosing and fixing OBIEE (Oracle Business Intelligence) performance issues, covering testing, caching, and optimization.
Introduction to regression testing in OBIEE to ensure system changes don't break existing functionality.
Introduction to a series on analyzing and improving performance in Oracle Business Intelligence Enterprise Edition (OBIEE).
A guide to defining effective performance tests for Oracle Business Intelligence Enterprise Edition (OBIEE), focusing on repeatability, accuracy, and ease of analysis.
A summary and FAQ on a methodical approach to diagnosing and optimizing performance in OBIEE (Oracle Business Intelligence Enterprise Edition).
A reflection on moving from SQL queries to data modeling using SQL Server 2012's BI Semantic Model for efficient reporting.
Reflection on moving from SQL queries to data modeling using SQL Server 2012 BI Semantic Model for better reporting.
A developer shares their motivation for starting a tech blog to explain programming and data topics from the ground up.
A tech blogger shares their motivation for starting a blog to explain programming and data topics from the ground up.
