|
Provided by: Gucons SAP BI TrainingTraining, Instruction and Documentation |
 |
Training
Provided by Gucons
In BI 7. 0 course, you will learn how SAPa s Business Intelligence solution allows you to convert data into valuable information through hands on practices backed by extensive study material. Through the Data Warehousing Workbench, practice Data Modeling, Data Acquisition and the new Transformation Procedures, to name a few. Also, discover how Integrated Planning of BI has revolutionized and eased the decision-making process.
Related Software Programs or Products: SAP BI 7.0, SAP ECC 6.0, SAP E.P
Related Jobs or Careers: SAP Technical Consultant, SAP CI 7.0 consultant, SAP Techno-Functional Consultant
|
|
||||||||||
SAP BI Training
Enterprise Data Warehousing
Introduction
1. General Introduction.
2. SAP introduction.
3. Data warehousing/ BW/ BI Introduction
4. Master data; Attributes, Texts, and Hierarchies.
5. Standard Naming conventions in SAP and BI
Data Modeling
* InfoObjects: Definitions
o Types: Characteristics, Key Figures, Time, and Unit.
* InfoCubes: Definitions.
o Types: Standards, real time, remote.
o Design of Infocube: Star Schema concepts. Precautions.
* DataStore objects (DSO):
o Types: Standards, Real time.
* InfoSets
* MultiProviders: Scenarios to create Multiproviders.
* Infocube VS DSO
Metadata and Document Management
* BI Content: Definitions, How to install BI contents,
Defining extraction
* For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource.
* Or for files: Creating DataSources for File Source Systems
Defining transformations
* Transformations and different scenarios.
Defining the data flow:
* Creating data transfer processes
* 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 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 KeyFigures
* Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
* Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures
* 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
Career Related Support
* Resume Building with sample resumes
* Frequently asked interview questions
* Common Production Issues
Advanced Topics
Hot Bonus Topics:
* Overview of Planning with SEM-BPS.
* Architecture of BPS components.
* Planning Models (Planning Area, Planning Level, Planning Functions, Planning Layouts, Packages).
* Characteristic relationships, Variables.
* Data Slice
* Web Interface and Planning Folders.
Performance in depth
* Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
* BW Statistics: Query Analysis Tools, Performance Tables
* Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
* Aggregates: Creating Aggregates, Finding effective aggregates
* Data Load Performance: Parallelism, Impact of Aggregates
* Partitioning: Logical Partitioning, Table Partitioning.
Introduction
1. General Introduction.
2. SAP introduction.
3. Data warehousing/ BW/ BI Introduction
4. Master data; Attributes, Texts, and Hierarchies.
5. Standard Naming conventions in SAP and BI
Data Modeling
* InfoObjects: Definitions
o Types: Characteristics, Key Figures, Time, and Unit.
* InfoCubes: Definitions.
o Types: Standards, real time, remote.
o Design of Infocube: Star Schema concepts. Precautions.
* DataStore objects (DSO):
o Types: Standards, Real time.
* InfoSets
* MultiProviders: Scenarios to create Multiproviders.
* Infocube VS DSO
Metadata and Document Management
* BI Content: Definitions, How to install BI contents,
Defining extraction
* For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource.
* Or for files: Creating DataSources for File Source Systems
Defining transformations
* Transformations and different scenarios.
Defining the data flow:
* Creating data transfer processes
* 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 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 KeyFigures
* Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
* Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures
* 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
Career Related Support
* Resume Building with sample resumes
* Frequently asked interview questions
* Common Production Issues
Advanced Topics
Hot Bonus Topics:
* Overview of Planning with SEM-BPS.
* Architecture of BPS components.
* Planning Models (Planning Area, Planning Level, Planning Functions, Planning Layouts, Packages).
* Characteristic relationships, Variables.
* Data Slice
* Web Interface and Planning Folders.
Performance in depth
* Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
* BW Statistics: Query Analysis Tools, Performance Tables
* Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
* Aggregates: Creating Aggregates, Finding effective aggregates
* Data Load Performance: Parallelism, Impact of Aggregates
* Partitioning: Logical Partitioning, Table Partitioning.
About The Training Provider: Gucons
Gucons - Gucons is a Training, Consulting, Outsourcing and Training Company. We recognize that many of you are willing to put the extra effort to migrate to SAP practice and become SAP consultants. We help you achieve your goal with a team of experienced SAP instructors, excellent infrastructure, a clear roadmap to SAP certification and preparation for job interviews.
However, we do not provide false...
