Month 1: Foundation & Core Concepts
1: Introduction & Architecture
Overview of OLTP , OLAP, Data Warehousing, SAP Datasphere
Key components: Spaces, Connections, Data Builder, Business Builder
Understanding integration with SAP S/4HANA and other sources
On-Premise vs Cloud, Cloud service Providers.
2: Data Modeling Basics
folder
Building simple data models
Semantic layer introduction
Hands-on: Create a basic data model from CSV file, S/4HANA data
3: Data Builder – Data layer ( DSP: Modeler/Developer)
Remote Table, Local Table, ERM model, Analytical Model
Replication Flow, Transformation Flow , Data Flow, Init and Delta
Graphical View , SQL View & SQL Script View
Intelligent Lookup, Task chains, Transports,
Hands-on : Sales Model
4: Business Builder – Business Layer ( End user’s area)
Business Builder concepts
Creating business entities and relationships
Semantic enrichment
Hands-on: Build a business model for Sales/Finance reporting
Month 2: Advanced Topics & Reporting
5: Advanced Modeling
SQL Script view, Python Script modeling
Joins, unions, Projection, and calculated , Restricted Measures.
Filters, Variables, Input parameters, Calculations, Functions in Datasphere
Performance optimization tips, Security, Roles, Users
6: Data Integration
Connection management (SAP & non-SAP sources)
Data ingestion methods: replication vs federation
Using Data Flow for transformations
Hands-on: Load data from SAP S/4HANA into Datasphere
7: Integration with Analytics (Reporting)
Connecting Datasphere to SAP Analytics Cloud (SAC)
Building dashboards and stories
Hands-on: Create a Sales / finance report in SAC using Datasphere data
BW Bridge – SAP BW to Data Sphere, Options
8: Best Practices & Project Simulation
Best practices for modeling and integration,FAQs, CV Topics, Mock Interview
Simulate a mini-project: End-to-end flow from S/4HANA → Datasphere → SAC
Project Prearation, Landscape, Phases,Requirements, Teams,
Modeler Activities – Roles & Responsibilities , Q&A and recap