University of Colorado Boulder - Data Warehouse Concepts, Design, and Data Integration
5.0 /5- Offered byCoursera
Data Warehouse Concepts, Design, and Data Integration at Coursera Overview
Duration | 23 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Data Warehouse Concepts, Design, and Data Integration at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 2 of 5 in the Data Warehousing for Business Intelligence Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Approx. 23 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish
Data Warehouse Concepts, Design, and Data Integration at Coursera Course details
- 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
Data Warehouse Concepts, Design, and Data Integration at Coursera Curriculum
Data Warehouse Concepts and Architectures
Course introduction video lecture
Course objectives video lecture
Course topics and assignments video lecture
Motivation and characteristics 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
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 software requirements
Pivot4J installation
Pentaho Data Integration installation
Overview of database software installation
Oracle installation notes
Making connections to a local Oracle database
Optional textbook reading material
Module 1 quiz
Multidimensional Data Representation and Manipulation
Data cube representation video lecture
Data cube operators video lecture
Overview of Microsoft MDX video lecture
Microsoft MDX statements video lecture
Overview of Pivot4J video lecture
Overview of WebPivotTable video lecture
WebPivotTable software demonstration
Pivot4J software demonstration video lecture
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
Optional textbook reading material
Pentaho Pivot4J tutorial
WebPivotTable Tutorial
Module 2 quiz
Quiz for module 2 assignment - WebPivotTable
Quiz for module 2 assignment - Pivot4J
Data Warehouse Design Practices and Methodologies
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
Mini case for data warehouse design video lecture
Data warehouse design methodologies video lecture
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
Practice problems for module 3
Optional textbook reading material
Module 3 quiz
Data Integration Concepts, Processes,and Techniques
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
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
Optional reading material
Module 4 quiz
Architectures, Features, and Details of Data Integration Tools
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
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
Module 5 quiz
Quiz for module 5 assignment
Data Warehouse Concepts, Design, and Data Integration at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Data Warehouse Concepts, Design, and Data Integration at Coursera Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?
Data ScienceData Science BasicsData ExplorationData Warehouse Concepts, Design, and Data Integration