SAP Business Intelligence(BI) Training

SAP Business Intelligence(BI) Training

About Proerp Academy

Proerp Academy is a leading E-Learning Platform both Online and Instructor-led training(Offline).We have trained the students and professionals across the globe in different technologies like  SAP, Big Data Hadoop,Amazon Webservices(AWS), Business Intelligence and Analytics,Big Data Analytics, Data Science Analytics and Digital Maketing.

We have efficient and affordable learning solutions that is accessible to the millions of interested students and professionals across the globe.

About the Course:

Proerp Academy’s SAP BI Online and Offline training will train the Students and Professionals  how to use SAP BI Module effectively and efficiently.

This  SAP BI training also helps the Students and Professionals to upgrade the skills to handle Extraction,Modelling and Reporting Activities in SAP BI.

This Course provides the skills and knowledge of experienced SAP BI Certified Consultants and Experts.

This Course will provide you the necessary skills to implement SAP BI Module in the Industry.

The Course provides you the overview of SAP BI Module.

Training Objectives:

  • SAP Business Intelligence(BI) Overview
  • BI Objects
  • Flat File Extraction
  • Info Providers in BI
  • Datastore Objects
  • Transformations
  • Open Hub Destination
  • Process Chain
  • Performance Management
  • ABAP for BI
  • BI Content
  • Reporting in BI
  • Extractions in BI

 

 

Module 1

Introduction to SAP BI

Goal:

In this module,You will learn about Introduction to Business Intelligence Concepts .

Objective:

After completing this module 1,you should be able to:

  • Understand Business Intelligence System
  • Understand BI Architecture
  • Understand Different Source Systems
  • Understand Star Schema and Extended Star Schema
  • Understand the Difference between OLTP(SAP R/3 System) and OLAP(SAP BI System)

Topics:

  • Introduction to Business Intelligence System
  • BI Architecture
  • Different Source Systems
  • Star Schema and Extended Star Schema
  • Difference between OLTP(SAP R/3 System) and OLAP(SAP BI System)

Hands on:

  • BI Architecture
  • Different Source Systems
  • Difference between Star Schema and Extended Star Schema
  • Difference between OLTP(SAP R/3 System) and OLAP(SAP BI System)

Module 2

BI Objects

Goal:

In this module,You will learn about BI Objects.

Objective:

After completing this module 2,you should be able to:

  • Understand Info Area
  • Understand Info Object Catalog
  • Understand Info Objects
  • Understand Data Source
  • Understand Application Component
  • Understand Transformations
  • Understand Info Cube
  • Understand Data Store Object(DSO)
  • Understand Info Package
  • Understand Data Transfer Process(DTP)

Topics:

  • Info Area
  • Info Object Catalog
  • Info Objects
  • Data Source
  • Application Component
  • Transformations
  • Info Cube
  • Data Store Object(DSO)
  • Info Package
  • Data Transfer Process(DTP)

Hands on:

  • Info Area Concept
  • Info Object Catalog Concept
  • Info Objects Concept
  • Data Source Concept
  • Application Component Concept
  • Transformations Concept
  • Info Cube Concept
  • Data Store Object(DSO) Concept
  • Info Package Concept
  • Data Transfer Process(DTP) Concept

 

 

 

Module 3

Flat File Extractions

Goal:

In this module,you will learn about Flat File Extractions.

Objective:

After completing this module 3,you should be able to:

  • Understand how Master Data(Attributes) is Loaded from Flat File to SAP BI System
  • Understand how Master Data(Attributes and Text) is Loaded from Flat File to SAP BI System
  • Understand how Transaction Data with Fixed units of measures and currencies is Loaded from Flat File to Infocube
  • Understand how Transaction Data with Variable units of measures and currencies is Loaded from Flat File to Infocube
  • Understand how to Create Transformations manually
  • Understand Error Stack DTP
  • Understand Direct Data Access DTP

