Microsoft Consulting Services

1
????????????? ??????-????????? ?
???????????????????? ?????????

• ??????? ???????
• Microsoft Consulting Services
• ???????????

2
??????????

• ???????? ??????? ??????? ?????? ?? ???????????
• ????????????? ??????????? MS SQL Server 2000
  Analysis Services
• ??????? ???????? ??????-????????? ?
  ???????????????????? ???????
• ??????? ?????????

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

• ?????????? ?????????????????? ??????? ? ???????
  ???????
• ??? ???????, ??? ?????? ???????? ?? ???? ????
  ??????? ??????? ???
• ????????? 1 ????????????? ?????????? ??????????
• IT-????? ??????? ????????? ?? ????????? ???????
  ?????????? ? ????? ????????? ????????????
• ???? ?????? ????????????? ???????? (????????) ???
  ???? ????? ??????????? ???????????
• ??? ??? ????
• ????????? 2 ???????? ? ??????????? ???????
• ???? ? ?? ?? ?????????? ??????? ?? ??????
  ??????????
• ????????? ?????? ?? ??????????? ? ?????
• ????? ???????????? ???? ?????
• ????? ?? ????? ??????????? ?????? ?? ???????????
  ?????????

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

• ????????? 3 ????????? ????????? ? ????????
  ???????? ??????? ??????? ?????????? ????,
  ???????????? ????????? / ?????
• ??? ???? ????????
• ??? ?????? ??? ? ??? ???????? ? ???????
• ??? ???????? ?? ????????
• ...
• ????? ??? ?????????? ??????????? ?? ???????? ?
  ???????? ??????????
• ????????? ???????
• ???????? ???????????

5
?????? Business Intelligence

• ??????????? ??????????? ?????????? ??????????
  ?????????? ? ??????, ? ?????? ? ????????
  ????????? ??????? ???????? ????????????
  ?????????????...
• ???? ????
• ???????????? ?????? ?????????? General Electric

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

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

7
??????????? ????????????? ??????????
????????? ???????, ?????????, ????? ????????
????????????? ??????? ?????????
????? ????????? ?????? ???
????????? ?????? ???????
??????? ????? ????? ???.
????
????
????? 1
????? 2
???????
...
????? N
8
BI ? ????? ?????? ????????????
??? ?????.
???????????
???????????
?????? ???????? ??????? - ?????????? ??????? -
?????????????? ?????????? - ???????,
????????????
- ProClarity- Cognos- Business Objects -
????????
Excel 2002 --PivotTables--PivotCharts Data
Analyzer
??????? ???????? ??????? - ???????????? ?????? -
?????????? / ?????????? - ???????? ??????????
?????????- ???? ?????- ?????
????? .xls-?????Save to Web
?????? ? ???????
???????- ???? ?????- ?????
9
OLAP ???????? ??? ??????
OLAP ??????????? ?????? ??????? ?????? ???????
????? ??????? ?????? ????????? ???????
?????????? ??????????????? ? ?????????
???????????? ?????????????

• ????????????? ??????????
• ?????? ?????????? ?????? ?????? (OLTP)
• ??????? ?????????????????? ?????? ??? ??????
• ???????? ??????????? ??????????? ??????????????
  ?????????? / ???????

• ?????????? ???????
• ??????????? ????????? ?????? ??????
• ?????????? ????? ???????? ?????????????
• ??????????? ????????????? ??????????? ??????

10
??? ??????????? ??? ????? ??????-???????

• ???????????????? ??????????? ?????? ??? ??????
• ????????? ???????? ???????? ??????? ????????????
  ??????????? ??????????? ??? OLAP-????
  (?????????, ????????)
• ???? ???????????? ????????? ?????? ??????? ??
  ?????????? ??????????? ????????????
• ?????????????? ? ??????? ?????? ???????? ??? ??
  ?????, ??? ? ??????????? ?????????? ????????
• ?????????? ??????????? ?????????????
  ????????????? ?? / ?? ??????? ????????? ??????
• ??? ?? ???????? ??????? (?????????? ????????),
  ??? ? ?????????? ???????????
• ??? ????????? (?????????????? ?????????????), ???
  ? ?????????? ??????? ??????

11
??? ??????????? ??? ????? ??????-???????

• ?????? ?????????????? ??????, ???????????
• ??????????? ??????? / ?????? ?????? ?????????
  ???????? (OLE DB)
• ????????? ???????????? ?????????????? ??? ???????
  ? ???????? ????????
• ??????? ?????? ?????????? ???????? ? ???????????
  ?? ??????????? ?????????? ?????
• ????????????? ?????????? ????????
• ???????????
• ?????????????? ???????? ?????, ????????
  ???????????? ?????????? ? ???????????,
  ???????????, ??????

12
??? ??????????? ??? ????? ??????-???????

• ?????????? OLAP-??????
• ?????????????? ????????? ?????? ??????????
  ???????? (ROLAP, MOLAP, HOLAP)
• ?????????? ? ?????? OLE DB-???????????
  ????????????? ???????????
• ?????????? ??????????? ??????? ???????????
  ?????????? ????????
• ?????????? ???????????? ??????????? ?????? ?
  ????????? ? ???????? ?????? ??????

13
??? ??????????? ??? ????? ??????-???????

• ??????????? ??????????? ?????????? ??????? ?
  ??????????? ??????
