微软商业智能解决方案

MicrosoftBI

Overview2022/11/101

MicrosoftBI

Overview2022/11MicrosoftBIStrategyandVisionMicrosoftBIPlatformMicrosoftSQLServer2005OfficeSystem2007PerformancePointServer2007BIDevelopmentMicrosoftBIFuture22022/11/10AgendaMicrosoftBIStrategyandVisiBIEcosystemAcrosstheenterpriseBIApplicationsBIPlatformDevelopment

ToolsMicrosoftBusinessIntelligence2022/11/10BIEcosystemAcrosstheenterpPersonalBITeamBIOrganizationalBIBICapabilitiesToCustomersBIContinuumEmpoweredAlignedMyContextImmediate,contentcreatedbymeforme,looselycoupledtotheteamcontext,it’sadocumentintheend…OurContextBIContentmanagedbyaserver,teamcontextwithloosecouplingtotheorganizationanditsgoalsandobjectivesTheOrganization’sContextEstablishescorp.contextforpersonalandteamBI,contentisabstractedandreusable,highscalabilityandsecurity,

businessprocesscentric2022/11/104PersonalBITeamBIOrganizatioScorecardsPlanningAuthoringConsolidationReportsAdhocQueryDashboardsAnalysisDataIntegrationStorageAnalyticsDataManagementBIUsageAreaStrategicValueSoundDataPersonalandTeamInsightCorporateDecisionsPlatformApplications2022/11/105ScorecardsPlanningAuthoringConMSBIStrategyandVisionToimproveorganizationsbyprovidingbusinessinsightstoallemployees,leadingtobetter,faster,morerelevant

decisionsMicrosofthasalong-termcommitmenttodeliveringacompleteandintegratedBIofferingSQLServerhasledinnovationintheBIspaceformorethanadecadeThereiswidespreaddeliveryofintelligencethroughMicrosoftOfficeTheplatformsareenterprise-gradeandaffordable62022/11/10MSBIStrategyandVisionToim7DeliveringValueToBICustomerApplicationDevelopersBusiness

InformationWorkersITProfessionalsStakeholdersCorporateDevelopersISVDevelopersSIDevelopersAnalystsInformationWorkersSeniorExecutives/ManagementDatabaseAdministratorsApplicationArchitectsCIOs,CTOsKeyChallengesMultipledevelopmenttoolsand

languagesInteroperabilityissuesbetweenapplicationsInabilitytoaccessdataacrossmultipleplatformsHardtofindandaccessrightdataHardtoanalyzeandactoninsightsRelianceonITforaccessandanalysisCostlymanagementofITsystemsAvailabilityofBIapplicationsInabilitytoleverageITinvestmentsMicrosoftBICapabilitiesIntegrateddevelopmentenvironmentthrough

VisualStudioExtensibilityusing.NETandXMLFind,shareandcollaborateviaSharePointUseOfficetoanalyzeandvisualizedataSimplifymanagementofintegratedBIinfrastructureBestoverallvalue2022/11/107DeliveringValueToBICustomBIPlatform(SQL)End-userTools(Office)AnalyticApplications(OfficeBusinessApplications)MSBIFramework2022/11/108BIPlatformEnd-userToolsAnalyMicrosoftBIStrategyandVisionMicrosoftBIPlatformMicrosoftSQLServer2005OfficeSystem2007PerformancePointServer2007BIDevelopmentMicrosoftBIFuture92022/11/10AgendaMicrosoftBIStrategyandVisiDataPlatformInformationWorkerPlatformMicrosoftBIPlatformIntegrationPerformance

ManagementEnterpriseGradePervasiveIntegratedFlexibleFullFeaturedInteroperableExtensiblePowerfulCostEffectiveFastTime-to-MarketChoiceofIntegrationPointsIntegratedBISolution102022/11/10DataPlatformInformationWorkeBIPlatform--SQLServer2005DataacquisitionfromsourcesystemsandintegrationDatatransformation

andsynthesisDataenrichment,

withbusinesslogic,hierarchicalviewsDatadiscoveryviadataminingDatapresentationanddistributionDataaccessfor

