HANA Developer‎ > ‎

HANA Modeling & Analytics (BI-BO)

                         
                                                                           SAP HANA Pune, SAP HANA training in Pune, SAP HANA Training, Institute for SAP HANA, SAP HANA, SAP Training Pune, SAP ABAP training                                in Pune, SAP Webdynpro Training in Pune, SAP institute, SAP Coaching Center, Best SAP 
Training Center  , Top SAP Training Center, SAP HANA Trainer, SAP Freelancer, SAP HANA Freelancer.     SAP HANA Training, Pune, Maharashtr
aIndia, 411
                                    HANA Modeling & Analytics (BI-BO)014 .  school of HANA
 

H
ANA is used as a DATABASE to improve the performance of the Business Applications ( i.e Business Transactions & Transactional Reports ) or to speed up Existing Analytic Reports.
So, a good HANA consultant Would understand NOT just the database but also the Analytic applications that can work with HANA to make it  a perfect combination.
Business Objects Powered by HANA is the best choice for any large organization looking for faster analytic Reporting.  SOH offers you a well designed course to cover all the skills that you require to work independently not only on the Database but also in the reporting front.

Introduction 

                          • History and Fundamentals of Data-warehousing in Depth.
                          • Star Schema And Extended Star Schema Techniques.
                          • Clear picture on OLTP and OLAP systems.

Introduction to SAP HANA

                          • SAP In-Memory Strategy
                          • HANA compare to BW 
                          • Architecture 
                          • Architecture Overview 
                          • IMCE and Surroundings (In memory Computing Engine)
                          • Row Store & Column Store 
                          • Installation and deployment scenarios 

Navigation

                          • Introduction to HANA Studio
                          • HANA Administration Prospective
                          • Modeler Prospective
                          • System monitoring.

LT (Landscape Transformation) OR Trigger Based Replication

                          • Remote Function Calls
                          • Creating RFC Destinations in SAP ABAP
                          • Replicating SAP tables from OLTP Server using Trigger based Replication
                          • Real time Replication
                          • Job Scheduling and monitoring.
                          • Parallel and Multi-Thread processing.

SQL Scripts

                          • Data Types
                          • Table Creation, Modification, Updating and Deletion operations.
                          • SQL Select Statements
                          • Joins and Unions 
                          • String Operations
                          • Stored procedures
                          • CE (Calculation Engine) Functions.
                          • Aggregations and lot more.

Modelling

                          • Applying star schema technique in SAP HANA
                          • Attribute Views 
                            • Calculated Columns
                            • Hierarchies 
                            • Time Data Generation 
                          • Analytic Views
                            • Variables & Input Parameters
                            • Calculated & Restricted Columns
                            • Currency & Quantity Conversions
                          • Calculation Views
                            • Star Joins, Cubes & Dimensions
                            • SQL Script based Views
                          • Calculation Engine Functions Depth.

HANA -ETL Replication Methodology

                          • BODS (Business Object Data services)
                          • HANA As a Central Repository
                          • JDBC & ODBC connectivity.
                          • Replicating data from SAP OLTP Server Using BODS
                          • Replicating data from Flat File Source systems
                          • Replicating data from BI System
                          • Backward replication technique.
                          • Bulk Load & Scheduling 
                          • Extracting ECC data using BW Extractors
                          • Scheduling Stored Procedures

Transformations using BODS 

                          • Merge Transform
                          • Pivot & Reverse Pivot Transformations
                          • SQL Transformation
                          • Key Generation Transform
                          • Validation Transform
                          • Case Transform

Business Objects CMC & Information Design Tool

                          • Creating Repository
                          • Relational Database & OLAP Connections
                          • Working with Universes
                          • Creation of Project & Data Foundation to Build the Universe
                          • Creating Data Services Repository User

Xcelsius / SAP BO Dashboards

                          • Consuming BEx Query
                          • Consuming an Universe to Design a Dashboard
                          • Working With TABs
                          • Working with Workbook
                          • Visualizing the data in Charts
                          • Using Selectors

SAP HANA Reporting Using MS Excel

                          • SAP HANA MDX Provider
                          • Creating ODBC Connection
                          • Reporting Fundamentals
                          • Using Filters and Hierarchies
                          • Graphical Reporting
                          • Advanced Reporting Techniques.

Reporting Using Business Object Explorer 4.0

                          • Creating HANA Source Systems
                          • Managing Info-Spaces
                          • Geographical Reporting
                          • Time based reporting
                          • Hierarchical Reporting
                          • Configuring & Indexing the Views
                          • Creating Exploration Viewset
                          • Creating URLs for Web-based Reporting
                          • Reporting with BOEx in Depth

Crystal Reports with SAP HANA

                          • Creating Relational Database Connection
                          • Reporting on HANA tables
                          • Reporting on HANA Views
                          • Reporting on Stored Procedures

SAP Lumira

  • Getting started With Lumira
  • Data Acquisition from SAP HANA and other Sources
  • Preparing the datasets.
  • Lumira on Cloud
  • Data Visualization
  • Designing Dashboards & Stories
  • Sharing the Stories on Cloud