Slides from a DataSaturday session on building a €100 data warehouse using Azure data platform.
Slides for Techorama and DataGrillen 2026 sessions on Microsoft Fabric and Azure Data Platform are shared on GitHub.
Guide on connecting Amazon Redshift to Dremio Cloud for federated queries, AI analytics, and cost optimization.
Guide to federating Azure Synapse Analytics with Dremio Cloud for multi-cloud analytics, query acceleration, and unified governance without data movement.
Explains why AI data analytics fail without a semantic layer to define business metrics and ensure accurate, secure queries.
Announcing two free online tech sessions: building a low-cost data warehouse with Azure and a beginner's guide to database indexing.
An introductory guide to data engineering, explaining its role, key concepts, and how it differs from data science in the modern data ecosystem.
Explains how Apache Iceberg brings ACID transaction guarantees to data lakes, enabling reliable data operations on open storage.
Explains the evolution from ETL to ELT in data engineering, clarifying the role of modern tools like dbt in the transformation process.
A curated list of essential resources for data engineering, including articles, newsletters, podcasts, and tools.
A guide explaining key data engineering terms like data warehouses, data lakes, data mesh, and data pipelines, with definitions and comparisons.
Explains Azure SQL Data Warehouse's Result Set Caching feature, its benefits for data warehousing, and how to enable it.
Explains the concept of a dimensional model in data, breaking down 'model' and 'dimension' to show how data is represented for analysis.
Explains dimensional models in data, breaking down the concepts of measurements, descriptions, and how models represent data for analysis.
RSiteCatalyst 1.4.10 adds QueueDatawarehouse, new Get* methods, and bug fixes for the Adobe Analytics R package.
A technical guide on loading detailed AWS billing data into a SQL Server data warehouse for advanced cost analysis.
Explores the difference between 'tuning' and 'optimising' OBIEE performance, emphasizing proper diagnosis and redesign over quick fixes.
Analysis of HP's marketing claims against Oracle Exadata, focusing on technical FUD and balanced system design for data warehousing.
SQL queries to analyze and identify performance bottlenecks in Oracle Data Integrator (ODI) batch jobs with many tasks.
Oracle's performance recommendations for OBIA 7.9.6, focusing on ETL improvements and hardware sizing.
