Advance SAP – BI (Business Intelligence) Course
Reviews
vishal khaladkar
teaching experience is good but lack of communication knowledge. doubts are cleared on the spot.
Kapil Usre
It was great experience here and happy to join aspire.
Danish Ahmad
Nice institute and best faculty.
SAP BI
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.
- Creating data transfer processesCreating process chains
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.
Benefits of Aspire Techsoft training
ASAP methodology
24 HOURS LAB
MATERIAL SOFT COPY& HARD COPY
100% PLACEMENT ASSISTANCE
RESUME PREPARATION
SOFT SKILLS& HR TIPS
vishal khaladkar
teaching experience is good but lack of communication knowledge. doubts are cleared on the spot.
Kapil Usre
It was great experience here and happy to join aspire.
Danish Ahmad
Nice institute and best faculty.
Your Ratings
Courses We Offer
ADD NEW SKILLS TO YOUR PROFILE
SAP Course
SAP ERP is enterprise resource planning software developed by the German company SAP SE. SAP ERP incorporates the key business functions of an organization.
- Duration
- 2 months
Hadoop Course
Apache Hadoop is an open-source software framework written in Java for distributed storage and distributed processing of very large data sets on computer clusters built from commodity hardware.
- Duration
- 2 months
Java Course
A high-level programming language developed by Sun Microsystem. Java is an OOP language similar to C++, but simplified to eliminate language features that cause common programming errors.
- Duration
- 2 months
Software Testing
Software testing is the process of evaluation a software item to detect differences between given input and expected output. Also to assess the feature of a software item. Testing assesses the quality of the product.
- Duration
- 2 months
Datawarehousing Course
A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data.
- Duration
- 2 months
PHP Course
PHP is used to create dynamic web pages , generated from the information accessed using MySQL database. Since PHP's syntax is similar to that of C and Perl, it is easy with basic programming skill.
- Duration
- 2 months
Diploma of WEB Designing
Web technology acts as a bridge between Web Servers and Web Clients. The technology consists of markup languages, programming interfaces and databases. it is reach many people all over the world.
- Duration
- 2 months
Clinical Fundamental Course
SAS is a popular and successful tool used in the field of data analysis and data modeling. SAS is a statistical analysis system i.e. statistical software suite which is developed by SAS Institute for advanced analytics purposes, Clinincal Trials, data migration, data mining, business intelligence, predictive analytics, investigation, etc.
- Duration
- 2 months
