Loading...
best4sap@gmail.com +91-9552124464

HANA MODELING & ANALYTICS (BI-BO)



HANA 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.

HANA MODELING & ANALYTICS (BI-BO) Training in Pune Advantages


>
  • Real-Time Project Training
  • Hands-on (Practical) Training
  • 100% Placement Support
  • 10+ Experienced Professionals
  • Flexible Batch Timings
  • Minimum Batch Size
  • Student Referral Bonus
  • Easy Accessible Locations

Job opportunities in HANA MODELING & ANALYTICS (BI-BO)

HANA MODELING & ANALYTICS (BI-BO) is growing field. Currently large number of openings for HANA MODELING & ANALYTICS (BI-BO). We are supporting the student to place in a company.

Quick Contact

HANA MODELING & ANALYTICS (BI-BO) Training Syllabus in Pune


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

Building Corporate Career in HANA MODELING & ANALYTICS (BI-BO)

Schedule an appointment with our experts and learn why so many Students have trusted Best 4 SAP over the years.

Scroll to Top