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

Notes

  • ABAP CDS Views for Analytics as they are currently not foreseen as a data access method in BW on HANA and BW/4HANA with exception of the technical content. Hence they will not be discussed in detail.
  • This training was developed in a partnership with ISR Information Products AG.

Submit your request

Is the course not scheduled? Or looking for other dates and locations that fit your schedule? Let us know what works for you by clicking the button below and select your preferred location. We will do our best to consider your request.

Register Interest