Data Warehouse Concepts, Design, and Data Integration

Full Details
Level
Price
Common Core
Images
No items found.

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

Full Details
Formats: 
Part of resource: 
Posted 
Mar 2023
This resource has religious influence.

Similar resources

Harness Business Data
Harness Business Data
College
Business Intelligence Concepts, Tools, and Applications
Business Intelligence Concepts, Tools, and Applications
College

About University of Colorado System

The University of Colorado plays a profound role in the lives of individuals, businesses and communities throughout Colorado, across the country and around the world. More than a half million alumni are leaders in business, science, the arts, health care and their communities, and they’re joined by some 15,000 more each year. In Aurora, Boulder, Colorado Springs and Denver, all four campuses are all for Colorado.

More by University of Colorado System

thumbnail
Beginning Game Programming with C#
Beginning Game Programming with C#
College
thumbnail
Fundamentals of Global Energy Business
Fundamentals of Global Energy Business
College
thumbnail
Harness Business Data
Harness Business Data
College
thumbnail
Business Intelligence Concepts, Tools, and Applications
Business Intelligence Concepts, Tools, and Applications
College
thumbnail
Database Management Essentials
Database Management Essentials
College
thumbnail
Foundations for Global Health Responders
Foundations for Global Health Responders
College