70-466 Implementing Data Models and Reports with Microsoft SQL Server

Microsoft SQL Server 2014: Design and Install Analysis Services and Tools
Course: 1 Hour, 57 Minutes

Course Introduction
Overview of the Multidimensional and Data Mining Mode
Overview of Tabular Mode
Overview of BI Features with SharePoint
SQL Server BI Scenarios and SharePoint
Identify the Correct Model for Data Analysis
Identify the Development and Production Considerations

Microsoft SQL Server 2014: Designing Multidimensional Models and Data Sources
Course: 2 Hours, 3 Minutes

Course Introduction
Understanding the Logical Architecture
Understanding the Cube Architecture
Designing a Schema for a Cube Architecture
Understanding the Different Data Sources
Creating a Data Source
Creating a Data Source View

Microsoft SQL Server: Implement and Configure Cubes
Course: 1 Hour, 47 Minutes

Course Introduction
Creating a Cube Using Existing Tables
Creating an Empty Cube
Creating a Cube Using a Template
Viewing the Cube Schema in Cube Designer
Viewing Cube Data and Metadata in Cube Designer
Checking Cube Data Through the Browser
Creating Actions on a Cube

Microsoft SQL Server 2014: Design and Implement Dimensions 
Course: 2 Hours, 8 Minutes
Course Introduction
Creating a Dimension Using the Dimension Wizard
Configuring a Dimension Structure Using the Designer
Configuring Dimension Attribute Relationships
Developing New Custom Attributes on Dimensions
Creating User-Defined Hierarchies
Defining Translations for Dimension Metadata
Creating a Time Dimension Using the Dimension Wizard
Modifying a Time Dimension Using the Designer
Managing Parent-Child Dimensions
Creating Linked Dimensions

Microsoft SQL Server: Implement Partitions and Custom Logic
Course: 2 Hours, 26 Minutes

Course Introduction
Designing a Partition Strategy
Understanding the Storage Modes for Partitioning
Understanding Proactive Caching for Partitions

Microsoft SQL Server 2014: MDX Queries, Process Models, and Deploy Databases
Course: 2 Hours, 32 Minutes

Course Introduction
Understanding MDX Queries on Multidimensional Models
Understanding the MDX SELECT Statement Syntax: Part I
Understanding the MDX SELECT Statement Syntax: Part II
Identifying Tuples in an MDX SELECT Statement
Returning Tuples from an MDX SELECT Statement
Using Number Functions in an MDX SELECT Statement
Using Set Functions in an MDX SELECT Statement
Using the TopCount Function in an MDX SELECT Statement
Restricting Queries with Query Axis
Restricting Queries with Slicer Axis
Using the scope MDX Statement
Using the CASE MDX Statement

Microsoft SQL Server 2014: Manage, Maintain, and Troubleshoot SSAS
Course: 2 Hours, 3 Minutes

Course Introduction
Optimizing Performance of Cubes and Dimensions
Monitoring SSAS Using Performance Counters
Using DMVs to Monitor SSAS
Optimizing MDX Queries
Optimizing MDX in Calculations
Monitoring and Clearing the SSAS Cache

Microsoft SQL Server 2014: Create and Manage Tabular Data Models
Course: 2 Hours, 46 Minutes

Course Introduction1
Creating a Tabular Model Using SSDT
Importing Data into a Tabular Model
Defining Relationships Between Tables
Creating Hierarchies
Managing the Visibility of Columns
Sorting and Filtering Columns
Creating Perspectives

Microsoft SQL Server 2014: Design Reports and Create Data Sources and Datasets
Course: 2 Hours, 4 Minutes

Course Introduction
Reporting Services Topologies and Configurations
Planning a Report
Identifying Report Components
Creating a Reporting Services Project
Installing Reporting Services
Configuring Reporting Services

Microsoft SQL Server 2014: Report Formatting and Interactivity
Course: 2 Hours, 34 Minutes

Course Introduction1
Creating a Tablix Report
Creating a Matrix Report
Formatting Fields and Column Headers
Adding Images, Maps, Charts, and Indicators
Adding Lists, Text Boxes, and Other Visuals
Grouping Data and Adding Line Totals and Grand Totals
Implementing Group and Report Variables
Defining Expressions
Using the Report Wizard to Create a Report

Microsoft SQL Server 2014: Manage Reporting Services
Course: 1 Hour, 37 Minutes

Course Introduction
Understanding Report Server Security Architecture
Configuring Report Server Level Security
Configuring Item-level Security
Securing Reports Using Roles
Securing Shared Data Source Items
Configuring Stored Credentials
Configuring SharePoint Groups and Permissions
Managing Encryption Keys

Microsoft SQL Server 2014: Process Report and Create Subscriptions and Schedules
Course: 1 Hour, 19 Minutes

Course Introduction1
Publishing Reports to a Report Server
Publishing Reports to a SharePoint Library
Deploying Custom Assemblies with Reports
Saving Reports Using Report Builder
Viewing Reports in Report Manager and a Browser