�ݺ�ߣ

???? ????????
????? ???????
????? ??? ????? ?????
???????? ??????
1
?
??????? ?????? ??????
2
?
??????? ?????? ??????
3
1
???????? ????? ??????? ?????????? ???????? ?????? ?????????
?????? ??????? ????????? ????
?
???????? ???????? ????????
?
??????? ????????? ??????
?
???????
?
z.mansoori@tci.ir
2
???????? ?????????
??????? ??????? ????????? ???? ??????????
???????? ???????? ????????
?
??????? ????????? ??????
?
???????
Sakhaee@tci.ir
3
??? ??? ?????? ??????? ????????? ???? ??????? ???????? ??????? ??????? ???????? ?????? ?????????
???? ?????
???????? ???????? ?????????? ???????
?
???? ???????? ????????
??????
?
????????? ??????
???????
?
???????
Zarei@tci.ir
???????
????? ??????? ???????? ????????
????? ??? ????? ?????
1
???????? ???? ????
BI
????
????????
????
.?????? ??????? ?????? ????????? ????? ????? ?????? ??????? ???
?????? ???? ???????? ???? ?????? ???? ???? ??????? ????? ?????? ???????? ???? ????? ??? ????? ????? ????? ???????
??? ???????? ??????? ??? ???
???? ??????
??????? ?????
???
.?????? ?????? ???? ????? ??????? ???? ???? ??????
??? ???? ?????? ???? ????? ????? ???????? ??????? ???????? ????? ??????? ???? ??????? ????? ???????
?????? ???
?????
???????
?????? ??? ??????? ????? ??????? ???? ???? ????? ????? ??????? ??????????? ????? ?????? ??? ??????????
?????? ????
????? ??????
???????
.
???????? ?????? ????
???? ????? ???? ???? ?????
????
????????
????? ??????? ?????? ??????? ???
????? ??? ????? ?????
????
????????
????
.????? ?????????
??????? ???????
????? ??? ????? ?????
?
OLAP
?
?????? ????? ?????? ????????
?
KPI
?????? ?????? ?
?????? ?????? ?
1
-
???????
???? ????????
????? ????????
??????
?????
?????? ?????? ??? ????? ??????? ????? ?????? ??????? ?
???? .????
??????? ??????
??????? ??????
??????? ????? ???????? ???? ???????? ?????? ????? ???????? ????? ????
????? ??????? ?????? ???? ????? ?????? ??????? ????? ?????? ?????
????? ??? ????? ?????
????
?????? ?
????
?????? ??????? ?????? ?????? ??? ????? ????? ??? ????? ??? ??????? ???? ?????? ???????? ??????? ??????
??? ???? ????? .??????
????? ???????? ???? ?????? ??????? ??????? ????? ???? ?????? ???? ????? ?????
???? ???????
?????? ????
??????? ???? ?????
??????? ????
?????? ????
?????? ????? ???????? ??????? ??? ??????? ????? ???? ??????
???? ?????
??????? ????
?????? ??? ????
??????? ????
??????? ????
?????? ????????
?????? ?????
?????? ??? ????? ??????? ??? ??????? ????????
????
??????? ?????
?????? ?????
?????? ???? ???? ????? ??? ????? ?????? ???? ????? ??????? ????????? ?????????
???? ?????? ????????
???????? ?????? ????? ???? ???
??????
Capex
???
Opex
?????
??????
.??????
????? ??????? ???????? ?????????? ?????? ???????? ????
????? ??? ????? ?????
???????
??????? ???? ???? ????? ?????? ????????
????????????
???? ?????? ????
??????
???? ????????
??????
???? ???????? ?????? ????
???
??? ????? ??????? ???? ??? ??????? ????? ???
.????
??????? ???? ?????? ????????
????? ?????? ????
???????????
??????
???????? ??????
??????? ???? ?????
??????? ????
??????? ???? ??????? ?????? ????? ?
????
??????? ????
?????? ????????
?????? ????
????????? ?????
?????? ?????? ???????? ?????? ??? ??????? ???? ????? ??? ?????
?????? ??? ????? ????????
??? ?????
??????? ??????
??????? ??????
?????? ???????? ????? ????
???
?????
????????? ????
?????????
??? ???? ??????? ??????? ?????? ??? ??????? ???? ????????
???????? ?????? ???????? ??? ????? ??????
.??????