Topics:

  • Master Data(Attributes) Loading from Flat File to SAP BI System
  • Master Data(Attributes and Text) Loading from Flat File to SAP BI System
  • Transaction Data with Fixed units of measures and currencies Loading from Flat File to Infocube
  • Transaction Data with Variable units of measures and currencies Loading from Flat File to Infocube
  • Creating Transformations manually
  • Errorr Stack DTP
  • Direct Data Access DTP

Hands on:

  • Loading of Master Data(Attributes) from Flat File to SAP BI System
  • Loading of Master Data(Attributes and Text) from Flat File to SAP BI System
  • Loading of Transaction Data with Fixed units of measures and currencies from Flat File to Infocube
  • Loading of Transaction Data with Variable units of measures and currenciesfrom Flat File to Infocube
  • Creating Transformations manually
  • Errorr Stack DTP Creation
  • Direct Data Access DTP Creation

Module 4

Data Store Objects(DSO)

Goal:

In this module,You will learn about DSO .

Objective:

After completing this module 4,you should be able to:

  • Understand how Transaction Data is Loaded from Flat File to Standard DSO
  • Understand how Transaction Data is Loaded from Flat File to Write Optimized DSO
  • Understand how Transaction Data is Loaded from Flat File to Direct Update DSO
  • Understand Overwrite Functionality of DSO
  • Understand Different Types of DSO
  • Understand how to Create Re-Modeling
  • Understand how to Create Re-Partitioning
  • Understand how to Create Info set
  • Understand how Create Multi Providers

Topics:

  • Transaction Data Loading from Flat File to Standard DSO
  • Transaction Data Loading from Flat File to Write Optimized DSO
  • Transaction Data Loading from Flat File to Direct Update DSO
  • Overwrite Functionality of DSO
  • Different Types of DSO
  • Creating Re-Modeling
  • Creating Re-Partitioning
  • Creating Info set
  • Creating Multi Providers

Hands on:

  • Loading of Transaction Data from Flat File to Standard DSO
  • Loading of Transaction Data from Flat File to Write Optimized DSO
  • Loading of Transaction Data from Flat File to Direct Update DSO
  • Overwrite Functionality of DSO
  • Different Types of DSO
  • Creation of Re-Modeling
  • Creation of Re-Partitioning
  • Creation of Info set
  • Creating Multi Providers

Module 5

Process Chain

Goal:

In this module,You will learn about Process Chain in SAP BI.

Objective:

After completing this module 5,you should be able to:

  • Understand how Master Data(Attributes and Texts) are Loaded from Flat File to SAP BI System using Process Chain
  • Understand how Transaction Data is Loaded from Flat File to SAP BI System using Process Chain
  • Understand how Transaction Data is Loaded from DSO to Info cube using Process Chain
  • Understand how Transaction Data is Loaded from Flat File to Info cube using Process Chain
  • Understand how to Schedule Process Chains
  • Understand how to Monitor Process Chain
  • Understand how to Remove from Schedule and Rescheduling the Process Chain

Topics:

  • Master Data(Attributes and Texts) Loading from Flat File to SAP BI System using Process Chain
  • Transaction Data Loading from Flat File to SAP BI System using Process Chain
  • Transaction Data Loading from DSO to Info cube using Process Chain
  • Understand how Transaction Data is Loaded from Flat File to Info cube using Process Chain
  • Scheduling Process Chains
  • Monitoring Process Chain
  • Removing from Schedule and Rescheduling the Process Chain

Hands on:

  • Loading of Master Data(Attributes and Texts) from Flat File to SAP BI System using Process Chain
  • Loading of Transaction Data from Flat File to SAP BI System using Process Chain
  • Loading of Transaction Data from DSO to Info cube using Process Chain
  • Loading of Transaction Data from Flat File to Info cube using Process Chain
  • Scheduling of Process Chains
  • Monitoring the Process Chain
  • Removing from Schedule and Rescheduling the Process Chain

 

Module 6

Open Hub Destination

Goal:

In this module,you will learn  about Open Hub Destination in SAP BI.

Objective:

After completing this module 6,you should be able to:

  • Understand Open Hub Destination for Flat File
  • Understand Open Hub Destination for Data base Tables

Topics:

  • Open Hub Destination for Flat File
  • Open Hub Destination for Data base Tables

