Consumption

Consumption is a reporting-oriented mart that sits alongside Core — built for dashboards, ad hoc analysis, and BI tools rather than as the system-of-record schema.

Dimensions

• dim_customer, dim_meter, dim_location, dim_service_point, dim_date

Facts

• fct_meter_readings — reading-level detail
• fct_daily_consumption, fct_weekly_consumption, fct_monthly_consumption — pre-aggregated consumption at common reporting grains
• fct_consumption_profile — shape-of-use profiles
• fct_temperature — weather context for consumption analysis
• fct_billed_consumption — consumption reconciled against billed amounts
• fct_outages — outage history

Because it's pre-aggregated at daily/weekly/monthly grains, Consumption is usually the faster starting point for dashboards and executive reporting, while Core is the right layer to build custom logic on top of.