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

微软商务智能

助力企业科学决策议题安排微软BI解决方案概述微软BI展现产品一览PerformancePointReportingService成功案例战略价值可靠健全数据可扩展性一致性、有效性整合性个人与团队业务洞察力协作、共享简单、易用高效、便捷企业决策力企业业务活动协调、统一企业管理目标化、职责化业务决策敏捷、准确平台应用业务状态脉络清晰领悟透彻企业客户数据再利用业务挑战与需求高层管理报表太多，分散，数据不一致；难及时监控到业务状况；决策时无有效基础数据；难以有效考核业绩…业务部门主管与业务分析员

所需报表难及时获取；

报表制作太麻烦；难以多角度、深层次分析业务异常原因；业务报表分享困难…IT主管“数据孤岛”造成数据分散，不一致，质量不高；报表与分析需求多且频繁变动，难以应付；报表多，业务系统性能受影响；报表随意分发，数据安全难以保障…报表即席查询个人与部门仪表板分析图表数据整合数据存储数据管理

安全一致性、有效性扩展能力……战略价值企业客户数据再利用解决方案可靠、健全

企业数据个人&团队业务洞察力企业管理

决策力企业数据报表与分析绩效管理应用商务智能系统 20062005BusinessIntelligence(BI) 1 2+4.8%Securityenhancementtools 2 1+4.5%Mobileworkforceapplications 3 3 +3.9%Collaborationtechnologies 4 * +3.6%Customersalesandservicetechnologies 5 8 +3.4%Service-orientedapplicationsandarchitecture(SOA,SOBA) 6 11 +3.2%Workflowmanagement 7 4+3.2%Networking,voiceanddatacommunications 8 7 +3.0%Virtualization(storage,computing,datacenter) 9 10 +2.9%Legacyapplicationmodernizationandupgrade 10 5 +2.5%Towhatextentwillyourinvestmentineachofthefollowingtechnologieschangein2006?RankingSpendingIncrease2006CIOTechnologyPrioritiesSource:GartnerEXP2006CIOSurvey商务智能系统—

NO.1的关注

BIisthe#1TechologyPriorityforCIOs

Themarketishot,spendingishigh,theopportunityishugeBI定义与基本理念“Abroadcategoryofapplicationsandtechnologiesforgathering,storing,analyzing,sharingandprovidingaccesstodatatohelpenterpriseusersmakebetterbusinessdecisions.”–Gartner“各种不同的应用程序和技术，可用于收集、存储、分析、共享数据并提供数据访问，从而帮助企业用户做出更好的业务决策。”–Gartner通过为所有员工提供业务认知来强化组织结构，从而做出更好、更快、更恰当的决策提升企业整体的业务分析效率和深度；执行完整的、集成的商业智能解决方案；通过MicrosoftOffice提供普及的智能分析前端；以经济实惠的成本满足企业需求；微软商务智能愿景敏捷、精准的业务决策Excel&ExcelService&ProclarityPerformancePointServerBI平台SQLServerReportingServices报表服务SQLServerAnalysisServices分析服务SQLServerDBMS关系型引擎SQLServerIntegrationServices集成服务SharePointServer呈现报表仪表板Excel电子簿分析视图记分卡计划与预算微软商务智能—端到端解决方案Why?Whathappened?Whatishappening?Whatwillhappen?

WhatdoIwanttohappen?PerformancePoint

BetterexecuteonstrategyPMProtagonistsBusinessExecutivesCFO,CEO,COO.Controller,FinanceExecutive.GeneralManager,LineofBusinessManager.InformationWorkersPowerUsers,BusinessAnalysts,Modelers.Contributors.ITManagersBUITCorporateITHowPMisaddressedtodayIsanyofthisstillrelevant?BusinessAnalystsExecutivesInformationWorkersManymovingpartsManualconsolidationLinkedSpreadsheetsError-proneSlow微软-商务智能助力企业科学决策HowPMcanbeaddressedWhat,Why,How,Who,When?Collaborative,User-friendly,Contextual.“Informationthatisrelevanttome”Aligned,Actionable,Accountable.“InformationthatIcantrustandacton”Flexible,Secure,Auditable.“Buildandmodifywithincompliance”ForecastingPlanningReportingScorecard&DashboardAnalytics微软-商务智能助力企业科学决策Whydidithappen?AnalyticsWhathappened?ReportingWhatwillhappen?

