微軟商業(yè)智能簡(jiǎn)介課件

1、Microsoft Business Intelligence StackModule 1Module 1商業(yè)智能技術(shù)簡(jiǎn)介Module 1Module 1SQL 2012 BI PlatformEnterprise Extract Transform Load with SQL Server Integration ServicesSQL Server Analysis Services DBMS Management SystemReporting Services and Report Builder 3.0Excel Power Pivot Module 1Enterprise Extr

2、act Transform Load with Integration ServicesModule 1Analysis Services Module 1 Understanding Multidimensional Space TerminologyData Warehouse/Data MartsCubesDimensionsHierarchiesMeasuresMDXData MiningModule 1Data Warehouse/Data MartsSee the italics for an excerpt from WikipediaModule 1CubesModule 1M

3、DXExpression Language for querying OLAP CubesSimilar to T-SQLModule 1Data MiningModule 1SharePoint 2010 Business IntelligenceModule 1ReportsModule 1SharePoint Server 2010 TerminologyWeb ServerContent DatabaseWeb ApplicationWeb CollectionWeb SiteContent TypeListModule 1Web ServerModule 1Content Datab

4、aseModule 1Web ApplicationDefined by:Port number, host headers or bothIncludes a application pool assignmentAn authentication methodModule 1Web CollectionSite Collection Templates:Module 1Web SiteThe actual Web Site off of the Site Collection. Module 1ListSimilar (kind-of) to tables in a databaseSup

5、port fields (like columns in the table)Can react to changes (like triggers in a database)Can be configured to filter, sort or group items.Module 1The Tool SetsDevelopment ToolsPower User ToolsInformation Worker ToolsModule 1Development ToolsBusiness Intelligence Development StudioVisual StudioShareP

6、oint DesignerModule 1Demonstration: The Microsoft Business Intelligence StackModule 1LabExplore the Movement of Data in the StackExamine the Data in the Cube using SQL Server Management StudioExamine the Data using Business Intelligence Development StudioCreate a Business CenterConfigure your Business Center Module 1ReviewReview Lab ExperienceReview and Discuss Module GoalsUnderstand the overview of the stackExplain the role of each of the services in SQL for BIOverview of SharePointGain a familiarity with terminology used in produc