What is a star schema and why is it common in analytics warehouses?

A star schema uses a fact table (events/measures) linked to dimension tables (entities like user, product, time). It simplifies BI queries, improves performance, and supports consistent metrics. Design tips: choose correct grain for facts, manage slowly changing dimensions, and document metric definitions to avoid inconsistent reporting.