欢迎来到天天文库
浏览记录
ID:14356178
大小:3.19 MB
页数:65页
时间:2018-07-28
《building business intelligence and data mining applications with microsoft sql server 2005》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、BuildingBusinessIntelligenceandDataMiningApplicationswithMicrosoftSQLServer2005Introductions∑Presenter–JavierLoria–SolidQualityLearning–javier@solidqualitylearning.comAgenda∑Overview&BIChallenges∑IntroducingtheUDM∑TheUDMinDetail∑DataMiningOverviewAgenda∑Overview&BIChallenges∑IntroducingtheUDM∑TheUD
2、MinDetail∑DataMiningOverviewBusinessIntelligencePlatformIntegrateIntegrateAnalyzeAnalyzeReportReportòDataacquisitionòDataenrichment,òDatapresentationfromsourcewithbusinessanddistributionsystemsandlogic,hierarchicalòDataaccessforintegrationviewsthemassesòDatatransformationòDatadiscoveryviaandsynthes
3、isdataminingOverview∑Gettinginformationfromenterprisedata∑UsingBIacrosstheenterpriseasanintegralpartofdoingbusiness∑Captureandmodelallofyourdata∑Integrationwithbusinessprocesses∑RelationalreportingandOLAPconvergedthroughasingledimensionalmodelBusinessIntelligenceChallenges∑MultipleDataModels∑Multip
4、leDataSources∑MultipleAPIs∑DuplicationofDataWhatIsaCube?AtlantaensionChicagoimDDenverGrapestCherriescMarketsduionDallasMelonsosApplesrPimenDQ1Q2Q3Q4TimeDimensionWhatIsaCube?EnterpriseBITodayEnterpriseBITodayDataSourcesDataModelsToolsMOLAPOLAPBrowserMOLAPDatamartReportingTool(1)DatamartReportingTool
5、(2)DWReportingTool(3)Relationalvs.OLAPReportsRelationalvs.OLAPReportsFeatureRelationalOLAPFlexibleschemaVURealtimedataaccessVUSingledatastoreVUSimplemanagementVUDetailreportingVUHighperformanceUVEnd-userorientedUVEaseofnavigationandUVexplorationRichanalyticsUVRichsemanticsUVAgenda∑∑∑Overview&BIChal
6、lengesOverview&BIChallengesOverview&BIChallenges∑IntroducingtheUDM∑TheUDMinDetail∑DataMiningOverviewTheUnifiedDimensionalModelTheUnifiedDimensionalModelTheBestofRelationalandOLAPTheBestofRelationalandOLAPRelationalReportingOLAPCubes∑Multiplefacttables∑Multidimensionalnavigation∑Hierarchicalpresenta
7、tion∑Fullrichnessthe∑Friendlyentitynamesdimensions’attributes∑PowerfulMDXcalculations∑Transactionlevelaccess∑CentralKPIframework∑Star,snowflake,3NF…∑Multipleperspectives∑Complexrelationships∑Partitions∑Recu
此文档下载收益归作者所有