themassesIntegrateAnalyzeReport112022/11/10BIPlatform--SQLServer2005DaSQLServer2005BIMissionCriticalBIInfrastructureIntegrateEnterpriseETLplatformOut-of-theboxtransformationsAnalyzeUnifiedDimensionalModelEnhanceddataminingandproactivecachingReportRichenduserreporting(ReportBuilder)ReportcontrolsRapidBIApplicationsDevelopmentBIDevelopmentstudioTightintegrationwithVisualStudioWebServicesEnterpriseClassPerformanceReliabilityandScalabilityPartitioningExtensible.NETFrameworkandXMLDataintegrationScenarioExamplesEmbedding“intelligence”intoLOBapplications24x7“MissionCritical”BIPredictiveanalyticsSelf-ServiceandProductionReporting2022/11/1012SQLServer2005BIMissionCritEnterpriseETLplatformHighperformanceHighscaleMoretrustworthyandreliableBestinclassusabilityRichdevelopmentenvironmentSourcecontrolVisualdebuggingofcontrol

flowanddataGreatrangeoftransforms

out-of-the-boxHighlyextensibleCustomtasksCustomenumerationsCustomtransformationsCustomdatasources2022/11/1013SQLServerIntegrationServiceEnterpriseETLplatform2022/11UnifiedDimensionalModelIntegratingrelationalandOLAPviewsPro-activecachingBringingthebestofMOLAPtoROLAPAdvancedBusinessIntelligenceKPIs,MDXscripts,translations,currency…WebservicesNativeXML/ADataMiningintheplatformDecisionTreesClusteringTimeSeriesSequenceClusteringAssociationNaïveBayesNeuralNetIntroducedinSQLServer20002022/11/1014SQLServerAnalysisServicesUnifiedDimensionalModelDecisReportingServicesOpen,extensibleenterprisereportingsolutionReportauthoring,

management,deliveryOfficeSystemintegrationVS.NETdevelopmentenvironmentSQLServer2005enhancementsIntegrationwithAS,IS,management

toolsDeveloperenhancementsImprovedreportinteractivityRichend-userreportingReportBuilderExtendingtheReach

ofReportingServicesAdhocReportingfor

theEnd-User2022/11/1015SQLServerReportingServicesReportingServices2022/11/1015EndUserClientOfficeSystem20072007MicrosoftOfficeSystemMicrosoftExcel2007MicrosoftOfficeSharePointServer2007162022/11/10EndUserClientOfficeSystemMicrosoftExcel2007Thecorespreadsheetcapabilitieshavebeendramaticallyenhancedtoenableduserstoanalyze,communicate,andmanageinformationProvidesfullsupportforMicrosoftSQLServer2005AnalysisServicesNewservertechnologyforsecureandcontrolledsharingofspreadsheetsPublishspreadsheetstoSharePointdocumentlibrariesMaintaina“singleversionofthetruth”whilestillsharingspreadsheetsProtectconfidentialandproprietaryinformation2022/11/1017MicrosoftExcel2007ThecoresAnalyzedatainExcelPublishspreadsheetsanddocumentstoSharePoint

Reusespreadsheets,reports,anddocumentsindashboardsandbusinessapplicationsAccessandexploredatainspreadsheets,reports,anddocumentsinthePortalBestwithSQLServerBusinessIntelligencewithOffice“12”2022/11/1018Office2007BIFeaturesAnalyzedatainExcelPublishsAcomplete,integratedtoolforthedevelopmentofBIapplicationsOnetool,multipletechnologies:Relational,OLAP,DM,SSIS,

Reporting,Code,Webpages…Enterprisesoftware

developmentenvironment:IntegratedintoVisualStudio.NETTeamdevelopment,sourcecontrol,

versioning,developerisolation,

resourceindependentcodingDevelopmentcyclelifetimesupportDevelop,Test,Deploy,Modify,Test…Breakthrougheaseofuse2022/11/1019Acomplete,integratedtoolfoManagescontentandbusinessprocessesImprovesbusinessinsightPresentbusiness-criticalinformationinonecentrallocationCentralizedReportCentersitesgiveusersasingleplacetofindthelatestspreadsheets,reports,orKPIsSharebusinessdatabroadlywhilehelpingtoprotectsensitiveinformationExcelServicesrunningonOfficeSharePointServer2007providesaccesstodataandanalyticsinreal-time,interactiveMicrosoftOfficeExcelspreadsheetsfromaWebbrowserSimplifiesinternalandexternalcollaboration2022/11/1020SharePoint2007ManagescontentandbusinesspWhydidithappen?AnalyticsWhathappened?ReportingWhatwillhappen?

ForecastingWhatdoIwanttohappen?Planning,Budgeting,

