ibm数据仓库与数据重整（英）.PPT

《ibm数据仓库与数据重整（英）.PPT》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Dr.PaulF.WilmsWorldwideDataManagementSales&TechnicalSupportDataWarehousing&DataRe-engineeringfortheBF&SIndustryDBWILMS@US.IBM.COMWhyBuildaDataWarehouse?BusinessRequirementsStepstowardaSuccessfulImplementationDataRe-engineering--UnlockthePoweroutofyourDataDataTransformationsDataCleansingPreparingth

2、eDataforMulti-dimensionalAnalysisStarSchemaRepresentationAutomatingtheDataWarehousingProcessSchedulingoftheDataWarehousePopulationMonitoringtheDataWarehouseActivityMetadata-TheDataWarehouseCornerstoneDatatoInformationProcessMetadataModelsMetadataMiningMetadataInterchangeDatamartsvsEnterprise-wideD

3、ataWarehousesCompetitivedifferentiatorsofIBMDataWarehouseSolutionAgendaWhyBuildaDataWarehouse?BusinessRequirementsStepstowardaSuccessfulImplementationDataRe-engineering--UnlockthePowerofyourDataPreparingtheDataforMulti-dimensionalAnalysisAutomatingtheDataWarehousingProcessMetadata--TheDataWarehous

4、eCornerstoneDatamartsvsEnterprise-wideDataWarehousesCompetitivedifferentiatorsofIBMDataWarehouseAgendaBusinessRequirementsfortheBF&SIndustryOpportunityquestionsforDataWarehouseWhichcustomersaremostlikelytodefecttoacompetitor?Whoareyourmostprofitablecustomers?Whatproductsdothemostprofitablecustomer

5、suse?Whatisthecreditriskforaparticularhousehold?Howriskadverseareparticularsegments,andwhy?Whichadditionalproductsisacustomerlikelytobuy?Whichbranchesshouldbeconsolidatedineachgeography?RiskManagementExampleNeed:singleviewofcustomerdatadetailedpaymenthistory(36months)--->seelifestylechangesacquire

6、newcustomersthatmatchgoodprofilehistorydataBusinessBenefitslowerriskexposuremorecrosssellingopportunitiesaccurateinfoleadstohigheracceptancerate&morerevenueBottomLine:Lossreductionof1.0%ona$5billioncreditbase=$50MDataWarehouseNeed--BankingIndustryExampleRetailBankingTransactionDataCreditCardHi

7、storyDataCustomerDataDataWarehousingSystemDataWarehouse2297-6643CreditCardUsageNeed:identifycustomerswhodoNOTusetheirVISAcard--->becausethebankpays$2percardpermonthtoVISAfortheuseoftheirlogoandservicesHowmanype