teaching experience is good but lack of communication knowledge. doubts are cleared on the spot.
It was great experience here and happy to join aspire.
Nice institute and best faculty.
General Introduction.
SAP introduction.
Data warehousing/ BW/ BI Introduction
Master data; Attributes, Texts, and Hierarchies.
Standard Naming conventions in SAP and BI
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
BI Content: Definitions, How to install BI contents
For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource
Or for files: Creating DataSources for File Source Systems
Transformations and different scenarios.
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 on differentsystem environments, Moving objects from one system to another.
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
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
BEx Analyzer
BEx Web Application Designer
BEx Report Designer
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 v OLTP: The OLAP Concept and differences between OLAP and OLTP
OLAP Functions: Aggregation, Currency Translation, Report-toReport Interface
User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
MetaData Repository: Searching for MetaData
Resume Building with sample resumes
Frequently asked interview questions
Common Production Issues
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.
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.
teaching experience is good but lack of communication knowledge. doubts are cleared on the spot.
It was great experience here and happy to join aspire.
Nice institute and best faculty.