Visit lab, meet the faculty, attend the demo classes for FREE then decide HANA is very important to SAP – it can deliver a substantial new revenue opportunity for SAP and its ecosystem, provide customers with game-changing benefits. The Power of SAP HANA Real-time Analytics • Operational Analytics • Big Data Warehousing • Predictive, Spatial and Text Analytics Real-time Applications • Consumer Engagement • Sense and Respond • Planning and Optimization Real-time Platform • Database & Data Processing Services • Application Platform Services • Integration and Data Virtualization Services • Mission-critical Deployment Services (Appliance, Cloud)

Topics Covered

SAP HANA 1.0 SP6 Course Duration: 45 Hours, 30 Days / 1.5 hour daily Unit 1: Introduction SAP HANA Modeling Introduction to SAP HANA SAP HANA Scenarios Deployment Options Approaching HANA Modeling Unit 2: Architecture Architecture Persistence Layer Backup & Recovery Unit 3: Connecting Tables Connecting Tables Unit 4: Advanced Modeling Analytic Views Creating Attribute Views Exercise 1: System Preparation Exercise 2: Creating Attribute Views Using Hierarchies Exercise 3: Using Hierarchies Creating Restricted & Calculated Columns Exercise 4: Creating Restricted & Calculated Measures Using Filter Operations Exercise 5: Using Filter Operations Using Variables Exercise 6: Using Variables Creating Calculation Views Exercise 7: Creating Graphical Calculation Views SAP HANA SQL Introduction Exercise 8: Working with SQL Statements SQLScript and Procedures Exercise 9: Creating a Simple Calculation View of type SQL Script Exercise 10: Creating a CV of type SQL Script using CE_FUNCTIONs Exercise 11: Creating Procedures Exercise 12: Creating a Calculation View of type SQL Script using procedures Using Currency Conversion Views Turning Business Rules into Decision Tables Exercise 14: Creating Decision Tables Unit 5: Full Text Search Full Text Search Overview Data Types and Fulltext Indexes Using Fulltext Search Exercise 15: Using Fulltext Search Unit 6: Processing Information Models Processing Info Models Exercise 16: Processing Information Objects Unit 7: Managing Modeling Content Managing Modeling Content Unit 8: Security and Authorizations User Management and Security Exercise 17: Working with SAP HANA users and roles Types of Privileges Exercise 18: Creating and assigning Analytic Privileges Template Roles Administrative SAP HANA and BI4 authentication Unit 9: Data Provisioning Using SLT Overview SLT Data Replication at a Glance SLT based Transformation Concepts and Advanced Replication Settings Unit 10: Data Acquisition Using SAP Data Services Introduction to SAP Data Services Loading Data into SAP HANA Unit 11: Data Provisioning Using Flat File Upload Introduction to Flat File Upload Loading Flat File Data into SAP HANA Unit 12: Data Provisioning Using Direct Extractor Connection Introduction to SAP HANA Direct Extractor Connection Overview Unit 13: Introduction to the Application Function Library Application Function Library Unit 14: Reporting SAP HANA Database Connectivity Options Microsoft Excel SAP BusinessObjects SAP BusinessObjects Analysis for Office SAP BusinessObjects Analysis for OLAP SAP BusinessObjects Explorer SAP Crystal Reports for Enterprise, Dashboards and Web Intelligence Walkthrough: SAP HANA Application Consultant Certification Questions with detailed explanation

Who should attend

SAP BI, BW, ABAP, BASIS, BE Freshers

Pre-requisites

SAP BI, BW, ABAP, BASIS, BE Freshers

What you need to bring

NA

Key Takeaways

Helpful links and additional notes relevant to SAP HANA Application Consultant Focus on SAP HANA Road Map Focus on SAP HANA 1.0 SP7 latest Features Explanation on End-to-End Live implementation projects on SAP HANA along with the approach Guidelines to add SAP HANA Skill set in your profiles