Glossary

0-9

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

DATE_ADD Function

CAST AS TIMESTAMP

CURRENT_DATE Function

CAST AS FLOAT64

CAST AS DATETIME

Data Modeling for Business Reporting

Server-Side Tracking

PARSE_BIGNUMERIC

Data Quality Metrics

CAST AS INTERVAL

Data Quality Issues

BYTE_LENGTH Function

Data Standardization

Healthcare Analytics

Custom Query Connection

TIME_DIFF Function

Session Merging

Supply Chain Optimization

Modeled Conversion

TIMESTAMP_DIFF Function

DATE_FROM_UNIX_DATE

CASE in ARRAY_LENGTH

FORMAT_DATETIME

DATE_DIFF Function

FORMAT_TIMESTAMP

Facebook Ads Access Token

Looker Studio Dashboard

Predictive Data Modeling

Google Analytics Debugger

FORMAT_DATE Function

CHAR_LENGTH Function

DATE_TRUNC Function

Event Parameters in GA4

NORMALIZE_AND_CASEFOLD

BigQuery Console

GENERATE_DATE_ARRAY

PARSE_TIMESTAMP

RFM Segmentation

Cross-Device User Profiles

COALESCE in ARRAY

GA4 BigQuery Export

DATE_SUB Function

Real-Time Analytics

Custom Events in GA4

Data Quality Framework

Data Quality Monitoring

SAFE.PARSE_DATE

Data Modeling in Retail

CRM Data Insights

ARRAY_TO_STRING

UNIX_DATE Function

PARSE_DATE Function

LAST_DAY Function

CAST AS NUMERIC

Data Modeling in Healthcare

Analytics-Ready Data

GENERATE_TIMESTAMP_ARRAY

Self-Service Analytics Enablement

ARRAY Type Consistency

BigQuery Performance Optimization

BigQuery Studio

CAST AS BIGNUMERIC

Cost Data Blending

Business-Ready Data

Naming Conventions in Analytics

SELECT AS STRUCT

NORMALIZE Function

REGEXP_EXTRACT_ALL

REGEXP_INSTR Function

STRPOS Function

CONTAINS_SUBSTR Function

REVERSE Function

INITCAP Function

REPEAT Function

Scalability in Data Modeling

Data Redundancy

Query Performance

Query Complexity

Grain (in Fact Table)

Slowly Changing Dimensions

Outrigger Dimension

Swappable Dimension

Shrunken Dimension

Fact Constellation Schema

Operational Data Store (ODS)

Data Mart Architecture

Data Vault Schema

Data Source Schema

Subject-Oriented Design

Hybrid Data Mart

Independent Data Mart

Dependent Data Mart

Invalid Geometry

ML.RECOMMENDATIONS

CTE Query Optimization Techniques

Recursive Iteration Limit

Step-by-Step CTE Debugging

CTE vs Temporary Table

Common Table Expression (CTE)

ACID Compliance

OLAP in Data Modeling

Multi-CTE Query

Data Modeling Best Practices

Logical to Physical Model Transformation

Data Mart (in OWOX Reports)

Data Modeling Stages

REGEXP_REPLACE Function

Static Schema in Views

Read-Only Views

Feature Preprocessing

Clustering in Views

Jensen-Shannon Divergence

Partitioned Views

Qualified Table Reference

Wasserstein Distance

ML.TFDV_VALIDATE

ML.TFDV_DESCRIBE

ML.VALIDATE_DATA_DRIFT

Entity-Relationship Modeling (ERM)

Data Model Types

Open Source ETL Tools

Attribute Hierarchy

Enterprise ETL Tools

Dimension Table

Data Modeling Techniques

Data Modeling Process

Cloud ETL Tools

Pre-Calculated Reporting Table

BigQuery Data Source

Partitioned Tables in BigQuery

DROP MATERIALIZED VIEW (BigQuery)

ALTER MATERIALIZED VIEW (BigQuery)

CREATE MATERIALIZED VIEW (BigQuery)

SQL Query Editor in BigQuery

Abstraction (in Data Modeling)

Polymorphism (in Data Modeling)

Encapsulation (in Data Modeling)

Class (in Data Modeling)

Method (in Data Modeling)

Object Query Language (OQL)

Object-Oriented Database Management System (OODBMS)

Object-Oriented Data Model (OODM)

Time Travel in Data Lakehouse

GA4 Export Data in BigQuery

Data Modeling Mistakes

CREATE MODEL (BigQuery ML)

BigQuery Connector

Application-Aware Modeling

Self Service Analytics

Self Service BI Tools

Qualitative Research

Sampling Techniques

Role-Based Access Control (RBAC)

Data Security Cost Considerations

Data Security Governance

Data Security Standards

Data Privacy Governance

Data Privacy for Snowflake

Data Privacy for BigQuery

Data Privacy for dbt

Data Anomaly Detection

Data Analysis Tools

Business Intelligence Dashboards

AI-Powered Data Modeling

Warehousing Solutions

Data Exploration

Data Driven Decision Making

Data Anonymization

Stored Procedure

Visual Representation (in Data Modeling)

View Management

Version Control for Databases

T-SQL (Transact-SQL)

System Stored Procedure

Stakeholder Validation (in Modeling)

Snowflake Schema

Semi-Structured Data Model

Schema Visualization

Schema Reporting

Schema Comparison

Reverse Engineering (Databases)

Relational Database

Relational Database Design

Real-Time Collaboration

Real Time Data Processing

Query Efficiency

Precompiled SQL

Query Parameter Support

Parameterized Query

Parameterization

Normalization Rules

Non-Identified Relationship

Multi-step Transformation

Modern Data Catalog Tools

Model Iteration (in Data Modeling)

Model Documentation Analytics

Materialized View

Identified Relationship

IDE Integration

High-Level Data Design

Governance Strategies

Governance Framework in Data Management

GitOps for Database Management

Forward Engineering

Execute Permission

Enterprise Conceptual Data Model

Drag-and-Drop Interface

Derived Attribute

Decentralized Data Team

Data Modeling Granularity

Data Modeling Conventions

Data Modeling Documentation

Data Model Versioning

Data Model Partitioning

Data Model Optimization

Database Schema Lineage

Database Schema Diagram

Database Diagram Tool

Data Transformation Tools

Data Transformation Frameworks

Data Team Culture

Data Replication

Data Quality for Snowflake

Data Quality for dbt

Data Profiling for Snowflake

Data Profiling for Redshift

Data Modeling Tool

Conceptual Data Modeling Tool

Collaborative Diagramming