This two day workshop helps experienced DW/BI developers gain architectural understanding and start applying the principles in their environment from next day.

What is Architecture

       What is Architecture

       Architecture Snapshot Views

       Trends and Landscape Changes

       Impact on Business Decision Life Cycle

Architecture Principles

       Architecture Drivers and Trade Offs

       Architecture Principles and Considerations

       Dimensions of Architecture Performance

       Origination of Architectural Challenges

       Typical Challenges

Work-Sheet: Two Architecture Principles I have applied in my environment

Typical User and IT Challenges in a DW environment

       Typical Business Challenges

       Business User Challenges

       IT and Technology Challenges

       Systemic Complexities and Challenges

Work-Sheet: Challenges and Issues in my work environment

DW Project Life Cycle:

       Business Outcomes: Metrics and KPIs

       Design and Deployment Methodologies

       Execution Approaches

DW Architectural Considerations / Decision Factors

       Context: DW Architecture Framework

       Origination of Architectural Constraints

       Architecture Goals and Drivers

       Architecture Components and Quick Preview

         Systemic Architecture

         Process and Information Architecture

         Data Architecture

         ETL Architecture

         Metadata Architecture

         Presentation Layer Architecture

         Technology and Product Architecture

         Application Architecture

         Infrastructure / Platform Architecture

         Processes and Functions (Process Value Chain)

DW Architect Skills

Self-Work-Sheet: Rate My Architect Skills

Work-Sheet: Architectural Constraints I have dealt with in my environment

Architectural components Deep Dive

                Information architecture

Design considerations and downstream Impacts

Design and Data Modeling Considerations

ETL Operational Lifecycle: Deep Dive Understanding

ETL Methods and Mechanisms

Architecting for Resilience

Error Handling and Recovery

Load Balancing and Reconciliation

Metadata Architecture

Data Lifecycle Architecture                               

How and Why of Capturing Current State environment Architectural Views

       Systemic View

       Technology / Product View

       Process and Information Architecture View

       Data and ETL Architecture View


Templates to capture your Capture State Architecture Views

Architecture Evaluation / Definition Templates

Capture Architectural Constraints and considerations for your projects

Identify Opportunities for Efficiency, Resilience, Optimization and Consolidation

Evaluate Rank, Score, Evaluate, Prioritize

Identify IT / Technical / Business Benefit

                Shortlist and Prioritize

                Define an Action Plan with Roadmap at Team / Subteam Levels

Real Life Case Study Scenarios and Interactive Discussion

Participant Pre Requisites

Four Plus Years of Experience

Participants should have at-least one implementation life cycle experience on a data warehousing project.

Complete the Participant Competency and Capability matrix to help understand your profile and needs better.