Traditional Data Architectures: Data Warehousing and ETL Systems

Data warehouses are actively used for business intelligence and because they integrate data from multiple sources are advantageous to simple databases in many instances. Considering modern companies often have ETL-based data warehousing systems decision-makers need to comprehend how they operate and are appropriately managed. In this course learn the necessary concepts and processes required to work with and manage projects related to data warehousing. Study data warehousing architectures and schemas and investigate some core data warehouse elements such as dimension fact tables and keys. Furthermore examine the extract transform and load (ETL) approach for working with data warehouses specifying process flow tools and software as well as best practices. When youre done youll know how to adopt data warehousing and ETL systems for your business intelligence and data management needs.