经营分析系统的开发及应用

上海交通大学硕士学位论文经营分析系统的开发及应用姓名：孙晓健申请学位级别：硕士专业：计算机应用技术指导教师：李治柱2006100112006823BusinessIntelligence,BIBIBSSOLAPBIOLAP2005[]OLAP4AbstractInordertoimprovetheworkingefficiencyandservicequalityoftelecommunicationtrade,setupflexiblemarketingmechanism,adapttotheneedsofthenewproductdevelopmentandfiercemarketcompetition,thecommercialintelligence(BusinessIntelligence,hereafterreferredtoasBI)beginstoenterthetelecommunicationarea.TheapplicationofBIisalsocalledBusinessAnalysisSystemhereintelecommunicationarea..BusinessAnalysisSystem(hereafterreferredtoasBAS)putseachinformationisolatedislandinorder,whicharedistributedintheenterprise,suchasBSSsystem,Billsystem,NetsystemandVIPcustomersystem,byusingdatawarehousetool.WiththehelpofOLAPanddatamining.,BASdrawsoutthenumerousdatastoredinenterprisesforyearstodotheprocessingandanalyzingfromdifferentviewtopresentthesuperintendentstheinterestinginformationsinvariousways.Itrealizestheunifiedvisualgraphs,providestheunitedwaytogetdatafromtheprovincialcenterandraisestheeffienciesofstatisticsandanalysis,sothattheanalystscanpaymoreattentionstothedataanalysis.ThisarticlestudiesonthefollowingsixaspectsaroundthedevelopmentsandapplicationsonBASsystemoftelecommunication.First,tointroducethenecessitiesofbuildinguptheBASintelecommunicationenterprises,aswellas,thepresentsituationandthedevelopingtrendfortheBASapplicationsintelecommunicationareaallovertheworld.Second,tostudyaboutthemaintoolsusedinBIsystem,suchasdatawarehouse,OLAP,dataminingandetc.Thethird,tointroducethegeneraldesignthinkingonBASsystembytakingJiangsuTelecomasanexample.Theforth,tointroducethefunctionrealizationsofBAS.Thefifth,tointroducetherunningenvironmentofBAS.Finally,carriestotheconclusionanalysis,theelaborationsystemapplicationeffectsaswellasthepromotionfunctiontothemanagementsofJiangsuTelecomandetc.ThissystemhasalreadybedevelopedandputintoapplicationinJiangsuTelecom.In2005,theBASsystemwonthefirstprizeinthesamekindcomparingandassessingwithinChinaTelecomGroup.5[Keywords]BASDataWarehouseOLAPDataMining91.1WTOMOUARPU97IT101.2DataWarehouseOLAPOn-LineAnalyticalProcessingDataMining2003FranceTelecomAT&TVodafone10%SprintSBCMikeDDunesSBCSouthwesternBellAmeritechPacificBellSBCTelecomNevadaBellSNETCallularOneSBCInternet22DunesSBCNCR11LSISBCSBC11000101005010012TBSBC16Dunes1201.3OLAPOLAP122.1()DB(DataWarehousingDW)BI(On-LineAnalyticalProcessingOLAP)(DataMiningDM)2.2W.H.Inmon()132.2.12.12.1DWFig.2.1.DataStructureofDW--metadata14/DSS1)::,,::2),OLTP::15::2.2.21)2)(CDM)16E-RE-R12(FS-LDM)PS-LDM12345PDM17I/O12342.2.3ETL123182.2.4DW,DW1DWDW:DW1.2.3.4.5.2.2192.2Fig.2.2.DataWarehouse(DW)Model2DWDWDW3ETLExtractTransformLoading20InformaticaPowercenter2.3OLAP2.3.1OLAPOLAPOLAPOLAPOLAPOLAPOLAPStarSchemaSnowflakeSchemaOLAPOLAPCubeOLAPOLAP21OLAPOLAP{///}{///}{//}2.3.2OLAPE-RE-ROLAPOLAP{}222.3.3OLAPOLAPROLAPOLAPMOLAPOLAPHOLAPOLAPROLAPROLAPOLAPROLAPMOLAPMOLAPOLAPOLAPMOLAPHOLAPHOLAPROLAPMOLAPMOLAPHOLAPROLAPMOLAPROLAPMOLAPHOLAPOLAP2.3.4OLAPOLAP23[Han01]drill-uproll-upOLAPdrill-downsliceOLAPdicerotatepivotOLAP2.3.5OLAPOLAP()cognosimpromptutransformercubeppes24web2.42.4.1(DataMining)TB(KnowledgeDiscoveryinDatabase)2.4.22.312----345252.3Fig2.3DataMiningFlowChart2.4.3(classification)(Regression)(TimeSeries)26(associationanalysis)RakeshApwal(clustering)2.4.43BPHopfieldARTKoholon27-2.4.5CRISP-DMCRISP-DMCRoss-IndustryStandardProcessforDataMining1996SPSSNCRDaimler-Benz2000CRISP-DM1.0KdnuggetsClementine200287)b)c)d)DataUnderstandinge)f)g)h)DataPreparation29i)/j)k)l)m)(Modeling)DatadescriptionandsummarizationSegmentation(Conceptdescriptions)(Classification)Prediction(Dependencyanalysis)n)o)p)q)(Evaluation)r)s)t)(Deployment)30u)v)w)x)2.4.62.5OLAP313.13.1100003.1Fig3.1TheBusinessAnalysisSystem.ITCTG-MBOSS323.2OABSS333.33.23.2Fig3.2TheBusinessAnalysisSystem.FrameofJiangsuTelecom343.3.13.2ETLCube3.3.23.23.3.33.2353.3.43.23.43.4.1363.4.23.4.33.53.5373.5Fig3.5TheTechnical.FrameoftheBusinessAnalysisSystem3.5.1ETLETLETLETLETLETLETL3.5.2/383.5.3OLAPWEBOA3.5.43.6394.14.1KPIKPI4.1Fig4.1FunctionoftheBusinessAnalysisSystemKPIKPI404.2OLAPHTMLXML/XSLURLURL414.34.3.1KPIKeyPerformanceIndicatorsKPI(4.1)4.1KPIFig4.1KPITarget4.3.2142OLAPOLAP(4.2)4.2Fig4.2PolyhedralAnalysisList434.3()()()()SQL…SQL…()()()()()()()()()()()()()()()()()()()()()()()()4.3Fig4.3ThemeAnalysisModel24.4Fig4.4ListoftheThemeAnalysis44/1ARPUMOUARPUMOUARPU23/445531)2)3)4)1)2)/3)4)1)2)3)464)1)/2)ARPU1)2)/////47154.3.31)2)4.5Fig4.5SpecialTitleAnalysisModel4.4484.4.11234.4.24.6Fig4.6DataAnalysisFlowchart491.2.3.4.505.6.4.7Fig4.7ManualAssignationModel1.2.3.4.515.4.8Fig4.4.8Auto-assignationModel524.9Fig4.9FlowCharofCheckingandAssessing4.4.3534.54.5.14.5.24.5.3544.5.44.5.54.5.64.64.6.1ETL()()551.2.3.ETLETLETLETL4.5.566.ETL4.6.257EIS()ETL58ETL594.74.7.1604.7.24.1Table4.1ListofDataResourceSystems1000010000614.104.10Fig4.10FlowChartofDataGathering4.7.3/62TCP/IPFTPETLETL4.7.463telejyfxtelejyfxtelejyfx4.7.54.2T