このコースについて
31,674

100%オンライン

自分のスケジュールですぐに学習を始めてください。

柔軟性のある期限

スケジュールに従って期限をリセットします。

約18時間で修了

推奨:6 hours/week...

英語

字幕:英語

習得するスキル

Extraction, Transformation And Loading (ETL)PentahoData IntegrationData Warehouse

100%オンライン

自分のスケジュールですぐに学習を始めてください。

柔軟性のある期限

スケジュールに従って期限をリセットします。

約18時間で修了

推奨:6 hours/week...

英語

字幕:英語

シラバス - 本コースの学習内容

1
4時間で修了

Data Warehouse Concepts and Architectures

Module 1 introduces the course and covers concepts that provide a context for the remainder of this course. In the first two lessons, you’ll understand the objectives for the course and know what topics and assignments to expect. In the remaining lessons, you will learn about historical reasons for development of data warehouse technology, learning effects, business architectures, maturity models, project management issues, market trends, and employment opportunities. This informational module will ensure that you have the background for success in later modules that emphasize details and hands-on skills.You should also read about the software requirements in the lesson at the end of module 1. I recommend that you try to install the software this week before assignments begin in week 2....
8件のビデオ (合計53分), 15 readings, 1 quiz
8件のビデオ
Course objectives video lecture4 分
Course topics and assignments video lecture4 分
Motivation and characteristics video lecture8 分
Learning effects for data warehouse development video lecture9 分
Data warehouse architectures and maturity video lecture10 分
Data Warehouse Examples video lecture9 分
Employment opportunities video lecture6 分
15件の学習用教材
Powerpoint lecture notes for lesson 110 分
Optional textbook10 分
Powerpoint lecture notes for lesson 210 分
Powerpoint lecture notes for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Powerpoint lecture notes for lesson 610 分
Powerpoint lecture notes for lesson 710 分
Overview of software requirements10 分
Pivot4J installation10 分
Pentaho Data Integration installation10 分
Overview of database software installation10 分
Oracle installation notes10 分
Making connections to a local Oracle database10 分
Optional textbook reading material10 分
1の練習問題
Module 1 quiz30 分
2
3時間で修了

Multidimensional Data Representation and Manipulation

Now that you have the informational context for data warehouse development, you’ll start using data warehouse tools! In module 2, you will learn about the multidimensional representation of a data warehouse used by business analysts. You’ll apply what you’ve learned in practice and graded problems using WebPivotTable or Pivot4J, open source tools for manipulating pivot tables. At the end of this module, you will have solid background to communicate and assist business analysts who use a multidimensional representation of a data warehouse....
7件のビデオ (合計45分), 9 readings, 1 quiz
7件のビデオ
Data cube operators video lecture6 分
Overview of Microsoft MDX video lecture6 分
Microsoft MDX statements video lecture6 分
Overview of Pivot4J video lecture6 分
Overview of WebPivotTable video lecture4 分
Pivot4J software demonstration video lecture5 分
9件の学習用教材
Powerpoint lecture notes for lesson 110 分
Powerpoint lecture notes for lesson 210 分
Powerpoint lecture notes for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Powerpoint lecture notes for lesson 610 分
Optional textbook reading material10 分
Pentaho Pivot4J tutorial10 分
WebPivotTable Tutorial10 分
1の練習問題
Module 2 quiz20 分
4時間で修了

Multidimensional Data Representation and Manipulation: Lesson Choices

Choice 1: If completing this assignment, you should also complete the WebPivotTable quiz. | Choice 3: If completing this assignment, you should also complete the Pivot4J quiz....
4 quizzes
2の練習問題
Quiz for module 2 assignment - WebPivotTable
Quiz for module 2 assignment - Pivot4J26 分
3
4時間で修了

Data Warehouse Design Practices and Methodologies

This module emphasizes data warehouse design skills. Now that you understand the multidimensional representation used by business analysts, you are ready to learn about data warehouse design using a relational database. In practice, the multidimensional representation used by business analysts must be derived from a data warehouse design using a relational DBMS.You will learn about design patterns, summarizability problems, and design methodologies. You will apply these concepts to mini case studies about data warehouse design. At the end of the module, you will have created data warehouse designs based on data sources and business needs of hypothetical organizations....
6件のビデオ (合計47分), 8 readings, 2 quizzes
6件のビデオ
Table design patterns video lecture8 分
Summarizability patterns for dimension tables video lecture6 分
Summarizability patterns for dimension-fact relationships video lecture6 分
Mini case for data warehouse design video lecture8 分
Data warehouse design methodologies video lecture8 分
8件の学習用教材
Powerpoint lecture notes for lesson 110 分
Powerpoint lecture notes for lesson 210 分
Powerpoint lecture notes for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Powerpoint lecture notes for lesson 610 分
Practice problems for module 310 分
Optional textbook reading material10 分
1の練習問題
Module 3 quiz20 分
4
2時間で修了

Data Integration Concepts, Processes, and Techniques

Module 4 extends your background about data warehouse development. After learning about schema design concepts and practices, you are ready to learn about data integration processing to populate and refresh a data warehouse. The informational background in module 4 covers concepts about data sources, data integration processes, and techniques for pattern matching and inexact matching of text. Module 4 provides a context for the software skills that you will learn in module 5. ...
6件のビデオ (合計48分), 7 readings, 1 quiz
6件のビデオ
Change data concepts video lecture7 分
Data cleaning tasks video lecture5 分
Pattern matching with regular expressions video lecture9 分
Matching and consolidation video lecture8 分
Quasi identifiers and distance functions for entity matching video lecture7 分
7件の学習用教材
Powerpoint lecture notes for lesson 110 分
Powerpoint lecture notes for lesson 210 分
Powerpoint lecture notes for lesson 310 分
Powerpoint lecture notes for lesson 410 分
Powerpoint lecture notes for lesson 510 分
Powerpoint lecture notes for lesson 610 分
Optional reading material10 分
1の練習問題
Module 4 quiz30 分
4.4
142件のレビューChevron Right

20%

コース終了後に新しいキャリアをスタートした

27%

コースが具体的なキャリアアップにつながった

22%

昇給や昇進につながった

人気のレビュー

by EKDec 16th 2015

Very nice class, well thought out and organized. The assignments are interesting and the practice assignments are relevant. Getting hands on on Pentaho was a big plus.

by MHDec 13th 2016

Good learning for Data integration and ETL learning. How data from source to target table transform over the business requirement to be ready for processing

講師

Avatar

Michael Mannino

Associate Professor
Business School, University of Colorado Denver

University of Colorado Systemについて

The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond....

Data Warehousing for Business Intelligenceの専門講座について

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience....
Data Warehousing for Business Intelligence

よくある質問

  • 修了証に登録すると、すべてのビデオ、テスト、およびプログラミング課題(該当する場合)にアクセスできます。ピアレビュー課題は、セッションが開始してからのみ、提出およびレビューできます。購入せずにコースを検討することを選択する場合、特定の課題にアクセスすることはできません。

  • コースに登録する際、専門講座のすべてのコースにアクセスできます。コースの完了時には修了証を取得できます。電子修了証が成果のページに追加され、そこから修了証を印刷したり、LinkedInのプロフィールに追加したりできます。コースの内容の閲覧のみを希望する場合は、無料でコースを聴講できます。

さらに質問がある場合は、受講者向けヘルプセンターにアクセスしてください。