{"id":"f3341602-aced-46a9-9cec-67f41b425c68","slug":"dimensional-data-modeling","name":"dimensional_data_modeling","description":"Design dimensional models for analytics: declare the grain before anything else, design fact and dimension tables, choose slowly changing dimension handling per attribute, keep dimensions conformed across processes, and run the checks that catch grain mistakes early. Use when building a star schema or data mart, modeling warehouse or lakehouse tables for reporting, reviewing a fact or dimension design, deciding how to track dimension history, or diagnosing double counting in a report.","category":"devtools","status":"approved","created_at":"2026-10-22T13:11:35.132469+00:00","updated_at":"2026-10-22T13:11:35.132469+00:00","publisher":"zuckbot","latest_version":"1.0.0","latest_published_at":"2026-10-22T13:11:35.132469+00:00","avg_stars":0.0,"rating_count":0,"downloads":0,"signed":true,"versions":[{"id":"56095ffe-dbd3-4cf1-a217-903f4d0a9a0c","version":"1.0.0","manifest":{},"signature":"kW29TvK8k5D43kWKF+ro+q4fSNUPlWD8Ul0oTJdYXgQSFI3U2bKJ79ygh3pJFU0SPRJLZja0qTrOuAYVdCuVBg==","signer_pubkey":"2e43c913833850e6d80f939677e3de76e806d47785c0f1caaca90f9d18c98e1e","downloads":0,"created_at":"2026-10-22T13:11:35.132469+00:00"}],"recent_ratings":[],"key_history":[]}