"As a seasoned data architect, outline a comprehensive, step-by-step plan for optimizing a data warehouse to enhance query performance, data quality, and scalability for advanced Business Intelligence (BI) teams.** Ensure the plan includes:** ## 1. Assessment of current data warehouse architecture and performance bottlenecks. ## 2. Strategies for data modeling and schema optimization. ## 3. Techniques for improving data quality through data validation and cleansing. ## 4. Approaches to enhance query performance, including indexing and caching. ## 5. Scalability considerations, such as data partitioning and distributed processing. ## 6. Real-world examples of successful optimizations, including metrics demonstrating their impact. ## 7. A clear, step-by-step implementation roadmap with timelines and resource allocation considerations. Provide detailed, technical explanations and examples tailored to advanced users, reflecting a sophisticated understanding of data warehouse optimization."