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
- 62 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 | CU DenverCoursera |
Data Warehouse Concepts Design and Data Integration Fees Structure
Type | Fees in INR |
| Data Warehouse concepts, Design, and Data Integration (audit only) | Free |
| 1 month (20+ hours/week) | Rs. 4,115/- |
| 3 month (20+ hours/week) | Rs. 8,230/- |
| 6 month (14 hours/week) | Rs. 12,345/- |
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
- 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
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
- Get help and meet other learners in this course. Join your discussion forums!
- 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 database software requirements and installation
- Pentaho Data Integration installation (Windows + Mac)
- PDI Installation Problems (Mac + Windows)
- Optional textbook reading material
Assignment
- 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
Assignments
- Concept quiz for Module 2
- 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
Assignments
- 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
Assignments
- 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
Assignments
- 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)
For foreign students, apart from English subtitles are available in Spanish, Russian, and French. Subtitles would provide support to the participants while learning.
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.
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.
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.
The instructor is Michael Mannino who is an Associate Professor at Business School, University of Colorado, Denver.