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 | Timing | Days | Duration | Mode Of Training | Request Price/Future Dates |
|---|---|---|---|---|---|
| 18.03.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 25.03.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 27.03.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 15.04.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 17.04.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 22.04.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 29.04.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 01.05.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 06.05.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 13.05.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 15.05.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 20.05.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 27.05.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 29.05.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 03.06.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 10.06.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 12.06.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 17.06.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 24.06.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 26.06.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 01.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 08.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 10.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 15.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 22.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 24.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 29.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 05.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 07.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 12.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 19.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 21.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 26.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 02.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 04.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 09.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 16.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 18.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 23.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 30.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online |
RELATED COURSES
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