datamart-review

What problem does it solve?

Mismatches between business analyst (BA) requirement documentation and Datamart high-level (HLD) and low-level (LLD) designs lead to incorrect reports, dashboards, and data products that do not align with business needs. This Skill eliminates that risk by enforcing end-to-end traceability from source data through Atomic entities to final Datamart outputs.

Core Features & Use Cases

• 3-Layer Cross-Check: Validates HLD coverage, Atomic-to-Datamart attribute mapping, and Datamart-to-reporting detail mapping for every group in a module.
• Issue Classification: Automatically categorizes gaps into 3 scenarios: missing HLD when BA is complete, logic mismatches from BA updates, and technical design errors, with clear action recommendations.
• Use Case: A data modeler working on the UBCK Lakehouse project can use this Skill to review an entire Datamart module, catch missing KPIs, incorrect ETL logic, or misaligned filters before deployment, ensuring all reporting outputs match BA requirements.

Quick Start

Use the datamart-review skill to cross-check the BA analyst documentation and Datamart HLD/LLD files for the 'customer_reporting' module to identify logic gaps and design inconsistencies.