The
Purpose of Business Intelligence
During all business activities,
companies create data. In all departments of the company, employees at all
levels use this data as a basis for making decisions. Business Intelligence
(BI) collates and prepares the large set of enterprise data. By analyzing the
data using BI tools, you can gain insights that support the decision-making
process within your company. BI makes it possible to quickly create reports about
business processes and their results and to analyze and interpret data about
customers, suppliers, and internal activities. Dynamic planning is also
possible. Business Intelligence therefore helps optimize business processes and
enables you to act quickly and in line with the market, creating decisive
competitive advantages for your company.
A complete Business Intelligence
solution is subdivided into various areas. SAP NetWeaver Business
Intelligence (SAP NetWeaver BI) provides comprehensive tools, functions,
and processes for all these areas:
A data warehouse integrates,
stores, and manages company data from all sources.
Enterprise data is collected centrally in the Enterprise
Data Warehouse of SAP NetWeaver BI. The data is usually extracted from different
sources and loaded into SAP NetWeaver BI. SAP NetWeaver BI supports SAP and
non-SAP sources. Technical cleanup steps are then performed and business rules
are applied in order to consolidate the data for evaluations. The consolidated
data is stored in the Enterprise Data Warehouse. This entire process is called extraction,
transformation and loading (ETL).
SAP Business Intelligence allows organizations to access the full wealth of
information available over the Internet, transform it, and use it in business
decision-making. This interpreted information is of vital importance to the
success of an organization. With SAP Business Intelligence, SAP offers you an
innovative and technically advanced solution that will help you, your
customers, and your partners to implement information models across different
organizations and to use these in INFORMATION ANYTIME, ANYWHERE
The Data Warehousing Workbench is the central work
environment that provides the tools for performing tasks in the SAP NetWeaver
BI Enterprise Data Warehouse.
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..
The people belonging to Strategic
layer are the decision makers...
How do they make decision?
They depend on historical data to
make decisions..
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....
No comments:
Post a Comment