Business Objects BI 培训教程

DataWarehousing:TalesfromtheTrenchesDataWarehousing:TalesfromtheTrenchesAlanSimonVicePresidentGlobalDataWarehousingServicesPracticeConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide2Unilever-ProfileThelargestconsumerpackagedgoodsmanufacturerintheworld,withoperationsin94countries,distributioninmore,anddealingin75currenciesdaily.WellknownhouseholdfavoritesincludingPersil,Knorr,Hellmann’s,Lipton,andDoveCompanyFacts:ƒLargestConsumerPackagedGoodsManufacturerƒOperationsin94countriesƒDistributioninmanymoreƒDealsin75currenciesdailyƒEmploys250,000peopleworldwideConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide3UnileverInformationProgram-BeforeOpCoBG3PUDRSupplyChainBrandScanGlobalCustomersFinanceUIP-CDWRequireslargemanualeffort,notsustainableovertime300+eachmonthConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide4UnileverInformationProgram-AfterOpCoBG3PUDRSupplyChainBrandScanGlobalCustomersFinanceUIP-CDWBusinessObjectsDataIntegratorConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide5DeltaDentalHoldingCompany-ProfileOffersafulllineofmanagedpreferredproviderorganization(PPO),dentalhealthmaintenanceorganization(DHMO)andUsual,CustomaryandReasonable(UCR)programsCompaniesincludeDeltaDentalofCalifornia,DeltaDentalofPennsylvania,PrivateMedicalInsuranceandDeltaDentalInsuranceCompanyCompanyFacts:ƒProcesses25millionclaimsannuallyƒCovers249,000dentistlocationsnationwideƒ$4billionrevenueConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide6DeltaDental–InfrastructureChallengeDeltaDentalofPennsylvaniaPMIDeltaDentalofCaliforniaDeltaDentalInsuranceCompaniesOS/400MVS-ESAHP-UXMSWindowsConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide7DDICPAPMICAEnterpriseDataWarehouse(future)Fraud&AbuseEntitySourceTypeSubjectAreaMartsDataManagementBusinessIntelligencePlatform/BusinessObjectsCrystalTransformationsMainframeWintelMainframeAS/400HP-UXMainframeRawCopyDIOracleSQLServerDB2FLATFILEFLATFILEFLATFILEStagingAreaDIDeltaDental–EnvironmentTodayDI=BusinessObjectsDataIntegratorConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide8CharterManufacturingProfile:ƒManufactureshigh-qualitysteelandsteelcomponentsƒFull-servicesupplierofengineeredcomponentsfortheautomotiveindustryDaimlerChrysler,FordMotorCompanyandGeneralMotorsBusinessPains:ƒDataredundancycausedChartertoovershootsalesforecastresultinginsignificantlossforthecompanyƒOracledatabasessupportERPsystem.SQLdatabasessupportmanufacturingsystems.NodataqualityassuranceordatawarehousingsolutionforBIinitiatives.KeyDrivers:ƒSimplifyandautomatedataextractionfromdiversedatasourcesƒNeededaneasywaytoviewdatalineageacrosstheirentireBIdeploymentConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide9CharterManufacturingWhyBusinessObjects:ƒFunctionalityandtheeaseofuseƒShortlearningcurveƒAbilitytotracebacktothesourcedirectlyfromthereportsƒForexample:toviewandverifytheunderlyingsourcedata,userssimplyclickonresultswithinareport.ƒEndtoendsolution–oncedatawarehouseiscomplete,movingtoperformancemanagementandwantedasingleplatformResults:ƒFinallyhaveasingle,reliableviewoftheirbusinessƒLoweredcostofownershipbyeliminatingmultipletoolsandselectingETLthatmetrequirementsbutalsointegratedwithprevious(andfutureplanned)investmentsConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide10DataWarehousingLessonsfromtheRealWorldTreateveryDWasa“realsystem”ƒPerformancetesting,capacityplanning,robustexceptionhandling…allthisandmuchmore!ƒDatawarehousingisn’tjust“abunchofboxes,lines,andarrows!”“InspectorGeneral”stylearchitectureanddesignwalkthroughsƒContinuallyaskthequestion:“Whatcouldgowronghere?”followedby“…andhowshouldwedealwiththat?”ƒContingencyplanningbuiltintoprojectplanningSelectiveandappropriateusageofemergingtechnologiesƒMobiletechnologies,Service-OrientedArchitecture/WebServices,advanceddatabasemanagement,etc.BusinessObjectsDataIntegrationBusinessObjectsDataIntegrationPhilipOnSr.ProductMarketingManagerConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide12HowToDeliverTrustedInformation?StandardizeononevendorforyourdataintegrationandBItechnologiesDataQualityFirewallTrustedInformationRealTimeETLEngineBatchDataIntegrationBusinessIntelligenceDatabasesDataWarehousePerformanceManagementReportingQueryandAnalysisMetadataImpactAnalysisDataLineageEnterpriseApplicationsLegacyConfidentialandproprietary.Copyright©2004BusinessObjectsS.A.Allrightsreserved.Slide13BusinessObjectsDataIntegrationProductsDeliveraccurate,timely,andtrustedinformationBusinessObjects™DataIntegratorƒProvidestrustedinformationƒMaximizesdeveloperproductivityƒDeliverseXtremeETLscalabilityBusinessObjectsRapidMartsƒPrebuiltdataintegrationsolutionforSAP,Oracle(PeopleSoft,J.D.Edwards),andSiebelapplicationsƒAcceleratetimetoinformationConfidentialandproprietary.Copyright©2004Bu