SAP BI/BW: Project Design and Implementation

3h 17mIntermediate2020-05-26

Authors

Michael Management

Hands-on simulations and expert-led video lessons

Course details

Get a hands-on guide showing how to go from the theoretical capabilities of SAP Business Intelligence (BI) and Business Warehouse (BW) to the nitty-gritty of building real-world solutions. Learn how to organize data with InfoObjects, build catalogs and collections, aggregate data from multiple sources in a DataSource, trigger calls for data into a Persistent Staging Area (PSA), and add and edit data in a DataStore object (DSO). You can also see how to manage organization methods and perform operations in an InfoCube. Plus, learn to exponentially speed up your data processing workflows with automation and perform data analysis in SAP BW.

Topics include:
Creating InfoObjects and InfoObject catalogs
Creating a DataSource
Calling data in a DataStore object
Transforming data
Automating data processing
Analyzing data

Skills covered

SAP ERPSAP SEDatabase AdministrationBusiness IntelligenceDatabase ManagementData ScienceBusiness Analysis and StrategyDeep Dive (X:Y)

Concepts

1. SAP BI and SAP BW - Project Design and Implementation

01 - Logging on and RSA overview
02 - Creating an InfoArea
03 - InfoObject catalogs - Characteristic and key figure
04 - InfoObject creation - Characteristics
05 - InfoObject creation - Key figures and unit InfoObjects
06 - DataSource creation
07 - InfoPackage creation and PSA overview
08 - DataStore object (DSO) creation
09 - DSO - Transformations and formulas
10 - DSO - Data transfer process (DTP) creation and load monitoring
11 - DSO activation and table contents overview
12 - InfoCube creation
13 - InfoCube - Transform, load, monitor, view data
14 - Load automation with process chains
15 - SAP BW back-end data analysis
16 - Edit data at PSA level
17 - DTP - Full vs. delta