• ??? ???????? ??????????? OLAP-??????????
• ??????? ? ???????
• ? ??????????? ?? ???? ? ???????? ??????????
• ?? ? / ?, C, Java, Delphi, Visual Basic,
  ActiveX Scripting, MS Office, PowerBuilder, Cobol
  ? ?.?.
• ? ?.?. ??????????, ??????????????? ?? ?????? ?
  ???????? / ????????

14
??? ??????????? ??? ????? ??????-???????

• ??? -
• ??? ??? ????????????????? ?????? ? ??? ??????

15
Microsoft BI ??????????? ??????
16
????????? ????? ????????? OLAP ?? ??????????
OLAP Report (http//www.olapreport.com/Market.htm
shares) ?? ????? 2002 ?.
...Many OLAP solutions are implemented using both
OLAP and non-OLAP technologies. As far as
possible, we exclude the latter from the
figures...
17
Microsoft ?? ????????? ? ??????? ????????????
??????? ? ??????? BI
?? ?????????? Gartner Group (http//www.gartner.co
m/webletter/microsoft/article3/article3.html)
18
ATT Growth Markets? ???????????? - ? ???? 2000
?.

• ??????-????????
• ???????? ????????? ???????? ?????,
• ???????????? ????? ??????????? ????????? ??????
  ?????
• ????????? ????? ????? ???????
• ??????? ?????? ?? ???????? ????????
• Microsoft SQL Server, ProClarity, Digital
  Dashboard, Map Info plug-in
• ??????????? ? ATT 500 ??????-??????????,
  ?????????? ?? ?????????, ???????? ??????????????
• ??? 11,000 ???????? (???????????? ??????????????)
  ??? ??????? ????? Web
• ?????????
• ??????? ?????????? 300 ?? 6 ???????

http//www.microsoft.com/servers/evaluation/casest
udies/ATT.doc
19
Vodafone, Ltd.? ??????? 2002 ?.

• ???? ?? ?????????? ????????????????????
  ??????-?????????? ? ????
• ???????? ? 29 ???????
• 83 ???. ????????
• Windows 2000 Datacenter Server SQL Server 2000
  Enterprise Edition
• 16-???????????? ????????????
• 1.4 ?? ?????? (EMC Symmetrix)
• Amit Pau, Vodafone Multimedia division, Managing
  director
• The workforce is becoming increasingly mobile
  and there are currently millions of e-mail and
  Internet users who are demanding remote access to
  these services. We wanted to provide the sort of
  infrastructure that would unlock the back office
  and empower mobile workers to keep in touch with
  their corporate information.

20
TELMOS, ??????? ??? 2002 ?.

• ?????????
• ? ?????????????? ???? Microsoft SQL Server TELMOS
  ?????????? ? ??????? ????? ??????????????????
  ??????????? ??????? ?????? ? ???????? ??????? ??
  ?????? ? ????????? (CRM) ????????
  ??????????????? ???? ?????? ? ?????????????????
  ???????? ??????-???????? ?? ???????????
• ?? ???? ?????? ????????? ???????????
  ????????????? ?????????????? ???????, ??????????
  ???????????? ???????????? ?????????
  ???????????????????? ?????
• ????????????
• ???? ????????????? ?????????? ? ??????? ? ???????
  ???????? ? ???
• ?????????? ??????? ????????? ??????
• ?????? ??????????? ? ?????????? ??????-?????????
• ???????? ???????? ?? ??????????? ?????????
• ?????????? ??????? ???????? ???????????

21
TELMOS

• ????????? ???????, ?????????? ?? Oracle, ???????
  ?????? ??? ??, ??? ? ????????? ?????????? ?????
  (UNIX-???????). ??? ????????? ???????????????? ?
  ?????????? ??????? ?? ???? Microsoft ???????
  ???????????.
• ??????? ??????? ? ???????? ????????, ??? ????,
  ??????? ?? ???????, ????????? ??????????? ???????
  ?????? ???????. ?????????? Microsoft ???????? ??
  ???????? ??????????? ?? ????, ??????? ?? ?????
  ????? ?????????.
• ??????? ?????
• ???????? ?? ?????????????? ???????????
• TELMOS
• http//www.microsoft.com/serviceproviders/casestud
  ies/telmosP119828.asp

22
????????? ???????? BI ? ????????????????????
???????

• ?????? ???????? ???????
• ??????????????? ????????, ???????????? ?????????
• ?????? ??????????? ????????
• ???????? ??????? ?????, ??????????? ????????
  ???????????
• ????????? ????????????

23
?????? ? ??????

• GSM analogue 1 - 5 ?? ???????
• GSM 1 - 3 ?? ???????

• ????????

24
?????? ??????? ???????????

• WatchDog
• Basset Telecom Solutions (http//www.basset.se)
• ?????????? ?? MS SQL Server 7.0, 2000

25
????????
26
?????????????? ??????????

• Microsoft Business Intelligencehttp//www.microso
  ft.com/business/bi/
• Microsoft SQL Serverhttp//microsoft.com/sql/defa
  ult.asp
• Microsoft Data Warehousing Alliancehttp//www.mic
  rosoft.com/sql/partners/DWA/default.asp
• Microsoft Consulting Services
• http//www.microsoft.com/BUSINESS/services/mcs.as
  p

27
(No Transcript)