SAP HANA Implementation, Modeling and Reporting Course at UDEMY Overview
Duration | 23 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Faculty
- + 1 more item
SAP HANA Implementation, Modeling and Reporting Course at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 2 downloadable resources & 13 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
SAP HANA Implementation, Modeling and Reporting Course at UDEMY Course details
- For Consultants
- For Developers
- For Architects
- For Functional Team Members and students
- Develop a strong understanding and practical knowledge about both SAP HANA 1.x and 2.x
- Be able to develop an end to end scenario on SAP HANA including modelling, reporting and data provisioning
- Use advanced features specific to SAP HANA database such as HDI, SDA , SDI
- Understand how to build coarse and granular security
- Understand how to implement change management using GIT
- Be able to extract data from various SAP and NON SAP source systems using BODS, SDA, DXC, File import and more methods
- Get introduced to BOBJ business intelligence and build reports using tools such as Lumira, Webi, IDT and more
- Understand the modelling levels, concepts and best practices
- SAP HANA® is a game changing and best selling product in the history of SAP®
- Learn it by implementing real time use cases, get started with the new and exciting world of real time reporting, analytics and big data
- Understand the new tools which will used with the Cloud solution like SAP Business Application studio, SAP Cloud central, SAP Cloud cockpit, SAP Cloud database explorer
SAP HANA Implementation, Modeling and Reporting Course at UDEMY Curriculum
2.x - Course structure and Guidance for best Outcome (MUST)
Welcome to the new SAP HANA 2.x Course structure
SAP HANA 2.0 50,000 feet Summary
2.x - Setting up your own SAP HANA Instance
Introduction to the section
Register and Download SAP HANA express edition
System Requirements
Setup Virtual box and Import VM image
Setup VMWare and Import + Install VM image
Configure and Start the Database
Host Mapping and Test WebIde
Mount DB on WebIDE
Selecting the Target tenant for persistence
2.x Building SAP HANA models for Purchase Insights
Section Introduction
Modelling Fundamental Idea (Over simplified)
WebIDE Walkthrough (getting ready for the project)
Project Data Model and Model Design
Importing Data and do your own modeling
Import the whole project with Data and Models
Introduction to SAP HANA Joins(Regular) - Theory
Inner Join 1-1 (Theory and Hands-on)
Inner Join 1-n (Theory and Hands-on)
Left Outer Join (Theory and Hands-on)
Right Outer Join (Theory and Hands-on)
Full Outer Join (Theory and Hands-on)
Referential Join (Theory and Hands-on)
Build Employee Dimension Calculation View
Build Partner Dimension Calculation View
Build Product Dimension Calculation View
Build Purchase Insights Cube Calculation View
A closer look at the Semantic Layer
Introduction to SAP HANA Nodes (Part 1)
Implement Restricted Column
2.x Smart Data Integration and Access(SDI/A)
Section Introduction
Install SDI Components on the Hana Server
Install SDI on VMware Using the Shared Drive
Importing Data and Build your own models
Create Remote Connection
Create MTA Project
UAA Setup (Access between Tenant and HDI)
Updating YAML file and Creating a .hdbgrants file
Create Virtual Table
Test an empty SDI FlowGraph
Import the Data Flows
Project Base cube design - Walkthrough
Create projection 1
Create projection 2
Use a Case Transform to Split the Data
Use a Union Transform to combine similar datasets
Use a Join Transform
Use a Aggregate Transform to Roll up the measures
Project CDC(Change Data Capture) Design - Walkthrough
Current Source Table Analysis
Setup Source table for the project
Create Virtual Table for CDC
Setup Namespace
Setup Capture Table for CDC
Build Surrogate Key
Use Table Comparison for CDC
Use History Preserving for CDC
2.x Build SAP HANA Models for Sales Insights
Section Introduction
Section Intro - Project Data Model and Model Design
Importing Data and do your own modeling
Import the whole Project with Data and Models
Build Partner Dimension Calculation View
Build Cube Calculation view for 2014 Data
Build Cube Calculation view for 2015 Data
Union 2014 and 2015 datasets
Implement a filter to restrict data
Implement an Input Parameter to collect user selection
Create an extra column for Currency Conversion
Implement Currency Conversion
Rank Feature Introduction
Implement Rank Functionality (Absolute)
Implement Rank Functionality (Percentage)
Implement a Temporal Join to make a time bound selection
Implement Spatial Join to operate on Geo data
Implement Hierarchies
Documentation
2.x- Model Optimization and Accuracy
Section Introduction
Fundamentals
Performance Analysis - Test Features
Debug Mode - Test Features
Explain Plan - Test Features
Visualize Plan - Test Features
Performance Improvement by reducing data vertically and horizontally
Performance Improvement by Avoiding Join when not required
Performance Improvement by Union Pruning(avoiding a sub set when not required)
Maintaining Accuracy
Data Lineage
SAP HANA Implementation, Modeling and Reporting Course at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?