Got a question? Call 1800 853 276   |   
Data, Analytics & AI Category Banner Image

SAP HANA Modelling (HA300)

  • Length 5 days
  • Price  $5368 inc GST
  • 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


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

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.


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

Recommended


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

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.