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 Introduction
• 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 Introduction
• 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 Introduction
• 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