ForecastingWhatdoIwanttohappen?Planning,Budgeting,

ConsolidationWhatishappening?ScorecardsandDashboardsPerformanceManagement

CapabilitiesrequiredPerformancePointServer2007

PlanningBusinessuserscaninteractwithandcontinuouslycontributetothebusinessprocessesofplanning,budgetingandforecastinginthefamiliarandeasy

touseOfficeExcelenvironment.PlanningAndModelingBusinessusersdesignmodelsthewaytheythinkabouttheirbusinessTop-downandbottom-upplanningfunctionalityconnectingpeople

anddrivingaccountabilityProcessmanagementtomanageforms,workflows,submissions,approvals,reports,notifications

andannotationsSecureandauditableenvironmentSpansfromsinglemodeldeploymentstoenterprisescenariosPPSFinancialAndBusinessIntelligencePPSprovidesDimensionswithbuiltinintelligenceAccount,Entity,Flow,TimeCurrency,ExchangeRate,BusinessProcess,ScenarioAssignabledimensionmember‘Types’todrivefinancialand

businessbehaviorAccounttypes,ExchangeRateTypes,EntityTypes….ModelswithbuiltintelligenceFinancial,businessreporting…BusinessruleswithbuiltinintelligenceConsolidation,Currencytranslationandadjustments,Intercompanyeliminations

andreconciliations,validations,allocations,mappings,businessdrivers,regularcalculations,ratios…BusinessprocessdesignandcontrolDesignprocessesforregularinformationandreportingneedsandassociatedsecuritysettingsAudittrailFormandreportdesigninExcelEndusersuseExcelforenteringandreviewingdatathroughformsandreports

Displaytheorganization’sstrategyanditstargets,goals,andalertsinavisualformattoallowuserstomonitorandtakeaction.PerformancePointServer2007

MonitorperformanceRichMonitoringCapabilitiesSpansfrompersonal

performance

dashboardsto

formalmethodology-based

andcascadingscorecardsAccesswiderangeofstructured

andunstructureddata-sources

formorecomprehensive

dashboardsandscorecardsRichdashboardfilterstodynamicallyfilterallviewsonthedashboard.ContextualKPIsandreports

reflectchangesinplanning,

budgeting,andforecastingdataDynamicStrategyMaps

linkedtoKPIdataAssignownerstoKPIs

foraccountabilityDashboardDesignerFamiliarMicrosoftOffice2007lookandfeelFastTimetoDeliveryandEaseofAdministrationDesignedforcollaborationandreuseOfflinecapabilitiesBuilt-intemplatesandwizardsallowusertoquicklybuildandsharedashboardsandscorecardsAnalyticsanddatavisualizationmakeiteasyforuserstounderstandcomplexinformationfaster,spothighlights,trendsandopportunities.PerformancePointServer2007

AnalyzeperformanceAnalysisAndDataVisualizationWeb-basedthinanalysisprovidesuserswithrichanalyticalfunctionalityoutofthebox,minimizinghelprequiredfromITStaffAnalyticsincludemultidimensionalsliceanddice,drill-across,

drill-to-detail,root-cause

analysis,andcentralized

businesslogicdefinitionsPredictiveanalyticsallowforforecastingandtrendanalysisGuidedandcontextualanalysisthroughtightintegrationofKPIs

andanalyticsinthedashboardAdvancedDataVisualizations

suchasdecompositiontrees

