HA300 SAP HANA Modeling

COURSE OVERVIEW

WE OFFER

 

  • Instructor-led Classroom-based & Live Virtual Online Training
  • Hands-on Training
  • Free Study Material
  • Lab Exercises
  • Unlimited Lab Access
  • 100 % Passing Guarantee or Free Re-training

COURSE INFORMATION

 

  • Fast Track
    Days: Monday-Friday
    Duration: 5 days
  • Slow Track
    Days: Saturdays / Sundays / Evenings
    Duration: 5 Weeks

Study Modes:

  • Classroom / On-site
  • Live Virtual

WHO IS THIS COURSE MEANT FOR?

 

  • If you are a Business application Consultant or aspiring to be one then you can take up this course.
  • This course is designed for Data Consultant / Managers seeking to enhance their skills and knowledge in their field.
  • If you are a Database Administrator or aspiring to be one then you can take up this course.
  • If you are an Application developer or aspiring to be one then you can take up this course.
  • This course is designed for BI specialists seeking to enhance their skills and knowledge in their field.

PREREQUISITE

 

  • You are required to have a basic introductory concept on HA100 – SAP HANA.
  • You are recommended to have studied the HA150 – SAP HANA SQL and SQLScript for SAP HANA course before partaking in this one.

 

RECOMMENDED

 

  • HA150 – SAP HANA SQL and SQLScript for SAP HANA

The supply of this course 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.

 

JOBS YOU CAN GET WITH HA300 SAP HANA MODELING

 

  • SAP HANA Consultant
  • Data Architect
  • Business Intelligence Developer
  • Data Analyst
  • SAP HANA Administrator

 

SAP HANA Modeling

For More information call us on

0208 123 7574

COURSE INSIGHT

HA300 SAP HANA Modeling is a 5-day instructor-led or virtual training course that uses SAP HANA 2.0 SPS03 software.  During your learning progress, you will be provided with free study material, some lab exercises, unlimited lab access, and hands-on training. You will be taught the core capabilities of SAP HANA graphical modelling. You will be taught more about this graphical modelling on a live virtual data model, as well as SQL-based modelling. This lesson will cover the table procedures and functions with the aim of focusing on the performance of the model. You will gain knowledge on how to manage modelled content in the SAP Web IDE for SAP HANA. You will also gain an overview of advanced data processing in the areas of text, spatial, predictive, and graph modelling. You will explore graphical modelling in SAP HANA Studio through a dedicated unit, equipping you with the necessary skills to work with various types of data models within SAP HANA. You can however be offered a free retraining session but the passing guarantee for this course is 100% assured.

COURSE OUTLINE

  • Calculation Views
    • Introducing Calculation 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 CUBE with Star Join Calculation Views
    • Extracting Top Values with Rank Nodes
  • Modeling Functions
    • Create Restricted and Calculated Columns
    • Filtering Data
    • Using Variables and Input Parameters
    • Implementing Hierarchies
    • Implement Currency Conversion
    • Defining Time-Based Dimension Calculation Views
  • Using SQL in Models
    • Introducing SAP HANA SQL
    • Query a Modeled Hierarchy Using SQLScript
    • Working with SQLScript
    • Creating and Using Functions
    • Creating and Using Procedures
  • Persistence Layer
    • Defining the Persistence Layer
    • Loading Data into Tables
    • Accessing Remote Data
  • Optimization of Models
    • Implementing Good Modeling Practices
    • Implementing Static Cache
    • Controlling Parallelization
    • Implementing Union Pruning
    • Using Tools to Check Model Performance
    • Developing a Data Management Architecture
  • Management and administration of Models
    • Working with Modeling Content in a Project
    • Creating and Managing Projects
    • Enabling Access to External Data
    • Working with GIT Within the SAP Web IDE
    • Migrating Modeling Content
  • Security in SAP HANA Modeling
    • Understanding Roles and Privileges
    • Defining Analytic Privileges
    • Defining Roles
    • Masking Sensitive Data
    • Anonymizing Data

The Benefits of Studying HA300 SAP HANA Modeling

This course will prepare you to:

  • You will have gained the appropriate knowledge to work with SQL and SQL Script based modelling.
  • You will be able to provide maximum performance and flexibility when developing and using the best SAP best practices when developing model information.
  • This course helps you learn how to model and manage projects and contents within the Web IDE.
  • Once you get to understand the SAP HANA data models, you will be capable of implementing data and security access controls.
  • You will be taken through advanced data processing which includes graph, spatial, predictive, and text.

Dates And Prices

Start Date TimingDaysDuration Mode Of TrainingRequest Price/Future Dates
01.07.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
08.07.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
10.07.202410:00 – 18:00Wed only 5 Weeks Classroom Based / Live Virtual Online
15.07.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
22.07.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
24.07.202410:00 – 18:00Wed only 5 Weeks Classroom Based / Live Virtual Online
29.07.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
05.08.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
07.08.202410:00 – 18:00Wed only 5 Weeks Classroom Based / Live Virtual Online
12.08.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
19.08.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
21.08.202410:00 – 18:00Wed only 5 Weeks Classroom Based / Live Virtual Online
26.08.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
02.09.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
04.09.202410:00 – 18:00Wed only 5 Weeks Classroom Based / Live Virtual Online
09.09.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
16.09.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
18.09.202410:00 – 18:00Wed only 5 Weeks Classroom Based / Live Virtual Online
23.09.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online
30.09.202410:00 – 18:00Mon - Fri 5 DaysClassroom Based / Live Virtual Online

RELATED COURSES

SAP HCM at iTraining London

SAP HCM

Company that offers design and build services for you from initial sketches to the final production.

read more

CCNA

Our aim is exclusively focused on high-quality training that are tailored to corporate needs. The training delivered by professional trainers.

read more

Comptia A+

Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.

read more

SAP FICO

We allow only a limited number of students in a class. So you get more attention from your instructor and clarify your doubts better.

read more