Course Outline

Foundations of Data Warehousing

  • Warehouse purpose, components, and architecture
  • Data marts, enterprise warehouses, and lakehouse patterns
  • OLTP vs OLAP fundamentals and workload separation

Dimensional Modeling

  • Facts, dimensions, and grain
  • Star schema vs snowflake schema
  • Slowly Changing Dimensions types and handling

ETL and ELT Processes

  • Extraction strategies from OLTP and APIs
  • Transformations, data cleansing, and conformance
  • Load patterns, orchestration, and dependency management

Data Quality and Metadata Management

  • Data profiling and validation rules
  • Master and reference data alignment
  • Lineage, catalogs, and documentation

Analytics and Performance

  • Cubing concepts, aggregates, and materialized views
  • Partitioning, clustering, and indexing for analytics
  • Workload management, caching, and query tuning

Security and Governance

  • Access control, roles, and row-level security
  • Compliance considerations and auditing
  • Backup, recovery, and reliability practices

Modern Architectures

  • Cloud data warehouses and elasticity
  • Streaming ingestion and near real-time analytics
  • Cost optimization and monitoring

Capstone: From Source to Star Schema

  • Modeling a business process into facts and dimensions
  • Building an end-to-end ETL or ELT workflow
  • Publishing dashboards and validating metrics

Summary and Next Steps

Requirements

  • An understanding of relational databases and SQL
  • Experience with data analysis or reporting
  • Basic familiarity with cloud or on-premises data platforms

Audience

  • Data analysts transitioning to data warehousing
  • BI developers and ETL engineers
  • Data architects and team leads
 35 Hours

Testimonials (5)

Related Categories


Fatal error: Uncaught TypeError: _isl_get_excluded_site(): Return value must be of type ?array, none returned in /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc:38 Stack trace: #0 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc(30): _isl_get_excluded_site() #1 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc(17): isl_get_excluded_site() #2 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/islc7.module(51): get_outline_isls() #3 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/islc7.module(7): islc_prepare_links() #4 /apps/hitra7/npfrontend/nptemplates/default.php(272): islc7_sites_links_array_v3() #5 /apps/hitra7/npfrontend/modules/course/course.php(143): require_once('...') #6 /apps/hitra7/npfrontend/core/routes.php(15): course_menu_callback() #7 /apps/hitra7/npfrontend/__index.php(81): require_once('...') #8 /apps/hitra7/npfrontend/index.php(15): include_once('...') #9 /apps/hitra7/index.php(66): include_once('...') #10 {main} thrown in /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc on line 38