BI
This presentation is the property of its rightful owner.
Sponsored Links
1 / 36

BI 專案生命週期 PowerPoint PPT Presentation


  • 263 Views
  • Uploaded on
  • Presentation posted in: General

BI 專案生命週期. 前言. 不同學者對於商業智慧 (Business intelligence, BI) 的定義有所不同。 整體而言, BI 有幾個重要特性: 第一、商業智慧的重點是在於以資訊作為企業決策的依據。 第二、資訊需具備即時、整合以及多維度的特性,才具決策上的價值。 第三、透過 BI 系統,企業可以及時發現內部營運現況及掌握市場動態,並可據以採取行動因應,洞燭機先。. 圖 2. 1 : BI 系統架構圖. 一個 BI 系統,在架構上需要包含底下幾個部份: (1) 資料倉儲是商業智慧系統的基礎; (2) 資料分析系統:包括 OLAP 、資料探勘等;以及

Download Presentation

BI 專案生命週期

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Bi

BI


Bi

  • (Business intelligence, BI)

  • BI

    • BI


Bi

2.1BI

  • BI

    • (1)

    • (2)OLAP

    • (3)


Bi

2.2BI

BI


Bi

  • BI


Bi

    • BI


Bi

  • (Enterprise Infrastructure Evaluation)

    • (Readiness)BI


Bi

  • 1

  • 2

    • BI

  • 3


Bi

      • (Role and responsibility)

      • (Meta data repository)


Project planning

(Project planning)

  • (Project management institute)

  • :

    • WBSCPMPERT


Bi

BI

BIBI


Bi

  • (Logical data modeling)

    • (Normative rules)

  • (Source data analysis)

    • ETL


Bi


Bi

  • (Meta data)

    • ()

    • ()


Bi

      • BI

      • BI


Bi

2.5 E-R Model

    • (Logical meta model)

      • E-R(Entity-relationship diagram)

      • Meta-meta data

        • meta data Meta-meta dataMeta data


Bi

  • BI

    • ETLETL

    • Meta dataMeta data


Bi

    • (Show-and-tell prototype)

    • (Mock-up prototype)

    • (Proof-of-concept prototype)

    • (Visual-design prototype)

    • (Demo prototype)

    • (Operational prototype)


Bi

  • BI(Slice and dice)(Insights)

  • BI(Schema):

    • (Star schema)

    • (Snowflake schema)


Bi

  • (Star schema)

  • , (Fact table)

  • , (Dimensional tables)

  • (Denomalized),


Bi

2.6 Star schema


Bi

2.7 Snowflake schema

  • (Snowflake schema)

    • (Normalized)


Bi

//

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

BIETL


Bi

ETL

(Synonyms)(Homonyms)


Bi

ETL ETL


Bi

  • ETL(Test log)5

    • (Unit testing)

    • (Integration testing)

    • (Regression testing)

    • (Performance testing)

    • (Acceptance testing)


Bi

(Centralized meta data repository)(Decentralized meta data repository)XML(XML-tagged distributed meta data repository)


Bi

(DBMS gateway)

XML(Extensible markup language) XML(XML gateway)XLM


Bi

  • BI

    • (Mandatory)(Beneficial to have)(Nice to have)?

    • (API)

    • 24*75


Bi

    • (Tool interface)

    • (Access interface)

    • (Migration)


Bi

BI(Online analytical processing tools, OLAP)OLAP

BI(Data mining)


Bi

  • OLAP

    • (what if)


Bi


Bi

BI(Go-live)(Production system)(Help desk)


Bi

  • BI36BI

    • BI BI


Bi

BIBI

BIBI

BI


  • Login