| |
| Course Schedule |
| Course |
: |
SAP BW / Business Intelligence |
| Timing |
: |
TBA |
| Total Hours |
: |
60 hours |
| Start Date |
: |
Every Fortnight |
| Tutors Profile |
: |
7 years Experienced Tutor |
| Remote Access |
: |
Yes |
|
|
| |
 |
| |
 |
 |
|
 |
 |
| |
|
SAP's BI application widely used in data warehouse. helps the enterprise in providing the automated solution as reporting tool. BI is often used by the companies that essentially run their business on SAP.
SAP's BI solution comprises of many existing or which are already defined "extractors", a very significant amount of pre-defined business content in the form of InfoCubes, master data (i.e. objects representing the entity for "Customer"/ "Material"), authorization roles, query views and reports all delivered in the software by SAP.
BW is now part of a suite of SAP applications called SAP NetWeaver. According to SAP, more than 12,000 installations of SAP's BI solution exist.
Course Curriculum:
The course is mainly emphases on following topics:
- BW Data warehousing
- BW Data Modelling
- BW Reporting
- BW Extraction
- BW Performance Tuning
|
 |
| Topics : |
|
| |
|
| A Enterprise Datawarehousing |
|
| |
|
Data Modelling
- Creating InfoObjects: Characteristics
- Creating InfoObjects: Key Figures
- Creating Datastore objects
- Creating Infocubes
- Creating Infosets
- Creating Multiproviders
Defining Extraction
- Maintaining Datasources
- Creating Datasources for File source systems
Defining Data distribution
- Using the datamart interface
- Creating openhub destinations
Scheduling and Monitoring
- Checking process chain runs
- Monitor for extraction processes and data transfer processes
|
Metadata and Document Management
Defining Transformations
Defining the data flow
- Creating data transfer processes
- Creating process chains
Performance optimization
- Creating the first aggregate for an InfoCube
- Using the BIA index maintenance wizard
User management
- Setting up standard authorizations
- Defining analysis authorizations
|
| |
|
| 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
Activities
- BEx Analyzer
- BEx Web Application Designer
- BEx Report Designer
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
|
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
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
|
| |
|
- Overview of Planning with SEM-BPS
- Architecture of BPS components
- Planning Models (Planning Area, Planning Level, Planning Functions, Planning Layouts, Packages)
- Chararcteristic 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
|
|
| |
|
| |
| |
 |
|
| |
|
|
|
