EDW in Volkswagen Financial Service

VOLKSWAGENFINANCIALSERVICESAGProcesscontroltakentothenextlevelEnterprisedatawarehousingatVolkswagenFinancialServicesAGDüsseldorf,20thOctober2005I-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDistributionApplicationsReportingPlanningAggregationEnhancementConsolidationDataversioningExtractionLoadingI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDistributionApplicationsReportingPlanningAggregationDataversioningExtractionLoadingControllingI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDistributionApplicationsReportingPlanningAggregationEnhancementConsolidationDataversioningExtractionLoadingCarfinanceControllingI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDistributionApplicationsReportingPlanningAggregationEnhancementConsolidationDataversioningExtractionLoadingCarFinanceDirectBankingControllingI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDistributionApplicationsReportingPlanningAggregationEnhancementConsolidationDataversioningExtractionLoadingCarFinanceLeasingDirectBankingControllingI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDistributionApplicationsReportingPlanningAggregationEnhancementConsolidationDataversioningExtractionLoadingCarFinanceControllingLeasingRegulatoryReportingDirectBankingI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDistributionApplicationsReportingPlanningAggregationEnhancementConsolidationDataversioningExtractionLoadingCRM/MarketingCarFinanceControllingLeasingRegulatoryReportingDirectBankingFleetCustomers...I-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelTheModusOperandiƒCentralizedqualityassuranceandtransportmanagementƒReleasemanagementƒStrongnaminganddevelopmentconventionsƒDataconsolidationusingancorporatewideEnterpriseDataWarehouseƒKeepingtrackofversionsofdataatcentralinflowarea(OperationalDataStore)I-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelTheModusOperandiDevelopmentTestConsolidationProductionCenterofCompetenceƒConsulttheprojectduringdesignphaseƒPerformqualityassurancebeforeFBTtransportCentralizedTransportManagementƒHandletransportrequestsintofollowingsystemsregardingreleasephasesCenterofCompetenceƒProvidetestconceptsandguidanceduringtestƒApprovedevelopmenttobereleasedwithinpre-definedreleasesI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelArchitectureHostInfoMartInfoSourceEnterpriseDataWarehouseExcelUKSAPSystemsOracle´DBMasterdataPlanningAreaEXCELCRMCOPortalWebΣ%+−OperationalDatastoreHistori-sationDynprosI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelDetails:DataflowEDWHe.g.:customer-totalliabilitiesInfoMartODSLayeractualdatahistoricdataProjectspecificdatastorageProjectspecificreportingDataconsolidationUpdaterulesUpdaterulesBWdatabasisƒbasedonbusinessrequirementsƒCentralcoordinationanddevelopmentUpdaterulesI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelEnhancedlevelAutomaticWarehousinginaproductivesystemƒcustomizenumberrangebufferƒdeleteallPSA-tables(ChangeLog)aftertimeframeƒcalculatedatabasestatistics/rebuildindicesƒhistorisationofalltransformationrulesI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelVersioncontrolforTransferrulesDataSourcePSAsourcesystemTransferrulesextractorDataSource(transferstructure)InfoSource(Communicationstructure)ODSInfoCubeUpdaterulesVirtualExitQueryChangingextractorChangingDataSourcestructureChangingVirtualcharacteristics/keyfiguresChangeQueryresult(VariableExit)ChangingInfoProviderChangingUpdaterulesChangingInfoSourcestructureChangingTransferrulesScopeI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelAttheendthisapproachleadsto...…BasicDataWarehousing…higheffortstobuildtheinfrastructurefortheWarehouse…single“applicationserver–approach”leadstolimitedcapabilitiestocontroltheassignmentofresourcestoprocesses…theneedtorealizemorequickwins/smartsolutionsinordertojustifyinvestmentsintheinfrastructuresetupI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelWheredoweneedtogo?ƒDecreasetimetomarketforourBIsolutions9continuouslystandardizedevelopmentprocessesƒProvideservicesforotherapplications9Offermasterdataconsolidation9Haveanopenandexpandablearchitecture9BIplatformasanintegratedkeycomponentoffinancialprocessesIntelligencefortheMasses!I-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelstepstothenextlevelI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelIntelligenceServicesMarketingnoteMarketingnoteCustomervalueLiabilityLiabilityLimitsLimitsMasterdataMasterdataCustomerdefaultCustomerdefaultI-SEB|RFE,ABO|20.10.2005VOLKSWAGENFINANCIALSERVICESAG...takentothenextlevelEachprocessneedsperformanceLogongroupProductiveDatabaseNearlineStorageHighPerformanceAnalyticsPrio1LoadingprocessesStandard-reportingHighEndApplic