?????????? ??????? [e-mail] ???????????? ?????? Microsoft Office Systems

1
??????? Microsoft ??? ??????-???????

• ?????????? ??????? KMayorov_at_topsbi.ru
  ???????????? ?????? Microsoft Office Systems

2

• ???? ??????? ???????? ??? ????? ?????? ??????
  ????????????? ? ??????? ??????? ?????????????
  ?????? ? ??????? ??????????? ??????? Microsoft
• ?????????? ???????
• ????????????? ????? ?????????????
• ????????????? ????????????? ??????
• ???????? ????? ?? ??????? Microsoft

3
BI ??? ?????????????

• ?????? KPI
• ?????????????
• ?????????????
• ????????????
• ???????

4
BI ??? ??????????

• ????????????? ???????? (???-????)
• ??? ?????, ???? ????????? ????? ????????
• ? ??? ????? ???????????? ?????? ??? ??????
• ?????? ??????? ? ???????????????
• ????? ??????? ?????? ?? ????????? ???????
• ?? ?? ?????, ?? ?? ?????????? ?????????

5
BI ??? ???????? ?????

• ????? ?????? ????????????? ? ???????
• ?? ??????? ?????????????
• ? ?? ???????? ???????? ? ? ??????
  ABC-??????????????
• ??? ??????????? ???????
• ?? ????? ??????????????
• ? ?? ???????????? ???????????? ?? ???????
  ???????? ???????

6
BI ??? ???????? ?????

• ??????? ???????? ?????? ?? ??????
• ?? 22 ?? 30 ??? ?? ?????????
• ? ??????? ????? ??? ???, ??????? ????????? ??????
  100?
• ??? ???????? ??????? ???????
• ?? ??????????? ????????????
• ? ?? ????????? ? ?????-?????????

7
????????????? ????????????? ??????
???????? ???????? ??????????
????.??????????
?????????????
????,??????
??????.
? ???????
??????????
??????????? ??????????
?????? ?????? ERP
OLTP
????????? ?????? ???????
8
?????? ? ?????????????? ???????
???????? ???????? ??????????
???????????
????.??????????
?????????????
????,??????
?????????
??????.
? ???????
??????????
??????? ?????
??????????? ??????????
?????? ?????? ERP
OLTP
????????? ?????? ???????
9
????????? ?????
???????? ???????? ??????????
?????? Business Intelligence
????.??????????
?????????????
????,??????
??????.
? ???????
??????????
??????????? ??????????
????????? ????????
?????? ERP, OLTP
???????????? ????????? ??????
???????????? ?????? ????????? ??????-??????
10
?????????????? ????????? Microsoft Business
Intelligence
11
???????????? ????????? ? ??????????? Microsoft
Microsoft BI Portal Scorecard Builder
???????? ???????? ??????????
KPI ?????????? Reporting Services Microsoft
Office Excel
????.??????????
?????????????
????,??????
??????.
? ???????
??????????
OLAP, Reporting Services collaboration tools
??????????? ??????????
Data Transformation ServicesMS SQL replications
????????? ????????
?????? ERP, OLTP
???????????? ?????? ????????? ??????-??????
12
???????? ? ?????????? Microsoft ??? BI
BI Portal KPI ?????????? Scorecard Builder
Microsoft SQL Server 2000 ???????????? ?????????
????????? ????????????, ? ??? ??????????????
?????? ???????????? ???????????????? ????????
??????????, ????????????? ? ???????? ???????
Reporting Services Excel ??????? ??????? Excel
OLAP, Reporting Services collaboration tools
Data Transformation ServicesMS SQL replications
13
???????? ? ?????????? Microsoft ??? BI
BI Portal KPI ?????????? Scorecard Builder
Reporting Services Excel ??????? ??????? Excel
Microsoft Office System ??? ?? ?????? ?????
???????????? ????????????, ?? ? ?????????
?????????, ????? ??????????????? ? ???????????
????????????
OLAP, Analysis Services collaboration tools
Data Transformation ServicesMS SQL replications
14
???? BI ???????
????????? ??????? ??? ??????? ??????
IT-?????? ????????
IT-?????? ?????????
15
Data Transformation Services
Data Transformation Services
DataWarehouse
16
Analysis Services

• Data Warehouse

?????????? - ???????? ??????????? ????????
??????, ??????????????? ?????????? ??????????
???????
Analysis Services
??????????? ???????
17
Reporting Services
18

• ??????? ?????????? ????????? Business
  Intelligence ???????
• ?? ??????????? Microsoft

19
(No Transcript)
20
(No Transcript)
21

• ???????

?????????? ??????? KMayorov_at_topsbi.ru
???????????? ?????? Microsoft Office
System ?????? ???????? TopS Business Integrator