SAP DataSphere Data Modelling

A Practical Course on Data Modelling in SAP DataSphere, for the creation of a Profit and Loss Statement.

What you’ll learn
Course Intro – Use Case and User Requirements
Data Import, Cleansing and Data Wrangling
Develop Data Models and Graphical View
Develop Analytical Model
Object Deployment
Unit Testing

Requirements
No programing skills required, However basic knowledge of Excel and Database would be helpful
A computer: Optional
A free trial signup of DataSphere to practice along: Optional
A free CSV source data will be provided for download in course

Description
Disclosure: This course contains the use of artificial intelligence. This course is an Introductory to Intermediary Practical Guide, on how to use SAP DataSphere to create Data Modeling. The created Data Model can then be consumed by a front end Business Intelligence tool to create a company’s Financial Reports. Learners will see how to downloaded Sales Data from an OLTP ERP table as a CSV flatfile and imported in to DataSphere for subsequent processing. This Flat File represents the Sales Data of the Company for a particular period in time. It is imported into a DataSphere Space, this act as a WorkSpace for our Project. Including the Data Wrangling Platform, where learners will get the opportunity to learn first hand Data Wrangling. Through Data Wrangling we are able to Cleanse, Harmonise and carry out initial Integration of the Imported Data before being converted into a Local Table in DataSphere.  This will be used as the Datasource for the Subsequent Data Modelling activities. On top of the Sales Data local table, a Graphical View is built, where learners will observe how we carry out Data Transformations and Data Integration by using methods like Table Joins, Calculated Columns and setting of Field Properties. The Graphical view is used as a source for creating the Analytical Model, which is an OLAP Model that can be consumed by BI tools to build Dashboards, Reports and Interactive Applications.

Who this course is for
Beginner and Intermediate SAP Datasphere Developers and Consultants
Anyone who wants to learn about SAP DataSphere
Anyone who wants to learn how to learn how Data Modelling using DataSphere
Anyone who wants to learn about Cloud based Datawarehousing Technology