Introduction to BI

BUSINESS TRIANGLE

An Enterprise can be seen in this way...

Strategic layer – CEO, MD, CIO

Managerial layer – MANAGERS, TEAM LEADS

Transaction layer – USERS

Main challenge of any business is decision making..

TO DO  or NOT TO DO

WHEN TO DO, HOW TO DO and WHY TO DO

The people belonging to Strategic layer are the decision makers...

How do they make decision?

They depend on historical data to make decisions ..

In any database this is how data resides

 We will be having millions of rows and thousands of columns in database tables..

So it is not practical to directly look into the database tables to get our required data

So  it is better data to represented in the form of graphs.. charts.. etc

BI means Business Intelligence.. In other words we can define as "Graphical representation of historical data"

The role of a BI Consultant is to Extract data from the transaction system, load it into BI system, and make reports..

In short , we can name it as ETL ( Extraction, Transformation and Loading)

 Source file  means data at transaction system.. It can be a flat file, SAP ECC, or any other database

 DataSource is a set of logically-related fields that are provided to transfer data into BI in a flat structure (the extraction structure), or in multiple flat structures (for hierarchies).

Infopackage is used to pull data from source system to datasource

Target is also known as Infoproviders.. there are different types of info providers depending upon the type of data. InfoObject, DSO, Infocube

 The transformation process allows you to consolidate, cleanse, and integrate data. You can semantically synchronize data from heterogeneous sources.

When you load data from one BI object into a further BI object, the data is passed through a transformation. A transformation converts the fields of the source into the format of the target.

DTP is used to pull data from DataSource to Target ( InfoProviders)


BI means graphical representation of DATA.. we have 2 types of data..

1)  Transaction data
2)  Master data


What is Master data and Transaction data?

Consider example of a supermarket..
The employee working at billing is entering some values and click enter... this data is transaction data

But here we can see our material is represented as "M01, M02..."

we don't know what is "M01"..

for that we have Master table for material , customer , vendor....

Best SAP training in Kerala

Best SAP training in Kochi

Best SAP training in Ernakulam

SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana