Evaluate Storage for Data Warehousing

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

• Explain how storage format choice affects query performance and workload compatibility
• Distinguish columnar storage for analytics from row storage for transactional workloads
• Use benchmarking tools to make data-driven storage decisions
• Balance compression and ingestion speed to align performance with business priorities

• Basic computer and internet skills
• Ability to follow course instructions and complete short exercises
• Introductory knowledge of data storage concepts helpful