??????? ??????? Business Intelligence

1
??????? ???????Business Intelligence

• ??? ???? ????
• ??????? ??? ?????? ?????? ?????? ???? 88

2
??????

• ??????? ??????? (BI) ?????
• ??????? ?????
• ????? BI
• ???????? BI
• ???????? ?????? BI
• ??? ????? ???? ???? ??? (????? ???? ?????? BI)
• ?? ???? ???? ?? ??? ????? ???? ???

3
??????? ???????

• ??????? ??????? ?? ????? ?? ?? ???? ?? ?? ??????
  ????? ?? ??? ?? ?? ??????? ?????? ?????? ?????
  ????? ? ???? ?? ????? ???? ?? ??? ? ??? ?? ??????
  ????? ?????? ?? ?????? ????? ????? ?????? ?? ???
  ? ?? ????? ???? ?????? ??????? ?? ???? ?????
• Howson, C. 2008, Successful Business
  Intelligence Secrets to Making BI a Killer App,
  McGraw-Hill, London.
• Ou, L. Peng, H. 2006, "Knowledge and Process
  Based Decision Support in Business Intelligence
  System", Computer and Computational Sciences,
  2006. IMSCCS '06. First International
  Multi-Symposiums on, pp. 780.
• Golfarelli, M., Rizzi, S. Cella, I. 2004,
  "Beyond data warehousing what's next in business
  intelligence?", DOLAP '04 Proceedings of the 7th
  ACM international workshop on Data warehousing
  and OLAPACM, New York, NY, USA, pp. 1.

4
??????? ?????

• ??? 1989 ???? ???? ?????? ???? ??
• ??? 95 ?? IBM ?? ????? ????? ????? ?????? ?????
  ??????? ?? ??? ???
• ??? ???? ???????? ?? ????? ??? 90 ???? ??

5
????? BI

• ???????? ????? ????
• ????? ???
• ?????????? ?????? ???????
• ???????? ????? ???????
• ???? ???? (Data mining)
• ????? ??? ??????? ????? ? ??????? ????
• ???????? ????
• ???????? ?????? ?????? ?????? BPM

6
???????? BI

• ????? ????
• ????? ???? ????? Ad-hoc ( ???? ????? ???? ???
  ???????? ???? ???)
• ??????? ???? Publish (Word, PDF, )
• ?????? ??
• ???? ?????? ? ????? ?? ??
• ???? ????????? (????? ???? ????? ????? ???? ?
  ...)
• ??????
• ??????? ?? OLAP
• ??????? ?? Data mining

7
???????? BI

• ????? ? ??????? ????
• Data Warehousing
• ???????? ?? ???? ??? ????? (XML, Office, RSS, )
• ?????? ?????? ?????? Business Performance
  Management
• ???????? ?? BSC ? KPI
• ??? ? ?????? ??????
• Web Based
• Mobile Alerts

8
???????? BI

• ??? ?? ?????????? (Microsoft Dynamics)
• ????? ???? SQL Server 2005 Reporting Service
• ?????? ??????? ?? ???? ??????? ? ???????
  Microsoft Dynamics
• ?????? ??? SharePoint
• ????? ??????? SQL Server 2005 OLAP
• ????? ??????? SQL Server Integration Service
• ???????? ?? BSC , KPI
• Full Office Integration
• ????? Microsoft Dynamics ???????? ??? ?? ??????
  ??????!

9
???????? BI

• ??? ?? ????? (Oracle BI)
• ????? ???? Oracle Hyperion
• ?????? ??????? ?? ???? ??????? ? ??????? Oracle
  BI
• ?????? ??? Oracle BI
• ????? ??????? Oracle OLAP, Data Mining, Real
  Time Decision
• ????? ??????? Oracle Data warehouse
• ???????? ?? BSC , KPI Oracle Hyperion
• Full Office Integration
• ??? ????? ??? ?? ???? ?????? ??? Oracle ????
  ??????? ????!

10
??? ?? ??? ?????? BI

• ????? ?????? ??? ? ????? (??????? ?????? ?????
  ??? ? ...)
• ????? ??????? ??????? (?????? ????)
• ????? ? ???????? ?????????? ???? ????

11
??? ?? ?????? ???? BI

• ???? ?????? ?? ??? ??????? ?? ??? ?? ?? ???? ??
  ???? ???? ????? ???? ???? (clustering) ?????
  ?????
• ??? ????? ???? ??? (DataViewer)
• ????? ???? (???? 80 ???? ???? ??? Select) ??? ??
  ??? ???? ?????
• ???? ??????? ???? ?? Word
• ????? ????? ???????
• ????? ?????? ??????? ? pivot ?? ?????? ????? ????
  ???????
• ??????? ????? ?? ?? ?? ????? ?????? ????????
  ?????? ???????
• ??? ?? ??? ??? ???? (Text Mining) ???? ???????
  ??????? ? ??????? ????