ConsolidationWhatishappening?ScorecardsandDashboardsPerformanceManagement2022/11/1021Whydidithappen?WhathappeneMicrosoftPerformancePointServer2007Acompleteandintegratedperformance-managementapplicationthatincludes:Monitoring:AdvancedScorecardsAnalytics:NextgenerationofProClaritytechnologyPlanning:Biz#apowerfulenvironmentforbudgeting,andforecastingthattargetsbusinessusersEnablescompaniestomoreeffectivelyplanandmanagetheirbusiness2022/11/1022MicrosoftPerformancePointSeAcomplete,integratedtoolforthedevelopmentofBIapplicationsOnetool,multipletechnologies:Relational,OLAP,DM,SSIS,

Reporting,Code,Webpages…Enterprisesoftware

developmentenvironment:IntegratedintoVisualStudio.NETTeamdevelopment,sourcecontrol,

versioning,developerisolation,

resourceindependentcodingDevelopmentcyclelifetimesupportDevelop,Test,Deploy,Modify,Test…Breakthrougheaseofuse2022/11/1023BIDevelopment--BIDSAcomplete,integratedtoolfoIntegratedenvironmentforaccessing,configuring,managing,administering,anddevelopingallcomponentsofSQLServerSupportsmostadministrationtasksCanregister,explore,configure,andqueryserverinstances:DatabaseEngineAnalysisServicesReportingServicesSQLServerMobileIntegrationServicesNotificationServicesCanscriptmanyoftheservices’objects2022/11/1024BIDevelopment--SSMSIntegratedenvironmentforaccSQLServer2005BusinessIntelligenceAnalysisServicesOLAP&DataMiningIntegrationServicesETLSQLServerRelationalEngineReportingServicesManagementToolsDevelopmentTools2022/11/1025SQLServer2005BusinessIntelMicrosoftBIFunctionalityMappingSQLServerRDBMSSQLServerIntegrationServices/Replication/BizTalkServerAnalysisServicesAnalysisServicesReportingServicesExcel,OWC,ProclaritySharePointPerformancePointServerSSABIDataWarehouse/MartExtract,Transform,&LoadOLAPDataMiningManagedReportingClientAnalysisToolsPortalCorporatePerformanceDataMartTemplatesAlertsNotificationServicesCustomDevelopment–VisualStudio.NetOperationsManagement–MOMPartnerSolutions2022/11/1026MicrosoftBIFunctionalityMap2022/11/1027MS

BISDM2022/11/1027MSBISDMMicrosoftBIStrategyandVisionMicrosoftBIPlatformMicrosoftSQLServer2005OfficeSystem2007PerformancePointServer2007BIDevelopmentMicrosoftBIFuture282022/11/10AgendaMicrosoftBIStrategyandVisiMS

BIRoadmapSQL7.0YukonEnterthegameLowendmarketplayCaptureindustryAPIMindshareFocusonTCOFocusondistributionSQL2000WinLeadershipFeaturecompletePenetratetheEnterpriseThoughtleadershipScaleFocusonrevenueRedefinetheMarketOffice2007PPS2007Katmail2022/11/1029DGTMSBIRoadmapSQL7.0YukonEnterENDUSERTOOLS&PERFORMANCEMANAGEMENTAPPSExcelPerformancePointServerBIPLATFORMSQLServerReportingServicesSQLServerAnalysisServicesSQLServerDBMSSQLServerIntegrationServicesSharePointServerSEARCHDELIVERYReportsDashboardsExcelWorkbooksAnalyticViewsScorecardsPlansCONTENTMANAGEMENTCOLLABORATION2022/11/1030MS

BIFutureVisionENDUSERTOOLS&PERFORMANCEM2022/11/10DGT31Let’smake

thingsbetterLetourcustomersfeel

newspace2022/11/10DGT31Let’smakethin

MicrosoftBI

Overview2022/11/1032

MicrosoftBI

Overview2022/11MicrosoftBIStrategyandVisionMicrosoftBIPlatformMicrosoftSQLServer2005OfficeSystem2007PerformancePointServer2007BIDevelopmentMicrosoftBIFuture332022/11/10AgendaMicrosoftBIStrategyandVisiBIEcosystemAcrosstheenterpriseBIApplicationsBIPlatformDevelopment

ToolsMicrosoftBusinessIntelligence2022/11/10BIEcosystemAcrosstheenterpPersonalBITeamBIOrganizationalBIBICapabilitiesToCustomersBIContinuumEmpoweredAlignedMyContextImmediate,contentcreatedbymeforme,looselycoupledtotheteamcontext,it’sadocumentintheend…OurContextBIContentmanagedbyaserver,teamcontextwithloosecouplingtotheorganizationanditsgoalsandobjectivesTheOrganization’sContextEstablishescorp.contextforpersonalandteamBI,contentisabstractedandreusable,highscalabilityandsecurity,

