Course announcements

  • In this course you will get an overview and practical introduction to the agile methodology and tools for the development of a HANA-SQL-based data warehouse.
  • This training will focus the SQL DataWarehouse approach by using the SAP HANA Platform, SAP XS Advanced (XSA), SAP Enterprise Information Management, the SAP Enterprise Architecture Designer, SAP HANA Data Warehousing Foundation and the SAP Data Hub.

Goals

  • This course will prepare you to:
    • Understand the SAP SQL Data Warehouse approach based on SAP HANA Platform.
    • Build up a modern and agile Data Warehouse using an integrated development methodology
    • Use the development tools in an integrated manner

Audience

  • Application Consultant
  • Business Analyst
  • Data Consultant / Manager
  • Developer
  • Developer Consultant
  • Enterprise Architect
  • Technology Consultant
  • Trainer

Prerequisites

Essential

  • HA100 - SAP Training
  • DataWarehouse experience

Recommended

Course based on software release

  • HANA 2.0
  • Web IDE
  • Database Explorer
  • XS Advanced
  • Enterprise Architect Designer
  • SAP HANA Data Warehousing Foundation
  • SAP Data Hub
  • SAP Analytics Cloud
  • Git

Content

  • Unit 1 Introduction - Overview and Introduction
    • Lesson 1: Why SAP SQL Data Warehousing
    • Lesson 2: SAP HANA Platform
    • Lesson 3: SAP HANA Development Environment
    • Lesson 4: SAP HANA Enterprise Architecture Designer
    • Lesson 5: SAP Data Warehousing Foundation
    • Lesson 6: SAP Data Hub
  • Unit 2: Reference Architecture, Concepts & Methods
    • Lesson 1: Reference DWH Architecture
    • Lesson 2: Reference Development Method
  • Unit 3: Modelling - Master Data / Transactional Data
    • Lesson 1: Modelling Approaches
    • Lesson 2: Modelling Methods
    • Lesson 3: Conceptual Data Model
    • Lesson 4: Physical Data Model
    • Lesson 5: Persistence Types
  • Unit 4: Implementation
    • Lesson 1: Implementation WebIDE
    • Lesson 2: Data Provisioning and Transformation
    • Lesson 3: Analytical Layer
    • Lesson 4: Analytics - SAP Analytics Cloud
    • Lesson 5: SAP HANA Data Warehouse Scheduling
    • Lesson 6: Deployment
  • Unit 5: Data Hub
    • Lesson 1: Data Hub
  • Unit 6: Outlook
    • DWF -Technical basis for an SAP HANA SQL Data Warehouse
    • SAP Analytic Cloud