Optimization Of Data Warehouse – Reporting Design 9 February 2025 Problem Definition:- As per any standard Data Warehouse Project the entities <Transactional DB Source, ETL(Extract, Transform & Load) Process, Analytical DB Destination, UI for Reporting> are being used in the current Process/Project.