|
SAP BI TRAINING COURSE
Business intelligence is a broad category of applications and technologies for gathering, storing, analyzing, and accessing data. In SAP BI/BW course, you will learn all the basics about the BW business warehouse system for reporting in SAP. The SAP Business Information Warehouse allows you to analyze data from operative SAP applications as well as all other business applications and external data sources such as databases, online services and the Internet.
The course will give you a really good and broad overview of SAP BW and you will learn to master its most important reports and features, equipping you with the necessary knowledge to enter and succeed in the SAP job market and beyonnline & Classroom
METHOD OF DELIVERY: Online & Classroom
COURSE DURATION: 50hrs online / 15 days Weekday / 8 Weekends in class
COURSE CONTACT: UK Tel: 0800 135 7371 (free phone) or 0207 993 65 93 US Tel : 718 841 7897
COURSE CURRICULUM:
- BW overview and navigation,
- Important BW standard reports
- Basic BW report editing
- Advanced BW report editing,
- BW query designer
- BW data load monitor
- BW Data warehousing
- BW Data Modeling
- BW Reporting
- BW Extraction
- BW Performance Tuning
COURSE CONTENTS
Introduction to ERP/SAP
- General Introduction ERP/SAP
Enterprise Data Warehousing
- Data warehousing/ BW/ BI Introduction
- Master data; Attributes, Texts, and Hierarchies
- Standard naming conventions in SAP and BI
Data Modeling
- InfoObjects: Definitions
- Types: Characteristics, Key Figures, Time, and Unit.
- InfoCube: Definitions.
- Types: Standards, real time, remote.
- Design of InfoCube: Star Schema concepts. Precautions.
- Data Store objects (DSO):
- Types: Standards, Real time.
- InfoSets
- MultiProvider: Scenarios to create Multiproviders.
- InfoCube VS DSO
Metadata and Document Management
BI Content
- Definitions and how to install BI contents
Defining Extraction for SAP source systems
- Creating Generic dataSource and maintaining SAP delivered dataSource
- Creating DataSource for File Source Systems
Transformations
- Defining transformation
- Creating Transformations
- Transformation scenarios
Data Transfer Process
- Defining the data flow
- Creating data transfer processes
Process Chain
- Defining Process chain
- Creating Process chains
Scheduling and Monitoring
- Checking process chain runs
- Monitor for extraction processes and data transfer processes
Performance optimization
- Creating the first aggregate for an InfoCube
- Using the BIA index maintenance wizard
User Management
- Setting up standard authorizations
- Defining analysis authorizations
Transports
- Real business scenarios knowledge on different system environments
- Moving objects from one system to another
BI SUITE
- Business Explorer
- BEx Query Designer
Queries
- New queries, Restricting Characteristics, Formulas and Exception Cells
- Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures
- Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
- Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures
Structures
- Creating Re-usable structures
- Functions on BW Server: Copying queries between Cubes, Deleting Query Elements
Web Application Designer
- WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
Web Applications
- Creating Web Applications, Settings, Stylesheets, Symbols and Properties
- Design: Designing the Layout of Web Templates, working with Library for Web Items
- Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes
- Activities
BEx Analyzer
- BEx Web Application Designer
- BEx Report Designer
BI Platform
Information Broadcasting
- Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
- User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
- Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.
OLAP
OLAP v OLTP
- The OLAP Concept and differences between OLAP and OLTP
OLAP Functions
- Aggregation, Currency Translation, Report-to-Report Interface
- Metadata Repository: Searching for Metadata
COURSE REQUIREMENT: Previous Educational Background Required
COURSE BENEFITS / PROSPECTUS IN UK AND OVERSEAS
As an SAP Consultant you will have opportunity to work with some of the top global companies in any part of the world. SAP Certification and training is globally recognised and attracts the best remuneration in the market place.
Acentar works with the best Consultants to ensure students are equipped with the necessary knowledge to enter and succeed in the SAP job market and beyond. So, whether you are looking for a career change or a career with a market leading remuneration package, you can rest assured Acentar will help you achieve your dream with our unique position in the SAP/ERP market.
Being a part of SAP means being a part of one of the most successful companies in the world, a recognized market leader. It also means being challenged like never before, taking risks, growing, and succeeding. The day you have an SAP qualification is the day you begin to play a key role in making SAP customers' businesses the best-run businesses in the world.
ALSO ON THIS COURSE WE OFFER THE FOLLOWING:
Hands on Experience
Real Time project work
Interview based Training
CV Building Service
CALL US FOR BOOKING/MORE DETAILS:
Course Telephone Contact
UK: 0800 135 7371 ( free phone) or 0207 993 65 93.
US: 7188 417 897
Email:
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
REQUEST A CALLBACK
|
