Optimized data warehouses by applying multi-layer data models and data modeling best practices, achieving data harmonization, increasing data usage by over 10%, and reducing average query time by 15 seconds