Industry 4.0 Big Data – SAP Hana Data Modelling


Programme Overview

The “ SAP Certified Application Associate – SAP HANA 2.0 (SPS03) ” certification exam verifies that the candidate possesses the required knowledge in the area of the SAP HANA 2.0 based on SPS03 for the profile of an SAP HANA application consultant for SAP HANA modelers. This certificate builds on the basic knowledge gained through related SAP HANA training (HA100, HA300, HA301) and preferanly refined by practical experience within an SAP HANA project team, whereby the consultant applies acquired knowledge in this specialist area practically in projects.

Course Objectives

After completing this course, students will be able to:

  • Design and build a complete Android application.
  • Debug and maintain Android applications using different tools and plugins.
  • Thoroughly understand the life-cycle of an Android application and its main components.
  • Use external resources, manifest files, intents and adapters
  • Understand and use all Android persistent storage techniques: Preferences, files, databases, and content providers.
  • Use Android’s background processing techniques.

Who should attend?

HA100 - SAP HANA Introduction

  • Application Consultant
  • Change Manager
    Business Analyst
  • Application Developer
  • BI/BW consultant & Data Scientist
  • Database Administrator

HA300 - SAP HANA SPS03 Modeling

  • Business application consultant
  • Data Consultant/Manager
  • Database Administrator
  • Application developer

HA301 - SAP HANA SPS03 Advanced Modeling

  • Business application consultant
  • Data Consultant/Manager
  • Database Administrator
  • Application developer
  • BI specialist

Course Pre-requisites

HA100 – SAP HANA Introduction

  • None

HA300 – SAP HANA SPS03 Modeling

  • HA100 – SAP HANA : Introduction

HA301 – SAP HANA SPS03 Advanced Modeling

  • HA100 – SAP HANA: Introduction
  • HA300 – SAP HANA : SPS03 Modeling

Course Outline

Industry 4.0: Introduction to Concepts & Technology Pillars

  • Overall course objective and deliverables
  • Overview of the course outline
    • What is Industry 4.0 and why now?
    • What enabled the new revolution?
    • Industry 4.0 framework & blueprint
  • Digital Supply Chain, IIoT, Cloud, Big Data Analytics
  • Cybersecurity, Augmented Reality, Additive
  • Manufacturing, Horizontal & Vertical Integration
  • Autonomous Robot, Artificial Intelligence, New Business
  • Business and operation
  • Best practices from the pioneers
  • OT & IT convergence & New roles and responsibilities

SAP HANA - Course Module

  • Describing SAP HANA
  • Understanding the
  • Need for a Modern Digital Platform
  • Describing how SAP HANA Powers a Digital Platform
  • Architecture of SAP HANA
  • Outlining Components of SAP HANA
  • Working with SAP HANA interfaces
  • Understanding Key Features of SAP HANA Database
  • Describing High Availability
  • Analytical Processing with SAP HANA
  • Understanding SAP Supplied Data Models
  • Advanced Modeling with SAP HANA
  • Data Management with SAP HANA
  • Describing Data Management
  • Describing Data Acquisition Tools
  • SAP HANA Data Management Suites
  • Developing and Running Applications on SAP HANA
  • Running SAP Enterprise Suites on SAP HANA
  • Running SAP Business Intelligence Tools to SAP HANA
  • Connecting SAP Business Intelligence Tools to SAP HANA
  • Outlining SAP Business Warehouse on SAP HANA
  • Developing SQL Data Warehouses with SAP HANA
  • Building Native HANA Applications
  • Appendix: Continuing your SAP HANA Learning Journey
  • Query a Modeled Hierarchy Using SQLScript
  • Creating and Using Functions
  • Creating and Using Procedures
  • CDS in SAP HANA Modeling
  • Defining the Persistence Layer Using CDS
  • Creating Views with CDS
  • SAP Supplied Virtual Data MODELS & SAP HANA LIve
  • Embedded Analytics and CDS
  • Optimization of Models
  • Using Tools to Check Model Performance
  • Implementing Good Modeling Practices
  • Management and administration of Models
  • Working with Modeling Content in a Project
  • Creating and Manage Projects
  • Enabling Access to External Data
  • Working with GIT within the SAP Web IDE
  • Using SAP Enterprise Architecture Designer
  • Migrating Modeling Content
  • Security in SAP HANA Modeling
  • Understanding Roles and Privilenges
  • Defining Analytic Privileges & Defining Roles
  • Masking Sensitive Data & Anonymizing Data
  • Introduction to Advanced Modeling
  • Information Views
  • Introducing Information Views
  • Understanding the Different Types of Views
  • Working with Common View Design Features
  • Using Nodes in Calculation Views
  • Using Projection Nodes
  • Using Join Nodes
  • Working with Data Sets
  • Aggregating Data
  • Creating Cubes with Star Join Calculation Views
  • Extracting Top Values With Rank Nodes
  • Modeling Functions
  • Create Restricted and Calculated Columns
  • Filter Data
  • Use Variables and Input Parameters
  • Create Hierarchies
  • Implements Currency Conversion
  • SAP HANA Studio Modeling
  • Using SQL in Models
  • Introducing SAP HANA SQL & Working with SQLScript
  • Introduction to Advanced Modeling
  • SAP HANA Predictive Analysis Library (PAL)
  • Describing SAP HANA PAL
  • Using PAL in Flowgraphs
  • Calling PAL Functions in Calculation Views
  • Calling PAL Procedures in SQL Scripts
  • Exploring the PAL Library
  • SAP HANA Spatial
  • Introduction SAP HANA Spatial
  • Working with Spatial Data Types
  • Importing and Exporting Spatial Data
  • Accessing and Manipulating Spatial Data
  • Using Spatial Clustering & SAP HANA Graph
  • Defining SAP HANA Graph Workspace
  • Describing the Different Graph Algorithms
  • Using the Graph Node in Calculation Views
  • Using GraphScript Procedures
  • SAP HANA Text & Understanding Full Text Search
  • Understanding Text Analysis & Understanding Text Mining
  • SAP HANA Series Data
  • Getting Started with SAP HANA Series Data

Trainer's Profile


Xavier is an Engineering Graduate in Computer Science from New Delhi, India. Has over 12 years of experience in IT infrastructure, management, training and consultancy. Trained over 800 professionals and fresh graduates in the span of 4 years on various SAP, Microsoft and DevOps technologies. Key Subject Areas: Big Data, Data Engineering, Data Warehouse, Machine Learning, Artificial Intelligence, Azure Cloud,
Business Intelligence Development & Reporting.

Trainees from various MNCs and Government sector organisations such as Petronas, BP, Shell, Sime Darby, BrightTree, EY, Accenture, Deloitte, Telekom Malaysia, Tenaga Nasional Berhad, Intelligence Malaysia, Abeam Consulting, Malaysian Airlinrs, Carlsberg, SAINS, HCL Axon, IBM, HP, World Health Organization aming many others. As well as students and fresh graduates from UPM, UKM, UMP and UiTM (Shah Alam) universities.

Have Any Question?

If you need further information about this course, please contact:

Registration Course