In this course, you will develop advanced SAP HANA modeling skills, so that you are able to create sophisticated and high performance information views, which can expose data to applications and report consumers. This course is based on software release SAP HANA SPS11.

1. Information Views

• Connect Tables
• Create Dimension and Cube Calculation Views

2. Modeling Functions

• Create Hierarchies
• Create Calculated and Restricted Columns
• Filter Data
• Use Variables and Input Parameters
• Implement Currency Conversion
• Create Decision Tables

3. SQL Script and Procedures

• Introduce SQL and SQLScript
• Create Table Functions and Procedures
• Use the SQL Debug Tools

4. Virtual Data Models in SAP HANA

• Use SAP HANA Live
• Create Virtual Data Models with Core Data Services

5. Text, Spatial, and Predictive Modeling

6. Management and Administration of Models

• Validate Information Models
• Transport Information Models
• Convert Deprecated Modeling Artifacts

7. Security in SAP HANA Modeling

• Key Concepts of SAP HANA Security
• Data Access Security

8. Optimization of Models

• Best Practices
• Performance of Models