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: Classroom
COURSE DURATION: 15 days Weekday / 12 Weekends in class
COURSE CONTACT: 0151-2250243 or info@regalgateschools.co.uk
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
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
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
Defining transformation
Creating Transformations
Transformation scenarios
Defining the data flow
Creating data transfer processes
Defining Process chain
Creating Process chains
Checking process chain runs
Monitor for extraction processes and data transfer processes
Creating the first aggregate for an InfoCube
Using the BIA index maintenance wizard
Setting up standard authorizations
Defining analysis authorizations
Real business scenarios knowledge on different system environments
Moving objects from one system to another
Business Explorer
BEx Query Designer
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
Creating Re-usable structures
Functions on BW Server: Copying queries between Cubes, Deleting Query Elements
WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
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 Web Application Designer
BEx Report Designer
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 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
