The data warehouse has been serving companies in reporting and analysis for decades with data that has been extracted from an operational system, then cleansed and transformed in business-oriented data models for business intelligence tools. There have been debates over which best practices to use in building them, and there have been many technology optimizations related data integrations, analytic databases, and BI tools that use the DW environments. Expanded business analytics needs and mounting challenges for enterprise data warehouses also arise from increased data volumes, velocity, a