Getting Started with Data Warehousing and BI Analytics (Coursera)

Offered by 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.

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

A data warehouse is a large repository of data that has been cleaned to a consistent quality. Not all data repositories are used in the same way or require the same rigor when choosing what data to store. Data warehouses are designed to enable rapid business decision making through accurate and flexible reporting and data analysis. A data warehouse is one of the most fundamental business intelligence tools in use today, and one that successful Data Engineers must understand.
You will also be able to describe how data warehouses serve a single source of data truth for organization’s current and historical data.
Organizations create data value using analytics and business intelligence applications. Now that you have experienced the ELT process, gain hands-on analytics and business intelligence experience using IBM Cognos and its reporting, dashboard features including visualization capabilities.
Finally, you will complete a shareable final project that enables you to demonstrate the skills you acquired in each module.
Completing this course will count towards your learning in any of the following programs:

What You Will Learn

  • Explore the architecture, features, and benefits of data warehouses, data marts, and data lakes and identify popular data warehouse system vendors.
  • Design and populate a data warehouse, and model and querydata using CUBE, ROLLUP, and materialized views. 
  • Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics. 
  • Design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.

Syllabus

WEEK 1
Data Warehouses, Data Marts, and Data Lakes
Welcome to your first module! This module provides a gentle but thorough introduction to data warehouse systems, data lakes, and data marts. When you complete this module, you’ll be able to identify and compare data warehouse systems, data mart, and data lake architecture, and understand how organizations can benefit from each of these three data storage entities. Optionally, you’ll explore the workings of IBM Db2 data warehouse system architecture, view use cases, and understand the key capabilities and integrations available with IBM Db2 Warehouse. Then, you’ll learn about three types of data warehouse systems and popular data warehouse system vendors. You will be ready to help your organization assess new data warehouse system offerings when you know the five essential, critical criteria, including total cost of ownership, to evaluate before changing to a new data warehouse system.

WEEK 2
Designing, Modeling and Implementing Data Warehouses
In this knowledge-packed module, you’ll explore general and reference enterprise data warehousing architecture. You’ll discover how data cubes relate to star schemas. Then you’ll learn how to slice, dice, drill up or down, roll up, and pivot relative to data cubes. Next, you will examine the capabilities of materialized views, their benefits, and how to apply them. You’ll learn how data organization using facts and dimensions and their related tables organizes information. Then, you will explore how to use normalization to create a snowflake schema as an extension of the star schema. You will learn about populating a data warehouse, incremental data updates, verifying data, querying data, interpreting an entity-relationship diagram for a star schema, creating a materialized view, and applying the CUBE and ROLLUP options. You’ll also discover how organizations can benefit by implementing staging.

WEEK 3
Data Warehouse Analytics
In this module, you’ll fast-track your data analytics learning and gain hands-on data analytics experience using IBM Cognos Analytics. After registering with Cognos Analytics, you’ll explore the platform’s capabilities by creating visualizations, building a simple dashboard, and trying out its advanced features.

WEEK 4
Final Assignment and Final Quiz
In this module, you’ll complete your final course project, which brings together concepts and practices you previously learned in the first three modules. In this final project, you will design and load data into a data warehouse using facts and dimension tables. Then you’ll write aggregation queries using CUBE and ROLLUP functions and create materialized query tables, known as a materialized view. You will complete your project by using IBM Cognos to create an analytics dashboard.

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 Analytics in Sports Law and Team Management (Coursera) Coursera
The State University of New York

Data Analytics in Sports Law and Team Management (Coursera)

This course provides an introduction to the fundamental ideas in applying data analytics to issues surrounding key regulatory and management functions within the sports industry. Sports as an industry is increasingly relying on data analytics for more effective deployment of resources and assessment of performance in areas ranging from player productivity to fan engagement, talent identification and development, coaching, sponsorship, and marketing. This course and its successors will help you understand this new role of data analysis in the sports business.

Dec 7th 2026
5-12 Weeks
Data Analytics for Lean Six Sigma (Coursera) Coursera
University of Amsterdam

Data Analytics for Lean Six Sigma (Coursera)

Welcome to this course on Data Analytics for Lean Six Sigma. In this course you will learn data analytics techniques that are typically useful within Lean Six Sigma improvement projects. At the end of this course you are able to analyse and interpret data gathered within such a project. You will be able to use Minitab to analyse the data. I will also briefly explain what Lean Six Sigma is.

Nov 23rd 2026
5-12 Weeks
Business Intelligence Concepts, Tools, and Applications (Coursera) Coursera
University of Colorado System

Business Intelligence Concepts, Tools, and Applications (Coursera)

This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You’ll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards.

Nov 23rd 2026
5-12 Weeks
Snowflake - SnowPro Core Certification Preparation (Coursera) Coursera
Board Infinity

Snowflake - SnowPro Core Certification Preparation (Coursera)

"Snowflake - SnowPro Core Certification Preparation" is a comprehensive course meticulously crafted to guide learners through the essentials of Snowflake, preparing them for the SnowPro Core Certification. Spanning three modules, the course begins with the fundamentals of Snowflake, exploring its architecture, data loading, and modeling. The second module delves into operational and management aspects, including account management, performance optimization, and security.

Dec 7th 2026
3 Weeks
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Nov 30th 2026
5-12 Weeks
Fundamentals of Data Warehousing (Coursera) Coursera
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.

Nov 23rd 2026
3 Weeks
Digital Manufacturing & Design (Coursera) Coursera
University at Buffalo,The State University of New York

Digital Manufacturing & Design (Coursera)

This course will expose you to the transformation taking place, throughout the world, in the way that products are being designed and manufactured. The transformation is happening through digital manufacturing and design (DM&D) – a shift from paper-based processes to digital processes in the manufacturing industry. By the end of this course, you’ll understand what DMD is and how it is impacting careers, practices and processes in companies both large and small.

Nov 23rd 2026
2 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 23rd 2026
4 Weeks
Predictive Modeling and Analytics (Coursera) Coursera
University of Colorado Boulder

Predictive Modeling and Analytics (Coursera)

Welcome to the second course in the Data Analytics for Business specialization! This course will introduce you to some of the most widely used predictive modeling techniques and their core principles. By taking this course, you will form a solid foundation of predictive analytics, which refers to tools and techniques for building statistical or machine learning models to make predictions based on data. You will learn how to carry out exploratory data analysis to gain insights and prepare data for predictive modeling, an essential skill valued in the business.

Nov 23rd 2026
4 Weeks