For over twenty years, data warehouses have served organizations in the areas of data integration, provisioning, management, and information delivery. Use cases ranging from basic reporting to advanced analytics have been successfully implemented across a variety of industries by companies of many different sizes. Due to rapid growth of non-traditional data sources, availability of new technologies and growing expectations of managers to compete on analytics, the traditional data warehouse is re-defined and presented within a broader modern context. A corporate data ecosystem is evolving and presents new opportunities for creating business capabilities that were not previously possible. Amidst these changes, the data warehouse continues to play foundational and integral roles within the expanding data landscape.

This 4.5 hour online course re-defines the scope of the “modern” data warehouse. The need for planning and the role of architecture are described and clarified, followed by a discussion about the challenges related to gathering useful information requirements. This is followed by a discussion of design approaches, development, testing and quality management techniques.

The true value delivered to the organization by a data warehouse depends on operational and service activities that leverage the data components previously implemented. It is through this combination of data and technology assets with managed operations and services that desired analytical and business capabilities are created. The design and implementation approaches of operations and services are provided to highlight this key requirement. The course material presents a full life cycle of the data warehouse including business context, scope, requirements, design, implementation and operations.

• The components that define a data warehouse platform
• What trends impact the modern data warehouse
• To position the data warehouse platform in the big data era
• Architectural options and considerations
• Development options and approaches
• The requirements gathering process
• Necessary design activities
• How operations and service processes enable business capabilities

• Data warehousing program and project managers
• Data warehouse architects
• Data scientists and analytics professionals
• Big Data practitioners
• Data warehouse designers and developers
• Data warehouse maintenance and support specialists
• Data integration and management practitioners
• Anyone who is new to data warehousing