?????
?????? ??????? ?????? ??????????
?????
?????? ??? ????
??????? ?????
??????
???????
???????? ??????
???????? ????
??????? ???? ?????????? ????? ???????? ?????? ?????? ????????
??????
????
?????? ???? ???????? ???????
??????? ??????? ???? ??????
?
???? ???? ??????? ?????? .????? ??????? ?????? ???????
???????????
??????????
???? ???? ??????????
????
?????? ?????????
??????? ???????
??????? ?????
????????? ??? ???????? ??? ?????
????? ??????? ?????? ?????? ????? ???? ????? ???? ????? ??????
????? ??? ????? ?????
????
????
.????? ??????? ???????? ??????? ?????? ??? ??????? ????? ??????? ??? ????????? ????????
??????? ???? ??????? ????? ????
????? ??????? ??????? ????
????? ??? ????? ?????
?????? ???
.????? ???? ??????? ???? ??????? ????? ???? ?????? ?????? ??????? ?????? ????? ??? ??????
?????
?????? ???
?????
???????? ???? ??????
?????? ?????? ??????
?????? ????????? ?????? ????????? ????? ?????????? ??????? ????
?????
????? ??? ????? ?????
.????? ???? ?????????
2
-
????? ??? ????? ????? ????? ??????? ?????????
????
???????
?????
70
?????
?????? ??? ????
??????? ?????
?????? ?????
?????? ??????? ?????? ??????? ???????
.???? ???? ???????
????? ????
80
???????
???????? ?????? ???? ???????
????
????????? ???????
?????? ????
????
??????
?????? ???????
?????
??????? ??????? ??? ?????? ???????? ???? ???????? ????? ?????? ?????? ???
?????? ??????? ???? ??? ???????? ?????? ???? ???? ???? ???? ????
????
????????? ?????????
?????? ???? ??????? ???? ??????
????? ???? .??????? ????
1990
??? ????? ??????? ???? ???? ????????? ?????? ?
???
????? ?????
BI
????
?????? ????
?????????? ????
?????? ???? ????? ????????? ???? ???????? ??????? ??????? ?????? ???? ????????
???
?????? ????
????????? ???????
.
?????? ???????
????? ??????? ?????
?????? ??????
?????? ??????? ????????
??????
?????? ????
?????? ???? ???? ?????? ???? ??????? ????? ???? ???? ?????? ???? ??????
3NF
????
?????? ?????
????????
.???????
????? ????
1996
????
?????? ???? ?????
?????? ???? ?????? ?????? ????? ????????? ??????? ?
??????
???????
???? ??? ???????? ?????? ??????
???? ????? ?????? ????????? ??????
?????
?????? ??????? ?????
?
????
??????
????
???????
?????? ??????? ???????
??????? ????? ????? ??????? ???? ???????? ????? ???? ??????? ????
???? ??????? ???? ?????? ????? ????? ???? ????? ????? ????? ???? .????? ???? ?????????
??????
.
???????
??????? ?????
?????? ??????
?????? ??????
??????? ?????? ???? ?????? ????? ??????? ????? ?????? ?????
???? ?????????? ????? ???? ???? ?????? ???? ???? ?????? ???? ?????
????
????????? ???? ????
???????? ???????
2
????
??????? ?????
?????? ????
???????? ?????????
??????? .??????
?????? ????
?????? ???????? ?????? ???? ????? ??? ????? ??????????
???? ???????
???? ?????? ?????? ??????? ??????
????
??????? ????
?????? ???? ????????? ?????? ??????? ?????
]
1
[
.
3
-
????????
????? ???????
????? ??? ????? ?????
????? ???????
?????
??????
????? ??? ?????
???? ?????? ?????? ????? ?
????????? ???? .??????
???? ??? ?????? ???????? ???? ???? ???? ??????? ?????? ????? ???? ???????? ?????? ?????? ????? ?????? ????
?????? ?????? ????? .????? ???? ?????? ??????? ???? ????
?????
????????? ????
DIKW
????
?????? ????
????????
?????
.
?????? ??????
??????? ?????
??????? ??????? ???????? ?????? ?????
3
?????
????????? ?
4
????
???????? ?
5
???
??????
6
??? ????? ???????? ??????? ??????? .?????? ????
????? ???? ??????
2
????? ?????? ??????
.?????
???? ????
????? ?????? ???? ???? ?????? ?????
????
???????? ????
?????? ????
?????? ????? ???? ?????? ?????
?
??????
?
?????? ????? .????? ???? ??????
????
?????? ????
?????? ??????
??????? ????
?????? ??? ????? ?????? ?????? ????? ????????
?????
?????? ??????
????
????
?????? ??????
???????
.????? ???????? ????? ??????
???? ????? ?????? ??????? ???? ????
????
?????? ?????
?????? ???? ?????? ?????????? ???????? ????
.????? ????????? ????????? ??????? ???? ???? ???? ?????? ???? ??? ????? ????? ?????? ???????? ?????
??????? ???????? ????? ????? ??????? ??????? ???? ??????? ???? ??????? ?????? ????? ??????? ????
???? ??? ???????? ??????? ??????? ???? ???? ???? ??????? ???????? ???? ??????? ???????? ??????
??? ???? ?????????
.????? ??????? ????? ???? ???????? ???? ?????? ????? ???? ???
?????
2
???????? ??????? ???? ????????? ?????? ??????? ?????
?
???? ??????? ??????? ???? ?????? ??????
???? ?????????? ??????? ???? .??????
???
?????? ??????
7
??? ??????? ???
???????? ???????
8
???? ?????? ????
????? ???? ??????? ?????
?
??????
?
???? ??????
???? ???? ????????? ????
??????
????
?????? ?????
?????? ????????
??????
?????? ????????? ??????
??????? ????
??????? ?????? ????? ????
?????
???????? ?????
?????? ?????? ?????? ????
??????????
]
2
[
.
1
-
3
-
OLTP
??????? ????
OLAP
?????? ???????? ????? ??????? ????
???????? ???
???????? ????????
?
??????
?????? ????? ????
????????? ???? ?????? .????? ???? ???????
9
???????? ????? ?????? ???
10
.
????? ????????? ????? ??????
?????
????????? ????
?????? ??????? ???? ???????? ????? ???
??????
?????? ????
??????
??? ?????? ???? ??????? ????????? ?????? ????
??? ?????? ??? ??????? ????? ??????
??? ???
??????? ???? ??????? ?????? ??????? ????
????????
??? ????
???
.????
????
???????
????
?????? ????
?????? ??????
????? ???? ?????? ?????
??????? ?????
OLTP
11
?????
?????? ?????? ????????
?????? ?????
?????? ?????
????????? ????
??????
.??????? ???? ??????????
??????
?????? ????
?????? ??????? ???? ?????? ????? ???????? ????? ??????
?????
????????
??? ????
?????????? ?????
???????
??? ???? ????????? ?????? ???????
???? ??? ?????
?????
??????? ??????
??????? ?????
?????? ??????? ????????? ????
???????
????? ??????? ???? .
BI
???????? ????? ??????? ?????? ???
????
?????? ?????? ????
??????? ???? ????
??????
?????? ???? ?????????
OLAP
12
???? ????????? ????? ?????? ???????? ????? ???????? ????
???? ???? ?????? ?????? .???????
?????
?????? ?????
????????
BI
?????
?????? ???? ????
???????? ??????
?????? ????
?????? ????????
???????
?????????
????? ???????
OLTP
???? ????? ????
??????
?????
?????? ?????
????????
OLAP
????
?????????
??????? ?????? ????????? ?????? ????? ??? ??????
]
3
[
.
?????? ????? ?????? ??????? ?????? ????? ??? ?????? ?????? ?????? ???? ????? ????? ????? ????
.????? ???? ????????? ???????? ?????
2
-
3
-
?????? ??????
???? ????????? ??????
????? ???????
?????? ???????
????? ??? ????? ????? ??????
?
?????? ???? ??????
.?????? ??????? ???????? ???? ????????? ????? ????
???? ????
?????? ????
??????? ??????
?????? ????
?????? ?????? ??????
??????
????? ????
OLTP
) ?????? ???? ??????? ???? ?????? ????
OSS
?
BSS
???
ERP
?????? (
??????? ??? ??????? ???? ???? ???
??????????
?????? ???????? ????
???????
BI
?????
?????? ???? ???????
?????? ????? ???? ???
OLAP
.?????? ???? ???????
???? ????
?????
???? ??? ?????????? ???? ????????? ????

????
???? ?????????
?????? ?????? ???? ??????????
?
???????
???? ???????
????
????
???????? ??????
??????? ???????
????? ???? ?????? ????? ????? .????? ????
3
.????? ??????
?????
3
????? ????
3
?????????
?????? ?????
?????? ?????
???????? ???? ????
?????? ??????
OLTP
????
????????
CRM
?
ERP
?????
?????? ?????? ?????? ?????? ?????? ???? ???
????
????????
?????
?????? ?????? ??????
?????? ????
??????
???
??????
??????
????????? ??????
???
????? ??????? ??????
?
??????
??????? ?????
????????? ??????? ???? ????
???????
?????? ????
ETL
13
???? ??? ????? ????? ???????? ????
?????? ????? ????????
?????? ???? ??????????
.
???????
ETL
????????? ???????
?????
?????? ??????? ???? ??????
OLTP
??????
??????? ?
????
????????
???
?????
??????
????
?????????? ????
??????? ????
?????? ???? .?????? ?????? ???? ?????? ???????? ???? ???? ?????? ??????????
?
???? ????
?????? ??????
???
????????? ????? ??????
OLTP
??????? ?????? ????
OLAP
???
???? ???? ?????? ????????
.??????
??????
?????? ???????? ??????
???? ????? ???? ?????? ????
???
??? ????? ?????? ???? ???? ???? ??? ????
????? ??????? ??????? ??????? ??????????
BI
????
?????? .?????? ????
?????? ?????
??????? ?????
???????
?????
??????
OLAP
?
?????? ????? ?????? ?????????
14
?
?????
?????? ????
?????? ????
????????
?
???
?????? ????
??????? ????
??????? ???????
????????
????? ????
?
?????
-
??????????
15
?
.????? ???? ???????
????
???????? ????
?????? ????? ?????
.????
??????? ????
?????? ?????
??????? ??????? ???? ?????? ??????? ???????? ???? ????? ????
?????
???????? ???? ????
??????
????? ?????? ???? ??? ??????? ????????
????? ???? ???
????????
???????? ?????
??????
?????? ???? ??????? ?
??? ?????? ??????? ????????? ???????
????? ???? ?????? ??? ?????
????????
16
???????
???????
?????? ????
???????
??????
????? ????
]
3
[
.
3
-
3
-
????????
?????? ????? ?????? ????????
????? ??????? ?????? ???????? ????????? ?????
OLAP
.?????? ????
?????? ???? ???????? ?????
???? ???? ???? ??? ????? ???? ????? ??????? ??????? ????
????? ???????
.??????
???????? ????? ?????
?????? ??????
???????? ??????
???????? ??? ???? ???????
????
???????? ????????
?????? ????? ??????? ????
????????? ?????? ???????? ?????? ????
.?????? ???? ??????
??????? ???????? ????? ????
???? ??????
???
???
?????? ??????? ???? ????
??????
?????? ???? ????????
?)?????
????????
??????????
????? ?????????
????? ???????
????
???????
?????? ????? ??? ???? ???????
?????
??????? ??????? ??????? ???????? ?????? ????
????
?????????
?????
?????? ?????
????????? ???????
????????
????????? ??? ?????? ??????? ?????? ???? ???? ????? ??? ???????
?????
????????? ???? ????? ??????? ????
????? ??????
(
????????? ??? ?????? ?????? ???? ?????? ????
????????? ?????? ????? ?????? ???
-
?????? ???? ?????? ???? ?????? ??????? ???????? ?????? ????
-
????
???????
?????? ????? ???? ???
?
??????
???
??????
17
?
?????? ????? ?????
18
?
????? ?????
??????? ???? .??????
?????? ???? ???????
?????
?????????
?????????
??? ???? ???????
???? ?????? ????
?
??????
??????? ????
????????
??????
??????
????
???????? ???????
?????? ????
??????
??????????
???? ??????
????
?????? ???????
?
??????
??????? ?????
??????? ????
?
?????
19
?
????
?????? ???????? ???????? ??????
20
?
.?????? ???? ???????
???? ????
?????? ????????
??????? ????? ???????
???? ?????? ???? ??????? ?????? ???????? ????????
????? ??????? ????? ??????
????
?????? ????????
??????
.???????
???????? ????? ????
???? ?????? ?????
??????? ????? ??????
?????
???
??????
???????????
?????
???????
???????
??????? ????? ???? ??????? ????? ?????? ???? ????????? ??????? ???
????
??????? ?????
.
????
?????????
??? ?????? ??????? ????? ??????? ??????? ??? ??????? ???????? ??????? ?????????? ???????
??? ??????? ???????
.??????? ???? ???????? ???? ?????? ???
???????? ????? ????? ???????? ??????? ????
????? ???? ????
??????????
????
??????? ??????
21
???? ????? ???? ?????? ??????
???? .????? ?????? ????? ???? ????? ???? ??????
???? ????
???????? ????
???????
???????
?????
?????? ????
??????? ??????
22
??????? ???? ?????????? .????? ???? ??????
?????
????? ????
??????? ??????
??????? ?????
???????? ????
?????
??????
???
??????
??????? ????
???????
???
?
?????
????????
???????
???????
??????
?
??????? ???? .?????? ??????
???? ?????? ?????
????
??????
?????
?????????
???? ?????
???????? ?????
?????? ????
??????
??????????
????
?
???? ?????? ???????? ????
?????
??????? ????? ???????? ???? ?????? ???? ??????? ??????
.????? ????????
?????? ??????
???????
???????? ????
?
??????? ???? ????
?
????
??????
???
?????????
??? ?????
??????? ???? ????
????? ??????? ?????? ????
.
????
??????? ??????
?????? ??????????? ??????? ??????? ????
????
??????? ???????? ???? ???? ?????? ???? ??? ??????? ????? ??????? ???? ????? ??????? ????? ??????
???? ?????? ????? ?????? ?????? ???????
???????? ?????
?????? ???? ?????? ?????? ???? ???? ??? ????? ?????? ?????
??? ??????? ??????? ???? ???? .???????
??? ????
??????? ????
???????? ????
?????? ??????
?????????? ????
?????? ?????
??????????
????? ????? ?????????
.???? ???????
??????
?????
-
??????????
????? ????
4
.????? ??????
?????
4
?????? ????
????? ??????
???
???
??????????
????
???? ??? ??????? ????
?????? ????????
?????
?
???
???? ???? ???????? ????? ???? ?????? ??????? ???????? ????? ???????
???? ??????? ?????????
23
?
????? ???? ??????
?????? ??????? ?????? ??????? ??????? ????? ????? ???? ?????? ???? ????????? .
?????? ???????? ???? ????
???
????? ???????
OLAP
.????? ???? ?????????
???????
??????????
??????? ?????
??????
???????? ??? ??????? ?????? ????? ??????
??????? ???? ???????? ????????? ??? ?????? ????? ??????? ????
?????
??????? ??????????
.
???????
?????
????? ?????? ??????
?????????
????????? ??? ??????? ????? ?????? ???? ???????
?????? ?????? ???????? ???? ?????????? ??? ??????? ????
?????
???? ????? ???? ????
??????
???
???????
????? ????????
???????
]
4
[
.
4
-
3
-
KPI
KPI
??????? ?????? ???????? ????? ?????? ????
24
?
?????? ???? ???? ??????? ?????? ??????
????? ?????? ??????
????????? ?????? ???? ?????
.????? ???? ?????? ????????
?????? ?????? ??????
?????? ?????? ???? ????? ??? ?????? ??????? ???????
???? ???????? ????? ???? ??????? ???? ???? ?
???? ???? ???? ?????? ??? ????? ??????? ???????? ????
????? .?????? ???? ??????
???
?????? ???? ?????
???????? ????????
KPI
???? ?????? ???????? ????????? ????? ?????? ???? ??? ?????? ?????

.??????
???? ?????? ?????? ????? ??????? ???? ????
??????? ???? ??????? ?????? ????
????????
???????? ????????? ???? ????? ???? ?????? ???? .????? ???? ??????? ????????? ?????? ?????
??????
?????? ?????? ???????? ?????? ?????? ??????
????????? ????? ????
???? ??????
????????
?????
???????? ???? ???
.
???? ??????????
???? ?????? ??????? ????? ??????? ?????? ?????
????????
?
??????? ???? ????? ????????? ????????? ??????? ????????? ?????? ???? ????????
???? ?????? ????
.??????? ?????? ????? ??????
????
?????
????????? ????
KPI
????
?????? ?????? ???????? ????
????? ????????
?????????
???
?
ARPU
25
???
EBITDA
26
???????
???? ???
??????? ?????? ??????? ??????
?????????
?????
???
????? ???? ???????? ????????? ??????? ???? ?????? ??????? ??????? ????
?
???
???? ???? ?????? ??????? ??????? ??????
????? ???? ????
]
5
[
.
5
-
3
-
?????? ??????
???????? ???? ???? ???? ??????? ??? ???? ?????? ????????? ???? ????
OLTP
?????????? ?????? ????
???? ????? ?????
????? ?????? ????? ????? ???? ?????? ?????? ???? ???? ???? ???? ?????? ?????? ?????
?????? ?????? ????? ?????????? .??????? ?????? ???? ??????
?
??????? ???? ????
?????? ????? ????
????? ??????? ???? ????? ?????????
BI
???? ????????? ???? ???????? ????? ?????? ??????
??????? ???? ???? ????? ????? ?????? ???????? ?????? ????? ??????? ???????? ???? ?????? ????????
.????? ????
????? ???? ??????? ???? ?????? ?????? ?????? ?????? ?????? ??????? ????? ??????????
.?????? ???? ????? ???? ?????? ???????
??? ???? ?????? ????? ????
???? ????? ?????? ???????? ??????
.????????? ???? ?????? ????? ???? ???? ?????? ???? ??? ?????? ?????????
????? ???? ??????
??????????
???? ????
?????
.????? ??????
?
????????? ???????
27
?
?????? ??????? ??????
28
?
????????? ???????
29
?
???????
?????? ??????
30
.????????? ???? ???? ?????????? ????? ???? ???? ???? ???? ??????? ?????? ???? ??????? ????
??????????
?????????
???? ????? ?????? ???? ????
???? ???? ????? ???? ?????? ????? ?????
??????
???? ?????? ???? ?????? ?????? .????? ?????? ?????? ?????? ???? ???? ?????? ???
?????????
???????
??????? ????? ???? ????? ???????
???
??? ?????
???
?????
??????? ???? ??????? ??????? ???????
???
?????
???????
????
????? ??????? ???? ???? ???????? ????? ??????? ?????
??????
.????? ????????
????
????????
???? ??????? ???????????? ?????? ???? ??????? ??????? ??????? ??????
?????? ??? ???????
??? ?????? ????? ???? ?????? ???? ??????? ???? ???
???
?????
??? ????????? ???? ??????
???? ?????? ????? ???? ??????? ???? ???? ??????
????? ?????
??????? ??????
?????????
?????? ???? ??????
??????
.?????
??? ????
??????
???
?????? ?????? ????
?????? ??????
????
???????? ??????? ????
????
????????? ????
???????
???????
???????????
????? ???? ????
???? ???????
?????
.
?????
?????? ????
???????? ???? ?????? ??????
5
?????????
??????
X
????
?????? ???? ????????
??????? ????
????????? ????
??????
??????? ???????
????????? ???
Y
?????
?????
?????? ??? ????
???????? ??????? ???? ????????? ?????
????
???
???????
?
??????
???????
?????? ???? ?????
??????? ??????
??????? ??????
???????
????
???????? ????
??????? ??????
??????
????
?????? .
???????? ?????? ?????????
???? ???? ????? ?????? ????? ?????? ????
???
????
????
?????? ???? ????? ??????
?????
??????? ???? ???? ?????? ???? ??? ????? ??????? ?????? ?????
??????? ???? ?????
??????
??????
??????
?????
?????
????? ??????? ???????? ???????
.
?????
5
????????? ???????
?????? ????? ???? ??? ????? ???? ????? ???? ???????? ??????? ?????? ????
?????? ??????? ?????? ???? ???? ??????? ?????? ????????? ?????? ???? ????? ???? ???? ?????
???? ???? ?????????
???
????? ???????? ?????????? .???
???????? ??????
31
????? ???? ????????? ????
??????????
????? ???? ??????
??????? ???? ????? ????? ?????????? ????? ????? ?????? ???? .
????? ???? ???? ??????? ?????? .?????? ???????? ???????? ????? ????? ???????? ???? ??????? ??????
????? ???? ????????? ?????? ???? ????? ???? ????? ????? ??????? ???? ?????? ???? ??????????
?????? ??????? ????? ?????? ????? ?????? ???? ????? ??????? ??????? ?????? ???? ??????? ????????
????? .?????
???? ????? ??????? ???? ????? ??????? ?????? ???????? ????? ????? ????? ???????? ????
????? ????????
???????? ??????
.????? ???? ?????? ????
???? ??????? ??????????
?????? ?????? ???????
????? ????? ????? ????
???
?????? ???
??????? ?????????? ??????????? ???? ?????? ?????? ???? ??????? ????? ???? ?????? ???? ?????????
????????? ???? ?????? ?????? ???? ????? ????
?????? ???? ????????? ??????? ????????? ???? ????
???? ?????? ?)?????
??????
???? ????????? ????????? ????? ??????? ???? ???? ????????? ????
???? ?????? ???? ??? (??????
??????? ???? ?????
????????? ???? ?????? ???? ??????
????????
????? ???? ???????
]
6
[
.
?????
??????? ????
?????? ?????
??????? ?????? ?????? ???? ?????????? ????? ??????? ??????? ???? ?????????
???????? ???????
32
????
?????? ????? ????? ???????? ??????? ???? ?????? ???? ??? ????? ???? ???????
?????
.
6
-
3
-
???????? ????????
?????? ????
??????? ????
?????? ????
??????? ???? ???? ?????? ??????? ????? ???? ????? ???????? ??????? ???? ????
???
KPI
????? ??????? ????? .?????? ???? ??????? ???? ????
KPI
????
???????? ????
??????
?????
?
.?????? ?????
??????
???????
???????? ??????
??????? ????????? ???? ?????? ??????? ????????? ???? ???????? ???? ???? ???????? ?????
?????? ???????? ???? ?????????
????
?????? ????
???????? ??? ????
?????? ?????? ????????? ????? ??????? ????? ???
?????? ???????
.
??????????
???? ???? ???? ?????? ?????? ????????? ???????
??? ???
????
???????? ???? ????
???????? ???
:?????? ???? ???????
?
?????? ???? ?????????? :??????????? ?????????
?????
?????? ????
????????? ???? ?????
??????? ??????
???????
????
???
????? ?????? ???? ??? ????? ??????? ????? ??????? ????
???????
??????
?????? ????????
??????? ??????
??????? ????
?
????????? ?????????
33
????? ??????? ??????? ?????? ???? ?????????? :
?
????
???????? ???? ????
???? ?????? ????????? ?????? ??? ???????
???????
?
?????????
OLAP
?????? ?????
????????? ??????? ???? ???? ???? ?????????? :
?????
??????? ????
???????
.????? ???? ??????? ???? ??????? ?????? ???? ?????? ??? ????? ????? ?????? ??????? ???????
?
???? ????? ?????? ????? ?????? ????? ?????? ?????? ????????? ????? ???????? :????????
??????? ???????? ?????? ???? ??? ??????? ?????? ???
KPI
?????? ???? ??????? ???? ????
?
????
?????
??????? ???????? ????
34
?????? ????? ???? :
???
???
??? ???
????
????????
???? ??????
???????? ????
????? ???? ??????? ??????? ??????
???
?????? ??????? ??????? ??????? ??????? ??? ??????? ???????

????
??????? ?????? ????? ????? ????????? ????? ????? .????? ???? ??????? ?????? ???????? ???? ????
?????
?
???
??????? ??????? ?????? ???? ??????? ????????? ????? :????? ?????????
?????
?????? ????
?????? ??? ???
????
???
????????
?????? ??? ????????
?????? ??????
????????? ?????
?????? ????
???????? ??????
???????? ???? ?????
???????? ?????????
??????? ???? ??????? ?????????
??? ????
???
??????
]
7
[
4
-
????? ??????? ?????? ??????
????? ??? ????? ?????
????? ???????
????? ??? ????? ?????
???? ????
?????? ???? ??????? ?????? ???? ???? ???????? ????
???
????
??????
??????? ???? ????
?????
??????? ??????
???? ????????? ????????? ??????? ???? ???? ???
???? ????????? ??????
???????? ??????? ????? ??? ???????
????????? ????? ?????? ??????? ????
????
6
???????
???????
???????? ???? ???? ??????? ????? ?????? ???????? ?????? ??????? ???? ??? ?????? ???? ??????
???????
:????? ???? ??????? ????? ???? ???????
?
?????
0
�C
??????? ????? ???? :?????? ?????????
?
??????
??????? ?????
??????? ??????? ???????
??? ???? ??????
????? ?????????? ?????? ???? ?????? ?????
??? ???
????? ?????? ????? ???? ???????
?????? ????????? ????? .????? ??????
???????
????
?????? ????
??????? ??????
?????? ???? ?????? ???????
????????? ??????? ??????
???????
.?????? ????
????? ????? ????
?????
?????? ??? ????
??????? ?????
???????? ??????? ????? ?????? ????
???????
???????
?????? ?????
???????
?????
??????? ?????
??????? ??? ????
?????????? ???
??????? ?????? ?????????
????? ???? ?????? ????
?
?????
1
-
??????? ????? ??????? ?????? ???? ????????? ????? :??????? ????? ???? ?????????
?????????
?????? ?)?????
CRM
(
????
??????? ?????
?????????? ????
????????? ???? ??? ?????? ???? ???????
???????
?????
????? ????? ????? ???? .????????? ????
???????
????? ??? ????? ?????
????
??????
??????? ?????? ???????? ??????? ????? ??????
?
?????
2
�C
??? ??? ?????
?????
??????? ???? ?????? ?????
????????? ????? ????? ???? :?????? ???????? ???? ???
???????
???????? ????? ????? .????? ????? ???? ???? ????? ????? ?????? ???? ?????? ???? ???? ??????
?????
???????? ????
?????? ????
?????? ????? ??????? ???? ?????? ??????
???
????????
?????
?????
?????? ??? ????
???????
????
?????? ?????? ????????
?
?????
3
�C
?????
?????? ??????? ????? ???? ????????? ????? ????? ???? :????????? ????????
???? ????? ??????
?????? ???????? ????? ???? ???? ???? ???? ?????? ???????? ?????? ???? ??? ??????
??????
KPI
????
???????? ?????
??????? ??????? ?????? ?????? ????????? ??? ????? ????????? ????
??????? ???? ???????
?
?????
4
�C
?????? ????????
OLAP
????
???????? ????
?????????? ?????? ???????? ????? ????? ???? :
????????? ?????? ????????
????
?????? ?????
???????? ???? ?????? ???? ????????? ??? ????? ???? ????? ??????
?????? ???? ??? ??????? ???? ?????? ???? ???? ?????
????? ??????? ???? ??? ????? ???? ????? ??????
?
?????
5
�C
????? ?????? ?????? ???? ????? ????? ???? :?????? ??????
????? ???? ?????? ????
????? ?????? ????? ??? ????? ???? ????? ?????? ?????? ??????
????
???????? ????
?????? ?????
???????? ???? ????
?????? ???
???? ???????
?????? ????? ????????
??????? ???????
????
??????
????
??????? ???? ??????? ???????
]
8
[
????? ??????? ????????? ??? ?????? ??????? ????? ?????? ???? ????? ????? ????? ???????
????? ??? ????? ?????
????
??????? ????
??????? ???????
?????? ????
????????? ???? ????????? ???????? ??? ???????? ?
???? ?????? ?????? ??????? ???? ???? ???????
?????
?????? ????
?????? ??????
?????? ????????
?????? ???? ?????
???????
?????
???? ??????? ????? ???? ????????? ??????? ???? ???? ????
????
????????? ????????? ????
.????
??????????
????
?????? ??????
?????? ?????
??????? ??????
?????? ?????? ????? ???????? ??? ??????? ????? ???? ?????? ???? ??????????
????? ??????? ??????? ??????
????? ??? ????? ?????
???? ??????
?????? ??????
??????? ??????
?????? ????
???????? ????
?????? ??????
2
???? ???? ???? ??? ?????? ????? ???? ??????
???????
?????? ??? ????
????????? ??? ????? ????? ?????
?????
???? ?????
?????? ???????
???????? ?????? ???? ?????? ??????? ??????? ??? ??????? ????
????
?????? ????????
??????
?????
5
??????? ???? ??????
.
5
-
???? ??????? ????? ????? ??????? ?????? ???????
????????
????
?????? ???? ???? ????
???????? ????
?????? ????
??????? ???? ???? ?????? ???????? ???????? ???? ??????? ????? ??????
:????? ???? ???????
1
.
??????
??????? ?????
?????????? ??? ??????
???????? ?????? ???? ???? ?????? ?????? ??????? ?????
?????? ???? ??????? ????????
�C
?????? ???????? ???? ??????
????
?????? ????
???????? ?????
?????? ????
??????
????? ???? ????????
2
.
??????? ????????? ???? ????????? ???? ??????? ??????? ?????? ?????? ??????? ????? ????
BI
?????? ???? ??????? ???? ?????? ????? ??? ????? ???? ??????? ??????? ???? ?????? ?
3
.
??????? ???????? ??? ?????? ???? ???????? ????? ??? ????? ?????? ???? ??????? ?????????
????? ??????? ??????? ????
�C
??????? ???? ????????? ????
????
???????? ????? ?????? ???????
???? ?????? ??? ???????? ?????? ?????
4
.
?????
??????? ????
?????? ??????
?????? ????
????????? ??? ??????? ?????? ??????? ???????
�C
80
???? ????
????????? %
?????
20
????
?????? ????????? ???? ????????? ????? ??????? ???? ????? ???? ????????? %
??????
5
.
??????????? ??????? ?????? ??????? ????? ????????
???????? ??????
???? ??????? ????
????? ???? ?????????
6
.
??????? ???????
????????
?????? ??????? ???? ?????? ???????? ?????? ??????? ????? ???????? ????
????? ???? ?????? ????? ?????? ???? ???? ??????? ?????? ?????????? ??? ????? ?????????
7
.
????
?????? ??????
?????? ???? ????
???????? ????
????????? ??? ????
????????? ????
????????? ???? ?????? ??? ????? ??????? ????
????? ???? ???????? ??????? ???? ???????? ?????? ????? ?????? ??????? ????????
8
.
???? ???????? ???? ??? ????????? ????
??????
?????? ?????
????????? ??? ?????
??????? ???? ??????? ??????? ??????
?????? ???????? ???????
?????? ???? ???????
9
.
?????? ??????
?????? ????????
?????? ????? ????? ??????? ???? ???? ??????? ??? ?????? ??????? ????????
????? ???? ????????? ??????? ????
6
-
???? ??????? ?????? ???????
????? ??? ????? ?????
???????? ????? ?????? ????? ?????? ???? ???????? ????????
?
????? ???????
??? ????
??????? ?????
?????
????
?????? ??????
?????? ????
?????????? ?????
??????? ????
?????? ????
???????? ???? .?????? ???? ??????? ???? ????? ???? ??????
?????
?????? ???????
?????? ?????
??????? ????
??????????? ??????
?????? ??????? ?????? ?????? ????????? ??? ??????
????? ??????? ???????
????? ??? ????? ?????
.??????
??????? ????
???????? ??? ?????
?????? ??????? ???????
?????
:???? ????????? ???? ??????? ????? ???? ???
? Oracle Business Intelligence Suite Enterprise Edition
? IBM Cognos
? Microsoft SQL Server Analytics/Reporting tools
? Microstrategy

7
-
?????? ???????
??????? ????? ???????? ????
???
???????? ????? ?????? ????
?????
?????? ?????
?????? ?????
???????? ????
???????
????
??????? ????
??????? ?????? ????? ???????? ???? ????? ????? ????? ???????? ?????? ???? ????? ??? ?????
??? ??????? ???? .????? ?????? ???????? ??????
????????
??????? ????????
?????? ???? ?????
??????? ????
??????? ???? ????
?????? ???? ???? ????????? ???????? ???? ???? ?????? ???? ????? ????? ??????? ????????
???????
??????? ?????? ????? ?????? ????? ???? ??????? ????? ???? ???? ????????? ????? ???????? ??? ?????
?????? ?????
?????
?????
??????? ???? ??????? ???? ??? ??????? ?????? ??????? ?????? ???? ???? ????????
???? ?????? ??? ???????
?????
???
.????? ??????? ?????? ??????? ????? ???????
????
??????? ??? ????
?????????? ?????
?????? ?????
?????? ??????? ????? ???????? ??? ?????? ????????? ???? ?????????
???????? ??? ?????? ??????? ???? ??????? ?????? ???????
?????
???????? ????
?????? ????
????????? ????
?????? ????????
????????? ???? ??????? ????? .?????????? ????? ??? ????? ??????? ???? ???? ??????????? ?????????
?????? ???? ?????? ?????
?
???
????????? ?????? ???????? ????? ???? ?????? ??????? ???? ??????? ?????
????
?????? ?????
?????? ?????
??????? ????
?????????? ????? ???? ?????? ?????? ????? ??? ??????? ??????
???
???
?????? ??????
?????
???????
??????? ????? ??????? ????? ??? ?????? ??????? ????? ???? ?????? ???
????????? ??????
.????? ????? ???????
8
-
???????
[1] D. J. Power. A Brief History of Decision Support Systems.
[2] J. H. Bernstein. The Data-Information-Knowledge-
Wisdom Hierarchy and its Antithesis.
[3] U. D. Surajit Chaudhuri, "An Overview of
DataWarehousing and OLAPTechnology," SIGMOD
Record, vol. 26, pp. 65-74.
[4] e. a. Djan Sarka. (2012). Implementing a Data Warehouse
with Microsoft SQL Server 2012.
[5] M. Rittman. Quickly Define KPIs and Scorecards That
Use Them.
[6] C. Vercellis. (2009). Business Intelligence: Data Mining
and Optimization for Decision Making.
[7] Business Intelligence Reporting. Available: http://etl-
tools.info/en/bi/reporting.htm
[8] Business Intelligence (BI) Maturity Model. Available:
http://bi-insider.com/portfolio/bi-maturity-model
1
Business Intelligence
2 In-Memory Database
3 Data
4
Information
5
Knowledge
6
Wisdom
7
Data Mining
8 Patterns
9 Transactional Data
10
Analytical Data
11
Online Transactional Processing
12
Online Analytical Processing
13 Extract-Transform-Load
14 Multidimenstional Database
15 Fact-Dimension
16
Dashboard
17
Dimension
18
Member
19 Fact
20 Measure
21 Primary Key
22 Foreign Key
23
Star-Schema
24
Key Performance Indocator
25
Average Revenue Per User
26 Earnings Before Interest, Taxes, Depreciation, and
Amortization
27 Regression Analysis
28
Decision Tree
29
Association Analysis
30
Cluster Analysis
31 Cross-selling
32 Return of Investment
33 Ad-hoc report
34
Write-back report

�ݺ�ߣ

????? ?? ?? ??? ?????

Recommended

More Related Content

Similar to ????? ?? ?? ??? ????? (20)

More from Zahra Mansoori (13)

????? ?? ?? ??? ?????