SAP HANA 2.0 Modeling Classroom Live Philadelphia, PA November 29, 2021

Price: $4,090

This course runs for a duration of 5 Days.

The class will run daily from 9:00 am EST to 5:00 pm EST.

Class Location: Philadelphia - Philadelphia, PA.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

Goals

  • This course will prepare you to:
    • Develop information models following SAP best practices for maximum performance and flexibility
    • Get started with SQL and SQLScript based modeling
    • Manage projects and modeling content in the Web IDE
    • Implement security and data access controls around SAP HANA data models
    • Get started with advanced data processing such as text, spatial, predictive and graph

Audience

  • Business application consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application developer
  • BI specialist

Course Overview

  • Information Views
    • Introducing Information Views
    • Understanding the Different Types of Views
    • Working with Common View Design Features
  • Using Nodes in Calculation Views
    • Using Projection Nodes
    • Using Join Nodes
    • Working with Data Sets
    • Aggregating Data
    • Creating Cubes with Star Join Calculation Views
    • Extracting Top Values with Rank Nodes
  • Modeling Functions
    • Create Restricted and Calculated Columns
    • Filter Data
    • Use Variables and Input Parameters
    • Create Hierarchies
    • Implement Currency Conversion
  • SAP HANA Studio Modeling
  • Using SQL in Models
    • Introducing SAP HANA SQL
    • Working with SQLScript
    • Query a Modeled Hierarchy Using SQLScript
    • Creating and Using Functions
    • Creating and Using Procedures
  • CDS in SAP HANA Modeling
    • Defining the Persistence Layer Using CDS
    • Creating Views with CDS
  • SAP Supplied Virtual Data Models
    • SAP HANA Live
    • Embedded Analytics and CDS
  • Optimization of Models
    • Using Tools to Check Model Performance
    • Implementing Good Modeling Practices
  • Management and administration of Models
    • Working with Modeling Content in a Project
    • Creating and Manage Projects
    • Enabling Access to External Data
    • Working with GIT Within the SAP Web IDE
    • Using SAP Enterprise Architecture Designer
    • Migrating Modeling Content
  • Security in SAP HANA Modeling
    • Understanding Roles and Privileges
    • Defining Analytic Privileges
    • Defining Roles
    • Masking Sensitive Data
    • Anonymizing Data
  • Introduction to Advanced Modeling

Prerequisites

SAP HANA Introduction

Recommended

HA150- SQL and SQLScript for SAP HANA

Other Available Dates for this Course

Virtual Classroom Live
November 01, 2021

$4,090.00
5 Days    9:00 am EST - 5:00 pm EST
view class details and enroll
Virtual Classroom Live
November 29, 2021

$4,090.00
5 Days    9:00 am EST - 5:00 pm EST
view class details and enroll
Virtual Classroom Live
December 13, 2021

$4,090.00
5 Days    9:00 am EST - 5:00 pm EST
view class details and enroll