【正文】 時(shí)間這些步驟需要多種不同的 BI 和 DW 技術(shù) 投資許可一個(gè) ETL 工具，將數(shù)據(jù)從操作系統(tǒng)移到該數(shù)據(jù)倉(cāng)庫(kù)許可交互式用戶訪問(wèn)工具許可 /創(chuàng)建信息傳遞工具這些步驟需要花費(fèi) 時(shí)間來(lái)了解并完善學(xué)到的最佳實(shí)踐知識(shí)研究 /了解每個(gè)用戶社區(qū)的分析需求設(shè)置用戶安全性和可見(jiàn)性規(guī)則執(zhí)行 QA 和性能測(cè)試管理進(jìn)行中的更改 /升級(jí)這些步驟需要具有專業(yè)技能 的 IT 或 BI 員工資源詳細(xì)了解操作數(shù)據(jù)源為每個(gè)數(shù)據(jù)源構(gòu)建 ETL 計(jì)劃為每個(gè)受眾構(gòu)建分析按主題領(lǐng)域設(shè)計(jì)數(shù)據(jù)倉(cāng)庫(kù)BI Approaches: Tools vs ApplicationsFederated Data SourcesSiebelOracle SAP R/3 PSFT EDWOtherETLDWOracle BI Platform MetadataBI contentComparison PointsPrebuilt BI Applications ApproachTools Build ApproachBI Content ?Metadata ?Data Warehouse ?ETL ?Oracle BI 應(yīng)用產(chǎn)品完整、預(yù)建的最佳實(shí)踐 BI 解決方案旅游和運(yùn)輸汽車通信和媒體復(fù)雜的制造業(yè)消費(fèi)部門 能源金融服務(wù)高科技行業(yè)保險(xiǎn)和醫(yī)療生命科學(xué)公共部門其它運(yùn)營(yíng)和分析來(lái)源Oracle BI 套件企業(yè)版預(yù)置適配器：銷售 服務(wù)和聯(lián)系中心 市場(chǎng)營(yíng)銷 訂單管理 和執(zhí)行 供應(yīng)鏈 財(cái)務(wù) 人力資源流水線分析三角預(yù)測(cè)銷售團(tuán)隊(duì)有效性追加銷售 /交叉銷售周期分析線索轉(zhuǎn)換員工生產(chǎn)效率薪酬分析HR 稅務(wù)報(bào)表勞動(dòng)力配備人員流動(dòng)趨勢(shì)人力資本回報(bào)A/R 與 A/P分析GL/資產(chǎn)負(fù)債表分析 客戶與產(chǎn)品的收益率PL 分析支出管理現(xiàn)金流分析供貨商績(jī)效支出分析采購(gòu)周期庫(kù)存可用性員工花費(fèi)BOM 分析訂單流水線訂單 vs. 可用庫(kù)存周期分析積壓分析執(zhí)行狀態(tài)客戶應(yīng)收款活動(dòng)記分卡響應(yīng)率產(chǎn)品傾向忠誠(chéng)度和流失率市場(chǎng)籃子分析活動(dòng) ROI客戶流失傾向客戶滿意度解決率服務(wù)代表有效性服務(wù)成本分析服務(wù)趨勢(shì)Sales Analytics Product ComponentsPremapped metadata, including embedded best practice calculations and metrics for the sales anization.216。 Logical Business Model216。 Presentation Layer216。 Physical SourcesService and Contact Center AnalyticsPrebuilt ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from HCM systems, and other sources1HR Analytics utilizes ETL routines that extract data from 2,000+ operational tables and load it into 3 starschemas available for immediate analysis2Premapped metadata, defining realtime access to analytical and operational sources, embedded best practice calculations and metrics for the HCM practitioner3A “best practice” library of over 150 prebuilt rolebased intelligence dashboards, reports and alerts for HR Managers. Analysts and Business Unit Executives4Business AnalyticsWarehouse216。 Logical Business Model216。 Presentation Layer216。 Physical Sources3Prebuilt ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from ERP systems and other legacy sources.2 A “best practice” library of over 250 prebuilt intelligence dashboards, reports and alerts for sales representatives, analysts, managers and executives4Prebuilt warehouse with over 20 starschemas designed for analysis and reporting on sales, fulfillment and receivables data.1Oracle Order Management and Fulfillment AnalyticsETL Business AdaptersCRM Legacy OMOMFinancial HRPOSLegacy InventoryOther Supply Chain SystemsOperational SystemsBusiness Analytics WarehousePremapped metadata, including embedded best practice calculations and metrics for Supply Chain, Supplier, and other Business Users.? Presentation Layer? Logical Business Model? Physical Sources3Prebuilt ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from SAP, PSFT, Oracle Applications and other sources.1A “best practice” library of over 125 prebuilt metrics, Intelligent Dashboards, Reports and alerts for Buyers, Cost center Managers, Suppliers, Supplier AP Managers and Supply Chain Executives4Prebuilt warehouse with more than 15 starschemas designed for analysis and reporting on Supply Chain Analytics2Oracle Supply Chain Analytics Product ComponentsETL Business AdaptersCRM VMI Supply ChainFinancial HR POS DemandPlanningOther Supply Chain SystemsOperational SystemsBusiness Analytics WarehousePremapped metadata, including embedded best practice calculations and metrics for Financial, Executives and other Business Users.216。 Logical Business Model216。 what they should be selling。 retrieve accurate forecasts。 the health of different market segments。 etc. and can rapidly adjust the sales process while it’s occurring, not after the fact. What’s in Sales Analytics 7 Rolebased Dashboard Pages? Sales Executive Managers? Competitor Team? Customer Team? Demand Generation Team? Sales Effectiveness Team? Sales Representatives? My Accounts? My Pipeline? My Forecast5 Functional Dashboards? Competitor? Overview? Details? Product? Heat Map? Demand Generation? Overview? Results? Lead Management? Pipeline? Overview? Forecasting? Details? Sales Effectiveness? Overview? Forecast Accuracy? Product? Customer? Overview? Account Summary? Products? No. of dashboards 5? No. of dashboard pages 23? No. of reports 134? No. of metrics 560Overview Forecasting Details My Pipeline My ForecastPipeline DashboardsThe Pipeline Dashboards have been designed to provide a full and detailed insight into the anizations sales pipeline and forecast. The prebuilt analysis helps Sales Executives, Managers and Representatives quickly identify pipeline and forecasting shortfalls and proa