solid quality - building business intelligence and data mining applications with microsoft sql server 2005

《solid quality - 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&BIChal

2、lenges∑IntroducingtheUDM∑TheUDMinDetail∑DataMiningOverviewBusinessIntelligencePlatformIntegrateIntegrateAnalyzeAnalyzeReportReportòDataacquisitionòDataenrichment,òDatapresentationfromsourcewithbusinessanddistributionsystemsandlogic,hierarchicalòDataaccessforintegration

3、viewsthemassesòDatatransformationòDatadiscoveryviaandsynthesisdataminingOverview∑Gettinginformationfromenterprisedata∑UsingBIacrosstheenterpriseasanintegralpartofdoingbusiness∑Captureandmodelallofyourdata∑Integrationwithbusinessprocesses∑RelationalreportingandOLAPconve

4、rgedthroughasingledimensionalmodelBusinessIntelligenceChallenges∑MultipleDataModels∑MultipleDataSources∑MultipleAPIs∑DuplicationofDataWhatIsaCube?AtlantaensionChicagoimDDenverGrapestCherriescMarketsduionDallasMelonsosApplesrPimenDQ1Q2Q3Q4TimeDimensionWhatIsaCube?Enterp

5、riseBITodayEnterpriseBITodayDataSourcesDataModelsToolsMOLAPOLAPBrowserMOLAPDatamartReportingTool(1)DatamartReportingTool(2)DWReportingTool(3)Relationalvs.OLAPReportsRelationalvs.OLAPReportsFeatureRelationalOLAPFlexibleschemaVURealtimedataaccessVUSingledatastoreVUSimple

6、managementVUDetailreportingVUHighperformanceUVEnd-userorientedUVEaseofnavigationandUVexplorationRichanalyticsUVRichsemanticsUVAgenda∑∑∑Overview&BIChallengesOverview&BIChallengesOverview&BIChallenges∑IntroducingtheUDM∑TheUDMinDetail∑DataMiningOverviewTheUnifiedDimension

7、alModelTheUnifiedDimensionalModelTheBestofRelationalandOLAPTheBestofRelationalandOLAPRelationalReportingOLAPCubes∑Multiplefacttables∑Multidimensionalnavigation∑Hierarchicalpresentation∑Fullrichnessthe∑Friendlyentitynamesdimensions’attributes∑PowerfulMDXcalculations∑Tra

8、nsactionlevelaccess∑CentralKPIframework∑Star,snowflake,3NF…∑Multipleperspectives∑Complexrelationships∑Partitions∑Recu