Companies Home Search Profile
TrainingHub TrainingHub

SAP HANA Implementation, Modeling and Reporting Course

Focused View

Junaid Ahmed

22:47:13

54 View
  • 001 Welcome to the New SAP HANA 2.x Course structure.mp4
    08:56
  • 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.mp4
    08:59
  • 005 Additional Study Materials and Documentation.html
  • 001 Introduction to the section.mp4
    00:44
  • 002 Register and Download SAP HANA express edition.mp4
    04:17
  • 003 System Requirements.html
  • 004 Setup Virtual box and Import VM image.mp4
    03:46
  • 005 Setup VMWare and Import + Install VM image.mp4
    09:31
  • 006 Configure and Start the Database.mp4
    12:09
  • 007 Host Mapping and Test WebIde.mp4
    03:21
  • 008 Mount DB on WebIDE.mp4
    02:09
  • 009 Selecting the Target tenant for persistence.mp4
    07:30
  • 001 Section Introduction.mp4
    04:51
  • 002 Modelling Fundamental Idea (Over simplified).mp4
    09:03
  • 003 WebIDE Walkthrough (getting ready for the project).mp4
    02:36
  • 004 Project Data Model and Model Design.mp4
    02:29
  • 005 3.18.txt
  • 005 Importing Data and do your own modeling.mp4
    06:28
  • 005 Modelling-project-1-20230319T131248Z-001.zip
  • 006 Import the whole project with Data and Models.mp4
    10:28
  • 007 Introduction to SAP HANA Joins(Regular) - Theory.mp4
    04:08
  • 008 Inner Join 1-1 (Theory and Hands-on).mp4
    09:22
  • 009 Inner Join 1-n (Theory and Hands-on).mp4
    05:54
  • 010 Left Outer Join (Theory and Hands-on).mp4
    03:31
  • 011 Right Outer Join (Theory and Hands-on).mp4
    02:35
  • 012 Full Outer Join (Theory and Hands-on).mp4
    02:18
  • 013 Referential Join (Theory and Hands-on).mp4
    02:28
  • 014 Build Employee Dimension Calculation View.mp4
    06:44
  • 015 Build Partner Dimension Calculation View.mp4
    12:50
  • 016 Build Product Dimension Calculation View.mp4
    07:05
  • 017 Build Purchase Insights Cube Calculation View.mp4
    09:00
  • 018 A closer look at the Semantic Layer.mp4
    12:11
  • 019 Introduction to SAP HANA Nodes (Part 1).mp4
    06:01
  • 020 Implement Restricted Column.mp4
    06:04
  • 001 Section Introduction.mp4
    03:21
  • 002 Install SDI Components on the Hana Server.mp4
    05:46
  • 003 Install SDI on VMware Using the Shared Drive.mp4
    07:34
  • 004 Importing Data and Build your own models.mp4
    06:39
  • 004 SDIA-20230319T131247Z-001.zip
  • 005 Create Remote Connection.mp4
    01:35
  • 006 Create MTA Project.mp4
    02:20
  • 007 UAA Setup (Access between Tenant and HDI).mp4
    02:08
  • 008 Updating YAML file and Creating a .hdbgrants file.mp4
    02:41
  • 009 Create Virtual Table.mp4
    02:34
  • 010 Test an empty SDI FlowGraph.mp4
    04:14
  • 011 Import the Data Flows.mp4
    05:49
  • 012 Project Base cube design - Walkthrough.mp4
    02:21
  • 013 Create projection 1.mp4
    12:34
  • 014 Create projection 2.mp4
    13:44
  • 015 Use a Case Transform to Split the Data.mp4
    07:52
  • 016 Use a Union Transform to combine similar datasets.mp4
    05:26
  • 017 Use a Join Transform.mp4
    06:46
  • 018 Use a Aggregate Transform to Roll up the measures.mp4
    06:51
  • 019 Project CDC(Change Data Capture) Design - Walkthrough.mp4
    03:24
  • 020 Current Source Table Analysis.mp4
    04:07
  • 021 Setup Source table for the project.mp4
    03:01
  • 022 Create Virtual Table for CDC.mp4
    02:19
  • 023 Setup Namespace.mp4
    01:57
  • 024 Setup Capture Table for CDC.mp4
    06:18
  • 025 Build Surrogate Key.mp4
    07:09
  • 026 Use Table Comparison for CDC.mp4
    10:29
  • 027 Use History Preserving for CDC.mp4
    08:37
  • 001 Section Introduction.mp4
    02:02
  • 002 Modelling-project-2-20230319T131244Z-001.zip
  • 002 Section Intro - Project Data Model and Model Design.mp4
    11:34
  • 003 Importing Data and do your own modeling.mp4
    05:01
  • 004 Import the whole Project with Data and Models.mp4
    04:37
  • 005 Build Partner Dimension Calculation View.mp4
    08:05
  • 006 Build Cube Calculation view for 2014 Data.mp4
    07:20
  • 007 Build Cube Calculation view for 2015 Data.mp4
    03:08
  • 008 Union 2014 and 2015 datasets.mp4
    05:29
  • 009 Implement a filter to restrict data.mp4
    03:36
  • 010 Implement an Input Parameter to collect user selection.mp4
    02:26
  • 011 Create an extra column for Currency Conversion.mp4
    07:12
  • 012 Implement Currency Conversion.mp4
    03:47
  • 013 Rank Feature Introduction.mp4
    00:45
  • 014 Implement Rank Functionality (Absolute).mp4
    09:33
  • 015 Implement Rank Functionality (Percentage).mp4
    02:23
  • 016 Implement a Temporal Join to make a time bound selection.mp4
    10:52
  • 017 Implement Spatial Join to operate on Geo data.mp4
    06:59
  • 018 Implement Hierarchies.mp4
    03:42
  • 019 Documentation.mp4
    02:59
  • 001 Section Introduction.mp4
    02:02
  • 002 Fundamentals.mp4
    09:01
  • 003 Performance Analysis - Test Features.mp4
    02:33
  • 004 Debug Mode - Test Features.mp4
    06:14
  • 005 Explain Plan - Test Features.mp4
    04:17
  • 006 Visualize Plan - Test Features.mp4
    14:02
  • 007 Performance Improvement by reducing data vertically and horizontally.mp4
    08:49
  • 008 Performance Improvement by Avoiding Join when not required.mp4
    05:21
  • 009 Performance Improvement by Union Pruning(avoiding a sub set when not required).mp4
    10:07
  • 010 Maintaining Accuracy.mp4
    07:47
  • 011 Data Lineage.mp4
    04:51
  • 001 SDIA-20230319T131247Z-001.zip
  • 001 Section Introduction.mp4
    01:09
  • 002 Security Fundamentals.mp4
    08:04
  • 003 Current Security Layout.mp4
    04:48
  • 004 Create User.mp4
    06:26
  • 005 Give User access to the HDI schema.mp4
    07:20
  • 006 Enable SQL Analytic Privilege at a Model Level to protect underlying data.mp4
    02:10
  • 007 Create SQL Analytic Privilege to give access to model data to a user.mp4
    02:19
  • 008 Assign Analytical Privilege to a User and Test Access.mp4
    05:09
  • 001 Section Introduction.mp4
    02:53
  • 002 Using Git for version control and Management.mp4
    06:21
  • 003 Setting up and Initializing a local Git repository.mp4
    04:16
  • 004 Managing changes in the main branch of the Local Git Repository.mp4
    06:47
  • 005 Merging changes from local branch to main branch in a Local Git Setup.mp4
    04:02
  • 006 Clone a Project from GitHub.mp4
    06:20
  • 007 Setting up and initializing a Remote Repository.mp4
    06:02
  • 008 Managing changes between the Local and Remote Git Repositories.mp4
    04:29
  • 009 Pushing changes from a branch in the local Git to the Remote Repository.mp4
    02:47
  • 001 Welcome.mp4
    03:37
  • 002 HANA 2.x High Level Preview Latest.mp4
    10:42
  • 003 Whats the Problem.mp4
    07:59
  • 004 What is SAP HANA.mp4
    05:39
  • 005 Main Features of SAP HANA.mp4
    07:14
  • 006 SAP HANA Solution+ Proof Points.mp4
    03:53
  • 007 SAP HANA Deloyment Options.mp4
    04:12
  • 008 Additional Study.html
  • 009 HANA 2.0 Update.mp4
    01:13
  • 001 SAP HANA Agile Data Mart.mp4
    02:17
  • 002 SAP HANA Operational Data Mart.mp4
    01:41
  • 003 SAP HANA Accelerators.mp4
    01:35
  • 004 SAP Business Suite, BW and Apps on HANA.mp4
    04:33
  • 005 SAP HANA Live & Rapid Deployment Solutions (RDS).mp4
    04:20
  • 006 Additional Study.html
  • 001 SAP HANA Landscape Architecture.mp4
    07:17
  • 002 SAP HANA DB Architecture.mp4
    05:36
  • 003 Persistence & Hardware.mp4
    08:42
  • 004 Additional Study.html
  • 001 HANA Studio Setup.mp4
    02:12
  • 002 HANA Studio Walk through.mp4
    12:25
  • 003 Create Schema, Tables and Packages.mp4
    08:59
  • 004 Exercise-1-Studio.pdf
  • 005 HANA 2.0 Update Web Development work bench and access url.mp4
    10:45
  • 006 HANA 2.0 Update Web IDE Walk through, connecting to a system.mp4
    08:41
  • 007 HANA 2.0 Update Web IDE Create table, Import data.mp4
    08:19
  • 008 HANA 2.0 Update Web IDE Creating calculation views.mp4
    04:31
  • external-links.txt
  • 001 What is CO-PA.mp4
    07:57
  • 002 CO-PA Implementation overview on SAP HANA.mp4
    03:43
  • 003 saphelp-46c-en-7a-4c37ef4a0111d1894c0000e829fbbd-content.pdf
  • 001 What is Data Provisioning and types of DP.mp4
    05:47
  • 002 E2E-Modeling-Tutorial-Data.rar
  • 002 Uploading Data from flat files.mp4
    09:48
  • 003 Exercise-2-CSV.pdf
  • 004 Introducing and Architecture SAP Landscape Transformation (SLT).mp4
    08:05
  • 005 Setup SLT.mp4
    08:55
  • 006 Load a Table using SLT.mp4
    03:40
  • 007 SLT-EX.pdf
  • 008 Introducing BODS.mp4
    03:52
  • 009 Import Table using Basic Query Transform.mp4
    09:56
  • 010 Advanced Query and Case Transform.mp4
    09:56
  • 011 Exercise-4-BODS.pdf
  • 012 Import data from SAP ERP to HANA using DXC Part 1.mp4
    07:59
  • 013 Import data from SAP ERP to HANA using DXC Part 2.mp4
    07:31
  • 014 Introduction to SAP Sybase Replication server.mp4
    03:09
  • 015 Introduction to Smart Data Access.mp4
    09:12
  • 016 Exercise Implementing Data Provisioning for COPA Use Case.html
  • 001 Say hi to Modeling and Star SchemaCubes.mp4
    06:20
  • 002 Levels of Modeling in SAP HANA.mp4
    05:18
  • 003 Joins- connecting tables.mp4
    08:08
  • 004 Modeling for COPA.mp4
    03:18
  • 005 HANA 2.0 Update Changes in the Modelling Approach in HANA 2.0.mp4
    03:41
  • 006 Create Attribute View --- Product.mp4
    09:58
  • 007 Create Attribute View Customer.mp4
    06:05
  • 008 COPA-Introduction-and-attribute-views.pdf
  • 009 Build Hierarchies.mp4
    06:18
  • 010 Time Attribute views.mp4
    06:21
  • 011 Create-Time-Attribute-Views.pdf
  • 012 Derived Attribute Views.mp4
    02:03
  • 013 Simple Analytic Views.mp4
    07:34
  • 014 Create Filters and Calculated colums.mp4
    08:46
  • 015 COPA-Analytical-View.pdf
  • 016 Restricted colums.mp4
    03:49
  • 017 Input variables.mp4
    03:08
  • 018 Currency conversion.mp4
    09:52
  • 019 Input Parameters.mp4
    06:26
  • 020 Exercise-Currency-Conversion.pdf
  • 021 Graphical Calculation Views.mp4
    13:26
  • 022 More Graphical Calculation Views Scenarios.mp4
    04:52
  • 023 COPA-Graphical-Calculation-View.pdf
  • 024 Create Decision Tables.mp4
    08:29
  • 025 Use Decision Tables in Calculation Views.mp4
    05:43
  • 026 Introduction to SqL script.mp4
    04:58
  • 027 Working with SQL script - Procedures.mp4
    08:55
  • 028 Create-Procedures-with-SQL-Script.pdf
  • 029 Implementing Scripted Calculation Views.mp4
    06:06
  • 030 Exercise-Calcunionscript.pdf
  • 031 Approach to Modeling in SAP HANA.mp4
    08:02
  • 032 Additional Study.html
  • 033 HANA 2.0 Update Attribute View as a Calculation View ( Customer Data).mp4
    15:25
  • 034 HANA 2.0 Update Attribute View as a Calculation View ( Material Data).mp4
    06:14
  • 035 HANA 2.0 Update Analytic View as a Calculation View ( Actual).mp4
    14:06
  • 036 HANA 2.0 Update Analytic View as a Calculation View ( Projected).mp4
    08:14
  • 037 HANA 2.0 Update Calculation View with only underlying calculation views.mp4
    08:58
  • 001 What is a Report.mp4
    03:24
  • 002 Introducing business objects Reporting stack.mp4
    06:22
  • 003 Information Design Tool(IDT) and Universe.mp4
    02:57
  • 004 IDT Create a Relational Connection to HANA.mp4
    05:11
  • 005 IDT Build a universe on top of HANA Models.mp4
    05:46
  • 006 Create-a-Universe-on-HANA-models.pdf
  • 007 Web Intelligence Connect to HANA Universe.mp4
    05:41
  • 008 Web Intelligence Build Report on top of hana Universe.mp4
    08:05
  • 009 Create-a-Report-on-Web-Intelligence.pdf
  • 010 MS Excel Report on HANA Cubes with Hierarchies.mp4
    04:43
  • 011 Design Studio Architecture.mp4
    02:17
  • 012 Design Studio Create Report on SAP Models PART 1.mp4
    08:54
  • 013 Design Studio Create Report on HANA Models PART 2.mp4
    08:47
  • 014 Creating-a-report-in-Design-Studio.pdf
  • 015 SAP Lumira Acquire and Prepare Data from SAP HANA.mp4
    03:56
  • 016 SAP Lumira Visualize Data.mp4
    08:15
  • 017 SAP Lumira Consume, build stories and Share.mp4
    02:09
  • 001 Delivery Units.mp4
    03:15
  • 002 Exporting SAP HANA Models.mp4
    05:02
  • 003 Importing SAP HANA Models.mp4
    05:32
  • 004 Importing BW Models and SAP ERP meta data into HANA.mp4
    04:30
  • 005 Useful Supplementary features.mp4
    07:11
  • 006 Additional Study.html
  • 001 Create Users.mp4
    02:30
  • 002 Privileges and Roles.mp4
    07:37
  • 003 Analytic Privileges.mp4
    06:40
  • 004 End to End security Mapping HANA and BOBJ User.mp4
    04:46
  • 005 Exercise 17.html
  • 006 Additional Study.html
  • 001 What to expect.mp4
    02:36
  • 002 Resources.html
  • 003 Why SAP HANA Cloud.mp4
    11:45
  • 004 What is SAP HANA Cloud.mp4
    08:37
  • 005 How is it different from SAP HANA on premise.mp4
    05:30
  • 006 SAP HANA Key Features.mp4
    05:27
  • 007 HANA Cloud tools.mp4
    02:38
  • 008 SAP HANA Use cases and proof points.mp4
    03:58
  • 001 Section Introduction.mp4
    00:41
  • 002 Hana cloud trail - How to access landing page and register.mp4
    08:08
  • 003 Provision the SAP HANA Cloud instance.mp4
    12:15
  • 004 check database health with HANA Cloud cockpit post installation.mp4
    05:28
  • 001 Section Introduction.mp4
    01:10
  • 002 Make sure your Instance is up and running.mp4
    03:15
  • 003 Accessing Business application studio (BAS) and connecting to your cloud DB.mp4
    08:03
  • 004 Deploy project in BAS and study the HDI created.mp4
    04:18
  • 005 Create tables and load data from BAS project using hdbtable method.mp4
    06:15
  • 006 BAS Walkthrough.mp4
    12:49
  • 001 The problem we are trying to solve and the process.mp4
    02:51
  • 002 Import data and Create user on the system cloud HANA DB.mp4
    07:59
  • 003 Create user provided service.mp4
    02:01
  • 004 Make entry in the MTA yaml file.mp4
    02:29
  • 005 Create HDB grant file.mp4
    03:59
  • 006 Create synonym, mapping and test.mp4
    05:59
  • 007 Create calculation view on the synonym, deploy and test.mp4
    05:00
  • 001 Section Introduction.mp4
    01:07
  • 002 General Modelling Idea.mp4
    09:05
  • 003 Fundamental DB Features.mp4
    04:31
  • 004 Create Schema, tables and insert values.mp4
    05:36
  • 005 Types of Calculation Views.mp4
    12:34
  • 006 Types of Nodes supported in Calculations views.mp4
    03:00
  • 007 Modelling Features.mp4
    05:10
  • 008 Demo variables, filters, calculated columns.mp4
    12:04
  • 009 Helpful Features.mp4
    03:38
  • 001 Section Introduction.mp4
    00:32
  • 002 Security Scenario.mp4
    03:15
  • 003 Create HDB role.mp4
    03:12
  • 004 Create users, grant roles and test for data access.mp4
    07:23

    • Description

    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)

    What You'll Learn?

    • 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
    • Understand how to improve model performance using performance tuning methods

    Who is this for?

  • Consultants, Developers, Architects, Functional Team Members and students

    • What You Need to Know?

  • Recommended Knowledge Areas: SAP ERP, Reporting, Modeling and Data Bases. This is not Required you can start from scratch

    • More details

    Description

    SAP HANA® is a game changing and best selling product in the history of SAP®. Helping companies solve data, reporting, latency challenges and unleash their potential with a real time platform. Learn it by implementing real time use cases, get started with the new and exciting world of real time reporting, analytics and big data.

    Key Learnings:

    1. 200+ Professionally authored Lectures.

    2. Immediately usable skills, put it to use in your current project or join a new project.

    3. Quizzes after each topic

    1.x Topics:

    1. Understand why SAP HANA®, Concepts, Architecture and Use cases

    2. Get Comfortable with SAP HANA®  landscape, associated tools and Studio

    3. Learn the different methods and tools to get data from SAP and Non-SAP Sources

    4. Learn In-Memory modeling techniques

    5. Learn to Build reports on SAP BOBJ® reporting stack


    2.x Topics:

    1. Setup up your own SAP HANA® Instance on your Local System

    2. Build SAP HANA® Models for Purchase Insights ( Level: Beginner)

    3. Smart Data Integration and Access (SDI/A) (Level: Beginner, Intermediate)

    4. Build SAP HANA® Models for Sales Insights (Level: Intermediate)

    5. Model Optimization and Accuracy

    6. Model and Data Security

    7. Version Control and Model Operation using Git

    Getting Started with Cloud:

    • What is SAP HANA Cloud and why now?

    • Get your own Trial SAP HANA Cloud Instance

    • How to Import data using HDB table data and CTL methods.

    • Get your initial project setup and curated data to get up and running quickly

    • Overview of database, modelling, design functionalities and features of the SAP HANA Cloud solution

    • Understand how this is different from On premise HANA solution

    • SAP HANA Cloud use cases and scenarios

    • Build Inter connectivity between your main DB instance and your project HDI using user provided service

    • Basic security features - Create users, roles and granting access

    • 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

    • Why this is a great time to enter the Cloud computing area (stay in demand and make premium salaries)

    • How to Create database artifacts, HDI, calculation views, various design and run time objects


    Engaging Teaching:

    1. Expressive and immersive teaching with demonstrations and learning tools

    2. Small, purposeful videos, packed with information, designed specifically for a virtual self paced audience.


    Course Resources:

    2.x: Guidance for server setup on your Local System, Data, Models and Quizzes

    1.x: Exercises, Tailored reading material and quizzes.


    Disclaimer:

    Credits: I have used SAP Public Manuals, Slides, SCN blogs and other resources as reference. Credits are due to the corresponding parties.

    SAP HANA® is a Product of SAP®.

    Explicitly mentioned or otherwise.

    I am not associated with SAP.

    Who this course is for:

    • Consultants, Developers, Architects, Functional Team Members and students

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    SAP HANA

    Junaid Ahmed
    Junaid Ahmed
    Instructor's Courses
    Hello there! I am Junaid Ahmed. I have a bachelors in electrical and electronics engineering and a masters in software engineering . I would like to call my self an Innovation technologist, I am excited to learn, Implement and teach new technologies. I come from a background in enterprise software, and I am currently also focusing on Internet of things , AR, AI and Leading an IoT product development. I have experience with enterprise applications, reporting, and security products. I have consulted with large organizations in Government, Telecom, Power, FMCG sectors, and start-ups. I manage projects using agile methods and tools. I hold certifications in SAP HANA and scrum master.  As far as training goes I have been involved in it parallelly for the decade in different products and practices including real-time analytics, IoT, AI and AR. I have around 50,000 students enrolled in my courses on Udemy. Our clients include Consulting Companies, Implementation partners, Consultants and anybody who is eager to learn in the best way possible. Happy Learning!
    Udemy
    Udemy
    View courses Udemy
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 230
    • duration 22:47:13
    • English subtitles has
    • Release Date 2023/09/12

    Courses related to SAP HANA

    SAP S4 HANA FICO Basic to Advance Complete Course
    UdemySAP S4 HANA FICO Basic to Advance Complete Course
    9:14:41
    01/31/2024
    SAP S4HANA CRM 7.2 Training in SAP Netweaver
    SkillShareSAP S4HANA CRM 7.2 Training in SAP Netweaver
    2:52:47
    03/04/2024
    SAP S/4 HANA for beginner - Complete Mastery from R/3 to S/4
    Udemy Brian Annan
    Brian Annan
    SAP S/4 HANA for beginner - Complete Mastery from R/3 to S/4
    2:10:22
    05/19/2024