SAP Hana Modelling Training in Chandigarh

• Equip participants with a foundational understanding of the SAP HANA architecture and its in-memory database design.
• Introduce core concepts of data modeling, including Attribute Views, Analytic Views, and Calculation Views.
• Provide hands-on experience with SAP HANA Studio, the primary modeling tool for SAP HANA.
• Enable learners to understand and apply data provisioning methods like SLT, Data Services, and Direct Extraction.
• Offer insights into advanced modeling techniques, including the use of SQLScript, procedures, and functions.

• Recorded Videos After Training
• Digital Learning Material
• Course Completion Certificate
• 24x7 After Training Support

• Database Administrators
• SAP Consultants
• Business Analysts
• Data Scientists
• Data Modelers

• Basic understanding of database concepts
• Familiarity with SQL and data modeling principles
• Prior experience with SAP systems (advantageous but not mandatory)
• Knowledge of business processes related to the specific SAP module (e.g., SAP BW, if focusing on that area)
• General IT proficiency and familiarity with data management tools.

• Multisoft Systems provides a globally recognized training certificate after successful completion of SAP HANA Modelling certification course.

Unit 1: Understanding SAP HANA

• Need to know the use of SAP HANA
• How it helps in Analytics
• Being a single source of Truth
• Powering your digital needs

Unit 2: Architecture of SAP HANA

• HANA Database Architecture
• In-Memory architecture
• Columnar Data Storage
• Parallel Processing
• Simplified business applications with HANA
• HANA Servers and Engines

Unit 3: Explore HANA Modeling Environments

• HANA Studio
• Different HANA Studio versions and its compatibility
• HANA Web-based Development Workbench
• HANA XSA Web IDE

Unit 4: Analytical Processing with SAP HANA

• Core Modeling with SAP HANA
• Virtual Data Models in SAP HANA
• Modeling in Development Workbench
• Modeling in HANA XSA Web IDE

Unit 5: SAP HANA Modeling

• XS Classic
• Modeling Information Views
• Introduction to Information Views
• Connecting Tables
• Creating different Calculation Views
• Defining measures and conversions
• Modeling functions
• Creating Restricted and Calculated Columns
• Filtering Data
• Using Variables and Input Parameters
• Using Hierarchies
• Using XS Advanced Web IDE for Modeling
• SAP supplied Virtual Data Models
• SAP HANA Live
• Embedded Analytics and CDS

Unit 6: SQL coding in HANA

• Introduction to SAP HANA SQL
• Working with SQL
• Creating and using Functions
• Creating and using Procedures
• Creating and using Sequences, DB Triggers, and Synonyms
• Joins, Union, Aggregation
• Window and String functions

Unit 7: Introduction to SAP HANA Advanced Data Processing

• Using Predictive Analytics Library functions in Modeling
• SAP HANA Spatial processing in HANA Models
• SAP Graph modeling in HANA
• SAP HANA Text & Series data in modeling
• Integrating with HANA Information models

Unit 8: Optimization of HANA Modeling

• Implementing Good/Best practices for Modeling
• Tools to check for Good or Best coding in HANA
• HANA models

Unit 9: Management and Administration of HANA XSA Modeling with Git

• Creating and Managing Projects
• Working with Modeling Content in a Project Working with Git within SAP Web IDE Understanding Migration and Migrating Modeling Content Chapter 10 – Security in SAP HANA Modeling Understanding Roles and Privileges Defining Users and Roles Defining Analytic Privileges

Unit 10: Security in SAP HANA Modeling

• Understanding Roles and Privileges
• Defining Users and Roles
• Defining Analytic Privileges