SAP Datasphere (Data Warehouse Cloud) – End-to-End Training

This course provides a complete understanding of SAP Datasphere, covering data warehousing concepts, cloud architecture, and integration with SAP BTP, HANA Cloud, and BW systems. You will learn to model data using spaces, tables, views, and analytical models, along with real-time data access, replication, and transformation techniques. The course also covers connectivity using SAP Cloud Connector, data flows, SQL scripting, and integration with external systems.

Course Overview

This SAP Datasphere course is designed to give you a solid understanding of modern cloud-based data warehousing within the SAP ecosystem. It begins with the fundamentals of SAP BTP, HANA Cloud, and the transition from traditional SAP BW systems to Datasphere. You will learn how to set up and navigate the Datasphere environment, work with spaces, and build data models using tables, views, dimensions, and measures. The course also covers data integration concepts such as connectivity, SAP Cloud Connector, virtual data access, and real-time data replication, helping you understand how data is accessed and managed across systems.

The course then moves into advanced areas including analytical modeling, data flows, hierarchies, and SQL scripting to transform and optimize data for business use. You will explore features like data access control, business builder, cataloging, and governance, along with integration scenarios involving SAP BW and external tools. With a strong focus on hands-on implementation and real-time troubleshooting, this course prepares you to design, manage, and deliver scalable data solutions using SAP Datasphere in real-world environments.

Upcoming Demos

Demo ModuleDemo DateDemo TimeTraining ModeAttend Today!
SAP FICONov-6th9:00 AM (IST)Offline
SAP FIORINov-16th10:00 AM (IST)Online
SAP CPIDec-7th6:00 PM (IST)Offline
SAP MMDec-22nd9:00 AM (IST)Online

Required Skill Set

Module

Pre-Requisite

Qualification

Course Content

  • Introduction to the course (Demo Session)
  • Who is this course for
  • Course overview –
  • Introduction to SAP Data sphere
  • Live System Demo
  • FAQs
  • Introduction to Data sphere
  • Difference between Cloud and On premise
  • What does Cloud offers? - What is SAP BTP?
  • Where does Data Warehouse fits?
  • What is HANA and BW/4HANA?
  • Evolution of SAP BW
  • What is SAP Data sphere aka Data Warehouse Cloud?
  • Benefits of Data sphere
  • What is Data sphere How it evolving from DWC?
  • Statement of Direction
  • Implementation Strategy?
  • Data sphere Architecture
  • Developer’s Bird eye view
  • What is SAP Analytics Cloud?
  • How Data sphere is different from SAC?
  • Setting up Data sphere account
  • Getting Started
  • System Walkthrough
  • What is Spaces in Data sphere?
  • User persona in SAP Data sphere
  • SAP Data sphere Modelers
  • SAP Data sphere Builder Layers
  • SAP Data sphere – Data Builder
  • Understanding Dimension and Measure
  • Semantic Usage and Types?
  • Creating table using CSV upload
  • Creating Tables using “New Table”
  • Time & Generate Time Data
  • What is Entity Relationship Model
  • Store ER Diagram
  • Uploading ER diagram as JSON
  • Views in Data sphere
  • View Editor – Association
  • Data Builder-Table, Views
  • Data Layer: Introduction to Analytical Model
  • Options for analytic consumption and openness with external tooling
  • Options for analytic consumption and openness with external tooling
  • Connectivity and Cloud Connector
  • Understand SAP Cloud Connector
  • Why we need cloud connector and setup
  • Configure SAP BTP with Cloud Connector
  • Connections with BW
  • Configure SAP BTP with Cloud Connector
  • Data Provisioning Agent
  • What is Cloud Connector?
  • Basics of Connectivity and Role of SCC
  • What is SAP BTP?
  • Setup your FREE BTP Account
  • Customer View of BTP Account
  • Cloud Connector
  • What is SAP HANA Cloud?
  • Database / Data warehouse / Data lake
  • HANA Cloud v/s On-premise
  • What is Schema in HANA - HDI Container
  • Create HANA Cloud Instance
  • Connect to your HANA Cloud DB
  • HANA Cloud Connections and Remote Table Objects
  • Connect to HANA Cloud from Data sphere
  • Virtual Data Access
  • Real time replication and Snapshot
  • Remote Tables - Types of Joins
  • Joins
  • Currency Conversion
  • Hierarchies and Data flows
  • Hierarchy - Data Flow
  • Introduction
  • FORMULA’S
  • Script operator in data flows
  • SQL views and Script
  • EPM Data Model
  • SQL Views
  • Common challenges in connecting
  • SQL Script - Rules to follow
  • Containers in SQL Script
  • Final code
  • Setup your Free Tier
  • Activating FREE Tier with BTP
  • Data Access Control DIM
  • What is Data Access Control
  • Cross Space Sharing
  • Data Integration Monitor
  • Overview - System Monitor
  • DB Analysis user
  • SAP HANA Cockpit
  • Data Market and I Lookup
  • Data Marketplace
  • Fuzzy Search
  • Data sharing Cockpit
  • Data provider profile
  • Context Management
  • Business Builder
  • The Business Builder Business Builder Artifacts
  • Overview
  • Models
  • Catalog and Integration Flows
  • Why data governance is so difficult?
  • What is Catalog
  • Data discovery and Consumption
  • Business Glossary and Terms
  • Tags and Classification
  • Administration and Monitoring
  • Replication Flow
  • Delta load
  • CDS Views
  • Excel Integration
  • BW Integration
  • SAP BW Hybrid Integration
  • Journey
  • BW Query to Data sphere
  • Remote Authorization
  • Process Flow
  • Authorization
  • Pre-Requisite
  • BW Bridg
  • Key Features
  • Reuse and Rebuild
  • Overview
  • – Architecture
  • - Overview
  • - BW Query to Data sphere
  • - Conversion Overview - Layer shift

Job Scope 

Training Mode 

Students 

:-  100 %

:-  Offline / Online 

:-   352

:-   15+ Years

Job Scope  :-  100 %

Training Mode :- Offline / Online

Students  :-  352

Call & Book Demo

Please enable JavaScript in your browser to complete this form.

Register for Batch

Please enable JavaScript in your browser to complete this form.

This will close in 20 seconds