Data Warehouses, Data Marts, and Data Lakes-An Introduction to Data Warehouses, Data Marts, and Data Lakes
Course Introduction
Data Warehouse Overview
()
Popular Data Warehouse Systems
()
Selecting a Data Warehouse System
()
[OPTIONAL] IBM Db2 Warehouse
()
Data Marts Overview
()
Data Lakes Overview
()
Data Lakehouses Explained
()
Summary & Highlights
Designing, Modeling and Implementing Data Warehouses-Designing, Modeling and Implementing Data Warehouses
Overview of Data Warehouse Architectures
()
Cubes, Rollups, and Materialized Views and Tables
()
Grouping Sets in SQL
Facts and Dimensional Modeling
()
Data Modeling using Star and Snowflake Schemas
()
Data Warehousing with Star and Snowflake schemas
Staging Areas for Data Warehouses
()
Verify Data Quality
()
Populating a Data Warehouse
()
Querying the Data
()
Summary & Highlights
Data Warehouse Analytics-Data Warehouse Analytics
Introduction to Analytics and Business Intelligence (BI) Tools
()
Cognos Analytics: Introduction and How to Sign Up
()
Navigating in Cognos Analytics
()
Creating a Simple Dashboard in Cognos
()
Advanced Capabilities in Cognos Analytics Dashboards
()
Accessing Your Warehouse With Cognos
()
Summary & Highlights
Final Assignment and Final Quiz-Final Assignment
Project Overview
Final Assignment and Final Quiz-Course Wrap-up
Team & Acknowledgements
Congrats & Next Steps