SAP HANA Implementation, Modelling and Reporting Course
- Descrição
- Currículo
- FAQ
- Revisões
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:
-
200+ Professionally authored Lectures.
-
Immediately usable skills, put it to use in your current project or join a new project.
-
Quizzes after each topic
1.x Topics:
-
Understand why SAP HANA®, Concepts, Architecture and Use cases
-
Get Comfortable with SAP HANA® landscape, associated tools and Studio
-
Learn the different methods and tools to get data from SAP and Non-SAP Sources
-
Learn In-Memory modeling techniques
-
Learn to Build reports on SAP BOBJ® reporting stack
2.x Topics:
-
Setup up your own SAP HANA® Instance on your Local System
-
Build SAP HANA® Models for Purchase Insights ( Level: Beginner)
-
Smart Data Integration and Access (SDI/A) (Level: Beginner, Intermediate)
-
Build SAP HANA® Models for Sales Insights (Level: Intermediate)
-
Model Optimization and Accuracy
-
Model and Data Security
-
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
-
Inter connectivity between your main DB instance and your project HDI, Security and much more.
Engaging Teaching:
-
Expressive and immersive teaching with demonstrations and learning tools
-
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.
-
1Welcome to the New SAP HANA 2.x Course structureVídeo Aula
-
2New Addition - Get Started with Hana Cloud (from section 19 onwards)Texto
-
3Accessing resources and planning your learning journeyTexto
-
4SAP HANA 2.0 50,000 feet SummaryVídeo Aula
-
5Additional Study Materials and DocumentationTexto
-
6Introduction to the sectionVídeo Aula
-
7Register and Download SAP HANA express editionVídeo Aula
Link to access SAP HANA Express edition
https://www.sap.com/products/technology-platform/hana/express-trial.html
-
8System RequirementsTexto
-
9Setup Virtual box and Import VM imageVídeo Aula
-
10Setup VMWare and Import + Install VM imageVídeo Aula
Install SAP HANA Express on VMware
-
11Configure and Start the DatabaseVídeo Aula
-
12Host Mapping and Test WebIdeVídeo Aula
-
13Mount DB on WebIDEVídeo Aula
-
14Selecting the Target tenant for persistenceVídeo Aula
-
15Stopping the DBTexto
-
16Section QuizQuestionário
-
17Section IntroductionVídeo Aula
-
18Modelling Fundamental Idea (Over simplified)Vídeo Aula
-
19WebIDE Walkthrough (getting ready for the project)Vídeo Aula
-
20Project Data Model and Model DesignVídeo Aula
-
21Import Data and do your own modelingVídeo Aula
-
22Import the whole project with Data and ModelsVídeo Aula
-
23Introduction to SAP HANA Joins(Regular) - TheoryVídeo Aula
-
24Inner Join 1-1 (Theory and Hands-on)Vídeo Aula
-
25Inner Join 1-n (Theory and Hands-on)Vídeo Aula
-
26Left Outer Join (Theory and Hands-on)Vídeo Aula
-
27Right Outer Join (Theory and Hands-on)Vídeo Aula
-
28Full Outer Join (Theory and Hands-on)Vídeo Aula
-
29Referential Join (Theory and Hands-on)Vídeo Aula
-
30Build Employee Dimension Calculation ViewVídeo Aula
-
31Build Partner Dimension Calculation ViewVídeo Aula
-
32Build Product Dimension Calculation ViewVídeo Aula
-
33Build Purchase Insights Cube Calculation ViewVídeo Aula
-
34A closer look at the Semantic LayerVídeo Aula
-
35Introduction to SAP HANA Nodes (Part 1)Vídeo Aula
-
36Implement Restricted ColumnVídeo Aula
-
37Section Quiz P1Questionário
-
38Section IntroductionVídeo Aula
-
39Install SDI Components on the Hana ServerVídeo Aula
-
40Install SDI on VMware Using the Shared DriveVídeo Aula
Install SDI on VMware using the shared drive.
With this method you can download the SDI or any other additional component on your local host and then use that path to install it in the VM
-
41Importing Data and Build your own modelsVídeo Aula
-
42Create Remote ConnectionVídeo Aula
-
43Create MTA ProjectVídeo Aula
-
44UAA Setup (Access between Tenant and HDI)Vídeo Aula
-
45Updating YAML file and Creating a .hdbgrants fileVídeo Aula
-
46Create Virtual TableVídeo Aula
-
47Test an empty SDI FlowGraphVídeo Aula
-
48Import the Data FlowsVídeo Aula
-
49Project Base cube design - WalkthroughVídeo Aula
-
50Create projection 1Vídeo Aula
-
51Create projection 2Vídeo Aula
-
52Use a Case Transform to Split the DataVídeo Aula
-
53Use a Union Transform to combine similar datasetsVídeo Aula
-
54Use a Join TransformVídeo Aula
-
55Use a Aggregate Transform to Roll up the measuresVídeo Aula
-
56Project CDC(Change Data Capture) Design - WalkthroughVídeo Aula
-
57Current Source Table AnalysisVídeo Aula
-
58Setup Source table for the projectVídeo Aula
-
59Create Virtual Table for CDCVídeo Aula
-
60Setup NamespaceVídeo Aula
-
61Setup Capture Table for CDCVídeo Aula
-
62Build Surrogate KeyVídeo Aula
-
63Use Table Comparison for CDCVídeo Aula
-
64Use History Preserving for CDCVídeo Aula
-
65Section Quiz SDIAQuestionário
-
66Section IntroductionVídeo Aula
-
67Section Intro - Project Data Model and Model DesignVídeo Aula
-
68Importing Data and do your own modelingVídeo Aula
-
69Import the whole Project with Data and ModelsVídeo Aula
-
70Build Partner Dimension Calculation ViewVídeo Aula
-
71Build Cube Calculation view for 2014 DataVídeo Aula
-
72Build Cube Calculation view for 2015 DataVídeo Aula
-
73Union 2014 and 2015 datasetsVídeo Aula
-
74Implement a filter to restrict dataVídeo Aula
-
75Implement an Input Parameter to collect user selectionVídeo Aula
-
76Create an extra column for Currency ConversionVídeo Aula
-
77Implement Currency ConversionVídeo Aula
-
78Rank Feature IntroductionVídeo Aula
-
79Implement Rank Functionality (Absolute)Vídeo Aula
-
80Implement Rank Functionality (Percentage)Vídeo Aula
-
81Implement a Temporal Join to make a time bound selectionVídeo Aula
-
82Implement Spatial Join to operate on Geo dataVídeo Aula
-
83Implement HierarchiesVídeo Aula
-
84DocumentationVídeo Aula
-
85Section QuizQuestionário
