Data warehouses work by extracting data from diverse source systems, transforming it into a consistent format, and loading it into the warehouse. This process, known as ETL, involves data cleansing, normalization, and aggregation to ensure data quality and consistency. Once data is stored in the warehouse, it can be queried and analyzed using various BI tools and analytical applications.