Data, Analytics & AI Category Banner Image

SAP HANA Modelling (HA300)

Length 5 days
Version HANA 2.0 SPS04

Course overview

View dates &
book now

Why study this course

This five-day instructor-led course teaches the core capabilities of SAP HANA for modelling, and covers mainly graphical modelling, as well as SQL-based modelling, 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.

The participants will gain knowledge about the management of modelling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modelling context.

We also provide an overview of advanced data processing in the areas of text, spatial, predictive and graph modelling.

This course is based on software release:

SAP HANA 2.0 SPS04

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

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 modelling
Manage projects and modelling 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

SAP at Lumify Work

Develop your SAP empowered employees with Lumify Work. Getting the right skills in place maximises the chance of project success and removes risk. Lumify Work provides a select range of SAP training courses for SAP S/4HANA, SAP HANA, SAP BusinessObjects and more. Lumify Work can work with you to navigate the curriculum and help you create a learning plan that will ultimately boost technology proficiency across your organisation.

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality Instructors and Content

Expert instructors with real world experience and the latest vendor-approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world's leading vendors as preferred training partner.

Ahead of the Technology Curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

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

Course subjects

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

Modelling Functions

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

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

Core Data Services (CDS) in SAP HANA Modelling

Defining the Persistence Layer Using CDS
Creating Views with CDS

Optimisation of Models

Using Tools to Check Model Performance
Implementing Good Modelling Practices

Management and Administration of Models

Working with Modelling Content in a Project
Creating and Managing Projects
Enabling Access to External Data
Working with GIT within the SAP Web IDE
Migrating Modelling Content

Security in SAP HANA Modelling

Understanding Roles and Privileges
Defining Analytic Privileges
Defining Roles
Masking Sensitive Data
Anonymising Data

Introduction to Advanced Modelling

Prerequisites

Essential

SAP HANA - 360° Introduction (HA100)

Recommended

SAP HANA SQL and SQLScript for SAP HANA (HA150)

THIRD PARTY REGISTRATION

Lumify Work offers certification and training through our partnership with SAP Inc. This arrangement requires Lumify Work to provide your details to SAP Inc for course and/or exam registration purposes.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.