Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure

Quick Facts

Medium Of Instructions	Mode Of Learning	Mode Of Delivery
English	Self Study	Video and Text Based

Course Overview

Along with the University of Colorado, Coursera has created Data Warehouse concepts, design, and data integration for working professionals involved in software engineering or business analytics. Through this programme, the candidates would come across theory and ability for drafting data warehouses and constructing data integration workflows. These are some prominent skills required for data warehouse administrators and developers. The candidates will get firsthand experience in designing a data warehouse and utilizing open-source resources for operating pivot tables and drafting data integration workflows.

This programme is recommended to professionals involved in information or business technology and aspires to become a data warehouse administrator or designer. The participants would gain knowledge about architectures, maturity models, management practices, and multidimensional models that provide an organizational view regarding data warehouse development. To complete the graded assignments, they can either use Oracle, PostgreSQL, or MySQL. Through this course, the candidate would construct data integration workflows and data warehouse designs to convince the business intelligence requirement in an organization.

The Highlights

Offered by University of Colorado System
Certification by Coursera
57 hours of course duration approximately
Availability to access in diversified languages subtitles

Programme Offerings

online
Quiz
assignments
project work
Practice Exercises

Courses and Certificate Fees

Certificate Availability	Certificate Providing Authority
yes	Coursera

Application Fee

Type	Fees in INR
Data Warehouse concepts, Design, and Data Integration (audit only)	Free
Data Warehouse concepts, Design, and Data Integration	Rs. 4,023/-
Data Warehouse concepts, Design, and Data Integration	Rs. 8,046/-
Data Warehouse concepts, Design, and Data Integration	Rs. 12,069/-

Eligibility Criteria

Education

The programme can only be applied by candidates who have completed the first four courses in Advanced Styling with Responsive Design, Interactivity with JavaScript, Introduction to CSS3 and Web Design for Everybody specialization: Introduction to HTML5

Certification Qualifying Details

To achieve the certificate, the candidate must have completed the programme and paid the fees as well.

What you will learn

Knowledge of Data Sorting

The participants would be able to estimate the organization’s business architecture alignment and data warehouse maturity.
They will learn to reflect on the role of refresh frequency trade-offs, change data, refresh constraints, and data quality goals in data integration process design.
By utilizing eminent open source software, they can draft data integration workflows.

Who it is for

Data ScientistBusiness AnalystData Engineer

Admission Details

To apply for Data Warehouse concepts, design, and data integration programme:

Step 1: Visit the Course page. https://www.coursera.org/learn/dwdesign

Step 2: Look for ‘Enroll for Free’ button and fill in the required details

Step 3: You will get a 7-day free trial. If you wish to continue after 7 days continue, otherwise cancel the admission.

Step 4: If you want to get full access to the course and earn the certificate, purchase the plan by entering billing details and choose a payment method.

Step 5: Once the transaction is complete, the candidate would receive a notification regarding enrollment.

The Syllabus

Videos

Course introduction video lecture
Course objectives video lecture
Course topics and assignments video lecture
Motivation and characteristics of video lecture
Learning effects for data warehouse development video lecture
Data warehouse architectures and maturity video lecture
Data Warehouse Examples video lecture
Employment opportunities video lecture

Readings

Powerpoint lecture notes for lesson 1
Optional textbook
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
Powerpoint lecture notes for lesson 6
Powerpoint lecture notes for lesson 7
Overview of software requirements
Pentaho Data Integration installation
Overview of database software installation
Oracle installation notes
Making connections to a local Oracle database
Optional textbook reading material

Practice Exercise

Concept quiz for Module 1

Videos

Data cube representation video lecture
Data cube operators video lecture
Overview of Microsoft MDX video lecture
Microsoft MDX statements video lecture
Overview of WebPivotTable video lecture
WebPivotTable software demonstration

Readings

Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
WebPivotTable Tutorial
Optional textbook reading material
Module 2 Assignment
Solution for the WebPivotTable assignment in Module 2

Practice Exercises

Module 2 quiz
Quiz for module 2 assignment - WebPivotTable

Videos

Relational database concepts for multidimensional data video lecture
Table design patterns video lecture
Summarizability patterns for dimension tables video lecture
Summarizability patterns for dimension-fact relationships video lecture
Schema integration video lesson
Data warehouse design methodologies video lecture
Mini case for data warehouse design video lecture

Readings

Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
Powerpoint lecture notes for lesson 6
Powerpoint lecture notes for lesson 7
Mini Case Study and Solution
Optional textbook reading material
Module 3 Assignment
Self-Evaluation for the Module 3 Assignment

Practice exercise

Concept quiz for Module
Reflective Quiz for the Module 3 Assignment

Videos

Concepts of data integration processes video lecture
Change data concepts video lecture
Data cleaning tasks video lecture
Pattern matching with regular expressions video lecture
Matching and consolidation video lecture
Quasi identifiers and distance functions for entity matching video lecture
SQL for data integration video lesson

Readings

Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Powerpoint lecture notes for lesson 5
Powerpoint lecture notes for lesson 6
Powerpoint lecture notes for lesson 7
Optional reading material
Module 4 assignment
Self evaluation for the Module 4 assignment

Practice Exercise

Concept quiz for Module 4
Reflective Quiz for the Module 4 assignment
Quiz for the Module 4 assignment

Videos

Architectures and marketplace video lecture
Common features of data Integration tools video lecture
Talend Open Studio video lecture
Pentaho Data Integration video lecture
Software video demonstration for Pentaho Data Integration
Course conclusion video lecture

Readings

Powerpoint lecture notes for lesson 1
Powerpoint lecture notes for lesson 2
Powerpoint lecture notes for lesson 3
Powerpoint lecture notes for lesson 4
Optional reading material
Guided tutorial for Pentaho Data Integration
Documents for the module 5 assignment
Self-Evaluation for the Module 5 Assignment

Practice exercises

Concept quiz for Module 5
Reflective quiz for the Module 5 assignment
Quiz for Module 5 assignment

Instructors

CU Denver Frequently Asked Questions (FAQ's)

1: In what languages subtitles are available?

For foreign students, apart from English subtitles are available in Spanish, Russian, and French. Subtitles would provide support to the participants while learning.

2: What is included in 7-days free trial?

7-days free trial includes the following benefits:

Unlimited access to study materials including lectures, assignments, discussion forums, etc.
Candidates can cancel the subscription anytime without any penalties before the trial ends.

3: When can I get complete access to the study materials?

The access to study materials and graded assignments would depend upon the mode of enrollment of the candidate. In case, the candidate selects audit mode, they can have access to the study materials and graded assignments for free of cost. However, they have to pay to acquire the certificate.

4: What is the benefit of completing Data Warehouse concepts, design, and data integration programme?

On completing the programme, the candidate would be able to populate, architect, and build a data warehouse to link up with real-world business reporting.

5: Who is the instructor?

The instructor is Michael Mannino who is an Associate Professor at Business School, University of Colorado, Denver.