According to the Wikipedia, the design methodologies of data warehouses are: Bottom-up design: In the bottom-up approach, data marts are first created to provide reporting and analytical capabilities for specific business processes.
These data marts can then be integrated to create a comprehensive data warehouse.
Extract, transform, load (ETL) and extract, load, transform (ELT) are the two main approaches used to build a data warehouse system.