SAP BI Training

Business Intelligence Is A SAP Product Which Majorly Focuses On Providing Its Customers/Organizations With A User-Friendly And Very Useful Form Of Representing Data That Could Be Helpful For Analyses Purpose And Making Business Decisions.

Business intelligence (BI) is an application used for giving meaning to raw data that an organization has. The raw data is cleansed, stored and applied with business logic to be useful for enterprise users to make better business decisions.

This data can be presented in the form of reports and can be displayed in the form of tables, charts etc. The main purposed of SAP Business Intelligence (BI) is to enable efficiency and robust report, analysis and evaluate of business data. SAP BI support consolidation of information both from product module and from an external source.

This course will prepare you to:

• Data Warehouse – Facilitaty the integrate, transform, consolidate, cleanup, and storage of data.
• BI Platform – Provide the technological infrastructures and offered various analytical technology and function.
• BI Suite: Business Explorer – Contain flexible report and analysis tool for strategics analysis, operational report, and decision-making supporting within a business.
• Development Technology – BI Java SDK, Open Analysis Interface, Web Design API.

Curriculum:

• Introduction
• General Introduction.
• SAP introduction.
• Data warehousing/ BW/ BI Introduction
• Master data; Attributes, Texts, and Hierarchies.
• Standard Naming conventions in SAP and BI Data Modeling
• Info Objects: Definitions
• Types: Characteristics, Key Figures, Time, and Unit.
• Info Cubes: Definitions.
• Types: Standards, real-time, remote.
• Design of Info cube: Star Schema concepts. Precautions.
• Data Store objects (DSO):
• Types: Standards, Real-time.
• Info Sets
• MultiProviders: Scenarios to create Multiproviders.
• Info cube VS DSO
• Metadata and Document Management
• BI Content: Definitions, How to install BI contents,Defining extraction
• For SAP source systems: Creating Generic data Source and maintaining SAP delivered data Source.
• Or for files: Creating Data Sources 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
• Design: Designing the Layout
• 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: Recalculating and Exporting into Enterprise Portal
• User Guide: Distributing Queries andWeb 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-to-Report Interface
• Metadata Repository: Searching for Metadata Career Related Support
• Resume Building with sample resumes Frequently asked interview questions
• Common Production Issues
• Monitor for extraction processes and data transfer processes Performance optimization: Creating the first aggregate for an Info Cube
• Using the BIA index maintenance wizard User management
• Setting up standard authorizations
• Defining analysis authorizations Transports:
• Real business scenarios in 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 Key Figures
• Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
• Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures
• 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
• 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.