businessprocesscentric2022/11/1035PersonalBITeamBIOrganizatioScorecardsPlanningAuthoringConsolidationReportsAdhocQueryDashboardsAnalysisDataIntegrationStorageAnalyticsDataManagementBIUsageAreaStrategicValueSoundDataPersonalandTeamInsightCorporateDecisionsPlatformApplications2022/11/1036ScorecardsPlanningAuthoringConMSBIStrategyandVisionToimproveorganizationsbyprovidingbusinessinsightstoallemployees,leadingtobetter,faster,morerelevant

decisionsMicrosofthasalong-termcommitmenttodeliveringacompleteandintegratedBIofferingSQLServerhasledinnovationintheBIspaceformorethanadecadeThereiswidespreaddeliveryofintelligencethroughMicrosoftOfficeTheplatformsareenterprise-gradeandaffordable372022/11/10MSBIStrategyandVisionToim38DeliveringValueToBICustomerApplicationDevelopersBusiness

InformationWorkersITProfessionalsStakeholdersCorporateDevelopersISVDevelopersSIDevelopersAnalystsInformationWorkersSeniorExecutives/ManagementDatabaseAdministratorsApplicationArchitectsCIOs,CTOsKeyChallengesMultipledevelopmenttoolsand

languagesInteroperabilityissuesbetweenapplicationsInabilitytoaccessdataacrossmultipleplatformsHardtofindandaccessrightdataHardtoanalyzeandactoninsightsRelianceonITforaccessandanalysisCostlymanagementofITsystemsAvailabilityofBIapplicationsInabilitytoleverageITinvestmentsMicrosoftBICapabilitiesIntegrateddevelopmentenvironmentthrough

VisualStudioExtensibilityusing.NETandXMLFind,shareandcollaborateviaSharePointUseOfficetoanalyzeandvisualizedataSimplifymanagementofintegratedBIinfrastructureBestoverallvalue2022/11/107DeliveringValueToBICustomBIPlatform(SQL)End-userTools(Office)AnalyticApplications(OfficeBusinessApplications)MSBIFramework2022/11/1039BIPlatformEnd-userToolsAnalyMicrosoftBIStrategyandVisionMicrosoftBIPlatformMicrosoftSQLServer2005OfficeSystem2007PerformancePointServer2007BIDevelopmentMicrosoftBIFuture402022/11/10AgendaMicrosoftBIStrategyandVisiDataPlatformInformationWorkerPlatformMicrosoftBIPlatformIntegrationPerformance

ManagementEnterpriseGradePervasiveIntegratedFlexibleFullFeaturedInteroperableExtensiblePowerfulCostEffectiveFastTime-to-MarketChoiceofIntegrationPointsIntegratedBISolution412022/11/10DataPlatformInformationWorkeBIPlatform--SQLServer2005DataacquisitionfromsourcesystemsandintegrationDatatransformation

andsynthesisDataenrichment,

withbusinesslogic,hierarchicalviewsDatadiscoveryviadataminingDatapresentationanddistributionDataaccessfor

themassesIntegrateAnalyzeReport422022/11/10BIPlatform--SQLServer2005DaSQLServer2005BIMissionCriticalBIInfrastructureIntegrateEnterpriseETLplatformOut-of-theboxtransformationsAnalyzeUnifiedDimensionalModelEnhanceddataminingandproactivecachingReportRichenduserreporting(ReportBuilder)ReportcontrolsRapidBIApplicationsDevelopmentBIDevelopmentstudioTightintegrationwithVisualStudioWebServicesEnterpriseClassPerformanceReliabilityandScalabilityPartitioningExtensible.NETFrameworkandXMLDataintegrationScenarioExamplesEmbedding“intelligence”intoLOBapplications24x7“MissionCritical”BIPredictiveanalyticsSelf-ServiceandProductionReporting2022/11/1043SQLServer2005BIMissionCritEnterpriseETLplatformHighperformanceHighscaleMoretrustworthyandreliableBestinclassusabilityRichdevelopmentenvironmentSourcecontrolVisualdebuggingofcontrol

flowanddataGreatrangeoftransforms

