Glossary
Data Analytics Glossary
492 terms · 22 letters
A21
- A/B Testing
- Abstraction in Data Modeling
- ACID Compliance
- AI-Powered Data Modeling
- ALTER MATERIALIZED VIEW in BigQuery
- Analytics-Ready Data
- Anchor Modeling
- Anonymized Data
- API
- Application-Aware Modeling
- Array Fields
- ARRAY in SQL
- ARRAY Type Consistency in SQL
- ARRAY_CONCAT in SQL
- ARRAY_LENGTH in SQL
- ARRAY_REVERSE in SQL
- ARRAY_TO_STRING in SQL
- Artificial Intelligence
- Associative Entity
- Attribute Hierarchy
- Attribute in Data Modeling
B19
- Best Data Orchestration Tools
- BI Dashboards
- Big Data
- BigQuery
- BigQuery Connector for Looker Studio
- BigQuery Console
- BigQuery Data Source
- BigQuery ML
- BigQuery Performance Optimization
- BigQuery SQL Query Editor: Features & Tips
- BigQuery Studio
- BigQuery Views
- Bind Variables in SQL
- Bridge Table
- Business Intelligence
- Business Intelligence Applications
- Business Rules in Data Models
- Business-Ready Data
- BYTE_LENGTH in SQL
C52
- Caller’s vs. Owner’s Rights in SQL Stored Procedures
- Cardinality in Data Modeling
- CASE in ARRAY_LENGTH
- CAST AS ARRAY in SQL
- CAST AS BIGNUMERIC in SQL
- CAST AS BOOL in SQL
- CAST AS BYTES in SQL
- CAST AS DATE in SQL
- CAST AS DATETIME in SQL
- CAST AS FLOAT64 in SQL
- CAST AS INT64 in SQL
- CAST AS INTERVAL in SQL
- CAST AS NUMERIC in SQL
- CAST AS STRING in SQL
- CAST AS STRUCT in SQL
- CAST AS TIME in SQL
- CAST AS TIMESTAMP in SQL
- CAST in SQL
- Centralized Data Team
- CHAR_LENGTH in SQL
- Class in Data Modeling
- Cloud Computing
- Cloud ETL Tools
- Cloud Migration
- Cloud Native
- Cloud Storage
- CLR Stored Procedures in SQL Server
- Clustering in BigQuery Views
- COALESCE in ARRAY
- Collaborative Diagramming
- Command Line Interface (CLI)
- Common Table Expression (CTE)
- Composite Key
- Conceptual Data Model
- Conceptual Data Modeling Tools
- Conceptual Diagram
- Conceptual Model in DBMS
- CONTAINS_SUBSTR in BigQuery
- Cost Analysis
- Cost Data Blending
- Cost-Effective Data Management
- CREATE MATERIALIZED VIEW in BigQuery
- CREATE MODEL in BigQuery ML
- CRM Data Insights
- CRM Marketing
- Cross-Device User Profiles
- Crow’s Foot Notation
- CTE Query Optimization
- CTE vs Temporary Table
- CURRENT_DATE in SQL
- Custom Events in GA4
- Custom Query Connection
D185
- Data Ambiguity
- Data Analysis Tools
- Data Analyst
- Data Analytics
- Data Analytics Tools
- Data Anomaly Detection
- Data Anonymization
- Data Architecture
- Data Architecture Design
- Data Architecture Diagram
- Data Auditing
- Data Backup
- Data Batch Processing
- Data Breach Prevention
- Data Catalog
- Data Catalog for BigQuery
- Data Catalog for Databricks
- Data Catalog for dbt
- Data Catalog for Redshift
- Data Catalog for Snowflake
- Data Center
- Data Cleansing
- Data Collaboration
- Data Compliance
- Data Confidentiality
- Data Consumer
- Data Consumption
- Data Cost Optimization
- Data Curation
- Data Democratization
- Data Denormalization
- Data Dictionary
- Data Dictionary for BigQuery
- Data Dictionary for Redshift
- Data Discovery
- Data Discovery for BigQuery
- Data Discovery for Databricks
- Data Documentation for BigQuery
- Data Documentation for dbt
- Data Documentation for Looker
- Data Documentation for Redshift
- Data Documentation for Snowflake
- Data Drift
- Data Duplication
- Data Encryption
- Data Engineer
- Data Engineering
- Data Enrichment
- Data Exploration
- Data Federation
- Data Flow Diagram
- Data Glossary
- Data Governance
- Data Governance for BigQuery
- Data Governance for Databricks
- Data Governance for Redshift
- Data Governance for Snowflake
- Data Governance Framework
- Data Graph
- Data Infrastructure
- Data Ingestion
- Data Integration
- Data Integrity
- Data Interoperability
- Data Lake
- Data Lakehouse
- Data Latency
- Data Layer
- Data Lineage
- Data Lineage for BigQuery
- Data Lineage for Databricks
- Data Lineage for dbt
- Data Lineage for Redshift
- Data Management Best Practices
- Data Mart Architecture
- Data Mart in OWOX
- Data Mart Layer
- Data Masking
- Data Mesh
- Data Migration
- Data Mining
- Data Model
- Data Model Abstraction
- Data Model Integrity
- Data Model Optimization
- Data Model Partitioning
- Data Model Types
- Data Model Versioning
- Data Modeling
- Data Modeling Best Practices
- Data Modeling Conventions
- Data Modeling Documentation
- Data Modeling for Business Reporting
- Data Modeling Granularity
- Data Modeling in Healthcare
- Data Modeling in Retail
- Data Modeling Mistakes
- Data Modeling Process
- Data Modeling Stages
- Data Modeling Techniques
- Data Modeling Tools
- Data Normalization
- Data Obfuscation? Techniques & Use Cases
- Data Orchestration? Tools & Examples
- Data Pipeline? Types, Use Cases & Benefits
- Data Platform? Components & Benefits
- Data Practices? Standards & Implementation
- Data Preparation? Steps, Tools & Best Practices
- Data Privacy for BigQuery
- Data Privacy for dbt
- Data Privacy for Snowflake
- Data Privacy Governance
- Data Privacy? Principles & Best Practices
- Data Product? Definition & Examples
- Data Profiling for Redshift
- Data Profiling for Snowflake
- Data Profiling? Definition & Techniques
- Data Provisioning? Architecture & Uses
- Data Quality Checks
- Data Quality for dbt
- Data Quality for Snowflake
- Data Quality Framework
- Data Quality Issues
- Data Quality Metrics
- Data Quality Monitoring
- Data Quality? Definition & Best Practices
- Data Redundancy? Definition & Examples
- Data Replication? Methods & Use Cases
- Data Reporting? Tools & Best Practices
- Data Restoration? Methods & Practices
- Data Retention Policies
- Data Science? Definition & Use Cases
- Data Security Cost Considerations
- Data Security Governance
- Data Security Governance Framework
- Data Security Standards
- Data Security? Principles & Best Practices
- Data Sharing? Methods & Best Practices
- Data Silos? Causes & How to Break Them
- Data Skew? Causes, Types & Fixes
- Data Source Schema? Definition & Guide
- Data Standardization? Methods & Benefits
- Data Stewardship? Role & Best Practices
- Data Storage Solutions
- Data Streaming? Definition & Use Cases
- Data Team Culture
- Data Teams
- Data Transformation Frameworks
- Data Transformation Tools
- Data Transformation? Methods & Tools
- Data Validation? Methods & Best Practices
- Data Value? How to Measure & Maximize It
- Data Vault Schema? Design & Examples
- Data Visualization? Types & Best Practices
- Data Warehouse? Definition & Guide
- Data Wrangling? Steps & Tools
- Data-Driven Decision Making
- Database
- Database Diagram Tools
- Database Logic in SQL
- Database Schema
- Database Schema Diagram
- Database Schema Lineage
- DataOps? Definition, Benefits & Examples
- Dataset? Definition & Examples
- DATE_ADD Function in SQL
- DATE_DIFF Function in SQL
- DATE_FROM_UNIX_DATE in SQL
- DATE_SUB Function in SQL
- DATE_TRUNC Function in SQL
- Dbt? Definition, Features & Use Cases
- DDL in SQL
- Decentralized Data Team
- Deduplication? Methods & Best Practices
- Deep Learning? Definition & Use Cases
- Degenerate Dimension? Definition
- Dependent Data Mart? Definition & Guide
- Derived Attribute? Definition & Examples
- Derived Model? Definition & Examples
- DevSecOps? Definition & Best Practices
- Dimension Table? Definition & Examples
- Dimensional Fact Model
- Drag-and-Drop Interface
- DROP MATERIALIZED VIEW in BigQuery
- Dynamic SQL? Definition & Examples
E10
F11
G11
- GA4 BigQuery Export
- GA4 Export Data in BigQuery
- GENERATE_ARRAY in SQL
- GENERATE_DATE_ARRAY in SQL Syntax & Examples
- GENERATE_TIMESTAMP_ARRAY in SQL
- GitOps for Database Management
- Google Analytics Debugger
- Governance Framework in Data Management
- Governance Strategies
- Grain in a Fact Table? Definition
- Granularity in Data? Definition & Guide
H3
I4
J2
L7
M28
- Machine Learning Algorithms
- Machine Learning and AI
- Machine Learning Models
- Many-to-Many Relationship (N:N)
- Materialized View? Definition & Guide
- Mazon Redshift? Features & Use Cases
- Metabase? Features & Use Cases
- Metadata Extractor? Tools & Use Cases
- Metadata Management? Guide & Tools
- Metadata Standards? Types & Examples
- Metadata? Definition, Types & Examples
- Method in Data Modeling
- ML Classification
- ML.EVALUATE in BigQuery
- ML.FORECAST in BigQuery
- ML.PREDICT in BigQuery
- ML.RECOMMENDATIONS in BigQuery
- ML.TFDV_DESCRIBE in BigQuery
- ML.TFDV_VALIDATE in BigQuery
- ML.VALIDATE_DATA_DRIFT in BigQuery
- Model Documentation in Analytics
- Model Iteration in Data Modeling
- Modeled Conversion? Definition & Guide
- Modern Data Catalog Tools
- Modern Data Stack? Components & Guide
- Modularity in Data? Definition & Benefits
- Multi-CTE Query in SQL
- Multi-Step Transformation
N17
- N Entity in Data Modeling? Definition
- N ETL Pipeline? Architecture & Guide
- N Execution Plan? SQL Query Optimization
- N Identified Relationship? Definition
- N Independent Data Mart? Definition
- N Object in Data Modeling? Definition
- N OLAP Cube? Definition & Architecture
- N OLAP System? Architecture & Use Cases
- N Outrigger Dimension? Definition
- N RDBMS? Definition & Examples
- Naming Conventions in Analytics
- Nested CTE in SQL
- Non-Identified Relationship
- Normalization Rules
- NORMALIZE Function in SQL
- NORMALIZE_AND_CASEFOLD in SQL
- NoSQL Database? Types & Use Cases
O11
P17
- Parameterization? Definition & Examples
- Parameterized Query
- PARSE_BIGNUMERIC in SQL
- PARSE_DATE Function in SQL
- PARSE_NUMERIC in SQL
- PARSE_TIMESTAMP in SQL
- Partitioned Tables in BigQuery
- Partitioned Views? Definition & Guide
- Persistent Data? Definition & Examples
- Physical Data Model? Definition & Guide
- Pipeline Development
- Polymorphism in Data Modeling
- Pre-Calculated Reporting Table
- Precompiled SQL? Definition & Benefits
- Predictive Analytics? Methods & Tools
- Predictive Data Modeling
- Primary Key? Definition & Examples
Q9
R24
- Raw Data? Definition & How to Use It
- Read-Only Views in BigQuery
- Real-Time Analytics? Tools & Use Cases
- Real-Time Collaboration in Data Teams
- Real-Time Data Processing
- Recursive CTE in SQL
- Recursive Data Model
- Recursive Iteration Limit in SQL
- Recursive Relationship
- REGEXP_EXTRACT_ALL in SQL
- REGEXP_INSTR Function in SQL
- REGEXP_REPLACE in SQL
- Relational Database Design
- Relational Database? Definition & Guide
- Relationships in Data Modeling
- REPEAT Function in SQL
- Reverse Engineering Databases
- Reverse ETL? Definition & Use Cases
- REVERSE Function in SQL
- RFM Segmentation
- Role-Based Access Control (RBAC)
- ROPO Analysis? Definition & Guide
- RPAD Function in SQL
- RTRIM Function in SQL
S44
- SAFE_CAST in SQL
- SAFE.PARSE_DATE in SQL
- Sampling Techniques
- Scalability in Data Modeling
- Scalable Infrastructure
- Schema Comparison
- Schema Reporting
- Schema Visualization
- Schema-on-Read? Definition & Guide
- SELECT AS STRUCT in BigQuery
- Self-Service Analytics
- Self-Service Analytics Enablement
- Self-Service BI Tools
- Semi-Structured Data Model
- Sentiment Analysis? Methods & Tools
- Server-Side Tracking
- Session Merging? Definition & Guide
- Shrunken Dimension? Definition & Guide
- Slowly Changing Dimensions
- Snowflake Data Warehouse: Overview & Guide
- Snowflake Schema in Data Modeling
- SQL Functions: Types, Syntax & Examples
- SQL Generation? Purpose & Examples
- SQL Injection: Risks, Types & Prevention
- SQL Logic: Meaning & Use Cases
- SQL? Definition & Key Concepts
- SQLMesh? Data Modeling Framework
- SRID Mismatch: Causes & Fixes in BigQuery
- ST_DISTANCE in BigQuery: Syntax & Examples
- ST_UNION in BigQuery: Syntax & Examples
- Stakeholder Validation in Data Modeling
- Standard Views in SQL
- Star Schema: Definition & Examples
- Static Schema in BigQuery Views
- Step Dimension? Definition
- Step-by-Step CTE Debugging in SQL
- Stored Procedures in SQL: Guide & Examples
- STRPOS Function in BigQuery: Syntax & Use
- Subject-Oriented Design: Definition & Use
- Subschema? Definition & Guide
- Supply Chain Optimization: Methods & Tools
- Surrogate Key: Definition & Examples
- Swappable Dimension
- System Stored Procedures in SQL
T6
U3
V4
W4
No term matches — try fewer letters.