Data Warehousing Capstone Project

Data Warehousing Capstone Project

This course is part of IBM Data Warehouse Engineer Professional Certificate

Instructors: Rav Ahuja

Access provided by Lok Jagruti University

3,108 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

24 reviews

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

24 reviews

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Demonstrate proficiency in skills required for an entry-level data warehouse engineering role.
Design and implement various concepts and components in the data warehouse engineering lifecycle such as data repositories.
Showcase working knowledge with relational databases, data warehouses, and data pipelines.
You can use your expertise in Linux shell scripting, SQL, and business intelligence Cognos dashboard design, to tackle data warehousing problems.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 assignments¹

AI Graded see disclaimer

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Management expertise

This course is part of the IBM Data Warehouse Engineer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from IBM

There are 5 modules in this course

In this course you will apply a variety of data warehouse engineering skills and techniques you have learned as part of the previous courses in the IBM Data Warehouse Engineer Professional Certificate. You will assume the role of a Junior Data Engineer who has recently joined the organization and be presented with a real-world use case that requires a data warehouse engineering solution.

In this module, you will design a data platform that uses MySQL as an OLTP database. You will be using MySQL to store the OLTP data.

What's included

2 videos2 assignments1 app item2 plugins

2 videos Total 6 minutes

Introduction to Capstone Project 4 minutes
Assignment Overview: OLTP Database 2 minutes

2 assignments Total 36 minutes

Checklist: OLTP Database 24 minutes
Graded Quiz: OLTP Database 12 minutes

1 app item Total 30 minutes

Lab: OLTP Database 30 minutes

2 plugins Total 10 minutes

Data Platform Architecture 5 minutes
OLTP Database Requirements and Design 5 minutes

In this module you will design and implement a data warehouse and you will then generate reports from the data in the data warehouse.

What's included

2 videos1 reading3 assignments3 app items1 plugin

2 videos Total 4 minutes

Assignment Overview: Data Warehouse Design & Setup 2 minutes
Assignment Overview: Data Warehouse Reporting 2 minutes

1 reading Total 1 minute

Optional Lab Information 1 minute

3 assignments Total 69 minutes

Checklist: Data Warehousing 15 minutes
Checklist: Data Warehouse Reporting 24 minutes
Graded Quiz: Build a Data Warehouse 30 minutes

3 app items Total 180 minutes

Hands-on Lab: Data Warehousing 60 minutes
Hands-on Lab: Data Warehouse Reporting using PostgreSQL 60 minutes
(Optional) Obtain IBM Cloud Feature Code and Activate Trial Account 60 minutes

1 plugin Total 30 minutes

(Optional) Hands-on Lab: Data Warehouse Reporting using DB2 30 minutes

In this module, you will assume the role of a data engineer at an e-commerce company. Your company has finished setting up a data warehouse. Now you are assigned the responsibility to design a reporting dashboard that reflects the key metrics of the business.

What's included

1 video5 readings2 assignments5 plugins

1 video Total 1 minute

Assignment Overview 1 minute

5 readings Total 42 minutes

(Optional): About this optional lesson with Looker Studio 2 minutes
(Optional) : Getting Started with Google Looker Studio 10 minutes
(Optional): Creating Visualizations in Reports using Looker Studio 10 minutes
(Optional) : Summary and Highlights 10 minutes
Final Assignment Overview 10 minutes

2 assignments Total 27 minutes

Checklist: Dashboard Creation 12 minutes
Graded Quiz: Dashboard Creation 15 minutes

5 plugins Total 195 minutes

(Optional):Hands-on Lab: Getting Started with Google Looker Studio 60 minutes
(Optional): Hands-on Lab: Creating and Configuring Visualizations in Reports with Google Looker Studio 60 minutes
(Optional) Hands-on Lab: Advanced charts in Looker Studio 15 minutes
Final Assignment Part A: Dashboard Creation using IBM Cognos Analytics 30 minutes
Final Assignment Part B: Dashboard Creation using Google Looker Studio 30 minutes

In this module, you will set up an ETL process using a Shell script to extract new transactional data for each day from the MySQL database and load it into the staging data warehouse in PostgreSQL. Later you will perform the transformation on the table in the staging warehouse to load the data in a dimension table and a fact table. You will then export these tables as CSV files to the production warehouse. You will set up a Cron Job to schedule these tasks.

What's included

1 video1 reading2 assignments1 app item1 plugin

1 video Total 2 minutes

Assignment Overview: ETL & Data Pipelines 2 minutes

1 reading Total 10 minutes

Formatting Functions in PostgreSQL 10 minutes

2 assignments Total 36 minutes

Checklist: ETL 6 minutes
Graded Quiz: ETL with MySQL, PostgreSQL, and Bash 30 minutes

1 app item Total 30 minutes

Hands-on Lab: ETL with MySQL, PostgreSQL, and Bash 30 minutes

1 plugin Total 15 minutes

Assignment Overview: ETL with MySQL, PostgreSQL, and Bash 15 minutes

In this final module, you will complete your submission of screenshots from the hands-on labs for your peers to review. Once you have completed your submission you will then review the submission of one of your peers and grade their submission.