Business Intelligence

Business Intelligence What Are DAX Variables? DAX Variables — introduced through the VAR and RETURN keywords — allow intermediate values to be stored and reused within a single… Technical Business Intelligence What Is dbt (Data Build Tool)? dbt (data build tool) is an open-source SQL-based transformation framework that enables data analysts and engineers to write, test, version-control, and document… Technical Business Intelligence What Is a Degenerate Dimension? A degenerate dimension is a dimension attribute that lives in the fact table itself rather than in a separate dimension table —… Technical Business Intelligence What Is Drill-Through vs Drill-Down in BI? Drill-down and drill-through are two distinct navigation paradigms in BI reports — drill-down descends through a hierarchy within the same visual (from… Technical Business Intelligence What Is Google Looker Studio? Google Looker Studio (formerly Data Studio) is Google's free, cloud-based data visualisation and reporting tool that connects to Google products (Sheets, BigQuery,… Technical Business Intelligence What Is Grain (Data Warehouse)? Grain is the definition of what a single row in a fact table represents — the most atomic level of detail stored… Technical Business Intelligence What Is a Junk Dimension? A junk dimension is a data warehouse design technique that consolidates multiple low-cardinality flag and indicator columns from a fact table —… Technical Business Intelligence What Is Kimball vs Inmon Methodology? Kimball and Inmon are the two foundational data warehouse design methodologies — Kimball's dimensional modelling approach builds business-process-specific star schemas consumed directly… Technical Business Intelligence What Is KPI Design in BI? KPI design in BI is the structured process of defining, calculating, and presenting Key Performance Indicators in a business intelligence platform —… Technical Business Intelligence What Is Medallion Architecture? Medallion architecture (Bronze-Silver-Gold) is a data lake design pattern that organises data into three quality layers — raw source data (Bronze), cleansed… Technical Business Intelligence What Is Microsoft Fabric? Microsoft Fabric is Microsoft's unified analytics platform — announced in 2023 and generally available — that integrates data engineering, data warehousing, real-time… Technical Business Intelligence What Is OLAP vs OLTP? OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) are two fundamentally different database design paradigms — OLTP optimised for high-volume transactional… Technical Business Intelligence What Is Oracle Analytics Cloud (OAC)? Oracle Analytics Cloud (OAC) is Oracle's cloud-native business intelligence and analytics platform — providing self-service dashboards, augmented analytics, data visualisation, and enterprise… Technical Business Intelligence What Are Oracle Analytics Cloud Subject Areas? Subject areas in Oracle Analytics Cloud (OAC) are the governed presentation layer of the semantic model — named collections of dimension and… Technical Business Intelligence What Is Oracle BI Publisher? Oracle BI Publisher (BIP) is Oracle's enterprise reporting tool for generating pixel-perfect, formatted document outputs — financial statements, invoices, regulatory filings, and… Technical