Why Todaycourses.com?
- Take Courses from anywhere
online.
- More than 1000 Employers
Registered Worldwide
- Assured Job Placements
- More than 200 Visa
processing employers
- More than 1000 courses.
- More than 100 Job Placements
Every day.
- Global Job Opportunity
Website : http://www.todaycourses.com
Email : info@todaycourses.com
SAP BW-BI COURSE CONTNENT
SAP BI – Introduction to SAP Netweaver 2004s (7.0 BI) system
SAP BI – DATA WAREHOUSING (DW)
· Overview, Posting & Fundamental of Data Warehousing
· Objects in the BI DW layer
· Data Acquisition & Transformation from SAP Source Systems
· Data Acquisition from other systems
· Business Content
· Other Info Providers
· Administration of Data Targets
· Introduction to Query Performance Optimization
· BI System upgrade and migration of dataflow from BW 3.x to BI 7.0
· Transformation &UoM conversions
· Write routines in transformations and debugging routines
· DTP & DTP Error handling
· Bi Integrated planning
· Concepte - BI Accelerator and Analysis Process Designer (APD)
SAP BI - REPORTING & ANALYSIS
· Introduction to BI Enterprise Reporting
· Get to know BEx Query Designer
· Key Figures, Characteristics, Variables, Exceptions and Conditions
· BExAnalyzer
· Enterprise Portal Integration and Document integration
· Report - Report - Interface
· Managing Query Objects
· Business Content
· Further SAP BI Reporting Tools
· Information Broadcasting
|
SAP BI - DATA STAGING & EXTRACTION
· Overview of Data Staging in SAP BI - BW Content
· Data Transfer with the service API
· Delta Management
· Transferring data from flat files
· XML Based extraction
· Data Mart Interface
· Application Specific Extraction
SAP BI - MODELING & AUTHORIZATION
· Logical Model and BI Data Model
· Tracking history and hierarchies
· Modeling characteristics and key figures
· Modeling ODS/DSO Objects and InfoCubes, Open Hub Service
· Multidimensional Modeling
· Changing Data Model
· Special Modeling aspects
· Authorizations - Setting up for reporting, standard roles and templates
· Securing requirements in SAP BI
· System Security
SAP BI - PERFORMANCE & ADMINISTRATION
· InfoProvidermodeling and administration for performane
· Optimize and monitor query performance and data acquisition performance
· Aggregates and rollup
· Transport Management for BI Objects
· Process chains - Development & Monitoring
|
SAP Business Objects Course Content
SAP Business Objects Course Content
SAP Business Objects Web Intelligence and BI Launch Pad 4.0.
Web-Intelligence Rich Client 4.0 |
Information Design Tool 4.0
Universe Designer Tool 4.0 Basic BO Administration (CMC) SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011) SAP Crystal Reports 2011 |
SAP BODS Course Content
DW Concepts
ETL Overview
Business Objects Overview
Data Services
Data Services Objects
Source and Target Metadata
Environment setup
Batch Jobs
Troubleshooting Jobs
|
Functions, Scripts and Variables
Important Transforms
Other Transforms
Error Handling Change Data Capture Data quality Overview Web-Services and Real-Time Integration SAP Integration |
SAP BUSINESS OBJECTS COURSE CONTNENT
DATA WAREHOUSING/DIMENSIONAL MODELING PRACTICAL CONCEPTS
· OLTP vs. OLAP
· Types of OLAP
· Dimensional modeling
· Data mart/Data warehouse Life cycle
· Star/Snow/Extended Star schema design
DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
· Joins & Cardinality
· Views/Materialized Views
· Date/Time Functions
· Conversion functions
· Package
· Derived table & Stored Procedure
BOXIR3 ARCHITECTURE
· Architectural overview
· Client tier components
· Application tier components
· Intelligence tier
· Processing tier
· Data tier
· Security management
· Information flow
UNIVERSE DESIGN
· Understanding Business Objects Universes
· Creating the Course Universe
· Building the Universe Structure
· Creating Dimension Objects
· Creating Measure Objects
· Resolving Loops in a Universe
· Resolving SQL Traps
· Using List of Values
· Applying Restrictions on Objects
· Using @Functions with Objects
· Using Hierarchies
· Deriving Tables & Indexes
· Working with Aggregate Awareness
· Designing Advanced Objects
· Creating Predefined Condition
· LOVs & Joins
· Securing Universes
· Implementing Universe Life Cycle Mgmt
· Maintaining & Optimizing Universes
· Creating Universe from Other Data sources
WEB INTELLIGENCE
· Understand concepts of Web intelligence
· Create Web Intelligence documents with Queries
· Restrict data returned by a query
· Design a report
· Enhance the presentation of data in reports
· Format a report
· Calculate data with formulas and variables
· Use multiple data sources
· Analyze data
· Manage and share Web Intelligence documents
· Work with Advanced Query techniques
· Work with calculation contexts
· Create formulas with character & date string functions
· Use "If" logic
· Work with additional reporting techniques
· Create hyperlinks
CRYSTAL REPORTS
· Planning a Report
· Selecting Records
· Formatting a Report
· Representing Data Visually
· Distributing Reports
· Creating Basic Formulas
· Organizing Data on a Report
· Applying Section Formatting
· Applying Conditional Reporting
· Using the Repository
· Using Report Templates
· Creating Formulas
· Building Parameterized Reports
· Summarizing Data with Cross-Tabs
· Using Report Sections
· Managing Reports
· Presenting Data Visually
· Add hyperlinks to a report
XCELSIUS(SAP DASHBOARD DESIGN)
· Creating a Model
· Adding Interactivity to a Model
· Creating a Connected Model
· Connect to Crystal Reports data and create Dashboard
· Connect to Web intelligence report data and
· Create Dashboard
· Connect to Business Objects Universes
· Using Query as a web service and create Dashboard
· Use Live Office data and create Dashboard
· Use other connectivity components and create Dashboard
ADMINISTRATION
· Understand the Business Objects
· Enterprise interface & architecture
· Manage Business Objects Enterprise content
· Secure Business Objects Enterprise content
· Secure application security
· Schedule content
· Publish reports
· Identify Business Objects Enterprise architecture
· Perform common server management tasks
· Manage the Business Objects Enterprise servers
WIDGETS
· Installing BI Widgets
· Using BI Widgets to Access BI Content
· Working with widgets
· BI Widgets Content Authoring Guidelines
· Auto refresh of Widgets
DESKTOP INTELLIGENCE
· Introduction to desktop intelligence
· Scope of analysis
· ZABO
· Report creation
· Saving the reports in local repository
· Publishing the report
· Report conversion (desktop) to (Webi)
|
VOYAGER
· Getting Started with Business Objects Voyager
· Using Queries to Analyze Cube Data
· Using Charts to Visualize Data
· Selecting Members to Display in Crosstabs and Charts
· Sorting, Filtering, and Ranking Data
· Highlighting Exceptions in Data
· Saving and Sharing Voyager Workspaces
SECURITY IMPLEMENTATION
· Creating Secured users & group
· Creation secured connections
· Creation of Secured objects
· Creation of security at Table, Column &row level
· Creation of secured restriction set and mapping to users or groups
OLAP UNIVERSE
· Creation of OLAP Universe by connecting to an Info cube
· Updating the OLAP Universe (Cube)
· Creating the Custom Hierarchies in OLAP Universes.
· Accessing multiple info cubes to create an OLAP Universe
IMPORT WIZARD\PUBLISHING WIZARD
· Using Import wizard
· Creation of BIAR
· Migrating the BO objects
· From one CMS TO ANOTHER CMS
· Migrating the objects from one
· domain to another (dev/stage/Prod)
· Backup & Maintenance Deployment
BUSINESS VIEW MANAGER
· Creation of Semantic layer for Crystal reports
· Creation of Dynamic list of values in Crystal reports
· Creation of Cascading list of values in Crystal reports
· Creating Data connection and Dynamic data connection
· Creation of Data foundation
· Creation of Business Element
· Creation of Business View
· Creation of LOV
· Saving the Business view to repository
· Accessing the Business View in Crystal reports using Database expert
· Creation of Crystal reports using Business
· View
PERFORMANCE MANAGEMENT
· Creation of Metric Universe
· Creation of Metrics & Analytics
· Creation of Dashboard using Metric
· Creating Performance dashboards using set analysis
LIVE OFFICE REPORTING
· Describe the benefits of using Live Office
· Connect to the repository
· Navigate the Live Office menu
· Insert charts, crosstabs, and fields from a Crystal report
· Insert report parts from a Web Intelligence document
· Insert a new query based on a Universe
· Insert Live Office objects into an email
· Navigate and refresh Live Office objects
· Enable consolidated prompts
· Set refresh settings for objects
· Set parameter binding
· Take a snapshot
· Save Live Office documents to the repository
· Open and view Live Office documents from the repository
BO-SAP INTEGRATION SERIES
· Understanding BO-SAP Integration kit
· Configuring single sign on authentication
· Creating SAP Authentication in BO
· Importing the roles of SAP into BO
· Entitlement settings of SAP & BO System
SAP WEBI/DASHBOARD REPORTING
· Creation of Web intelligence reports using Info cube & BW Query
COMPARISON OF ALL BO VERSIONS (5.X/6.5/XIR1/XIR2/XIR3)
· Architecture changes
· Report creation charges
· Universe level changes
· Security level changes
· Addition of new features
PERFORMANCE TUNING OF DATABASE W.R.T BO
· BO Query tuning
· BO Execution plan/Tracing
· Combined Query
· Views/Derived tables
PERFORMANCE TUNING OF BO
· Universe Tuning
· Webi report Tuning
· Database Tuning
· Deployment methods
· Crystal reports tuning
· BO Query optimization & Customization
POLESTAR/BUSINESS EXPLORER
· Creating Polestar Reports
· Configuring Pole star with BO System
|
THANKYOU
sap bi training material
sap bi training online
what is sap bi
sap bi training online free
sap bi training videos
sap bi training material pdf
sap bi training in hyderabad
sap bi training in bangalore