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.
Evaluate Storage for Data Warehousing Success
Evaluate Storage for Data Warehousing Success
This course is part of multiple programs.
Instructor: Hurix Digital
Access provided by Bertelsmann
Gain insight into a topic and learn the fundamentals.
Beginner level
Recommended experience
2 hours to complete
Flexible schedule
Learn at your own pace
What you'll learn
Storage format choice strongly affects query performance and should match workload needs, not general assumptions.
Column storage suits read-heavy analytics, while row storage performs better for transactional and write-focused workloads.
Benchmarking with real datasets and queries offers the best basis for sound storage architecture decisions.
Compression and ingestion speed must be balanced carefully to align performance with business priorities.
Skills you'll gain
Tools you'll learn
Details to know
Shareable certificate
Add to your LinkedIn profile
Taught in English
Recently updated!
March 2026
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is available as part of
When you enroll in this course, you'll also be asked to select a specific program.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 2 modules in this course
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Explore more from Data Science
University of Colorado System
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.