SAP S/4 HANA COURSE SYLLABUS

Module 1: Modeling in SAP HANA

• Create Attribute Views
• Design Analytical Views
• Create Calculation Views from multiple analytical Views
• Best Practices while Creating Information Models
• Performance Optimization techniques in SAP HANA
• Currency Conversion
• Variables in HANA
• Meta data import to SAP HANA Using SAP
• Export Models
• Import Models
• SQL Script
• CE Functions
• Procedures
• Hierarchies – Level Based Hierarchies and Parent Child Hierarchies
• Restricted Measures & Calculated Measures & Calculated Attributes
• Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities
• Auto Documentation of Information Models

Module 2: Data Reporting

• SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA
• IMCE Clients – ODBO , ODBC, JDBC, BICS
• Microsoft Excel 2010 Connection to HDB
• Create Universe through Information Design Tool using JDBC Connections
• Web Intelligence Document on SAP HANA Universe
• Design studio
• Lumira
• BO Analysis for Office
• BO Analysis for OLAP
• BO Explorer
• Crystal Reports for enterprise

Module 3: Data Provisioning or Data Loading

• SAP DXC – Direct Extractor Connection
• Flat File Upload to SAP HANA
• SAP BODS : Overview Data Services Workbench and Designer
• Creating Data store for ECC and HANA
• Create Data Services Job and Load the data to
• SAP HANA DB

Module 4: Administration in SAP HANA

• Backup & recovery
• SAP HANA Studio Installation and configuration
• Clients Installation
• Create ODBC Connections
• Monitor HDB
• Multi Version Concurrency Control – MVCC
• IMDB Installation
• Distributed System Handling – Cold backup and Hot backup
• Persistency Layer

Module 5: User Management & Security

• Creating users
• Creating Roles
• Assign privileges to Users/ Roles
• Template Roles
• SQL statements for user management
• Analytical privileges, Package Privileges, System
• Privileges , SQL Privileges

Module 6: COPA Accelerator

• COPA Overview COPA Reporting in HANA
• Architecture for CO-PA Accelerator, Use Case Scenarios , Scope
• DBSL – Data Shared Library Connection for HANA as a secondary Database
• SLT Replication – SAP HANA Model

Module 7: SAP BW on HANA

• Overview of SAP BW
• SAP BW Powered By HANA as a database
• In Memory Optimized Info Cube
• In Memory Optimized DSO
• Bex Report on SAP HANA Transient Provider
• SAP BW Composite provider on HANA Model

Module 8: SAP S4 HANA

S4HANA A New Product :
• The First Contact to S4HANA
• Impact on SAP HANA Business Processes
• SAP HANA Architecture and Technical Basic Concept Excercise 2 :
• First View in the SAP HANA Database
• SAP Simple Finance as an instance of a new Application
• Introduction into Simple Finance:
• Posting with SAP Fiori
• Ways to S/4 HANA
• Lesson Customer Code Migration from ERP Finance to SAP Simple Finance
• SAP Simple Finance as an instance of a new Application
• Introduction into SAP Fiori
• Fiori Launch Pad

Meet Ananth Tirumanur. Hi there 👋

I work on projects in data science, big data, data engineering, data modeling, software engineering, and system design.

• 👨‍💻 All of my projects are available at https://github.com/akrish1982
• 💬 Ask me about Data engineering, SQL, Databases, Data pipelines, Data infrastructure
• 📄 My work history: https://www.linkedin.com/in/ananthtirumanur/
• ⚡ Fun fact: Marathoner & Casual Birding enthusiast

Connect with me:

• Twitter: @akrish82
• LinkedIn: https://linkedin.com/in/ananthtirumanur/

My Resources:

• LinkedIn Newsletter: Data Engineering with AWS
• Udemy Course: AWS Certified Data Engineer Associate Practice Test
• Python Crash Course: Python Crash Course on Gumroad

Languages and Tools:

AWS, Bash, Cassandra, Django, Docker, Elasticsearch, Flask, Git, Go, Grafana, Hadoop, Hive, Hugo, Kafka, Kubernetes, Linux, MariaDB, MySQL, Pandas, PostgreSQL, Python, Redis, Scala, Scikit-learn, SQLite