--- title: Data Warehousing description: Data warehousing involves consolidating data from multiple sources into a central repository for analysis and reporting. Learners will understand ETL processes, dimensional modeling, star and snowflake schemas, and how to support business intelligence operations. category: programming-tech subcategory: databases difficulty: beginner, intermediate, advanced url: /subject/data-warehousing --- # Data Warehousing Data warehousing involves consolidating data from multiple sources into a central repository for analysis and reporting. Learners will understand ETL processes, dimensional modeling, star and snowflake schemas, and how to support business intelligence operations. ## Available Resources 3 Books • 1 Courses • 2 Websites ## Podcasts ### 1. The Data Stack Show **Author:** Eric Dodds and John Wessel Weekly interview podcast produced by RudderStack in which hosts talk with data engineers, analysts and data scientists about building data infrastructure, pipelines, warehouses and data products, and about the tooling and organisational choices behind them. Listeners gain practitioner context on modern data stacks. **Difficulty:** Intermediate | **Language:** en | **Price:** Free **Link:** https://datastackshow.com **Tags:** data-engineering, data-infrastructure, data-pipelines, data-warehousing, modern-data-stack ## Books ### 1. The Data Warehouse Toolkit **Author:** Ralph Kimball, Margy Ross Kimball's reference on dimensional modeling and the full warehouse lifecycle, from requirements gathering through ETL design and BI delivery. After it you can design star schemas, plan fact and dimension tables, and sequence a warehouse build. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/0470149779?tag=edmonddante07-20 **Tags:** books, technology-computer-science, database--backend ### 2. Data Warehousing Fundamentals Welcome to Fundamentals of Data Warehousing, the third course of the Key Technologies of Data Analytics specialization. By enrolling in this course, you are taking the next step in your career in data analytics. This course is the third of a series that aims to prepare you for a role working in data analytics. In this course, you will be introduced to many of the core concepts of data warehousing. You will learn about the primary components of data warehousing. We’ll go through the common data warehousing architectures. The hands-on material offers to add storage to your cloud environment and configure a database. This course covers a wide variety of topics that are critical for understanding data warehousing and are designed to give you an introduction and overview as you begin to build relevant knowledge and skills. **Difficulty:** Beginner | **Language:** English | **Price:** Free **Link:** https://www.coursera.org/learn/fundamentals-of-data-warehousing **Tags:** books, technology-computer-science, database--backend ### 3. Building the Data Warehouse **Author:** W. H. Inmon Inmon's foundational text on the enterprise data warehouse: subject-oriented, integrated, time-variant storage feeding downstream data marts. Explains granularity, partitioning, and the operational data store, and gives you the top-down architecture that contrasts with Kimball's approach. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/0471081302?tag=edmonddante07-20 **Tags:** books, technology-computer-science, database--backend ## Websites ### 1. kimballgroup.com Kimball Group is a resource for data warehousing best practices, centered on the Kimball dimensional modeling methodology. The site features articles, white papers, and design guidance on star schemas, data warehouse architecture, and scalable analytics. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://kimballgroup.com **Tags:** websites, technology-computer-science, database--backend ### 2. tdwi.org TDWI.org is a premier resource for data warehousing, BI, and analytics professionals, offering news, in-depth articles, research reports, webinars, training, and conference events to help practitioners design, implement, and optimize data warehouses and BI solutions. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://tdwi.org **Tags:** websites, technology-computer-science, database--backend ## Courses ### 1. Advanced Data Warehousing Capstone of IBM's Data Warehouse Engineer certificate. You build a MySQL OLTP source, a PostgreSQL staging warehouse with fact and dimension tables, shell-script ETL jobs on cron, and a Cognos or Looker Studio dashboard. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://www.coursera.org/learn/data-warehousing-capstone-project **Tags:** courses, technology-computer-science, database--backend --- *This content is part of Dantes.io - Your Treasure Map to Knowledge* *Curated by humans at Dantes.io. Personal study use welcome; republishing this curation requires permission (team@dantes.io).* View this page online: https://dantes.io/subject/data-warehousing