- Data Warehouse Overview
- Popular Data Warehouse Systems
- Selecting a Data Warehouse System
- IBM Db2 Warehouse (Optional)
- Data Marts Overview
- Data Lakes Overview
Intermediate
Online
4 Weeks
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
certificate availability
certificate providing authority
The syllabus
Week 1: Data Warehouses, Data Marts, and Data Lakes
Videos
Readings
- Course Introduction
- Summary & Highlights
Practice Exercises
- Practice Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes
- Graded Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes
Week 2: Designing, Modeling and Implementing Data Warehouses
Videos
- Overview of Data Warehouse Architectures
- Cubes, Rollups, and Materialized Views and Tables
- Facts and Dimensional Modeling
- Data Modeling using Star and Snowflake Schemas
- Staging Areas for Data Warehouses
- Verify Data Quality
- Populating a Data Warehouse
- Querying the Data
Readings
- Grouping Sets in SQL
- Data Warehousing with Star and Snowflake schemas
- Summary & Highlights
Practice Exercises
- Practice Quiz: Designing, Modeling and Implementing Data Warehouses
- Graded Quiz: Designing, Modeling and Implementing Data Warehouses
Week 3: Data Warehouse Analytics
Videos
- 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
Readings
- Summary & Highlights
Practice Exercises
- Practice Quiz: Data Warehouse Analytics
- Graded Quiz: Data Warehouse Analytics
Week 4: Final Assignment and Final Quiz
Readings
- Project Overview
- Team & Acknowledgements
- Congrats & Next Steps
Practice Exercise
- Final Quiz
Instructors
Mr Rav Ahuja
Global Program Director
IBM
B.E /B.Tech, MBA
Mr Ramesh Sannareddy
Instructor
IBM
Other Bachelors
Articles
Popular Articles
Latest Articles
Courses of your interest
Business Models for Innovative Care for Older Peop...
University of Copenhagen via Coursera
Leadership in Interprofessional Informatics
University of Minnesota, Minneap... via Coursera
How Artificial Intelligence Can Support Healthcare
University of Groningen, Groningen via Futurelearn
How to Create and Implement a Business Strategy
Coventry University, Coventry via Futurelearn
How to Become an Entrepreneur from Design Thinking...
Coventry University, Coventry via Futurelearn
Systems Thinking for Sustainability Complex System...
Except Integrated Sustainability via Futurelearn
Project Management and its Role in Effective Busin...
Coventry University, Coventry via Futurelearn
Quality Improvement in Healthcare the Case for Cha...
University of Bath, Bath via Futurelearn
Coaching Skills Sports Coaching and Leadership
Deakin University, Melbourne via Futurelearn
More Courses by IBM
AI Applications With Watson
IBM via Edx
Python for Data Science Project
IBM via Edx
Site Reliability Engineering Capstone
IBM via Edx
Blockchain Framework and Platforms
IBM via Edx
Introduction to System Programming on IBM Z
IBM via Edx
Smarter Chatbots with Node RED and Watson AI
IBM via Edx
Application Development using Microservices and Se...
IBM via Coursera
IBM Data Topology
IBM via Coursera