APAndrea Parisinandreaparisdata.hashnode.dev·Jun 11 · 6 min readThe Moment I Realised a Database Is Not a Data WarehouseContext The platform combines real-time cryptocurrency market data from the CoinGecko API with sentiment analysis derived from cryptocurrency-related YouTube discussions. Apache Kafka, Spark Structure00
MAMaulana Akbar Dwijayainmaulcenter.hashnode.dev·Jun 1 · 13 min readHow to Prepare Your Data Warehouse for Compliance AuditsBuilding Strong Governance, Security, and Audit Readiness In today’s digital era, organizations generate enormous amounts of data every single day. From customer transactions and financial reports to 10
MAMaulana Akbar Dwijayainmaulcenter.hashnode.dev·May 27 · 8 min readHow Much Does It Cost to Build a Data Warehouse?Introduction Modern organizations generate massive amounts of data every day from ERP systems, CRM platforms, financial applications, websites, mobile apps, IoT devices, and business operations. While20
VDVishnu Dinthedatatrench.hashnode.dev·May 9 · 8 min readSCD Types 0–6: The One Reference I Wish Existed When I StartedYour stakeholder wants to know what a customer's city was when they placed an order two years ago. Simple question. But whether you can answer it depends entirely on which SCD strategy you chose when 00
RLRisingWave Labsinrisingwave.com·Apr 3 · 5 min readBuilding a Streaming Data Warehouse with Apache Iceberg and RisingWaveA streaming data warehouse built on RisingWave and Apache Iceberg combines the freshness of a real-time pipeline with the analytical depth of a traditional data warehouse—without the cost of either a dedicated streaming engine or a commercial warehou...00
AAAbstract Algorithmsinabstractalgorithms.dev·Mar 13 · 15 min readDimensional Modeling and SCD Patterns: Building Stable Analytics WarehousesTLDR: Dimensional modeling with explicit SCD policy is the foundation for reproducible metrics and trustworthy historical analytics. TLDR: Dimensional models stay trustworthy only when teams define 00
BLBrice Luuinbluu.dev·Jan 31 · 10 min readEasy Time‑Travel for your Data Warehouse with dbt snapshotsWhy your "Sales by Region" keeps lying to you If a "simple" KPI like Sales by Region keeps changing every time someone moves house or changes team, that's not your dashboard being flaky. That's your data model telling you it only remembers the latest...00
DODonald Okothinsyntaxray-dataeng.hashnode.dev·Jan 28 · 7 min readSQL Guide: Convert CSV to Star Schema DesignIntroduction The star schema is a data warehouse table design pattern where a single main table contains measurable/ numerical data, and multiple other tables contain descriptive data about the entries in the main table. A fact table is the name give...00
UBUmar Balakinaiagcp.hashnode.dev·Jan 18 · 25 min readData WarehouseModule 1: Guide to Core Concepts 1. What is an Operational System (OLTP)? An operational system is the system that supports day-to-day business operations. It handles frequent, real-time transactions such as order entry, payments, inventory updates, ...00
PPropstratainpropstrata.com·Jan 15 · 4 min readCustom Data Warehouse + Power BI vs Propstrata🗒 Framed through DLER and MLER for property management operators. Instead of talking about exit or sale, this comparison is framed in terms that matter day to day for operators: DLER and MLER. The question is simple. Which approach gives you clear...00
