SAP HANA Certification Top Topics to Focus on

Below is the list of topics you need to focus for SAP HANA certification. SAP HANA is an in-memory platform for data analytics. Read more online here.

SAP HANA List of Top Topics

1.Data Provisioning   > 12%

Describe possible scenarios and tools for replicating and loading data into SAP HANA from different data sources (e.g. SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC)).

2. Security and Authorization                                 8% – 12%

Describe the concept of authorization in SAP HANA, and implement a security model using analytic privileges, SQL privileges, pre-defined roles, and schemas. Perform basic security and authorization troubleshooting.

3. Data modeling – Analytical views              8% – 12%

Implement data models with SAP HANA using analytical views. Advise on the modeling approach and best practices.

4. Data modeling – Calculation views           8% – 12%

Implement data models with SAP HANA using calculation views, and advise on the modeling approach and best practices.

5. Advanced data modeling                                8% – 12%

Apply advanced data modeling techniques, including currency conversion, variables, and input parameters. Implement decision automation using business rules.

6. Optimization of data models and reporting                     8% – 12%

Monitor, investigate, and optimize data models and reporting performance on SAP HANA. Advice on modeling approaches and tools to achieve optimum performance. Evaluate the impact of different implementation options such as table joins, aggregation, or filters. Understand the implication on the performance of the various reporting tools and connection types.

7. Administration of data models                  8% – 12%

Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models.

8. Reporting                                         < 8%

Provide advice on reporting strategies, and perform appropriate reporting solutions with SAP HANA. Build reports using various tools, for example, Microsoft Excel or SAP BusinessObjects BI tools.

9. Data modeling – SQL Script                     < 8%

Apply SQL Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL.

10. Data modeling – Attribute views                    < 8%

Implement data models with SAP HANA using attribute views, and advise on the modeling approach and best practices.

11. Deployment scenarios of SAP HANA                 < 8%

Describe the deployment scenarios for SAP HANA and evaluate appropriate system configurations.

12. SAP HANA Live & Rapid Deployment Solutions for SAP HANA  < 8%

Describe the value of HANA and identify scenarios for SAP delivered content for SAP HANA, such as SAP HANA Live and Rapids Deplyment Solutions.

The below are the key areas where you need to learn SAP HANA contents and highly useful for certification.

SAP HANA is an in-memory platform for data analytics. Read more online here.

13. Data Provisioning   > 12%

Describe possible scenarios and tools for replicating and loading data into SAP HANA from different data sources (e.g. SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC)).

14. Security and Authorization                                 8% – 12%

Describe the concept of authorization in SAP HANA, and implement a security model using analytic privileges, SQL privileges, pre-defined roles, and schemas. Perform basic security and authorization troubleshooting.

15. Data modeling – Analytical views              8% – 12%

Implement data models with SAP HANA using analytical views. Advise on the modeling approach and best practices.

16. Data modeling – Calculation views           8% – 12%

Implement data models with SAP HANA using calculation views, and advise on the modeling approach and best practices.

17. Advanced data modeling                                8% – 12%

Apply advanced data modeling techniques, including currency conversion, variables, and input parameters. Implement decision automation using business rules.

18. Optimization of data models and reporting                     8% – 12%

Monitor, investigate, and optimize data models and reporting performance on SAP HANA. Advice on modeling approaches and tools to achieve optimum performance. Evaluate the impact of different implementation options such as table joins, aggregation, or filters. Understand the implication on the performance of the various reporting tools and connection types.

19. Administration of data models                  8% – 12%

Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models.

20. Reporting                                         < 8%

Provide advice on reporting strategies, and perform appropriate reporting solutions with SAP HANA. Build reports using various tools, for example, Microsoft Excel or SAP BusinessObjects BI tools.

21. Data modeling – SQL Script                     < 8%

Apply SQL Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL.

22. Data modeling – Attribute views                    < 8%

Implement data models with SAP HANA using attribute views, and advise on the modeling approach and best practices.

23. Deployment scenarios of SAP HANA                 < 8%

Describe the deployment scenarios for SAP HANA and evaluate appropriate system configurations.

24. SAP HANA Live & Rapid Deployment Solutions for SAP HANA  < 8%

Describe the value of HANA and identify scenarios for SAP delivered content for SAP HANA, such as SAP HANA Live and Rapids Deployment Solutions.

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.