Implementing Data Models And Reports With Microsoft® SQL Server® M20466

Introduction to Business Intelligence and Data Modeling: Elements of an Enterprise BI Solution - The Microsoft Enterprise BI Platform - Planning an Enterprise BI Project

Creating Multidimensional Databases: Introduction to Multidimensional Analysis - Creating Data Sources and Data Source Views - Creating a Cube - Overview of Cube Security

Working with Cubes and Dimensions: Configuring Dimensions - Defining Attribute Hierarchies - Sorting and Grouping Hierarchies

Working with Measures and Measure Groups: Working with Measures - Working with Measure Groups

Introduction to MDX: MDX Fundamentals - Adding Calculations to a Cube - Using MDX to Query a Cube

Enhancing a Cube: Working with Key Performance Indicators - Working with Actions - Working with Perspectives - Working with Translations

Implementing an Analysis Services Tabular Data Model: Introduction to Analysis Services Tabular Data Models - Creating a Tabular Data Model - Using an Analysis Services Tabular Data Model in the Enterprise

Introduction to DAX: DAX Fundamentals - Enhancing a Tabular Data Model with DAX

Implementing Reports with SQL Server Reporting Services: Introduction to Reporting Services - Creating a Report with Report Designer - Grouping and Aggregating Data in a Report - Publishing and Viewing a Report

Enhancing Reports with SQL Server Reporting Services: Showing Data Graphically - Filtering Reports by Using Parameters

Managing Report Execution and Delivery: Managing Report Security - Managing Report Execution - Subscriptions and Data Alerts - Troubleshooting Reporting Services

Delivering BI with SharePoint PerformancePoint Services: Introduction to SharePoint Server as a BI Platform - Introduction to PerformancePoint Services - PerformancePoint Data Sources and Time Intelligence - Reports, Scorecards, and Dashboards

Performing Predictive Analysis with Data Mining: Overview of Data Mining - Creating a Data Mining Solution - Validating a Data Mining Model - Consuming Data Mining Data