andperformancemapsDashboardsKeyCapabilitiesInteractive,visualdisplaysofperformancedataReportsfrommultipledatasourcesIntegratedwithSharePointParameterizedusingfiltersCustomizedusingSharePointMasterPagesEasilydeliveraggregated,interactiveviewsofyourperformancemetricsanddatatoallyourstakeholdersanddecisionmakers.DashboardDesignerKeyCapabilitiesAddmultipleitemtypesScorecardsChartsGridsStrategyMapsOtherReportsDraganddropitemstocanvasCoordinateviewswithfiltersUseflexiblezonelayoutsPreviewDeploytoSharePointQuicklydesignanddeploycompellingdashboardsusinglayouttemplatesandanintuitivedrag-and-dropinterface.AnalyticChartsKeyCapabilitiesDrillUp/DownDrillDownTo(CrossDrill)Expand/CollapsePivotSmartsizingShowDetails(DrilltoDetail)TooltipsfordatapointsShowchartdatainagridExporttoExcelShowinNewWindowAJAXtechnologyPresentAnalysisServices2005queriesinchartviewstailoredfordashboarddisplays.Explorethedatatounderstanddrivingfactors.AnalyticGridsPresentAnalysisServices2005queriesingridviewstailoredfordashboarddisplays.Explorethedatatounderstanddrivingfactors.KeyCapabilitiesDrillUp/DownExpand/CollapsePivotShowDetails(DrilltoDetail)DrillDownTo(CrossDrill)ExporttoExcelShowinNewWindowSmartcolumnheaderandlabelshorteningTooltipswithfullheaderlabelCustomizablegridformattingwithCSSAnalyticViewDesignerKeyCapabilitiesDraganddrophierarchiesSelectmembersandmeasuresNavigatethroughhierarchiesPreviewviewAddfiltersUseMDXeditormodeDesignAnalysisServices2005queriesusingnavigation,querylayout,andmemberselection.StrategyMapsKeyCapabilitiesDisplaysKPIstatusonVisioobjectsUsesPPSKPIsSupportsVisiostencilsVisuallycombineyourorganization’soverallstrategywithitsperformancegoals,status,andrelateddata.TrendChartsandAnalysisKeyCapabilitiesForecastdatausingscorecardsandKPIsSetnumberofperiodstoforecastSetexplicitortrailingperiodsSetdataminingalgorithmparametersForecastvaluesusingthehistoricalperformanceofscorecarddata.UseSQLServerdataminingalgorithmstogenerateprojections.ReportTypesScorecardsStrategyMaps*AnalyticChartsandGrids*TrendCharts*ReportingServicesProClarityAnalyticsServer*Excel2007andExcelServices*WebURLsPivotTablesandPivotCharts*NewforPPS(notinBSM2005)DashboardFiltersKeyCapabilitiesAddfilterstopages,zones,oritemsOverridefilterswithcustomMDXUseafixedvaluelistUsedynamiclistbasedonMDXqueriesDesignatedisplayandreturncolumnsSetdefaultvaluesExploreandcompareperformanceacrossviewsandreportsbychoosingitemsfromfilterlists.Linkedviewsandreportsupdatetogether.DataSourcesKeyCapabilitiesExcel2007,SharePointlistsastabulardatasourcesCreateKPIsfromExcelworksheetsDataSourceConnectivityExcel*ExcelServices*SharePointLists*SQLServerAnalysisServicesSAPBW*ODBCExtensible*NewforPPS(notinBSM)AccessandcombinedatafromavarietyofresourcesbringingrapidvisibilityofCorporatePerformanceagainstPlantoAllUsersExporttoExcel2007KeyCapabilitiesExportscorecards,analyticgrids,analyticcharts,andstrategymapsdirectlyfromdashboardstoExcel2007PerformancePointBuilderPerformancePointBuilderProClarityAnalytics6-Analytics“Ad-hoc”analyticdashboardsMonitor-Metrics-KeybusinessviewsAnalyze-Trends-ContributionsInvestigate-“ClicktoAnalyze”企业报表与分析平台：分析展现丰富化

Proclariy

—丰富的图表，灵活的分析，醒目的异常显示鸟瞰图：金额、利润以面积、颜色表示，一目了然分解图：角度、层次随意跳转，简化分析异常报警：好、坏异常数据，醒目显示数据整合数据清洗高性能数据移动快速建立数据仓库层次化业务分析消除IT架构与应用之间的隔阂实时商业智能深入数据挖掘自定义报表数据展现与门户集成即席报表报表分析集成企业级BI数据平台

SQL

Server：集ETL、OLAP/Data

Mining与报表服务于一体BIApplicationsand

AnalyticalClientsDevelopment

ToolsBIPlatform企业级数据中心、数据仓库平台

SQLServer2005整合服务—ETL完整功能企业级数据整合工具高性能：内存级数据处理支持复杂数据流程设计支持各类复杂数据源多种数据清洗、转换任务组件设计开发特性可视化数据流程设计动态调试、断点自定义任务、转换、数据源集成特性与数据挖掘紧密集成支持WebServices,XML,与BI应用紧密集成自身能够作为数据