Scribd
Upload
8 views7 pages

Course 2 Module 01 Lesson 2

The document outlines the objectives and structure of a Data Warehouse Concepts and Architectures course, detailing the course flow and topics covered across multiple modules. Key assignments include schema design, pivot table manipulation, and data integration workflows, utilizing open source tools. The course aims to balance theoretical concepts with practical software skills and management practices.

Uploaded by

protozoan75
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views7 pages

Course 2 Module 01 Lesson 2

The document outlines the objectives and structure of a Data Warehouse Concepts and Architectures course, detailing the course flow and topics covered across multiple modules. Key assignments include schema design, pivot table manipulation, and data integration workflows, utilizing open source tools. The course aims to balance theoretical concepts with practical software skills and management practices.

Uploaded by

protozoan75
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Information Systems Program

Module 1
Data Warehouse Concepts and Architectures

Lesson 2: Course topics and assignments


Lesson Objectives
• Understand course topics and course flow
• Understand assessments especially practice and graded
problems
• Obtain software

Information Systems Program


Course Topics
Data warehouse User
Data mart tier
server departments

Operational
database Staging Extraction
Area
process
Transformation
process

Operational Data mart


database

Detailed and
summarized data
EDM
External
data source Data warehouse
Data mart

Architectures Pivot Table Manipulation

Schema Design Data Integration 3

Information Systems Program


Course Flow
• Motivation and characteristics
• Architectures
Module • Project characteristics and maturity model
1 • Employment opportunities

• Multi-dimensional data model


• Microsoft MDX language
Module
2 • Pivot table tool practice

• Schema patterns and summarizability problems


• Schema integration practice
Module • Enterprise data warehouse development
3

• Data integration process concepts


• Change data characteristics
Module
4 • Data integration techniques

• Architectures and features of data integration tools


• Overview of Talend and Pentaho tools
Module
5 • Practice with Pentaho Data Integration
4

Information Systems Program


Assignments

Pivot Table Manipulation


Schema Integration

Data Integration Workflow 5

Information Systems Program


Tools

Information Systems Program


Summary
• Balance concepts, design, software skills, and
management practices
• Assignments for schema design, pivot table manipulation,
and data integration workflows
• Usage of open source tools for pivot table manipulation
and data integration workflows

Information Systems Program

You might also like