MOC 20768 - Developing SQL Data Models

Module 1: Introduction to Business Intelligence and Data ModelingIntroduction to Business IntelligenceThe Microsoft business intelligence platformLab : Exploring a Data WarehouseAfter completing this module, you will be able to:Describe the concept of business intelligenceDescribe the Microsoft business intelligence platformModule 2: Creating Multidimensional DatabasesIntroduction to multidimensional analysisCreating data sources and data source viewsCreating a cubeOverview of cube securityLab : Creating a multidimensional databaseAfter completing this module, you will be able to:Use multidimensional analysisCreate data sources and data source viewsCreate a cubeDescribe cube securityModule 3: Working with Cubes and DimensionsConfiguring dimensionsDefine attribute hierarchiesSorting and grouping attributesLab : Working with Cubes and DimensionsAfter completing this module, you will be able to:Configure dimensionsDefine attribute hierarchies.Sort and group attributesModule 4: Working with Measures and Measure GroupsWorking with measuresWorking with measure groupsLab : Configuring Measures and Measure GroupsAfter completing this module, you will be able to:Work with measuresWork with measure groupsModule 5: Introduction to MDXMDX fundamentalsAdding calculations to a cubeUsing MDX to query a cubeLab : Using MDXAfter completing this module, you will be able to:Describe the fundamentals of MDXAdd calculations to a cubeQuery a cube using MDXModule 6: Customizing Cube FunctionalityImplementing key performance indicatorsImplementing actionsImplementing perspectivesImplementing translationsLab : Customizing a CubeAfter completing this module, you will be able to:Implement key performance indicatorsImplement actionsImplement perspectivesImplement translationsModule 7: Implementing a Tabular Data Model by Using Analysis ServicesIntroduction to tabular data modelsCreating a tabular data modelUsing an analysis services tabular model in an enterprise BI solutionLab : Working with an Analysis services tabular data modelAfter completing this module, you will be able to:Describe tabular data modelsCreate a tabular data modelBe able to use an analysis services tabular data model in an enterprise BI solutionModule 8: Introduction to Data Analysis Expression (DAX)DAX fundamentalsUsing DAX to create calculated columns and measures in a tabular data modelLab : Creating Calculated Columns and Measures by using DAXAfter completing this module, you will be able to:Describe the fundamentals of DAXUse DAX to create calculated columns and measures in a tabular data modelModule 9: Performing Predictive Analysis with Data MiningOverview of data miningUsing the data mining add-in for ExcelCreating a custom data mining solutionValidating a data mining modelConnecting to and consuming a data mining modelLab : Perform Predictive Analysis with Data MiningAfter completing this module, you will be able to:Describe data miningUse the data mining add-in for ExcelCreate a custom data mining solutionValidate a data mining solutionConnect to and consume a data mining solution