HANA Modelling


SAP HANA data Modeling which is also known as SAP HANA information Modeling is that the core of HANA software development. you'll apply business logic to make a record that's meaningful and might build modelling views along with database tables. These modelling views might be consumed through SAP HANA native applications, HTML or Java-based applications. you will additionally use SAP tools like Analysis office or SAP Lumira to instantly connect to HANA and statement modelling views. This course is designed to present details of the Model process and SAP HANA Modeling.

We at Aspire Techsoft ensure to meet demands of growing technology by producing quality skilled SAP HANA Modelling experts who can be worthy of service to the industry. We are one of the best Online HANA Modelling training institute.


Our syllabus for HANA Modelling

  • Why HANA & What is SAP HANA in a Nutshell.

  • Challenges with Current Landscapes.

  • How SAP HANA Solves Current Challenges.

  • SAP HANA Database Architecture.

  • Data Storage in SAP HANA.

  • Types of Database Engines in SAP HANA.

  • Persistence Layer, backup and Recovery.

  • SAP HANA Platform.


  • SAP Business Suite on SAP HANA.

  • SAP HANA Sidecar.

  • On-premise deployment.

  • Cloud Deployment.

  • SAP HANA Platform Licensing.

  • SAP HANA Studio Overview.

  • Adding SAP HANA Instance in SAP HANA Studio.

  • Basic Steps – Create Schema, Table and Package in SAP HANA.

  • SAP HANA Perspective.

  • SAP HANA Modeler Perspective.

    SAP HANA Administration Perspective.

    SAP HANA Developer Perspective.

    SAP HANA Web IDE for Modeling.

  • Introduction to Data Provisioning Techniques.

  • Flat File Upload using SAP HANA Studio.

  • SAP Landscape Transformation (SLT).

  • SAP Replication Server (SRS).

  • SAP Data Services.

  • Loading Data to SAP HANA using SAP Data Services.

    Loading Data to SAP HANA using SAP Data Services from Flat Files.

    Loading Data from SAP ECC Extractors to SAP HANA – ODP.

    SAP Data Services-SQL and Validation Transform.

    SAP Data Services-Case and Merge Transform.

    SAP Data Services-Delta data load.

  • SAP Data Services-Job scheduling and management.

  • Enterprise Information Management (EIM).

  • Smart Data Access (SDA).

  • Direct Extractor Connection (DXC).

  • Smart Data Streaming.

  • Remote Data Synchronization.

  • Data Provisioning Summary and Tool Selection.

  • Introduction to SQL in SAP HANA.

  • SQL Data Types.

  • JOIN Types.

  • SQL Statements.

  • SQL Functions.

  • SQL Functions for Calculated Column.

  • Procedures.

  • A. Introduction to Modeling.

  • Attribute View – Creation.

    Attribute View – Advanced Properties.

    Attribute View creation using Copy and Derived options.

    Time Attribute View.

    Analytic View – Creation.

    Analytic View – Advanced Properties.

    Calculation View – Creation Using GUI.

    Calculation View – Advanced Properties.

    Calculation View – Creation Using SQL Script.

    Calculation View – Creation as Dimension.

    Calculation View – RANK Function.

    Calculation View – Filter Expression.

    Calculation View – Start Join.

    Calculation View – Dynamic Join.

  • B. Decision Tables – Overview.

  • Decision Tables With Return Values.

    Decision Tables With Update Values.

    Decision Tables on Information Models.

  • C. Calculated Column.

  • Calculated Column – Attribute.

    Calculated Column – Measure.

  • D. Restricted Measures.

  • E. Variables Vs Input Parameters.

  • Variables.

    Input Parameters.

    Input Parameters in Calculated Columns.

  • F. Distinct Count – Counter.

  • G. Temporal Join for Time Dependent Data.

  • H. Level Hierarchy.

  • I. Parent-Child Hierarchy.

  • J. Currency Conversion.

  • K. Content Procedures.

  • Quick View screen in SAP HANA Studio.

  • Copy.

  • Rename.

  • Refactor.

  • Mass Copy.

  • Switch Ownership.

  • Schema Mapping.

  • Maintain Package Specific Default Schema.

  • Generate Time Data.

  • Cleaning Unused Objects.

  • Auto Documentation.

  • Introduction.

  • Classic Analytic Privileges.

  • SQL Analytic Privileges.

  • Static VS Dynamic Analytic Privileges.

  • Dynamic SQL Analytic Privileges.

  • Introduction.

  • Standard Roles.

  • System Privileges.

  • Object Privileges.

  • System Delivered users.

  • Role Creation.

  • User Creation.

  • Introduction and Connectivity Options.

  • MS Excel.

  • Standard Universe Creation using IDT.

  • Universe Creation using SAP HANA Business Layer in IDT.

  • System Delivered users.

  • SAP BO Explorer.

  • SAP Lumira.

  • Web Intelligence.

  • Crystal Reports.

  • Design Studio.

  • Introduction.

  • Visualize Plan.

  • Tracing.

  • Partitioning.

  • Partitioning Tables.

  • Dynamic Tiering.

  • Introduction to Transportation Options.

  • Export and Import.

  • Delivery Units.

  • Application Lifecycle Management (ALM).

  • Solution Manager using CTS+.

  • Data Cleansing During Provisioning.

  • Schema Creation.

  • Models Creation.

  • Experts Panel

    Learn with the experts in the field.

    Faculty, HANA Modelling
    Experience: 5 Year(s).

    Yogita Narale

    Yogita Has 5+ Years Of Experience In HANA Modelling, Currently Working In MNC. Being An SAP-Certified She Possesses A Great Set Of Skills. In Her Career Of 5 Years, She Worked In Various Types Of Projects.

    Faculty, HANA Modelling
    Experience: 8 Year(s).

    Dashrath Jadhav

    Dashrath Is Working As HANA Modelling Consultant In An MNC Since Last 5 Years. In His Career, He Worked On Lots Of Projects And Have A Great Set Of Skills. Student Trained By Him Already Got Placed In An MNC.

    Faculty, HANA Modelling
    Experience: 10 Year(s).

    Suraj Panchal

    Suraj Is Currently In An MNC Since Last 10 Years. In Hir Career, He Worked On Lots Of Projects And Have A Great Set Of Skills. He Is An SAP Certified Trainer. Student Trained By Him Already Got Placed In An MNC.

    Student Reviews

    See what student says about this course.

    Pravin S.

    Aspire Is The Best SAP Training Institute In Pune, Good To Learn New Things With Practical Oriented Training.

    Vilas Kumar

    Aspire Techsoft Has Played A Very Important Role In Getting Me Placed In A Reputed IT Organisation Like Crest Premedia.

    Chinmay Sahu

    A Good Place To Learn SAP , Experienced Faculty , Well Teaching.

    Schedule & Batches

    Following are the ongoing and upcomming batches.

    × No Upcoming Batch Found ! visit after some time.