0
  • No products in the cart.
Cart Total:$0.00

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012

This course prepares students for the Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 exam.

$39.99

SKU: IT-mssql-466-365 Categories: , , , , ,
Description

This course prepares students for the Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 exam. The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining. The exam measures your ability to accomplish the technical tasks listed below.

Build an analysis services multidimensional database Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database Build a tabular data model Build a report with SQL Server Reporting Services (SSRS)

This course prepares students for the Microsoft 70-466: Implementing Data Models & Reports with SQL Server exam. The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining.

The exam measures your ability to accomplish the technical tasks listed below.

  • Build an analysis services multidimensional database (35-40%)
  • Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database (15-20%)
  • Build a tabular data model (15-20%)
  • Build a report with SQL Server Reporting Services (SSRS) (25-30%)

Course Outline

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 Course Content

Download Course Outline

Introduction To Business Intelligence and Data Modeling Part1

Introduction To Business Intelligence and Data Modeling Part2

The Microsoft Business Intelligence Platform Part 1

The Microsoft Business Intelligence Platform Part 2

The Microsoft Business Intelligence Platform Part 3

The Microsoft Business Intelligence Platform Part 4

Implementing Reports the SQL Server Reporting Services Part 1

Implementing Reports the SQL Server Reporting Services Part 2

Implementing Reports the SQL Server Reporting Services Part 3

Implementing Reports the SQL Server Reporting Services Part 4

Implementing Reports the SQL Server Reporting Services Part 5

Implementing Reports the SQL Server Reporting Services Part 6

Implementing Reports the SQL Server Reporting Services Part 7

Implementing Reports the SQL Server Reporting Services Part 8

MSDS Sheets

Managing Report Execution And Delivery

Managing Report Execution

Subscriptions And Data Alerts

Creating Multidimensional Databases

Creating Data Sources And Data Source Views

Creating And Browsing a Cube

Working with Cubes And Dimensions

Sorting And Grouping Attributes

Working With Measures and Measure Groups

Introduction To MDX

Adding Calculations To A Cube

Customizing Cube Functionality Part 1

Customizing Cube Functionality Part 2

Customizing Cube Functionality Part 3

Implementing A Tabular Data Model Part 1

Implementing A Tabular Data Model Part 2

Introduction to DAX

Demonstration Making A Tabular Model Part 1

Demonstration Making A Tabular Model Part 2

Using DAX

Implementing An Analysis Services Tabular Data Model Part 1

Implementing An Analysis Services Tabular Data Model Part 2

Deploying A Tabular Data Model

SQL Analysis Services Part 1

SQL Analysis Services Part 2

Creating Data Visualizations With Power View

Supporting Self Service Reporting

Performing Predictive Analysis With Data Mining

Using The Data Mining Wizard

Predictive Analytics Part 1

Predictive Analytics Part 2

Related Products

$39.99

Course features:

12 Hrs 46 Min

47 VIDEOS

1 Year Access

Available on Web