0 views collected around this technical thread.
This article details the architecture, core processes, and module designs of the JiShi BI platform, a self‑built data visualization and analysis system that integrates data ingestion, processing, enhanced AI‑driven analytics, and multi‑dimensional dashboard capabilities to support enterprise decision‑making.
The second article in the user‑behavior series explains ClickHouse‑based funnel analysis, covering unordered and ordered models, configuration, computation, and storage phases, key ClickHouse functions such as windowFunnel and array utilities, detailed SQL examples, and optimization strategies for real‑time, low‑cost querying.
This article introduces nine fundamental data analysis techniques—including periodic, structural, layered, matrix, decomposition, funnel, correlation, tag, and MECE methods—explaining how to apply each to interpret business metrics, uncover insights, and guide decision‑making without requiring advanced mathematics or complex algorithms.
This article details how Beike Zhaofang leveraged the ClickHouse columnar OLAP database for large‑scale user behavior analysis, covering its architecture, key features, performance benchmarks against other engines, data ingestion pipelines, custom UDFs for funnel and retention metrics, deployment setup, and future enhancements.
The article explains how to move beyond macro app metrics by collecting offline and real‑time user data, storing it in HDFS, processing it with Spark, visualizing behavior paths as state‑machine trees, and performing branch‑funnel analysis to uncover conversion bottlenecks and improve product quality.