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

BI 專案生命週期 PowerPoint PPT Presentation


  • 269 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


  • (Business intelligence, BI)

  • BI

    • BI


2.1BI

  • BI

    • (1)

    • (2)OLAP

    • (3)


2.2BI

BI


  • BI


    • BI


  • (Enterprise Infrastructure Evaluation)

    • (Readiness)BI


  • 1

  • 2

    • BI

  • 3


      • (Role and responsibility)

      • (Meta data repository)


(Project planning)

  • (Project management institute)

  • :

    • WBSCPMPERT


BI

BIBI


  • (Logical data modeling)

    • (Normative rules)

  • (Source data analysis)

    • ETL



  • (Meta data)

    • ()

    • ()


      • 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

    • ETLETL

    • Meta dataMeta data


    • (Show-and-tell prototype)

    • (Mock-up prototype)

    • (Proof-of-concept prototype)

    • (Visual-design prototype)

    • (Demo prototype)

    • (Operational prototype)


  • BI(Slice and dice)(Insights)

  • BI(Schema):

    • (Star schema)

    • (Snowflake schema)


  • (Star schema)

  • , (Fact table)

  • , (Dimensional tables)

  • (Denomalized),


2.6 Star schema


2.7 Snowflake schema

  • (Snowflake schema)

    • (Normalized)


//

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

BIETL


ETL

(Synonyms)(Homonyms)


ETL ETL


  • ETL(Test log)5

    • (Unit testing)

    • (Integration testing)

    • (Regression testing)

    • (Performance testing)

    • (Acceptance testing)


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


(DBMS gateway)

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


  • BI

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

    • (API)

    • 24*75


    • (Tool interface)

    • (Access interface)

    • (Migration)


BI(Online analytical processing tools, OLAP)OLAP

BI(Data mining)


  • OLAP

    • (what if)



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


  • BI36BI

    • BI BI


BIBI

BIBI

BI


  • Login