ERP BI/BW Training in Chennai | ERP BI/BW Training Institute in Chennai

ERP BI Training


ERP BI Training


General Introduction

ERP introduction

Data warehousing/ BW/ BI Introduction

Master data; Attributes, Texts, and Hierarchies

Standard Naming conventions in ERP and BI


Data Modelling

InfoObjects: Definitions

Types: Characteristics, Key Figures, Time, and Unit

InfoCubes: Definitions

Types: Standards, real time, remote

Design of Infocube: Star Schema concepts Precautions

DataStore Objects (DSO):

Types: Standards, Real time


MultiProviders: Scenarios to create MultiProviders

Infocube VS DSO


Metadata and Document Management

BI Content: Definitions, How to install BI contents


Defining extraction

For ERP source systems: Creating Generic DataSource and maintaining ERP delivered dataSource

Or for files: Creating DataSource 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

Monitor for extraction processes and data transfer processes

Performance optimization:

Creating the first aggregate for an InfoCube

Using the BIA index maintenance wizard


User management:

Setting up standard authorizations

Defining analysis authorizations



Real business scenarios on different system environments, Moving objects from one system to another

BI SUIT: 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


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, and Checkboxes, Dropdown Box and other web items and their attributes



BEx Analyser

BEx Web Application Designer

BEx Report Designer


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



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


Frequenty Asked Questions

1. 1. Why Should i learn ERP from IICT ?

ERP Course at IICT is designed & conducted by ERP experts with 10+ years of experience in the ERP domain Only institution in Chennai with the right blend of theory & practical sessions In-depth Course coverage for 45+ Hours More than 15,000+ students trust IICT Affordable fees keeping students and IT working professionals in mind Course timings designed to suit working professionals and students Interview tips and training Resume building support Real-time projects and case studies.

2. Will IICT Help Me With Placements After My ERP Course Completion?

We are happy and proud to say that we have strong relationship with over 600+ small, mid-sized and MNCs. Many of these companies have openings for ERP Specialist. Moreover, we have a very active placement cell that provides 100% placement assistance to our students. The cell also contributes by training students in mock interviews and discussions even after the course completion.

3. How many students have been trained by IICT up till now?

We are proud to state that in the last 10+ years of our operations we have trained over 25,000+ aspirants to well-employed IT professionals in various IT companies.

4. How Equipped Are The ERP Faculties At IICT?

Our ERP faculty members are industry experts who have extensive experience in the field handing real-time application and completing mega real-time projects in ERP in different sectors of the industry. The students can rest assured that they are being taught by the best of the best from the ERP industry.

5. Will I Be Given Sufficient Practical Training In ERP ?

Our courseware is designed to give a hands-on approach to the students in ERP. The course is made up of theoretical classes that teach the basics of each module followed by high-intensity practical sessions reflecting the current challenges and needs of the industry that will demand the students’ time and commitment.

6. What Are The Payment Modes Accepted At IICT ?

We accept Cash, Card, Bank transfer and G Pay.

7. How old is IICT ?

More than 10 years we are into ERP Training domain. We are doing training across Chennai.

8. What certification will I receive after course completion?

You will receive IICT globally recognized course completion certification.

9. What will be the size of a ERP batch at IICT ?

We at IICT believe in giving individual attention to students so that they will be in a position to clarify all the doubts that arise in complex and difficult topics. Therefore, we restrict the size of each ERP batch to 5 or 6 members.

10. How about group discounts (or) corporate training for our team?

Yes, IICT provides group discounts for its training programs. To get more details, visit our website and contact our support team via Call, Email, Live Chat option or drop a Quick Enquiry. Depending on the group size, we offer discounts as per the terms and conditions.


Training Experiences with Us

erp bi training nazarethpettai erp bi training k k nagar erp bi training ashok nagar erp bi training kovoor erp bi training mogappair west erp bi training ambattur industrial estate erp bi training kundrathur erp bi training pattabiram erp bi training anna nagar erp bi training arumbakkam erp bi training poonamallee erp bi training thiruverkadu erp bi training maduravoyal erp bi training mangadu erp bi training thirumazhisai erp bi training kovur erp bi training madhuravoyal erp bi training valasaravakkam erp bi training virugambakkam erp bi training sri ayyappanagar erp bi training porur erp bi training mugalivakkam erp bi training vadapalani erp bi training saligramam erp bi training koyambedu erp bi training nungambakkam erp bi training choolaimedu erp bi training saidapet erp bi training raj bhavan erp bi training anna university erp bi training iit erp bi training kotturpuram erp bi training t nagar erp bi training kodambakkam erp bi training west mambalam erp bi training tambaram erp bi training tambaram iaf erp bi training tambaram sanatorium erp bi training perungalathur erp bi training tambaram east erp bi training perungalathur erp bi training chitlapakkam erp bi training selaiyur erp bi training medavakkam erp bi training madambakkam erp bi training mambakkam erp bi training sithalapakkam erp bi training padappai erp bi training pallavaram erp bi training chromepet erp bi training anakaputhur erp bi training paruthippattu erp bi training pozhichalur erp bi training pammal erp bi training old pallavaram erp bi training kovilambakkam erp bi training tiruneermalai erp bi training velacheri erp bi training nanganallur erp bi training adambakkam erp bi training madipakkam erp bi training st thomas mount erp bi training guindy erp bi training ramapuram erp bi training thoraipakkam erp bi training nandanam erp bi training alwarpet erp bi training mandaveli erp bi training adyar erp bi training thiruvanmiyur erp bi training besant nagar erp bi training injambakkam erp bi training perungudi erp bi training tharamani erp bi training sholinganallur erp bi training navalur erp bi training kelambakkam