www.RAZBON.com
12
?????? ???? ???
??? ????? ???? ??? (DataViewer) ?????? ?????????
??? ???? ????? ???? ??????? ??????? (Business
Intelligence)
Razbon SQLGenerator ????? ????????? ????? ?
?????? ????? ??? ? ????
Razbon Wordwriter ????? ????????? ????? ????? ??
???? Word
Razbon DBTransfer ????? ????????? ?????? ? ?????
?????? ??? ???????
Razbon Dashboard ????? ????????? ????? ??????? ?
????? ?? ?? ???????
Razbon DataViewer
13
?????? ???? ???
????? ? ??????? ???? ???

• ??????? ????? ???? (????? join ??????? ??? pivot
  ? ?????? ?? Word? ???? ????? ??????? ? ???? ?????
  ????)
• ????? ? ????? ??????? (?? ??? ?? ??? ?? ?????? ?
  Word ?? ??? ???? ?? ????? ?? ??? ???? ????? ??
  ???? ??????? ??? ????? ??? ???!)
• ??? ??????? ???? ?? ????? ?????? (??? ?? ???
  ??????? ?? ????? ?? ???????? ??? ? Office ???
  ???? ?? ???? ?? ???? ?????? ??? ??? ????? ???????
  ???)

Razbon DataViewer
14
?????? ???? ???
???? ???? ????? ????? ?? ?? ??? ?????? ????
?????? ?? ?? ??? ?? ???. ???????? ?? ???? ??? ??
???? ??????? ???? ??? ???????? ????? ?? ?????? ??
?? ????? ?????? ????????? ????? ???? ? ... ????
?????? ????? ? ???????? ???? ?? ???? ???
Razbon DataViewer
15
?????? ???? ???
???? ???? ?? ?? ????? ?????? ???? ???? ???? ???
????? ???? ?? ????? ??? ???? ??? ?? ???? ??????
????? ???. ????? SQLGenerator ???? ???? ???? 80
???? ??????? Select ??? ????? ????? Join ???
Group by? In ? Exists ?? ?? ??? ?? ???
????? ??????? ??? ????? ????? ???? ???
Razbon DataViewer
16
?????? ???? ???
?? ??? ?????? ????? ??? ?? ???? ??? ?? ?????
????? ???? ??????? ?????? ?? ??? ?? ????? ??????
??? ? ?? ????? ?????? ????? ? ????? ????? ??
??????? ???? ???? ????? ????? ??
???????? ?? ????? ??? ??? ?? ???? ??? ??????
??????? ? ????? Pivot ???? ?????? ???? ?????? ?
????????? ?????
Razbon DataViewer
17
?????? ???? ???
?????? ???????? ?? ?? ?????? ??????? ???? ?????
???? ??? ????? ???????? ?? ????? ????? ???.
????? ????? ??????? ????????? ????? ????? ????
???? ? ... ?? ??? ???? ???? ?? ????? ???? ????
??? ???
Razbon DataViewer
18
?????? ???? ???
????? ????? ???? ???? ?? ?????? ??????? ?????
???? ???? ???? ??????? ? ????? ?????? ??? ???????
?? ??? ??????? ????? ???
Razbon DataViewer
19
?????? ???? ???
????????? ?????? ? pivot ???? ?? ????? ???? ?????
? ????? ???? ?????
?????? ?????????? ?? ????? ????? ?? ??? ????? ???
? ???? ??? ?? Word ? Excel ??? ?????
Razbon DataViewer
20
?????? ???? ???
????? ??????? ???? ???? ?? Word ????? ???? ???.
???? ???????? ??????? ???? ? ??????? ????? ?????
??? ???? ? ... ?????? ???? ?? ???? Word ????? ???
?????? ????? ? ??? ????? ? ??? ?? Word
Razbon DataViewer
21
?????? ???? ???
?? ??? ????? ?? ???? ????? ??????? ???? ?? ??
????? ?? Word ???? ???? ?? ???? ?????? ?????
???? ??????? ???????? pivot ? ??? ?? ???
Razbon DataViewer
22
?????? ???? ???
?? ????? ?????? ??????? ?? ???? ?? ??? ???????
???? ???????? ?????? ??? ???
?? ??? ????? ?? ???? ?? ???? ??? ????? Excel,
Access, SQL, Oracle ? ??? Fox ??? ??? ? Text ??
??? ????? ???
Razbon DataViewer
23
?????? ???? ???
?? ?????? ??????? ??? ?? ?? ???? ??????????
??????? ??????? ??? ???? ????? ?? ? ?????? ???
???????? ?????? ????? ????
Razbon DataViewer
24
?????? ???? ???
??????? ???????? ????? ?? ??? ?? ?????? ?? ??
???? ???? ?? ?? ????? ?????? ? ???? ??? ??????
?????? ???? ????
Razbon DataViewer
25
?????? ???? ???
????? ?? ??? ????? ????! ???? ?? ????? ???
?????? ???? ?? ?? ???.
Razbon DataViewer
26
?????? ???? ???
?????? ????? ????? ????????? ?? ????? ????? ??
?? ???? ?? ??? ????? ???? ?? ????? ???
Razbon DataViewer
27
?????? ???? ???
???? ?????? (Texter) ?????? ??? ???? ???? ? ????
???? ?????? ????? ????? ?????? ??????? ???? ?????
? ?????? ?? ????? ?? ???
Razbon DataViewer
28
??? ??????? ????? ? ????? ??? ????? www.RAZBON.co
m
Razbon DataViewer