SAP Business Intelligence (BI) Training

Business Intelligence (BI) training imparts the knowledge and skills that the market seek in a BI consultant.for providing the best business solutions. The in-depth study and extensive hands-on session will enable the participants to successfully perform modeling of any given data. How to convert raw data into information, generate reports by integrating different information, and providing authorization is covered during the learning sessions. Focus is also laid on the data extraction concepts and Enhancement of Business Content Data Sources.

1. Data Modeling

• Architecture of SAP NetWeaver BI
• Benefits and use of the business content
• Overview of the most important objects
  • Info objects
  • Info Providers
  • Properties
• Data Source – type and properties
• DSO- types and properties
• Info cube – types and properties
• Multi provider
• Info set
• Transformation – types and rules type
• Developing a BI data model
• Modeling data marts
• Enhancing/changing the data model
• Remodeling aspects of an Enterprise Data Warehouse architecture
• Open Hub Service
• Introduction to administration of BI data targets

2. Reporting

• Architecture and functions of the SAP BI analysis tools
• Navigation in SAP BI reports
• Creating query definitions with the BEx Query Designer and the BEx Web Analyzer
• Integrating key figures, characteristics, hierarchies, variables, properties, exceptions, and conditions in the query definitions
• Using the BEx information broadcaster to distribute reports
• Integrating documents in reports
• Configuring report-report interfaces
• Presenting reports in MS Excel or HTML
• Using predefined reports from the SAP Business Content
• Report layout
  • Using different web items to create demanding web applications
  • Creating formatted reports that are optimized for presentation and printing
  • Using GIS functions to display data on maps
  • Advanced options and settings options in the BEx Information Broadcaster
  • Using the advanced options in MS Excel
  • Introduction to modelling analytical applications using the Visual Composer

3. Data Extraction

• Data acquisition
  • Data flow in BI
  • Transformations
  • Delta management
  • Enhancement of Business Content Data-Sources
  • Process of extracting data from SAP source systems
  • Data staging via different interfaces
  • Real-time data acquisition
  • Direct access
  • Unit of measure conversion
• LO Cockpit
• UD Connect
• DB Connect

4. Authorization

• User management & authorizations
  • Architecture and strategies for a BI authorization concept
  • Security requests in SAP BI
  • Creating authorizations for reporting
  • Administrative tasks
  • Source systems
  • Planning environment

5. Performance Tuning & Process Chain

• Aggregates, Rollup and Compression etc.
• Basics for optimizing query performance
• BI accelerator
• Details about Process chains