Hands on:

  • Creation of Open Hub Destination for Flat File
  • Creation of Open Hub Destination for Data base Tables

Module 7

ABAP for BI

Goal:

In this module,You will learn about  ABAP for BI.

Objective:

After completing this module 7,you should be able to:

  • Understand how to Create Tables
  • Understand how to Create Fields
  • Understand how to Create Domain
  • Understand how to Create Data Element
  • Understand how to Create Views
  • Understand Start Routine
  • Understand Field Routine
  • Understand End Routine
  • Understand Expert Routine

Topics:

  • Creating Tables
  • Creating Fields
  • Creating Domain
  • Creating Data Element
  • Creating Views
  • Start Routine
  • Field Routine
  • End Routine
  • Expert Routine

Hands on:

  • Tables Creation
  • Fields Creation
  • Domain Creation
  • Data Element Creation
  • Views Creation
  • Start Routine Creation
  • Field Routine Creation
  • End Routine Creation
  • Expert Routine Creation

Module 8

BI Business Content Data Sources

Goal:

In this module,You will learn about BI Business Content Data Sources.

Objective:

After completing this module 8,you should be able to:

  • Understand Business Content Data Sources
  • Understand how Data is Extrated from SAP R/3 System to SAP BI System using Business Content Data Sources

 

Topics:

  • Business Content Data Sources
  • Data Extraction from SAP R/3 System to SAP BI System using Business Content Data Sources

Hands on:

  • Business Content Data Sources
  • Extracting Data from SAP R/3 System to SAP BI System using Business Content Data Sources

Module 9

Extraction

Goal:

In this module,You will learn about SAP BI Extraction.

Objective:

After completing this module 9,you should be able to:

  • Understand the SAP Business Content Extraction
  • Understand Generic Extraction
  • Understand Logistics Extraction
  • Understand Controlling and Profitability(COPA) Extraction

Topics:

  • SAP Business Content Extraction
  • Generic Extraction
  • Logistics Extraction
  • Controlling and Profitability(COPA) Extraction

Hands on:

  • SAP Business Content Extraction Steps
  • Generic Extraction Steps
  • Logistics Extraction Steps
  • Controlling and Profitability(COPA) Extraction Steps

 

 

 

Module 10

SAP BI Reporting

Goal:

In this module,You will learn about SAP BI Reporting.

Objective:

After completing this module 10,you should be able to:

  • Understand BEx Query Designer and BEx Analyser
  • Understand Restrictions in BEx Reporting
  • Understand how to use Variables
  • Understand Conditions
  • Understand how to use Formulas
  • Understand how to use Calculated Key Figures
  • Understand how to use Restricted Key Figures
  • Understand how to use Selections
  • Understand how to handle Exceptions
  • Understand how to handle Filters
  • Understand how to use Free Characteristic
  • Understand how to use Structures
  • Understand how to Monitor Query
  • Understand Navigational Attributes
  • Understand Display Attributes
  • Understand how to Assign Hierarchy to Query
  • Understand how to Publish SAP BI Report

Topics:

  • BEx Query Designer and BEx Analyser
  • Restrictions in BEx Reporting
  • Variables
  • Conditions
  • Formulas
  • Calculated Key Figures
  • Restricted Key Figures
  • Selections
  • Exceptions
  • Filters
  • Free Characteristic
  • Structures
  • Query Monitoring
  • Navigational Attributes
  • Display Attributes
  • Assign Hierarchy to Query
  • Publishing SAP BI Report

Hands on:

  • BEX Query Designer and BEX Analyser Creation
  • BEX Reporting Restrictions
  • Variables Creation
  • Conditions Creation
  • Handling Formulas
  • Work with Calculated Key Figures
  • Work with Restricted Key Figures
  • Work with Selections
  • Work with Exceptions
  • Work with Filters
  • Work with Free Characteristic
  • Work with Structures
  • Work with Query Monitoring
  • Work with Navigational Attributes
  • Work with Display Attributes
  • Assignment of Hierarchy to Query
  • Publishing SAP BI Report