Articles by tag: data-vault

Calculation View in asapBI without SQL

Learn how to visually build analytical models in asapBI for ADB, PostgreSQL and Trino. Export to UDF, clusters without load on DB. For DWH developers.

Data Vault Modeling in asapBI IDE

Learn how to create hubs, links, and satellites of Data Vault in asapBI IDE for Greenplum. DDL autogeneneration, structure visualization. Instructions for DWH developers.

ETL for 15 million GPS pings: stack and architecture

Breakdown of ETL system processing 15 million GPS coordinates of buses per day. PostgreSQL, PostGIS, PySpark, Data Vault. Trip segmentation and spatial analytics for middle/senior dev. Study the implementation.