BI??????

1
BI??????

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

2
??

• ??????????(Business intelligence, BI)????????
• ????,BI???????
• ??????????????????????????
• ?????????????????????,?????????
• ?????BI??,?????????????????????,??????????,?????

3

• ??BI??,??????????????
• (1)??????????????
• (2)????????OLAP????????
• (3)??????

?2.1BI?????
4

• BI?????????????????????,????????

?2.2BI??????
5
2-1 ????

• ?????,???????????,??BI????????????????,???????????
  ??
• ???????,????????,????????????????
• ?? ????????
• ?? ??????
• ?? ????

6

• ??????,?????????,??????
• ???????
• BI?????
• ??????????
• ??????????
• ??????
• ???????
• ??????

7
2-2 ????

• ?????????(Enterprise Infrastructure Evaluation)
• ?????,??????????????(Readiness)????BI??????,??????
  ?????????
• ?????????,?????????
• ?? ????????
• ?? ?????????

8
2-2-1 ?????????

• ?? ????????
• 1?????
• ????????????????
• 2???????
• ????????????????,?????BI??,?????????,????????????
  ?????????????????
• 3??????????
• ????????????????

9

• ?? ?????????
• ????????????,?????????
• ??????????????????(Role and responsibility),?????
  ??????
• ???????????????,??????????,?????????
• ????????????????,?????????????????
• ?????????????????????????????????????????????????
  ????,???????????
• ????? (Meta data repository) ??????????,?????????
  ??,???????????????????????????????????????

10
2-2-2 ????(Project planning)

• ????????(Project management institute)????????????
  ???????
• ???????????????
• ?????????
• ???????????
• ???????????
• ??????????
• ???????????
• WBS?CPM?PERT????????

11
2-3 ?????? 2-3-1 ????

• ???????,???????????????????,???????????????BI????
  ?
• ?????????,?????????????????????????,??BI??????????
  ????????????,????BI?????,???????????,???????,?????
  ??????

12
2-3-2 ????

• ??????????,???????????????????????
• ??????(Logical data modeling)?
• ???????????????????????????????????(Normative
  rules),????????????,????????????????????,?????????
  ???
• ??????(Source data analysis)?
• ????????????????????????,??????????????????????,??
  ???????????,????????ETL?????,??,?????????????,????
  ?,?????????????????,?????????

13

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

14
2-3-3 ?????????

• ????????????,???????(Meta data)???????????????????
  ?,???????????????????????????,????????????????????
  ???
• ????,????????? 
• ??????????????
• ????????(?????????????????)
• ????????(?????????)
• ??????????

15

• ??????????????????
• ???????????
• ??BI??,????????????????,?????,?????,?????????
• ??????????????
• BI????????????????,?????????????????????????????
• ????????????????????
• ???????????,?????????,????????????

16

• ??????????????????
• ??????????(Logical meta model)
• ?????????????????????,?????????E-R??(Entity-relati
  onship diagram)???
• ??Meta-meta data
• ??meta data ?????????,Meta-meta data????Meta data
  ??????

?2.5 E-R Model
17
2-3-4 ????

• ?????????????,??????,???????????????????????BI???
  ?,????????????????????????,???????????????
• ???????????????????????
• ??ETL???????????????,????ETL?????,??????????? 
• ??Meta data???????????????,???????????Meta
  data?????????

18

• ??????
• ???????????(Show-and-tell prototype)
• ?????????(Mock-up prototype)
• ????????(Proof-of-concept prototype)
• ??????????(Visual-design prototype)
• ????????(Demo prototype)
• ????????(Operational prototype)

19
2-4 ?????????2-4-1 ?????

• ?????????????,???????,BI???????????,???????????,??
  ???(Slice and dice)???????,?????????,?????????????
  (Insights)?
• ?????????,??BI?????????????,?????(Schema)???
• ???? (Star schema)
• ????(Snowflake schema)

20

• ???? (Star schema)
• ?????????????, ?????????????????????(Fact
  table),??????????,?????????
• ????????????????, ?????(Dimensional tables),
  ??????????????????????
• ????????(Denomalized)???,??,???????????????????,??
  , ?????,??????????,?????????,?????????????,?????,?
  ???????????

21
?2.6 Star schema
22

• ????(Snowflake schema)
• ????????????,??????????????(Normalized),???????,??
  ??????,?????????,????????,??????,???????????????

?2.7 Snowflake schema
23
2-4-2 ??/??/??????

• BI????????????????????????,?????????????(Target
  database)????,?????????????????(Extraction,
  transformation, and loading, ETL)?
• ??????,???????????????????????,??????????????????
  ??,???????????????????????????,?BI??????????????,
  ??,???????????,??????ETL?????????
• ?????,???????,?????????????

24

• ??,?ETL????????,??????????????
• ??,????????????????????????,?????????????????,????
  ??????????????,???????????????,??????????
• ??,??????????????(Synonyms),??????????????(Homonym
  s),?????????

25

• ??,????????????????????,??,??????????,????????,???
  ???????????
• ???ETL?,??????????????,????????????,??????????????
  ?????,?????????,????????,?????????,?? ETL??????

26

• ??ETL?????,???????????????????????????????????(Te
  st log)??????????,????5?
• ????(Unit testing)
• ????(Integration testing)
• ????(Regression testing)
• ????(Performance testing)
• ????(Acceptance testing)

27
2-4-3 ???????

• ??????????????????????(Centralized meta data
  repository)??????????(Decentralized meta data
  repository)?XML???????????(XML-tagged distributed
  meta data repository)?
• ????????????????????????????,?????????????????,???
  ?????????????????????,????????????

28

• ?????????????????????????,??????????????(DBMS
  gateway)??????,????????,????????????????????,?????
  ????????,???????????????????,??????????????
• XML(Extensible markup language)???????????????????
  ?????????,?? XML??(XML gateway)??????????????,????
  ?????????????????????????????????,????XLM?????????
  ?????????????????????,??????????????????

29

• ??BI?????????????????????,????????????,?????????
• ?????????????,????????(Mandatory)?????????????????
  (Beneficial to have)???????????(Nice to have)?
• ???????????????????????????????(API)????????????? 
  
• ?????????????247?????????????????????????????????
  ??????5?????????????

30

• ?????????????????
• ?????????
• ???????????(Tool interface)
• ???????????(Access interface)
• ??????(Migration)??

31
2-4-4 ??????

• BI??????????????????????(Online analytical
  processing tools, OLAP)??OLAP ????????????????????
  ?,?????????,???????????????
• ???BI?????????(Data mining),???????????????????

32

• OLAP??????
• ?????
• ???????(what if?????)
• ?????????
• ???????????

33

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

34
2-5 ??????2-5-1 ????

• BI?????????????????,????????(Go-live),????????????
  ,??????(Production system)????,???????????????????
  ?,?????????????,???????(Help desk)???

35
2-5-2 ?????

• ?BI????????3?6??,????????????????????BI???????????
  ????
• ??BI???????????? BI????????????????????

36
??

• ??BI??????????????????????,?????????????????,??,BI
  ??????????,???????????????????
• ??,????????????BI???????????,?????BI???????????,??
  ??????????,???????????????????????
• ??,???????????, BI????????????????,???????????????
  ,???????????????,????????????????