out-of-the-boxHighlyextensibleCustomtasksCustomenumerationsCustomtransformationsCustomdatasources2022/11/1044SQLServerIntegrationServiceEnterpriseETLplatform2022/11UnifiedDimensionalModelIntegratingrelationalandOLAPviewsPro-activecachingBringingthebestofMOLAPtoROLAPAdvancedBusinessIntelligenceKPIs,MDXscripts,translations,currency…WebservicesNativeXML/ADataMiningintheplatformDecisionTreesClusteringTimeSeriesSequenceClusteringAssociationNaïveBayesNeuralNetIntroducedinSQLServer20002022/11/1045SQLServerAnalysisServicesUnifiedDimensionalModelDecisReportingServicesOpen,extensibleenterprisereportingsolutionReportauthoring,

management,deliveryOfficeSystemintegrationVS.NETdevelopmentenvironmentSQLServer2005enhancementsIntegrationwithAS,IS,management

toolsDeveloperenhancementsImprovedreportinteractivityRichend-userreportingReportBuilderExtendingtheReach

ofReportingServicesAdhocReportingfor

theEnd-User2022/11/1046SQLServerReportingServicesReportingServices2022/11/1015EndUserClientOfficeSystem20072007MicrosoftOfficeSystemMicrosoftExcel2007MicrosoftOfficeSharePointServer2007472022/11/10EndUserClientOfficeSystemMicrosoftExcel2007Thecorespreadsheetcapabilitieshavebeendramaticallyenhancedtoenableduserstoanalyze,communicate,andmanageinformationProvidesfullsupportforMicrosoftSQLServer2005AnalysisServicesNewservertechnologyforsecureandcontrolledsharingofspreadsheetsPublishspreadsheetstoSharePointdocumentlibrariesMaintaina“singleversionofthetruth”whilestillsharingspreadsheetsProtectconfidentialandproprietaryinformation2022/11/1048MicrosoftExcel2007ThecoresAnalyzedatainExcelPublishspreadsheetsanddocumentstoSharePoint

Reusespreadsheets,reports,anddocumentsindashboardsandbusinessapplicationsAccessandexploredatainspreadsheets,reports,anddocumentsinthePortalBestwithSQLServerBusinessIntelligencewithOffice“12”2022/11/1049Office2007BIFeaturesAnalyzedatainExcelPublishsAcomplete,integratedtoolforthedevelopmentofBIapplicationsOnetool,multipletechnologies:Relational,OLAP,DM,SSIS,

Reporting,Code,Webpages…Enterprisesoftware

developmentenvironment:IntegratedintoVisualStudio.NETTeamdevelopment,sourcecontrol,

versioning,developerisolation,

resourceindependentcodingDevelopmentcyclelifetimesupportDevelop,Test,Deploy,Modify,Test…Breakthrougheaseofuse2022/11/1050Acomplete,integratedtoolfoManagescontentandbusinessprocessesImprovesbusinessinsightPresentbusiness-criticalinformationinonecentrallocationCentralizedReportCentersitesgiveusersasingleplacetofindthelatestspreadsheets,reports,orKPIsSharebusinessdatabroadlywhilehelpingtoprotectsensitiveinformationExcelServicesrunningonOfficeSharePointServer2007providesaccesstodataandanalyticsinreal-time,interactiveMicrosoftOfficeExcelspreadsheetsfromaWebbrowserSimplifiesinternalandexternalcollaboration2022/11/1051SharePoint2007ManagescontentandbusinesspWhydidithappen?AnalyticsWhathappened?ReportingWhatwillhappen?

ForecastingWhatdoIwanttohappen?Planning,Budgeting,

ConsolidationWhatishappening?ScorecardsandDashboardsPerformanceManagement2022/11/1052Whydidithappen?WhathappeneMicrosoftPerformancePointServer2007Acompleteandintegratedperformance-managementapplicationthatincludes:Monitoring:AdvancedScorecardsAnalytics:NextgenerationofProClaritytechnologyPlanning:Biz#apowerfulenvironmentforbudgeting,andforecastingthattargetsbusinessusersEnablescompaniestomoreeffectivelyplanandmanagetheirbusiness2022/11/1053MicrosoftPerformancePointSeAcomplete,integratedtoolforthedevelopmentofBIapplicationsOnetool,multipletechnologies:Relational,OLAP,DM,SSIS,

Reporting,Code,Webpages…Enterprisesoftware

developmentenvironment:IntegratedintoVisualStudio.NETTeamdevelopment,sourcecontrol,

versioning,developerisolation,

resourceindependentcodingDevelopmentcyclelifetimesupportDevelop,Test,Deploy,Modify,Test…Breakthrougheaseofuse2022/11/1054BIDevelopment--BIDSAcomplete,integratedtoolfoIntegratedenvironmentforaccessing,config