Fundamentals of Data Warehousing (Coursera)

Offered by LearnQuest,
Fundamentals of Data Warehousing (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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.

Course 3 of 4 in the Key Technologies in Data Analytics Specialization

Syllabus

WEEK 1
Concepts
In the first module of the course, we'll learn about the core concepts of data warehousing, including subject-oriented, integrated, time-variant, and nonvolatile. By the end of this module, you will know how to identify these data warehousing characteristics and their use cases. So let's get started!

WEEK 2
Components
In the second module of this course, we'll learn about the primary components in data warehousing, including database structures, ETL and ELT, metadata, and tools.

WEEK 3
Design and Architecture
In the third module of this course, we'll learn about the design and architecture used in data warehousing, including design approaches, single tier architectures, two tier architectures, and three tier architectures.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Data Warehousing and Business Intelligence (Coursera) Coursera
University of California, Irvine

Data Warehousing and Business Intelligence (Coursera)

This course builds on “The Nature of Data and Relational Database Design” to extend the process of capturing and manipulating data through data warehousing and data mining. Once the transactional data is processed through ETL (Extract, Transform, Load), it is then stored in a data warehouse for use in managerial decision making. Data mining is one of the key enablers in the process of converting data stored in a data warehouse into actionable insight for better and faster decision making.

Sep 21st 2026
4 Weeks
Getting Started with Data Warehousing and BI Analytics (Coursera) Coursera
IBM

Getting Started with Data Warehousing and BI Analytics (Coursera)

Data is one of an organization’s most valuable commodities. But how can organizations best use their data? And how does the organization determine which data is the most recent, accurate, and useful for business decision making at the highest level? After taking this course, you will be able to describe different kinds of repositories including data marts, data lakes, and data reservoirs, and explain their functions and uses.

Jul 6th 2026
4 Weeks
Data Mining Pipeline (Coursera) Coursera
University of Colorado Boulder

Data Mining Pipeline (Coursera)

This course introduces the key steps involved in the data mining pipeline, including data understanding, data preprocessing, data warehousing, data modeling, interpretation and evaluation, and real-world applications. Data Mining Pipeline can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform.

Sep 28th 2026
4 Weeks
Big Data Science with the BD2K-LINCS Data Coordination and Integration Center (Coursera) Coursera
Icahn School of Medicine at Mount Sinai

Big Data Science with the BD2K-LINCS Data Coordination and Integration Center (Coursera)

In this course we briefly introduce the DCIC and the various Centers that collect data for LINCS. We then cover metadata and how metadata is linked to ontologies. We then present data processing and normalization methods to clean and harmonize LINCS data. This follow discussions about how data is served as RESTful APIs. Most importantly, the course covers computational methods including: data clustering, gene-set enrichment analysis, interactive data visualization, and supervised learning. Finally, we introduce crowdsourcing/citizen-science projects where students can work together in teams to extract expression signatures from public databases and then query such collections of signatures against LINCS data for predicting small molecules as potential therapeutics.

Sep 21st 2026
5-12 Weeks
The Path to Insights: Data Models and Pipelines (Coursera) Coursera
Google

The Path to Insights: Data Models and Pipelines (Coursera)

This is the second of three courses in the Google Business Intelligence Certificate. In this course, you'll explore data modeling and how databases are designed. Then you’ll learn about extract, transform, load (ETL) processes that extract data from source systems, transform it into formats that enable analysis, and drive business processes and goals.

Sep 21st 2026
4 Weeks
Data Warehouse Concepts, Design, and Data Integration (Coursera) Coursera
University of Colorado System

Data Warehouse Concepts, Design, and Data Integration (Coursera)

This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows.

Sep 28th 2026
5-12 Weeks
Introducción al Análisis de Datos (Coursera) Coursera
IBM

Introducción al Análisis de Datos (Coursera)

Este curso presenta una gentil introducción a los conceptos del análisis de datos, el rol de un Analista de Datos y las herramientas que se utilizan para realizar las funciones diarias. Obtendrás una comprensión del ecosistema de datos y de los fundamentos del análisis de datos, como la recopilación de datos o la minería de datos. También aprenderás las aptitudes generales que se requieren para comunicar eficazmente tus datos a los interesados y cómo el dominio de estas aptitudes puede darte la opción de convertirte en un tomador de decisiones impulsado por los datos.

Oct 2nd 2023
5-12 Weeks
ETL and Data Pipelines with Shell, Airflow and Kafka (Coursera) Coursera
IBM

ETL and Data Pipelines with Shell, Airflow and Kafka (Coursera)

After taking this course, you will be able to describe two different approaches to converting raw data into analytics-ready data. One approach is the Extract, Transform, Load (ETL) process. The other contrasting approach is the Extract, Load, and Transform (ELT) process. ETL processes apply to data warehouses and data marts. ELT processes apply to data lakes, where the data is transformed on demand by the requesting/calling application.

Sep 21st 2026
5-12 Weeks
Database Management Essentials (Coursera) Coursera
University of Colorado System

Database Management Essentials (Coursera)

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy.

Sep 21st 2026
5-12 Weeks
Discovering BI: From Warehousing to Interactive Dashboards (Coursera) Coursera
Coursera Instructor Network

Discovering BI: From Warehousing to Interactive Dashboards (Coursera)

In a world where vast amounts of data are generated every second, understanding database structures and the art of transforming data into intelligence is increasingly crucial for those looking to excel in this realm. To embark on this journey, there is no better starting point than Business Intelligence (BI), covering everything from data storage to the creation of engaging dashboards.

Sep 28th 2026
1 Week
AWS Data Processing (Coursera) Coursera
Whizlabs

AWS Data Processing (Coursera)

AWS: Data Processing Course is the second course of AWS Certified Data Analytics Specialty Specialization. This course focuses on providing data processing solutions. The entire course is designed to teach learners the concept of EMR and Extract, Transform and Load. This course also put emphasis on ETL services and Data Processing solutions in AWS.

Jul 22nd 2024
3 Weeks