Acerca de este Curso
36,809 vistas recientes

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Aprox. 18 horas para completar

Sugerido: 6 hours/week...

Inglés (English)

Subtítulos: Inglés (English)

Habilidades que obtendrás

Extraction, Transformation And Loading (ETL)PentahoData IntegrationData Warehouse

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Aprox. 18 horas para completar

Sugerido: 6 hours/week...

Inglés (English)

Subtítulos: Inglés (English)

Programa - Qué aprenderás en este curso

Semana
1
4 horas para completar

Data Warehouse Concepts and Architectures

8 videos (Total 53 minutos), 15 readings, 1 quiz
8 videos
Motivation and characteristics video lecture8m
Learning effects for data warehouse development video lecture9m
Data warehouse architectures and maturity video lecture10m
Data Warehouse Examples video lecture9m
Employment opportunities video lecture6m
15 lecturas
Powerpoint lecture notes for lesson 110m
Optional textbook10m
Powerpoint lecture notes for lesson 210m
Powerpoint lecture notes for lesson 310m
Powerpoint lecture notes for lesson 410m
Powerpoint lecture notes for lesson 510m
Powerpoint lecture notes for lesson 610m
Powerpoint lecture notes for lesson 710m
Overview of software requirements10m
Pivot4J installation10m
Pentaho Data Integration installation10m
Overview of database software installation10m
Oracle installation notes10m
Making connections to a local Oracle database10m
Optional textbook reading material10m
1 ejercicios de práctica
Module 1 quiz30m
Semana
2
3 horas para completar

Multidimensional Data Representation and Manipulation

8 videos (Total 50 minutos), 9 readings, 1 quiz
8 videos
Microsoft MDX statements video lecture6m
Overview of Pivot4J video lecture6m
Overview of WebPivotTable video lecture4m
WebPivotTable software demonstration5m
Pivot4J software demonstration video lecture4m
9 lecturas
Powerpoint lecture notes for lesson 110m
Powerpoint lecture notes for lesson 210m
Powerpoint lecture notes for lesson 310m
Powerpoint lecture notes for lesson 410m
Powerpoint lecture notes for lesson 510m
Powerpoint lecture notes for lesson 610m
Optional textbook reading material10m
Pentaho Pivot4J tutorial10m
WebPivotTable Tutorial10m
1 ejercicios de práctica
Module 2 quiz20m
4 horas para completar

Multidimensional Data Representation and Manipulation: Lesson Choices

4 quizzes
2 ejercicios de práctica
Quiz for module 2 assignment - WebPivotTable
Quiz for module 2 assignment - Pivot4J26m
Semana
3
4 horas para completar

Data Warehouse Design Practices and Methodologies

6 videos (Total 47 minutos), 8 readings, 2 quizzes
6 videos
Summarizability patterns for dimension-fact relationships video lecture6m
Mini case for data warehouse design video lecture8m
Data warehouse design methodologies video lecture8m
8 lecturas
Powerpoint lecture notes for lesson 110m
Powerpoint lecture notes for lesson 210m
Powerpoint lecture notes for lesson 310m
Powerpoint lecture notes for lesson 410m
Powerpoint lecture notes for lesson 510m
Powerpoint lecture notes for lesson 610m
Practice problems for module 310m
Optional textbook reading material10m
1 ejercicios de práctica
Module 3 quiz20m
Semana
4
2 horas para completar

Data Integration Concepts, Processes, and Techniques

6 videos (Total 48 minutos), 7 readings, 1 quiz
6 videos
Pattern matching with regular expressions video lecture9m
Matching and consolidation video lecture8m
Quasi identifiers and distance functions for entity matching video lecture7m
7 lecturas
Powerpoint lecture notes for lesson 110m
Powerpoint lecture notes for lesson 210m
Powerpoint lecture notes for lesson 310m
Powerpoint lecture notes for lesson 410m
Powerpoint lecture notes for lesson 510m
Powerpoint lecture notes for lesson 610m
Optional reading material10m
1 ejercicios de práctica
Module 4 quiz30m
4.4
145 revisionesChevron Right

17%

comenzó una nueva carrera después de completar estos cursos

23%

consiguió un beneficio tangible en su carrera profesional gracias a este curso

20%

consiguió un aumento de sueldo o ascenso

Principales revisiones sobre Data Warehouse Concepts, Design, and Data Integration

por 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.

por 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

Instructores

Avatar

Michael Mannino

Associate Professor
Business School, University of Colorado Denver

Acerca de Sistema Universitario de Colorado

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....

Acerca de Programa especializado 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

Preguntas Frecuentes

  • Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.

  • Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.