Buy Now AED 239.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Data Warehouse Concepts, Design, and Data Integration
  • Level Foundation
  • Duration 62 hours
  • Course by University of Colorado System
  • Offered by

About

This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows. In the data integration assignment, you can use either Oracle, MySQL, or PostgreSQL databases. You will also gain conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience, software background, and organizational context that prepares you to succeed with data warehouse development projects. In this course, you will create data warehouse designs and data integration workflows that satisfy the business intelligence needs of organizations. When you're done with this course, you'll be able to: * Evaluate an organization for data warehouse maturity and business architecture alignment; * Create a data warehouse design and reflect on alternative design methodologies and design goals; * Create data integration workflows using prominent open source software; * Reflect on the role of change data, refresh constraints, refresh frequency trade-offs, and data quality goals in data integration process design; and * Perform operations on pivot tables to satisfy typical business analysis requests using prominent open source software

Modules

Course Introduction

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course introduction video lecture

1 Readings

  • Get help and meet other learners in this course. Join your discussion forums!

Course objectives

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course objectives video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Course topics and assignments

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Course topics and assignments video lecture

2 Readings

  • Optional textbook
  • Powerpoint lecture notes for lesson 2

Motivation and characteristics

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Motivation and characteristics video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Learning effects for data warehouse development

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Learning effects for data warehouse development video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Data warehouse architectures and maturity

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data warehouse architectures and maturity video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Data Warehouse Examples

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data Warehouse Examples video lecture

1 Readings

  • Powerpoint lecture notes for lesson 6

Employment opportunities

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Employment opportunities video lecture

1 Readings

  • Powerpoint lecture notes for lesson 7

Course software requirements

    • 3 Readings
Show info about module content

3 Readings

  • Overview of database software requirements and installation
  • Pentaho Data Integration installation (Windows + Mac)
  • PDI Installation Problems (Mac + Windows)

Quiz

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Concept quiz for Module 1

1 Readings

  • Optional textbook reading material

Data cube representation

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data cube representation video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Data cube operators

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data cube operators video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Overview of Microsoft MDX

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Overview of Microsoft MDX video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Microsoft MDX Statements

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Microsoft MDX statements video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Concepts and Practice with WebPivotTable

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Overview of WebPivotTable video lecture
  • WebPivotTable software demonstration

2 Readings

  • Powerpoint lecture notes for lesson 5
  • WebPivotTable Tutorial

Quiz and Assignment for WebPivotTable

    • 3 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept quiz for Module 2
  • Quiz for the module 2 assignment - WebPivotTable

3 Readings

  • Optional textbook reading material
  • Module 2 Assignment
  • Solution for the WebPivotTable assignment in Module 2

Relational database concepts for multidimensional data

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Relational database concepts for multidimensional data video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Table design patterns

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Table design patterns video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Summarizability patterns for dimension tables

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Summarizability patterns for dimension tables video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Summarizability patterns for dimension-fact relationships

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Summarizability patterns for dimension-fact relationships video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Schema integration process

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Schema integration video lesson

1 Readings

  • Powerpoint lecture notes for lesson 5

Data warehouse design methodologies

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data warehouse design methodologies video lecture

1 Readings

  • Powerpoint lecture notes for lesson 6

Mini case for data warehouse design

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Mini case for data warehouse design video lecture

2 Readings

  • Powerpoint lecture notes for lesson 7
  • Mini Case Study and Solution

Practice, Quiz and Assignment

    • 3 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept quiz for Module 3
  • Reflective Quiz for the Module 3 Assignment

3 Readings

  • Optional textbook reading material
  • Module 3 Assignment
  • Self-Evaluation for the Module 3 Assignment

Concepts of data integration processes

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Concepts of data integration processes video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Change data concepts

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Change data concepts video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Data cleaning tasks

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data cleaning tasks video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Pattern matching with regular expressions

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Pattern matching with regular expressions video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Matching and consolidation

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Matching and consolidation video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Quasi identifiers and distance functions for entity matching

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Quasi identifiers and distance functions for entity matching video lecture

1 Readings

  • Powerpoint lecture notes for lesson 6

SQL statements for data integration

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • SQL for data integration video lesson

1 Readings

  • Powerpoint lecture notes for lesson 7

Quiz and assignment

    • 3 Readings
    • 3 Assignment
Show info about module content

3 Assignment

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

3 Readings

  • Optional reading material
  • Module 4 assignment
  • Self evaluation for the Module 4 assignment

Architectures and marketplace

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Architectures and marketplace video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Common features of data integration tools

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Common features of data Integration tools video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Talend Open Studio

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Talend Open Studio video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Pentaho Data Integration

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • Pentaho Data Integration video lecture
  • Software video demonstration for Pentaho Data Integration

1 Readings

  • Powerpoint lecture notes for lesson 4

Quiz, Practice, and Assignment

    • 5 Readings
    • 3 Assignment
Show info about module content

3 Assignment

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

5 Readings

  • Optional reading material
  • Guided tutorial for Pentaho Data Integration
  • Module 5 assignment
  • Documents for the module 5 assignment
  • Self-Evaluation for the Module 5 Assignment

Course conclusion

    • 1 Videos
Show info about module content

1 Videos

  • Course conclusion video lecture

Auto Summary

Unlock the essentials of data warehousing with this foundational course on concepts, design, and data integration. Perfect for business and IT professionals aiming to become data warehouse designers or administrators, this course offers hands-on experience with data warehouse design, pivot tables, and integration workflows using Oracle, MySQL, or PostgreSQL. Guided by expert instructors over 3720 minutes, the course provides a deep dive into maturity models, architectures, and multidimensional models. Available via Coursera with various subscription options, it's ideal for those looking to advance their skills in business intelligence.

Michael Mannino
Instructor

Michael Mannino