商业分析和商业智能概述_Business Analytics and BI Overview 201

2014/7/24BUSINESSANALYTICSANDBIOVERVIEW2Copyright©2013-2014byTeradata.Allrightsreserved.•数据·分析·决策·触发•WhatisBICC?•BI的17种武器•目前成熟的BI产品和解决方案•BI新技术，新方向AGENDA3Copyright©2013-2014byTeradata.Allrightsreserved.•BI是查询和报告工具?•BI是在线分析处理工具?•BI是数据挖掘?•BI是统计分析?•BI是决策支持系统（DSS）?•BI是分析性ERP?•BI是分析性CRM?•BI是分析性SCM?•BI是企业绩效管理?•BI是平衡计分卡……?BI是什么？反映了财务、非财务衡量方法之间的平衡，长期目标与短期目标之间的平衡，外部和内部的平衡，结果和过程平衡，管理业绩和经营业绩的平衡等多个方面4Copyright©2013-2014byTeradata.Allrightsreserved.Data:FromTransactionstoInteractionsALLDATAWEBPetabytesCRMTerabytesGigabytesERPExabytesIncreasingDataVarietyandComplexityUserGeneratedContentMobileWebSMS/MMSSentimentExternalDemographicsHDVideoSpeechtoTextProduct/ServiceLogsSocialNetworkBusinessDataFeedsUserClickStreamWebLogsOfferHistoryA/BTestingDynamicPricingAffiliateNetworks联署网络/分销联盟SearchMarketingBehavioralTargeting行为定向广告投放模式DynamicFunnelsPaymentRecordSupportContactsCustomerTouchesPurchaseDetailPurchaseRecordOfferDetailsSegmentation5Copyright©2013-2014byTeradata.Allrightsreserved.PathToAnalyticsStrategicVisionDataSophisticationTodayREPORTINGWHAThappened?BatchReportsANALYZINGWHYdidithappen?AdHoc,BIToolsPREDICTINGWHATWILLhappen?PredictiveModelsOPERATIONALIZINGWHATIShappeningnow?LinktoOperationalSystemsACTIVATINGMAKEithappen!AutomatedLinkagesSTRATEGICINTELLIGENCEOPERATIONALINTELLIGENCEOperationalIntelligenceistheapplicationofStrategicIntelligencetooperationalsystemsandprocesses,whenitcanmakeabusinessimpactAlignAccelerateWorkloadComplexityContinuousUpdate/ShortQueriesEvent-BasedTriggeringBatchAdHocAnalytics•Querycomplexitygrows•Workloadmixturegrows•Datavolumegrows•Depthofhistorygrows•Numberofusersgrows6Copyright©2013-2014byTeradata.Allrightsreserved.BIAnalyticalCapability–DimensionScalingLevel0Level1Level2Level3Level4Level5Analysisisfocusedonoperationalperformance,alignedtobusinesssystemsandunderstanding‘Isithappening?’Thereisminimalintegrationofresultsacrossbusinessfunctions.Informationavailablesupportsfew,ifany,businessprocessesacrossthevaluechain.Analysisisfocusedonindividualbusinessunitanditsproductsalesandtotalrevenuestotrytodetermine'Whathappened.'Workloadonthesystemisprimarilybatchwithpre-definedqueries.Reportsaredesignedtopro-duceoperationalmetricsandtrackresultsforthecurrenttimeperiodandarelimitedtoanyhistorythatmaybegenerallyavailable.Dataarestoredatsummarylevelforpastreportingperiodsandaregenerallyconsideredadequateforperiod-over-periodcomparisons.Analysiscannowanswerquestionsaround'Whydidithappen.'Thismayincludecomparisonofresultsformarketinginitiatives,deductionsbycarrierbasedondeliverytimes,claimslossesbygivenprocedurecodes,orcustomersatisfactionbyvariouscustomerservicereps.Thereisanincreaseinad-hocqueriesfrompriorlevels.Deeperanalyticsandmodelingarebeingtriedonanexperimentalbasis,primarilywithapplicationsoutsidetheware-house.Analysisnowfocusesonpredicting'Whatwillhappen.'Additionaldatamustbecapturedandanalyzedwiththeresultsdeliveredbyspecificpromotions,channels,productsandpricingplans.Sophisticatedpredictivemodelingcapabilitieshelptoimprovetheresultsandlowerthecostsofthemarketingstrategies.Somedatamining/analyticsareperformedin-database.Thecompany'sabilitytounderstand'Whatishappening'andrespondquicklytocustomerrequirementsandcompetitivethreatsiscriticaltonear-termresultsandperformance.Continuousupdateandtime-sensitivequeriesgainimportance.Therealprofitabilityofindividualcustomersmustbeunderstoodtorefinemarketingstrategiestomaximizetheyieldontheirassets.Mostdataminingandanalyticsperformedin-database.Businessintelligenceisextendedtoask‘WhatdoIwanttohappen?'and‘Makingithappen'.Event-basedtriggeringtakesholdintheorganization.Informationflowstoreal-timeprocessesthatautomatetheroutinetrans-actions,leavingpersonnelfreetolookforoperationalexceptionsandnewopportunities.Nearreal-timeinformationisprovidedtointernalorganizations,suppliers,andclientstosupporttheirbusinessneeds.7Copyright©2013-2014byTeradata.Allrightsreserved.8Copyright©2013-2014byTeradata.Allrightsreserved.BICompetencyCenter（BICC）–TheIntegrationofCompetencyandSkillsSourceApplicationsOrganizationandprocessesToolsandapplicationsDataintegrationandmanagementBusinessSkillsBusinessneedsOrganizationandprocessesAnalyticSkillsStatistical&processskillsBusinessneedsITSkillsTools,applications,DatamanagementToolsandapplicationsDevelopuserskillsControlfundingDefineBIvisionManageprogramsOrganizemethodologyleadershipBuildtechnologyblueprintEstablishstandardsBICCBusinessneeds9Copyright©2013-2014byTeradata.Allrightsreserved.分析数据来预测未来可能发生的事情过去事件的特征正在发生事件的趋势找出最佳措施、取得最优化的结果找出原因10Copyright©2013-2014byTeradata.Allrightsreserved.分析技能是基础，能整理所需的数据，能说服业务部门使用分析结果11Copyright©2013-2014byTeradata.Allrightsreserved.BI在IT架构中的位置SourceSystemsIntegratedInformationEnvironmentExternalaccessAcquisitionLayerIntegratedLayerDataProducersInformationConsumersDataGovernanceITGovernanceDataWarehouseGovernanceBIGovernanceAccessLayerIntegrationLayer(ETL/EAI,SOA)IntegrationLayer(ETL/EAI,SOA)TargetSystems12Copyright©2013-2014byTeradata.Allrightsreserved.13Copyright©2013-2014byTeradata.Allrightsreserve