微软-商务智能助力企业科学决策

微软商务智能助力企业科学决策 议题安排 微软BI解决方案概述微软BI展现产品一览PerformancePointReportingService成功案例 企业客户数据再利用业务挑战与需求 高层管理报表太多 分散 数据不一致 难及时监控到业务状况 决策时无有效基础数据 难以有效考核业绩 业务部门主管与业务分析员所需报表难及时获取 报表制作太麻烦 难以多角度 深层次分析业务异常原因 业务报表分享困难 IT主管 数据孤岛 造成数据分散 不一致 质量不高 报表与分析需求多且频繁变动 难以应付 报表多 业务系统性能受影响 报表随意分发 数据安全难以保障 战略价值 企业客户数据再利用解决方案 可靠 健全企业数据 个人 团队业务洞察力 企业管理决策力 商务智能系统 20062005BusinessIntelligence BI 12 4 8 Securityenhancementtools21 4 5 Mobileworkforceapplications33 3 9 Collaborationtechnologies4 3 6 Customersalesandservicetechnologies58 3 4 Service orientedapplicationsandarchitecture SOA SOBA 611 3 2 Workflowmanagement74 3 2 Networking voiceanddatacommunications87 3 0 Virtualization storage computing datacenter 910 2 9 Legacyapplicationmodernizationandupgrade105 2 5 Towhatextentwillyourinvestmentineachofthefollowingtechnologieschangein2006 Ranking SpendingIncrease 2006CIOTechnologyPriorities Source GartnerEXP2006CIOSurvey 商务智能系统 NO 1的关注BIisthe 1TechologyPriorityforCIOsThemarketishot spendingishigh theopportunityishuge BI定义与基本理念 Abroadcategoryofapplicationsandtechnologiesforgathering storing analyzing sharingandprovidingaccesstodatatohelpenterpriseusersmakebetterbusinessdecisions Gartner 各种不同的应用程序和技术 可用于收集 存储 分析 共享数据并提供数据访问 从而帮助企业用户做出更好的业务决策 Gartner 通过为所有员工提供业务认知来强化组织结构 从而做出更好 更快 更恰当的决策 提升企业整体的业务分析效率和深度 执行完整的 集成的商业智能解决方案 通过MicrosoftOffice提供普及的智能分析前端 以经济实惠的成本满足企业需求 微软商务智能愿景 敏捷 精准的业务决策 微软商务智能 端到端解决方案 Why Whathappened Whatishappening Whatwillhappen WhatdoIwanttohappen PerformancePointBetterexecuteonstrategy PMProtagonists BusinessExecutivesCFO CEO COO Controller FinanceExecutive GeneralManager LineofBusinessManager InformationWorkersPowerUsers BusinessAnalysts Modelers Contributors ITManagersBUITCorporateIT HowPMisaddressedtoday Isanyofthisstillrelevant BusinessAnalysts Executives InformationWorkers ManymovingpartsManualconsolidationLinkedSpreadsheetsError proneSlow HowPMcanbeaddressed What Why How Who When Collaborative User friendly Contextual Informationthatisrelevanttome Aligned Actionable Accountable InformationthatIcantrustandacton Flexible Secure Auditable Buildandmodifywithincompliance Whydidithappen Analytics Whathappened Reporting Whatwillhappen Forecasting WhatdoIwanttohappen Planning Budgeting Consolidation Whatishappening ScorecardsandDashboards PerformanceManagementCapabilitiesrequired PerformancePointServer2007Planning Businessuserscaninteractwithandcontinuouslycontributetothebusinessprocessesofplanning budgetingandforecastinginthefamiliarandeasytouseOfficeExcelenvironment PlanningAndModeling BusinessusersdesignmodelsthewaytheythinkabouttheirbusinessTop downandbottom upplanningfunctionalityconnectingpeopleanddrivingaccountabilityProcessmanagementtomanageforms workflows submissions approvals reports notificationsandannotationsSecureandauditableenvironmentSpansfromsinglemodeldeploymentstoenterprisescenarios PPSFinancialAndBusinessIntelligence PPSprovidesDimensionswithbuiltinintelligenceAccount Entity Flow TimeCurrency ExchangeRate BusinessProcess ScenarioAssignabledimensionmember Types todrivefinancialandbusinessbehaviorAccounttypes ExchangeRateTypes EntityTypes ModelswithbuiltintelligenceFinancial businessreporting BusinessruleswithbuiltinintelligenceConsolidation Currencytranslationandadjustments Intercompanyeliminationsandreconciliations validations allocations mappings businessdrivers regularcalculations ratios BusinessprocessdesignandcontrolDesignprocessesforregularinformationandreportingneedsandassociatedsecuritysettingsAudittrailFormandreportdesigninExcelEndusersuseExcelforenteringandreviewingdatathroughformsandreports Displaytheorganization sstrategyanditstargets goals andalertsinavisualformattoallowuserstomonitorandtakeaction PerformancePointServer2007Monitorperformance RichMonitoringCapabilities Spansfrompersonalperformancedashboardstoformalmethodology basedandcascadingscorecardsAccesswiderangeofstructuredandunstructureddata sourcesformorecomprehensivedashboardsandscorecardsRichdashboardfilterstodynamicallyfilterallviewsonthedashboard ContextualKPIsandreportsreflectchangesinplanning budgeting andforecastingdataDynamicStrategyMapslinkedtoKPIdataAssignownerstoKPIsforaccountability DashboardDesigner FamiliarMicrosoftOffice2007lookandfeelFastTimetoDeliveryandEaseofAdministrationDesignedforcollaborationandreuseOfflinecapabilitiesBuilt intemplatesandwizardsallowusertoquicklybuildandsharedashboardsandscorecards Analyticsanddatavisualizationmakeiteasyforuserstounderstandcomplexinformationfaster spothighlights trendsandopportunities PerformancePointServer2007Analyzeperformance AnalysisAndDataVisualization Web basedthinanalysisprovidesuserswithrichanalyticalfunctionalityoutofthebox minimizinghelprequiredfromITStaffAnalyticsincludemultidimensionalsliceanddice drill across drill to detail root causeanalysis andcentralizedbusinesslogicdefinitionsPredictiveanalyticsallowforforecastingandtrendanalysisGuidedandcontextualanalysisthroughtightintegrationofKPIsandanalyticsinthedashboardAdvancedDataVisualizationssuchasdecompositiontreesandperformancemaps Dashboards KeyCapabilitiesInteractive visualdisplaysofperformancedataReportsfrommultipledatasourcesIntegratedwithSharePointParameterizedusingfiltersCustomizedusingSharePointMasterPages Easilydeliveraggregated interactiveviewsofyourperformancemetricsanddatatoallyourstakeholdersanddecisionmakers DashboardDesigner KeyCapabilitiesAddmultipleitemtypesScorecardsChartsGridsStrategyMapsOtherReportsDraganddropitemstocanvasCoordinateviewswithfiltersUseflexiblezonelayoutsPreviewDeploytoSharePoint Quicklydesignanddeploycompellingdashboardsusinglayouttemplatesandanintuitivedrag and dropinterface AnalyticCharts KeyCapabilitiesDrillUp DownDrillDownTo CrossDrill Expand CollapsePivotSmartsizingShowDetails DrilltoDetail TooltipsfordatapointsShowchartdatainagridExporttoExcelShowinNewWindowAJAXtechnology PresentAnalysisServices2005queriesinchartviewstailoredfordashboarddisplays Explorethedatatounderstanddrivingfactors AnalyticGrids PresentAnalysisServices2005queriesingridviewstailoredfordashboarddisplays Explorethedatatounderstanddrivingfactors KeyCapabilitiesDrillUp DownExpand CollapsePivotShowDetails DrilltoDetail DrillDownTo CrossDrill ExporttoExcelShowinNewWindowSmartcolumnheaderandlabelshorteningTooltipswithfullheaderlabelCustomizablegridformattingwithCSS AnalyticViewDesigner KeyCapabilitiesDraganddrophierarchiesSelectmembersandmeasuresNavigatethroughhierarchiesPreviewviewAddfiltersUseMDXeditormode DesignAnalysisServices2005queriesusingnavigation querylayout andmemberselection StrategyMaps KeyCapabilitiesDisplaysKPIstatusonVisioobjectsUsesPPSKPIsSupportsVisiostencils Visuallycombineyourorganization soverallstrategywithitsperformancegoals status andrelateddata TrendChartsandAnalysis KeyCapabilitiesForecastdatausingscorecardsandKPIsSetnumberofperiodstoforecastSetexplicitortrailingperiodsSetdataminingalgorithmparameters Forecastvaluesusingthehistoricalperformanceofscorecarddata UseSQLServerdataminingalgorithmstogenerateprojections ReportTypes ScorecardsStrategyMaps AnalyticChartsandGrids TrendCharts ReportingServicesProClarityAnalyticsServer Excel2007andExcelServices WebURLsPivotTablesandPivotCharts NewforPPS notinBSM2005 DashboardFilters KeyCapabilitiesAddfilterstopages zones oritemsOverridefilterswithcustomMDXUseafixedvaluelistUsedynamiclistbasedonMDXqueriesDesignatedisplayandreturncolumnsSetdefaultvalues Exploreandcompareperformanceacrossviewsandreportsbychoosingitemsfromfilterlists Linkedviewsandreportsupdatetogether DataSources KeyCapabilitiesExcel2007 SharePointlistsastabulardatasourcesCreateKPIsfromExcelworksheetsDataSourceConnectivityExcel ExcelServices SharePointLists SQLServerAnalysisServicesSAPBW ODBCExtensible NewforPPS notinBSM AccessandcombinedatafromavarietyofresourcesbringingrapidvisibilityofCorporatePerformanceagainstPlantoAllUsers ExporttoExcel2007 KeyCapabilitiesExportscorecards analyticgrids analyticcharts andstrategymapsdirectlyfromdashboardstoExcel2007 PerformancePointBuilder PerformancePointBuilder ProClarityAnalytics6 Analytics Ad hoc analyticdashboardsMonitor Metrics KeybusinessviewsAnalyze Trends ContributionsInvestigate ClicktoAnalyze 企业报表与分析平台 分析展现丰富化Proclariy 丰富的图表 灵活的分析 醒目的异常显示 鸟瞰图 金额 利润以面积 颜色表示 一目了然 分解图 角度 层次随意跳转 简化分析 异常报警 好 坏异常数据 醒目显示 报表 分析 集成 企业级BI数据平台SQLServer 集ETL OLAP DataMining与报表服务于一体 企业级数据中心 数据仓库平台SQLServer2005整合服务 ETL完整功能 企业级数据整合工具高性能 内存级数据处理支持复杂数据流程设计支持各类复杂数据源多种数据清洗 转换任务组件设计开发特性可视化数据流程设计动态调试 断点自定义任务 转换 数据源集成特性与数据挖掘紧密集成支持WebServices XML 与BI应用紧密集成自身能够作为数据源再度利用 分析服务 提供多维数据库存储方式 Cube 支持灵活多样的多维分析技术统一维度模型 UDM 集成了关系型与OLAP视图主动缓存 ProactiveCache BringingthebestofMOLAPtoROLAPMOLAP ROLAP以及HOLAP的区分不再重要数据挖掘算法提供 企业级数据中心 数据仓库平台SQLServer分析服务 内置数据挖掘技术 可视化的数据挖掘工具与导航8种数据挖掘算法集成DecisionTreesNa veBayesianClusteringSequenceClusteringAssociationRulesNeuralNetworkTimeSeriesTextMining行业标准的领导者DMX XML A支持第三方算法嵌入关联销售销售预期客户分类客户行为分析风险管理信用评估欺诈检测流量点击分析 TextMining 企业级数据中心 数据仓库平台SQLServer报表服务 报表与分析基础平台支持 支持多种数字 图形 Web格式的报表输出可以定制开发新的图表插件 DundasExamples DundasExamples 企业级数据中心 数据仓库平台SQLServer报表服务 报表与分析基础平台支持 嵌入式报表ReportDesigne