Explore the SAP HANA landscape, Interfaces for administrators and developers, Learn about the in-memory database, Join Engine, OLAP Engines, Calculation Engine

Version & Service pack details, In-Memory SAP HANA Computing Studio, Connection and session management, Studio Perspectives : Modeler, Development, Debug, Administration Console Catalog and Content in Studio, Hierarchies, Views, Decision Table, Attributes, Variables

Importance of Data Modeling, SAP HANA General Modeling Principles, ER Model, Multi-Dimensional Model, Star Schema, Levels of Modeling in SAP HANA : Attribute Views, Analytic Views, Calculation Views

Hands-on Exercise – Create ER Model, Create Multi-Dimensional Model, Create a Star Schema

Time, Derived, Shared and Hidden views, Hierarchies (Parent-Child), Filters

Hands-on Exercise – create different type of Views, Create parent-child hierarchy, Apply Filters

Multi-Dimensional Model with Analytic Views, Calculated Measures and Attributes, Restricted Measure, Variable Types (Concept, Input).

Hands-on Exercise – Open Analytic View in a Multi-Dimensional Model, Use calculated Measures and Attributes, Use Restricted Measure, Use Variables

Calculation Views (Graphical, Scripted), Union, Join (Inner, Left Outer, Right Outer, Full Outer, Text, Referential), Projection, Aggregation, Choosing Views for Information Model, Connecting tables.

Hands-on Exercise – Check graphical calculation view, Perform full outer join and other types of join operations, Choose Views for Information Model, Connect with tables

Introduce SQL and SQLScript, HANA SQL (DDL, DML, DCL), SAP HANA Referential Join, Table Functions and Procedures, Calling Procedures, Using the SQL Debug Tools.

Hands-on Exercise – Write HANA SQL DDL query, Write HANA SQL DML query, Write HANA SQL DCL query, Perform a referential join, Create Table Functions and Procedures, Call Procedures, Use the SQL Debug Tools

Control Statements, CE_COLUMN_TABLE, CE_JOIN_VIEW, CE_OLAP_VIEW, CE_CALC_VIEW and others

Hands-on Exercise – Use CE_COLUMN_TABLE, Use CE_JOIN_VIEW, Use CE_OLAP_VIEW, Use CE_CALC_VIEW

What is Data Provisioning, Data Provisioning Scenarios, Overview of SAP HANA Vora, Loading Data to HANA Database Table From Excel File, Flat File, Oracle Database, SAP ECC, SAP BW Data Provisioning Using BODS, Data Provisioning Using SLT (SAP Landscape Transformation Replication Server)

Hands-on Exercise – Load data to HANA, Database Table from an excel file, Make data Provisioning Using BODS, Make data Provisioning Using SLT (SAP Landscape Transformation Replication Server)

Data transformation in SAP HANA, The process of data integration, data cleansing and consolidation, The process of loading data from one BI object to another, Various types of transformation (Merge, History Preservation, Row Generator, Table Comparison, Slowly Changing Dimensions)

Hands-on Exercise – Load data from one BI object to another, Perform transformation using Merge technique, Perform transformation using Slowly Changing Dimensions

Understand the Key Concepts of SAP HANA Security, Define Data Access Security, User Creation, Role Creation, Assigning role to user, Assigning Analytical privileges to role

Hands-on Exercise – Create a user account, Create roles Assign roles to user, Assign Analytical privileges to role

Introduction to Transport Connection, Overview on SAP Transport Connection, HANA Transports

Hands-on Exercise – Connect with Transport feature

Project –Develop reports using SAP HANA

Dataset – Sales

This project is involved with creation of reports using SAP HANA. You will get in-depth understanding of creating SAP HANA reports with SAP Business Objects explorer, learning to deploy different SAP HANA views like attribute, analytic and calculation views, understanding how to create SAP HANA Crystal Report, deploying MDX Provider for connecting HANA system to Excel data, data modeling techniques. Upon completion of the project you will gain expertise to develop reports from multiple data sources and view it to glean valuable insights.