SAP BI/BO Learners Point Training Institute
Course Objective
Upon completion of the course, one will be able to confidently develop, deploy/implement SAP projects and achieve needed ; One will be able to analyse existing SAP systems; Processes configuration of modules suggest changes and support end users. One will develop skills and confidence to work as a BI/BO consultant by demonstrating high-quality programming skills and the level of expertise to troubleshoot and provide technical support.
Course Outline
R/3 Architecture.
- Landscape of SAP.
- BW - Introduction, DWH Introduction
- SAP Business Warehouse concepts and Overview
- Different Source Systems
- Star Schema and Extended Star Schema
- Difference between OLAP and OLTP Processors
Objects
- Info area
- Info object catalogue
- Info Objects
- Application component
- Info source
- Data source
- Transfer rules
- Communication structure
- Update rules
- Info Cubes
- ODS
- Info Package
Objects
- Info Area
- Info Object catalog
- Info objects
- Data source
- Source system
- Application component
- Data source
- Transformations
- Info Cube
- DSO
- Info package
- DTP
Flat file extractions ( & )
- Master data extraction
- Attribute
- Text
- Hierarchy
- Transaction data extraction
- To DSO
- To Info Cube
- DSO to Info Cube
- Data Flow difference between and
- Migration Strategyfrom to
- Data mart concept.
Info Providers: ( & )
- Info Objects
- Introduction to InfoCubes
- Types of InfoCubes .
- Standard InfoCube
- Real time Infocube
- Virtual Providers
Introduction to Datastore Object(DSO)
- Types of DSO's .
- Standard DSO
- Direct-Update DS
- Write Optimized DSO
- Multi Providers & Info set
Analysis Process Designer Transformations
- Introduction to Transformations
- Transformation Rule types (Direct assignment,
- Routines, Initial value, Time Distribution, No update,
- Constant, read master data, Read from DSO)
- Transformation Rule Groups
Open Hub Destination
- Destination As Table(Local & Application server)
- Destination As Data Base Table.
- Concepts of Info spoke(in )
Re-modeling
Error Stack
Process Chain
- Introduction to Process Chain
- Creating Master Data Process Chains
- Creating Transactional Data Process Chain
- Scheduling Process Chains
- Creating Meta Chain
- Monitoring process chains
- Removing from schedule and rescheduling the process
- chains
Performance Management
- Types of Performance Optimization Techniques
- Backend or Data Loading Performance Techniques
- Deleting Indexes.
- Line - item Dimension & High cardinality
- Aggregates & Collapse.
- Partitioning & Re-Partitioning
- DB Statistics
- BI Performance Tuning Activities
Transportation
- Introduction to Transportation.
- BW system Landscape
- Creating of Package and Transport requests
- Collecting the objects in BW across the Landscape
- Transporting the Objects across the BW Landscape
- Deleting and reimporting Transport requests.
- Finding transportation Logs and return cods.
- Transportation error and Solutions
This course is no longer available.
- Duration: Upto 35 Hours
Course details
The course provides in-depth knowledge of business intelligence, business warehousing and business objects engaging best training resources which make sure the learners quickly grasp, sustain the knowledge and carry it back to their desks. The topics covered in the course include business process performance, a web-intelligence dashboard for data Modelling at customer services level, process chain, OLAP & OLTP and more. A combination of highly talented Industry expert trainers, Practical and real scenarios-based training, specially customized course material and tools will offer nothing but the best training experience ensuring highest levels of productivity from the classrooms.Course Objective
Upon completion of the course, one will be able to confidently develop, deploy/implement SAP projects and achieve needed ; One will be able to analyse existing SAP systems; Processes configuration of modules suggest changes and support end users. One will develop skills and confidence to work as a BI/BO consultant by demonstrating high-quality programming skills and the level of expertise to troubleshoot and provide technical support.
Course Outline
R/3 Architecture.
- Landscape of SAP.
- BW - Introduction, DWH Introduction
- SAP Business Warehouse concepts and Overview
- Different Source Systems
- Star Schema and Extended Star Schema
- Difference between OLAP and OLTP Processors
Objects
- Info area
- Info object catalogue
- Info Objects
- Application component
- Info source
- Data source
- Transfer rules
- Communication structure
- Update rules
- Info Cubes
- ODS
- Info Package
Objects
- Info Area
- Info Object catalog
- Info objects
- Data source
- Source system
- Application component
- Data source
- Transformations
- Info Cube
- DSO
- Info package
- DTP
Flat file extractions ( & )
- Master data extraction
- Attribute
- Text
- Hierarchy
- Transaction data extraction
- To DSO
- To Info Cube
- DSO to Info Cube
- Data Flow difference between and
- Migration Strategyfrom to
- Data mart concept.
Info Providers: ( & )
- Info Objects
- Introduction to InfoCubes
- Types of InfoCubes .
- Standard InfoCube
- Real time Infocube
- Virtual Providers
Introduction to Datastore Object(DSO)
- Types of DSO's .
- Standard DSO
- Direct-Update DS
- Write Optimized DSO
- Multi Providers & Info set
Analysis Process Designer Transformations
- Introduction to Transformations
- Transformation Rule types (Direct assignment,
- Routines, Initial value, Time Distribution, No update,
- Constant, read master data, Read from DSO)
- Transformation Rule Groups
Open Hub Destination
- Destination As Table(Local & Application server)
- Destination As Data Base Table.
- Concepts of Info spoke(in )
Re-modeling
Error Stack
Process Chain
- Introduction to Process Chain
- Creating Master Data Process Chains
- Creating Transactional Data Process Chain
- Scheduling Process Chains
- Creating Meta Chain
- Monitoring process chains
- Removing from schedule and rescheduling the process
- chains
Performance Management
- Types of Performance Optimization Techniques
- Backend or Data Loading Performance Techniques
- Deleting Indexes.
- Line - item Dimension & High cardinality
- Aggregates & Collapse.
- Partitioning & Re-Partitioning
- DB Statistics
- BI Performance Tuning Activities
Transportation
- Introduction to Transportation.
- BW system Landscape
- Creating of Package and Transport requests
- Collecting the objects in BW across the Landscape
- Transporting the Objects across the BW Landscape
- Deleting and reimporting Transport requests.
- Finding transportation Logs and return cods.
- Transportation error and Solutions
About Learners Point Training Institute
Empowering Professionals for a Dynamic Future in the UAELearners Point Academy is a premier provider of professional training and development solutions, dedicated to equipping individuals and organizations across the UAE with the skills and knowledge needed to thrive in today's competitive landscape.
A Commitment to Excellence
We offer a diverse and comprehensive range of training solutions, with a particular focus on IT, Cybersecurity, Management and Logistics, in addition to other key sectors:
- Business & Leadership: Sharpen your strategic thinking and management skills to lead with confidence.
- Finance & Accounting: Master financial analysis and reporting for sound decision-making.
- Human Resources: Optimize talent acquisition and cultivate a thriving workplace culture.
- Soft Skills & Personal Development: Enhance communication and leadership abilities for personal and professional growth.
- Supply Chain Management: Streamline operations and ensure efficient delivery of goods and services.
- Quality Management: Drive process improvement and deliver exceptional customer satisfaction.
At Learners Point Academy, we believe in a learner-centric approach, combining theoretical knowledge with practical application. Our expert instructors, drawn from industry leaders, provide personalized guidance and support to ensure optimal learning outcomes.
Tailored Learning Options
We understand that professionals have diverse learning needs and schedules.
Therefore, we offer a variety of delivery methods:
- Classroom Training: Benefit from face-to-face interaction and networking opportunities in our modern facilities across the UAE.
- Live Online Training: Participate in engaging virtual classes with real-time interaction for learners within the UAE and across the MENA region.
- In-Company Training: Customize training programs to meet your organization's specific needs and deliver them at your preferred location within the UAE.
Learners Point Academy empowers you to achieve your professional goals and drive success for your organization. Contact us today to explore our extensive course catalog and embark on your transformative learning journey! See all Learners Point Training Institute courses
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Payroll (UK Payroll) Apex LearningUSD 25
USD 480Duration: Upto 5 Hours - Own SAP System in 30 minutes Course CentralUSD 23
USD 100Duration: Upto 1 Hour