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

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
Foundations for Big Data Analysis with SQL (Coursera) Coursera
Cloudera

Foundations for Big Data Analysis with SQL (Coursera)

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.

Nov 9th 2026
5-12 Weeks
Analytical Solutions to Common Healthcare Problems (Coursera) Coursera
University of California, Davis

Analytical Solutions to Common Healthcare Problems (Coursera)

In this course, we’re going to go over analytical solutions to common healthcare problems. I will review these business problems and you’ll build out various data structures to organize your data. We’ll then explore ways to group data and categorize medical codes into analytical categories. You will then be able to extract, transform, and load data into data structures required for solving medical problems and be able to also harmonize data from multiple sources.

Nov 9th 2026
4 Weeks
Fundamentals of Cloud Computing (Coursera) Coursera
LearnQuest

Fundamentals of Cloud Computing (Coursera)

This course is the second 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 cloud computing. You will learn about the primary deployment models. We’ll go through the common cloud computing service models. The hands on material offers the opportunity to review and configure a cloud account.

Nov 9th 2026
3 Weeks
Build a Data Warehouse Using BigQuery (Coursera) Coursera
Starweaver

Build a Data Warehouse Using BigQuery (Coursera)

Unlock the power of Google BigQuery as you embark on a journey to become proficient in data warehouse building and advanced querying. In this comprehensive course, you'll learn to harness the capabilities of BigQuery, from setting up and accessing the platform to creating data warehouses using both the user interface and Python. Through hands-on lessons and practical applications, you'll develop the fundamental skills needed to manage, query, and optimize your data in this powerful cloud-based platform.

Nov 23rd 2026
1 Week
Fundamentals of Big Data (Coursera) Coursera
LearnQuest

Fundamentals of Big Data (Coursera)

Welcome to Fundamentals of Big Data, the fourth 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 fourth 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 big data.

Nov 9th 2026
3 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.

Nov 9th 2026
4 Weeks
Python Project for Data Engineering (Coursera) Coursera
IBM

Python Project for Data Engineering (Coursera)

This mini-course is intended to apply foundational Python skills by implementing different techniques to collect and work with data. Assume the role of a Data Engineer and extract data from multiple file formats, transform it into specific datatypes, and then load it into a single source for analysis. Continue with the course and test your knowledge by implementing webscraping and extracting data with APIs all with the help of multiple hands-on labs. After completing this course you will have acquired the confidence to begin collecting large datasets from multiple sources and transform them into one primary source, or begin web scraping to gain valuable business insights all with the use of Python.

Nov 9th 2026
1 Week
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.

Nov 16th 2026
5-12 Weeks
Relational Database Support for Data Warehouses (Coursera) Coursera
University of Colorado System

Relational Database Support for Data Warehouses (Coursera)

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

Nov 9th 2026
5-12 Weeks