Three-layer Snowflake warehouse — a raw landing zone mirroring source structure, a core star schema built around commodity, geography, and supplier dimensions, and a reporting schema exposing only pre-aggregated, business-ready views
DirectQuery to Power BI — Power BI connects live to the reporting schema through a read-only service role, so the semantic model never touches raw or core data
Built-in risk scoring — report measures include year-over-year price movement and a Herfindahl-Hirschman Index (HHI) reading on supply concentration, replacing ad hoc "looks concentrated" judgment calls with a standard, defensible metric

Retail