Online training batch schedules:

SAP HANA MODELLING TRAINING IN PUNE | ONLINE

Duration of Training  :  40 hrs

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

Sap Hana Modelling Training & Certification in Pune

Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry

Realtime Projects, Scenarios & Assignments

Why Radical Technologies

Pre-requisite : No Prerequisite. We will start from Basic

In Radical Technologies, we take all prerequisites required to learn SAP HANA MODELLING.

Deployable on premise or in the cloud, SAP HANA is the in-memory computing platform that lets you accelerate business processes, deliver more business intelligence, and simplify your IT environment. By providing the foundation for all your data needs, SAP HANA removes the burden of maintaining separate legacy systems and siloed data, so you can run live and make better business decisions in the new digital economy.

How does SAP HANA MODELLING work?

SAP HANA combines an ACID-compliant database with application services, high-speed analytics, and flexible data acquisition tools in a single, in-memory platform. As an in-memory database, SAP HANA stores and retrieves data used by applications. It can also act as a modern-day warehouse, integrating data from a wide variety of data sources with live transactional data to deliver up-to-date insights. Built-in application services support the development and deployment of new business apps that exploit data from the digital highway and leverage advanced data processing – text search and analytics, predictive analytics, spatial data processing, graph data processing, and streaming analytics – to deliver deeper insight from Big Data and the Internet of Things at unprecedented speed

COURSE CONTENT :

SAP HANA Studio

Modeler, Administration View, Navigator, System Monitor

 Architecture of SAP HANA

Row Store

Column Store

Database engine of HANA

Data modeling

Reporting

Architecture

Administration

 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 BODS

Export Models

Import Models

SQL Script

CE Functions

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

 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

 Data Provisioning or Data Loading

SAP LANDSCAPE Transformation – SLT

SAP BODS Load to SAP HANA – ODP Enabled

Data Sources

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

 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

 User Management & Security

Distributed System Handling – Cold backup and Hot Backup

 Persistency Layer

 Creating Users

 Creating Roles

 Assign privileges to Users/Roles

 Template Roles

 SQL Statements for user management

 Analytical Privileges, Package Privileges, System Privileges, SQL Privileges

 COPA Accelerator

COPA Overview COPA Reporting in HANA

 Architecture for CO – PA Accelerator , Use Case Scenarios , Scope

 DBSL – Database Shared Library Connection for HANA as secondary Database

 SLT Replication – SAP HANA Model

 SAPBW on HANA

Overview of SAP BW

 SAP BW Powered By Hana as database

 In Memory Optimized Info cube

 In Memory Optimized DSO

Bex Report on SAP HANA Transient Provider

SAP BW Composite provider on HANA model

Learn Sap Hana Modelling – Course in Pune with Training, Certification & Guaranteed Job Placement Assistance!

Online Batches Available for the Areas

Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad