SAP HANA Implementation, Modeling and Reporting Course

سرفصل های دوره

Learn how to build a Real Time Platform using SAP HANA the best selling product in the history of SAP (1.x + 2.x+ Cloud)

01 - 2.x - Course Structure and Guidance for best Outcome (MUST)

001 Welcome to the New SAP HANA 2.x Course structure

002 New Addition - Get Started with Hana Cloud (from section 19 onwards).html

003 Accessing resources and planning your learning journey.html

004 SAP HANA 2.0 50,000 feet Summary

005 Additional Study Materials and Documentation.html

02 - 2.x - Setting up your own SAP HANA Instance

001 Introduction to the section

002 Register and Download SAP HANA express edition

003 System Requirements.html

004 Setup Virtual box and Import VM image

005 Setup VMWare and Import + Install VM image

006 Configure and Start the Database

007 Host Mapping and Test WebIde

008 Mount DB on WebIDE

009 Selecting the Target tenant for persistence

03 - 2.x - Building SAP HANA Models for Purchase Insights ( Level Beginner)

001 Section Introduction

002 Modelling Fundamental Idea (Over simplified)

003 WebIDE Walkthrough (getting ready for the project)

004 Project Data Model and Model Design

005 3.18.txt

005 Importing Data and do your own modeling

005 Modelling-project-1-20230319T131248Z-001.zip

006 Import the whole project with Data and Models

007 Introduction to SAP HANA Joins(Regular) - Theory

008 Inner Join 1-1 (Theory and Hands-on)

009 Inner Join 1-n (Theory and Hands-on)

010 Left Outer Join (Theory and Hands-on)

011 Right Outer Join (Theory and Hands-on)

012 Full Outer Join (Theory and Hands-on)

013 Referential Join (Theory and Hands-on)

014 Build Employee Dimension Calculation View

015 Build Partner Dimension Calculation View

016 Build Product Dimension Calculation View

017 Build Purchase Insights Cube Calculation View

018 A closer look at the Semantic Layer

019 Introduction to SAP HANA Nodes (Part 1)

020 Implement Restricted Column

04 - 2.x - Smart Data Integration and Access (SDIA) (Level Beginner, Intermediate)

001 Section Introduction

002 Install SDI Components on the Hana Server

003 Install SDI on VMware Using the Shared Drive

004 Importing Data and Build your own models

004 SDIA-20230319T131247Z-001.zip

005 Create Remote Connection

006 Create MTA Project

007 UAA Setup (Access between Tenant and HDI)

008 Updating YAML file and Creating a .hdbgrants file

009 Create Virtual Table

010 Test an empty SDI FlowGraph

011 Import the Data Flows

012 Project Base cube design - Walkthrough

013 Create projection 1

014 Create projection 2

015 Use a Case Transform to Split the Data

016 Use a Union Transform to combine similar datasets

017 Use a Join Transform

018 Use a Aggregate Transform to Roll up the measures

019 Project CDC(Change Data Capture) Design - Walkthrough

020 Current Source Table Analysis

021 Setup Source table for the project

022 Create Virtual Table for CDC

023 Setup Namespace

024 Setup Capture Table for CDC

025 Build Surrogate Key

026 Use Table Comparison for CDC

027 Use History Preserving for CDC

05 - 2.x - Build SAP HANA Models for Sales Insights (Level Intermediate)

001 Section Introduction

002 Modelling-project-2-20230319T131244Z-001.zip

002 Section Intro - Project Data Model and Model Design

003 Importing Data and do your own modeling

004 Import the whole Project with Data and Models

005 Build Partner Dimension Calculation View

006 Build Cube Calculation view for 2014 Data

007 Build Cube Calculation view for 2015 Data

008 Union 2014 and 2015 datasets

009 Implement a filter to restrict data

010 Implement an Input Parameter to collect user selection

011 Create an extra column for Currency Conversion

012 Implement Currency Conversion

013 Rank Feature Introduction

014 Implement Rank Functionality (Absolute)

015 Implement Rank Functionality (Percentage)

016 Implement a Temporal Join to make a time bound selection

017 Implement Spatial Join to operate on Geo data

018 Implement Hierarchies

019 Documentation

06 - 2.x - Model Optimization and Accuracy

001 Section Introduction

002 Fundamentals

003 Performance Analysis - Test Features

004 Debug Mode - Test Features

005 Explain Plan - Test Features

006 Visualize Plan - Test Features

007 Performance Improvement by reducing data vertically and horizontally

008 Performance Improvement by Avoiding Join when not required

009 Performance Improvement by Union Pruning(avoiding a sub set when not required)

010 Maintaining Accuracy

011 Data Lineage

07 - 2.x - Model and Data Security

001 SDIA-20230319T131247Z-001.zip

001 Section Introduction

002 Security Fundamentals

003 Current Security Layout

004 Create User

005 Give User access to the HDI schema

006 Enable SQL Analytic Privilege at a Model Level to protect underlying data

007 Create SQL Analytic Privilege to give access to model data to a user

008 Assign Analytical Privilege to a User and Test Access

08 - 2.x - Version Control and Model Operation

001 Section Introduction

002 Using Git for version control and Management

003 Setting up and Initializing a local Git repository

004 Managing changes in the main branch of the Local Git Repository

005 Merging changes from local branch to main branch in a Local Git Setup

006 Clone a Project from GitHub

007 Setting up and initializing a Remote Repository

008 Managing changes between the Local and Remote Git Repositories

009 Pushing changes from a branch in the local Git to the Remote Repository

09 - 1.x - Introduction and Positioning

001 Welcome

002 HANA 2.x High Level Preview Latest

003 Whats the Problem

004 What is SAP HANA

005 Main Features of SAP HANA

006 SAP HANA Solution+ Proof Points

007 SAP HANA Deloyment Options

008 Additional Study.html

009 HANA 2.0 Update

10 - 1.x - SAP HANA Scenarios

001 SAP HANA Agile Data Mart

002 SAP HANA Operational Data Mart

003 SAP HANA Accelerators

004 SAP Business Suite, BW and Apps on HANA

005 SAP HANA Live & Rapid Deployment Solutions (RDS)

006 Additional Study.html

11 - 1.x - SAP HANA Architecture

001 SAP HANA Landscape Architecture

002 SAP HANA DB Architecture

003 Persistence & Hardware

004 Additional Study.html

12 - 1.x - SAP HANA Studio + Development Workbench + Web IDE

001 HANA Studio Setup

002 HANA Studio Walk through

003 Create Schema, Tables and Packages

004 Exercise-1-Studio.pdf

005 HANA 2.0 Update Web Development work bench and access url

006 HANA 2.0 Update Web IDE Walk through, connecting to a system

007 HANA 2.0 Update Web IDE Create table, Import data

008 HANA 2.0 Update Web IDE Creating calculation views

external-links.txt

13 - 1.x - Introduction to CO-PA Report

001 What is CO-PA

002 CO-PA Implementation overview on SAP HANA

003 saphelp-46c-en-7a-4c37ef4a0111d1894c0000e829fbbd-content.pdf

14 - 1.x - Data Provisioning

001 What is Data Provisioning and types of DP

002 E2E-Modeling-Tutorial-Data.rar

002 Uploading Data from flat files

003 Exercise-2-CSV.pdf

004 Introducing and Architecture SAP Landscape Transformation (SLT)

005 Setup SLT

006 Load a Table using SLT

007 SLT-EX.pdf

008 Introducing BODS

009 Import Table using Basic Query Transform

010 Advanced Query and Case Transform

011 Exercise-4-BODS.pdf

012 Import data from SAP ERP to HANA using DXC Part 1

013 Import data from SAP ERP to HANA using DXC Part 2

014 Introduction to SAP Sybase Replication server

015 Introduction to Smart Data Access

016 Exercise Implementing Data Provisioning for COPA Use Case.html

15 - 1.x - Modeling

001 Say hi to Modeling and Star SchemaCubes

002 Levels of Modeling in SAP HANA

003 Joins- connecting tables

004 Modeling for COPA

005 HANA 2.0 Update Changes in the Modelling Approach in HANA 2.0

006 Create Attribute View --- Product

007 Create Attribute View Customer

008 COPA-Introduction-and-attribute-views.pdf

009 Build Hierarchies

011 Create-Time-Attribute-Views.pdf

012 Derived Attribute Views

013 Simple Analytic Views

014 Create Filters and Calculated colums

015 COPA-Analytical-View.pdf

016 Restricted colums

017 Input variables

018 Currency conversion

019 Input Parameters

020 Exercise-Currency-Conversion.pdf

021 Graphical Calculation Views

022 More Graphical Calculation Views Scenarios

023 COPA-Graphical-Calculation-View.pdf

024 Create Decision Tables

025 Use Decision Tables in Calculation Views

026 Introduction to SqL script

027 Working with SQL script - Procedures

028 Create-Procedures-with-SQL-Script.pdf

029 Implementing Scripted Calculation Views

030 Exercise-Calcunionscript.pdf

031 Approach to Modeling in SAP HANA

032 Additional Study.html

033 HANA 2.0 Update Attribute View as a Calculation View ( Customer Data)

034 HANA 2.0 Update Attribute View as a Calculation View ( Material Data)

035 HANA 2.0 Update Analytic View as a Calculation View ( Actual)

036 HANA 2.0 Update Analytic View as a Calculation View ( Projected)

037 HANA 2.0 Update Calculation View with only underlying calculation views

16 - 1.x - Reporting

001 What is a Report

002 Introducing business objects Reporting stack

003 Information Design Tool(IDT) and Universe

004 IDT Create a Relational Connection to HANA

005 IDT Build a universe on top of HANA Models

006 Create-a-Universe-on-HANA-models.pdf

007 Web Intelligence Connect to HANA Universe

008 Web Intelligence Build Report on top of hana Universe

009 Create-a-Report-on-Web-Intelligence.pdf

010 MS Excel Report on HANA Cubes with Hierarchies

011 Design Studio Architecture

012 Design Studio Create Report on SAP Models PART 1

013 Design Studio Create Report on HANA Models PART 2

014 Creating-a-report-in-Design-Studio.pdf

015 SAP Lumira Acquire and Prepare Data from SAP HANA

016 SAP Lumira Visualize Data

017 SAP Lumira Consume, build stories and Share

17 - 1.x - Transporting models

001 Delivery Units

002 Exporting SAP HANA Models

003 Importing SAP HANA Models

004 Importing BW Models and SAP ERP meta data into HANA

005 Useful Supplementary features

006 Additional Study.html

18 - 1.x - Security

001 Create Users

002 Privileges and Roles

003 Analytic Privileges

004 End to End security Mapping HANA and BOBJ User

005 Exercise 17.html

006 Additional Study.html

19 - SAP HANA Cloud Introduction

001 What to expect

002 Resources.html

003 Why SAP HANA Cloud

004 What is SAP HANA Cloud

005 How is it different from SAP HANA on premise

006 SAP HANA Key Features

007 HANA Cloud tools

008 SAP HANA Use cases and proof points

20 - Get your Free SAP HANA Cloud Instance

001 Section Introduction

002 Hana cloud trail - How to access landing page and register

003 Provision the SAP HANA Cloud instance

004 check database health with HANA Cloud cockpit post installation

21 - Setup Business Application Studio and your first project with data

001 Section Introduction

002 Make sure your Instance is up and running

003 Accessing Business application studio (BAS) and connecting to your cloud DB

004 Deploy project in BAS and study the HDI created

005 Create tables and load data from BAS project using hdbtable method

006 BAS Walkthrough

22 - SAP HANA Cloud Connectivity between System DB Schema and Project HDI

001 The problem we are trying to solve and the process

002 Import data and Create user on the system cloud HANA DB

003 Create user provided service

004 Make entry in the MTA yaml file

005 Create HDB grant file

006 Create synonym, mapping and test

007 Create calculation view on the synonym, deploy and test

23 - SAP HANA Cloud functionalities, features and Advanced capabilities

001 Section Introduction

002 General Modelling Idea

003 Fundamental DB Features

004 Create Schema, tables and insert values

005 Types of Calculation Views

006 Types of Nodes supported in Calculations views

007 Modelling Features

008 Demo variables, filters, calculated columns

009 Helpful Features

24 - User and Roles - Giving Access to your models

001 Section Introduction

002 Security Scenario

003 Create HDB role

004 Create users, grant roles and test for data access

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy