business intelligence - week03

8/6/2019 Business Intelligence - Week03

1/35

Business Intelligence

(0641611)Lecture Week-3

Pengambilan Keputusan Efektif

Beban: 2 SKS

SEMESTER: VI (Enam)/GenapDOSEN: Djadja Achmad Sardjana, S.T., M.M.

[email protected]

0818-658980 & 0858-61625868

26-May-11 1Business Intelligence IF-UTama


2/35

Current Status

Mountains of Data

What do Ido???

How do I increasesales????

How do I make myproduct better???

Business Users


3/35

Mountains

of Data

From Operational Systems

ERP (Enterprise Resource

Planning) Sales/Order

Inventory

Customer Relationship

Management (CRM)

Web Sites

Orders

Click-stream


4/35

Mountains

of Data

Organizations have lots of data

Data is not in a form that is useful to decision-makers

Not easy to review

Not informative nor insightful


5/35

Todays Inf

ormati

on Fl

ow

Business in 90s invested in transactionalsystems: Supply Chain Management (SCM)

Customer Relationship Management (CRM)

Enterprise Resource Planning (ERP)

Manufacturing Resource Planning (MRP)

Finance (budget, forecasting and reporting)


6/35

Proliferation of Data

MRPSCMCRM Finance

OperationsSales FinanceProcure-ment

Silos of data by functional area

Transact

ion

Layer

Reporting

Layer


7/35

Data from Disparate Sources

Region: ARegion: BDiv 2 Div 1

SalesSales SalesSales

Silos of data within large organizations

Transaction

Layer

Reporting

Layer


8/35

Business Intelligence Business is now investing in Business Intelligence

Business Intelligence is about making effective

business decisions


9/35

What is BI?The process by which an organization

manages large amounts of data, extracting pertinent

information, and turning that information into

knowledge upon which actions can be taken.


10/35

What is BI?Business intelligence (BI) is a broad category of

application programs and technologies for gathering,

storing, analyzing, and providing access to data to

help enterprise users make better business

decisions.


11/35


12/35

The BI

Cycle

BI

start


13/35

Reas

ons f

or BI

BI enables organizations to make well informed business

decisions and gain competitive advantage.

BI enables organizations to use information to quickly and

constantly respond to changes.


14/35

Benefitsof BI

Improved performance based upon timely andaccurate information

Elimination of guesswork

Expedited decision making

Early visibility of changes:

Customer buying patterns

Supply chain activity

Financial arrangements


15/35

Benefitsof BI

Single Version of the truth

Accurate, timely data available to all levels of the

organization


16/35


17/35

BI ActivitiesBI applications include the activities

of:

decision support,

query and reporting,

online analytical processing

(OLAP),

statistical analysis,

forecasting, and

data mining.


18/35

BI Users There are many different users

who can benefit from business

intelligence Executives

Business Decision Makers

Information Workers

Line Workers

Analysts


19/35

BI Solutions-

How to make it happen

Two main components:

Data Consolidation and Storage

Data Retrieval, Analysis andPresentation


20/35

BIC

urriculum Multi-Dimensional Analysis

Data Warehousing

Data Mining

Dimensional Modeling Data Visualization


21/35

The Pr

oblem

Mountains of DataBusiness People

GAP

How do I increasesales????

How do I make myproduct better???

How do I retain

customers?


22/35

Bridging the Gap

Need data storage structures to

facilitate fast analysis of huge

volumes of data

Need software to provide access tothe data, allow flexible manipulation,

and provide meaningful presentation


23/35

Data Storage Structures

Multi-Dimensional Databases

Cubes


24/35

Multi-Dimensional

Databases Measures

Any quantitative expression

Some are designated as Key Performance

Indicators (KPI) Appropriate to the business process.

Dimensions

How we describe the measures:

Product/Customer/Region/Time

These are the Bys

What were ourCustomer Sales by Product Line

by Region by Quarterfor the past two years?.


25/35

Logical Structure


26/35

Multi-Dimensional

Databases (Cubes)

ODS ODS ODS

Data Warehouse

Multi-DimensionalDatabase (Cube)

* ODS = Operational Data Store

Relational

Database

Programs

Business

Intelligence

Programs


27/35

Multi-Dimensional

Databases

Multi-DimensionalDatabase (Cube)


28/35

Softw

are Applications

Multi-DimensionalDatabase

(Cube)

BusinessPerson

BusinessPerson

BusinessPerson

Reporting

Applications

AnalyticApplications

Score Cards

Dashboards


29/35

Analytics Reporting Applications

Limited user interaction

Fulfill a significant portion of an

organizations information needs Analytic Applications

Allow users to visualize and

explore data following their train ofthought

Extensive interactivity


30/35


31/35


32/35

Analytic Application


33/35

Summary Students learn to:

Create multi-dimensional

databases Create professional quality reports

Use analytics to provide in-depth

data analysis


34/35


35/35

SekianSekian dandan

TerimaT

erima KasihKasihSampai berjumpa

di kuliah minggu depan

26-May-11 35Business Intelligence IF-UTama

History ofBusiness

Intelligence-10m36

business intelligence - week03

Documents