Evaluate Storage for Data Warehousing Success

Overview

Master the critical decision-making skills for optimizing data warehouse storage architecture. This course equips data professionals with the analytical expertise to evaluate columnar versus row-oriented storage formats based on workload characteristics, query patterns, and performance requirements. You'll learn to analyze compression ratios, assess ingestion performance implications, and conduct systematic benchmarking of formats like Parquet, ORC, and Avro. Transform your ability to make informed storage architecture decisions that directly impact analytical performance and cost-effectiveness in enterprise data warehousing environments. This course is unique because it combines theoretical understanding with hands-on benchmarking practice, giving you real-world experience in evaluating storage formats using actual performance metrics. To be successful in this project, you should have basic understanding of data warehousing concepts and familiarity with SQL queries.

Syllabus

Module 1: Storage Architecture Evaluation Foundations

Learners will establish foundational understanding of storage format trade-offs and begin evaluating columnar versus row-oriented approaches for analytical workloads.

Module 2: Performance Benchmarking and Recommendations

Learners will conduct hands-on performance benchmarking of storage formats and create evidence-based recommendations that mirror professional data engineering decision-making processes.