Awesome GitHub RepositoriesBI Semantic Layers

Supersonic 是一个基于 LLM 的数据分析平台和语义层引擎，可将自然语言问题转换为可执行的 SQL 查询。它作为一个商业智能仪表板和 Text-to-SQL 接口，允许用户通过对话界面检索业务指标和洞察。 该系统通过使用受控的逻辑层来定义统一的指标和维度，将业务定义与物理数据库模式解耦。这种语义建模允许平台将人类语言模式映射到精选模型，并将抽象的语义陈述转换为针对特定数据库引擎定制的物理 SQL。 该平台提供了一个企业级数据网关，具有数据集、列和行级别的基于角色的细粒度访问控制。其能力包括多轮对话管理、多数据库连接以及用于第三方工具集成的插件架构。 该项目通过无头编程 API 和用于外部数据消费的语义层 API 暴露其功能。

Erupt is a framework for building administrative interfaces, business intelligence layers, and visual workflow engines. It provides a multi-tenant admin panel and an LLM admin framework that automatically generates web-based management consoles and REST endpoints from backend class definitions. The project distinguishes itself by integrating AI agent orchestration, allowing administrators to manage server operations and execute backend logic through a conversational chat interface. It also features a BI semantic layer that maps raw warehouse data into business-oriented cubes for self-service

Data warehouse learning is a reference implementation of a real-time stream processing system and open-source data lakehouse architecture. It combines stream processing engines, open lakehouse formats, and analytical data warehouses into a complete e-commerce data warehouse system built for both offline and real-time analytics pipelines. The project implements hybrid data warehouse architectures utilizing multi-layer storage models and stream-batch processing pipelines. It features change data capture pipelines that stream database transaction logs into messaging systems, progressive data tra