Seven critical mistakes that can derail semantic layer projects in data engineering, with practical advice on how to avoid them.
Explains how a semantic layer enforces data governance by embedding policies directly into the query path, ensuring consistent metrics and access control.
A step-by-step guide to building a robust semantic layer for consistent data metrics, covering architecture, stakeholder alignment, and implementation.
Explains what a semantic layer is, its components, and how it provides consistent business definitions for data queries and AI agents.
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).
Oracle's Product Assurance team launches a new technical blog focused on OBIEE configuration, tuning, and detailed implementation guidance.
A presentation on performance testing methodologies and best practices for Oracle Business Intelligence Enterprise Edition (OBIEE).
A developer preparing for their first tech conference presentation on OBIEE performance testing seeks advice from seasoned speakers.
Oracle's performance recommendations for OBIA 7.9.6, focusing on ETL improvements and hardware sizing.
Discusses the state of the OBIEE (Oracle Business Intelligence) community forum, moderation ideas, and hopes for the upcoming OBIEE 11g release.
A technical guide on configuring multiple Oracle BI repositories (RPDs) on a single server instance, covering setup for both Unix and Windows environments.
