Today’s businesses are investing heavily in capabilities to harness the massive amounts of data that fuel Business Intelligence (BI). Working knowledge of Data Warehouses and BI Analytics tools is a crucial skill for Data Engineers, Data Warehousing Specialists, and BI Analysts, making them some of the most valued resources for organizations.

This course equips you with the skills and hands-on experience to design, implement, and maintain enterprise data warehouse systems and business intelligence tools. You’ll gain extensive knowledge of various data repositories, including data marts, data lakes, and data reservoirs.

You'll explore data warehousing system architectures, deepen your understanding of data organization using related tables, and analyze data using business intelligence tools like Cognos Analytics, including its reporting, dashboard features, and interactive visualization capabilities.

The course includes hands-on practice labs and a real-world inspired project that can be added to your portfolio to demonstrate your proficiency in working with data warehouses. Skills you will gain include building data warehouses, Star/Snowflake schemas, CUBEs, ROLLUPs, Materialized Views/MQTs, reports, and BI dashboards.

What you will learn:

After completing this course, you will be able to:

Explain 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 query data using SQL to build CUBEs, ROLLUPs, and Materialized Views.
Analyze warehouse data using popular Business Intelligence (BI) tools such as Cognos Analytics to create reports and dashboards.
Demonstrate loading data into a data warehouse, writing aggregation queries, creating materialized query tables, and building an analytics dashboard.

Course Syllabus

Module 1 - Data Warehouses, Data Marts, and Data Lakes

Module Introduction and Learning Objectives
Data Warehouse Overview
Popular Data Warehouse Systems
Selecting a Data Warehouse System
Data Marts Overview
IBM Db2 Warehouse
Data Lakes Overview
Data Lakehouses Explained
Summary & Highlights
Practice Quiz
Graded Quiz

Module 2 - Designing, Modeling and Implementing Data Warehouses

Module Introduction and Learning Objectives
Overview of Data Warehouse Architectures
Cubes, Rollups, and Materialized Views and Tables
Grouping Sets in SQL
Facts and Dimensional Modeling
Hands-on Lab: Working with Facts and Dimension Tables
Data Modeling using Star and Snowflake Schemas
Data Warehousing with Star and Snowflake schemas
Staging Areas for Data Warehouses
Hands-on Lab: Setting up a Staging Area
Verify Data Quality
Hands-on Lab: Verifying Data Quality for a Data Warehouse
Populating a Data Warehouse
Hands-on Lab: Populating a Data Warehouse using PostgreSQL
Querying the Data
Hands-On Lab: Querying the Data Warehouse using PostgreSQL (Cubes, Rollups, Grouping Sets and Materialized Views)
Summary & Highlights
Practice Quiz
Graded Quiz

Module 3 - Data Warehouse Analytics

Module Introduction and Learning Objectives
Introduction to Analytics and Business Intelligence (BI) Tools
Cognos Analytics: Introduction and How to Sign Up
Navigating in Cognos Analytics
Hands-on Lab 4: Getting Started with Cognos Analytics
Creating a Simple Dashboard in Cognos
Hands-on Lab 5: Different Methods for Creating Dashboard Visualizations with Cognos Analytics
Advanced Capabilities in Cognos Analytics Dashboards
Hands-on Lab 6: Advanced Dashboard Capabilities in Cognos Analytics
Accessing Your Warehouse With Cognos
Hands-on Lab: Analyzing Data With Cognos Analytics.
Hands-on Lab: Analyzing Db2 Data With Cognos Analytics
Summary & Highlights
Practice Quiz: Data Warehouse Analytics
Graded Quiz: Data Warehouse Analytics

Module 4 - Final Assignment and Final Quiz

Module Introduction and Learning Objectives
Practice Project Overview
Practice Project: Introduction to Data Warehousing
Final Project Overview
Reading: Identify Requirements for your Analytics System
Final Assignment: Data Warehouse Fundamentals
Hands-on Lab: Final Assignment using PostgreSQL
Peer Review: Project Submission
Final Quiz

Module 5 - [Optional] Hands-on Labs using IBM Db2

About this optional Module
Obtain IBM Cloud Feature Code and Activate Trial Account
Hands-on Lab: Create Db2 service instance and Get started with the Db2 console
Hands-on Lab: Create Db2 Service Credentials
Hands-on Lab: Populating a Data Warehouse using IBM DB2
Hands-on Lab: Querying the Data Warehouse using IBM DB2 (Cubes, Rollups, Grouping Sets and Materialized Views)
Hands-on Lab: Final Assignment using IBM DB2

Course Wrap-up

Course Wrap up
Congratulations and Next Steps
Thanks from the Course Team
Copyrights and Trademarks
Course Rating and Feedback
Badge
Claim Your Badge
Badges FAQs

General Information

This course is self-paced.
This platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

Recommended Skills Prior to Taking this Course

Learners should have working knowledge of SQL and relational databases.

Data Warehouses and BI Analytics

Language

Topic

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update