Business Intelligence

Business Intelligence What Is DAX? DAX (Data Analysis Expressions) is the formula language used in Power BI, Analysis Services Tabular and Power Pivot to define measures, calculated… Technical Business Intelligence What Is a Dimension Table? A dimension table stores the descriptive attributes, such as account, entity, cost centre, product and date, used to filter, group and label… Technical Business Intelligence What Is Direct Query vs Import Mode? Direct query vs import mode is the Power BI storage choice between Import, which loads data into the in-memory engine for fast,… Technical Business Intelligence What Is ELT (Extract, Load, Transform)? ELT (extract, load, transform) is the data integration pattern that loads raw source data into a target analytical platform first and transforms… Technical Business Intelligence What Is Embedded Analytics? Embedded analytics is the integration of BI reports, charts and KPIs directly into operational applications such as ERP screens, portals and workflow… Business Business Intelligence What Is an Executive Dashboard? An executive dashboard is a concise BI view for senior leaders that presents the few financial and operational KPIs that matter most,… Business Business Intelligence What Is a Fact Table? A fact table is the central table of a dimensional model that stores numeric measures of a business process at a defined… Technical Business Intelligence What Are Finance BI Use Cases? Finance BI use cases are the specific analytical questions and decisions a BI investment must support, such as budget versus actual variance… Business Business Intelligence What Is Incremental Refresh? Incremental refresh is the Power BI feature that partitions a large table by date and refreshes only recent or changed partitions instead… Technical Business Intelligence What Is Looker? Looker is Google Cloud's enterprise BI platform built around LookML, a version-controlled, code-based semantic modelling language that defines metrics and business logic… Business Business Intelligence What Is Master Data Management (MDM)? Master data management (MDM) is the discipline and supporting technology for creating and maintaining one governed, authoritative version of core business entities… Business Business Intelligence What Is a Measure? A measure is a numeric calculation in a BI model, such as revenue, margin or headcount, that is evaluated at query time… Technical Business Intelligence What Is an Operational Dashboard? An operational dashboard is a near-real-time BI view that monitors the daily or intraday status of operational processes, such as invoice queues,… Business Business Intelligence What Is a Paginated Report? A paginated report is a BI output with precise, print-ready layout that flows across defined pages with consistent headers, footers and column… Business Business Intelligence What Is Power BI? Power BI is Microsoft's business intelligence platform for connecting, modelling, visualising and sharing data, comprising Power BI Desktop, the cloud Power BI… Business