Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

SAP HANA - Modeling

This SAP HANA - Modeling Essentials training course teaches the core capabilities of SAP HANA for modeling, and covers mainly graphical modeling, as well as SQL-based modeling, mainly table functions and procedures, with a focus on performance. It also introduces Core Data Services as a flexible method to model a persistence layer. You will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context.

This SAP HANA - Modeling Advanced training course provides advanced knowledge and practical experience on several topics that are included in, or connected to, the scope of the modeler role. Its purpose is to take a step further, beyond the core modeling knowledge, and to demonstrate how applications powered by SAP HANA can benefit from innovations such as Spatial Data Storage and Processing, Text Search and Analysis, Predictive Analysis and Graph Modeling.

By attending SAP HANA - Modeling Essentials workshop, delegates will learn 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 a quick overview of advanced data processing such as text, spatial, predictive and graph

By attending SAP HANA - Modeling Advanced workshop, delegates will learn to:

  • Understand and put into practice the main advanced modeling capabilities of SAP HANA in the areas of text search and analysis, graph modeling, spatial analysis and predictive modeling.
  • Promote these advanced modeling capabilities to extend the core SAP HANA Modeling features.
  • Broaden your experience with the modern SAP HANA tooling in XS Advanced (SAP Web IDE for SAP HANA)

For SAP HANA - Modeling Essentials

  • Attend a training on SAP HANA - Essentials or equivalent practical experience.
  • Attend a training on SQL and SQLScript for SAP HANA or equivalent practical experience.

For SAP HANA - Modeling Advanced

  • Attend a training on SAP HANA - Essentials or equivalent practical experience.
  • Attend a training on SQL and SQLScript for SAP HANA or equivalent practical experience.
  • Attend a training on SAP HANA - Modeling Essentials or equivalent practical experience.

The SAP HANA - Modeling class is ideal for:

  • Business Application Consultants
  • Data Consultants / Managers
  • Database Administrators
  • Application Developers
  • BI Specialists

COURSE AGENDA

SAP HANA - Modeling Essentials
(Duration : 5 Days)

1

Information Views

  • Introducing Information Views
  • Understanding the Different Types of Views
  • Working with Common View Design Features
2

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
3

Modeling Functions

  • Create Restricted and Calculated Columns
  • Filter Data
  • Use Variables and Input Parameters
  • Create Hierarchies
  • Implement Currency Conversion
4

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
5

CDS in SAP HANA Modeling

  • Defining the Persistence Layer Using CDS
  • Creating Views with CDS
6

Optimization of Models

  • Using Tools to Check Model Performance
  • Implementing Good Modeling Practices
7

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
  • Migrating Modeling Content
8

Security in SAP HANA Modeling

  • Understanding Roles and Privileges
  • Defining Analytic Privileges
  • Defining Roles
  • Masking Sensitive Data
  • Anonymizing Data
9

Introduction to Advanced Modeling

SAP HANA - Modeling Advanced
(Duration : 3 Days)

1

Introduction to Advanced Modeling

2

SAP HANA Predictive Analysis Library (PAL)

  • Describing SAP HANA PAL
  • Using PAL in Flowgraphs
  • Calling PAL Functions in Calculation Views
  • Calling PAL Procedures in SQL Scripts
  • Exploring the PAL Library
3

SAP HANA Spatial

  • Introducing SAP HANA Spatial
  • Working with Spatial Data Types
  • Importing and Exporting Spatial Data
  • Accessing and Manipulating Spatial Data
  • Using Spatial Clustering
4

SAP HANA Graph

  • Defining SAP HANA Graph Workspace
  • Describing the Different Graph Algorithms
  • Using the Graph Node in Calculation Views
  • Using GraphScript Procedures
5

SAP HANA Text

  • Understanding Full Text Search
  • Understanding Text Analysis
  • Understanding Text Mining
6

SAP HANA Series Data

  • Getting Started with SAP HANA Series Data

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X