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

299 USD 201.35 USD 33%
Test scorm

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012. 

read more

Module 1

  • Course Introduction
  • Course Modules
  • SQL Server 2012 Business Intelligence
  • Introduction to Business Intelligence
  • Data Warehouse
  • Extract, Transform and Load (ETL)
  • SQL Server Integration Services
  • SQL Server 2012 BI Tools
  • Developer Tools
  • Exam Scenarios

Module 2

  • SQL Server Reporting Services
  • Introduction to SSRS
  • Creation and Delivery
  • SSRS Reports
  • Report Grouping
  • Expressions
  • Drilldown Report
  • Parameters
  • Visual Components
  • Creating SQL Server
  • Exam Scenarios
  • Module Review

Module 3

  • SSRS Management
  • Deploying Reports
  • Report Security
  • Executing Reports
  • Report Caching
  • Report Snapshot
  • Subscriptions
  • Data Alerts
  • Managing Reporting Services
  • Exam Scenarios
  • Module Review

Module 4

  • Multidimensional Cubes
  • Introduction to Cubes
  • Cube Components
  • Creating and Configuring Analysis Services Cube
  • Exam Scenarios
  • Module Review

Module 5

  • Advanced Cube Concepts
  • Measures
  • Formatting Measures
  • Measure Groups
  • Measure Group Storage
  • Aggregations
  • Dimensions
  • Dimension Storage
  • Hierarchies
  • Grouping and Sorting
  • Working with Measures
  • Exam Scenarios
  • Module Review

Module 6

  • Customizing Cubes and Security
  • Actions
  • Perspectives
  • Key Performance Indicators
  • Translations
  • SSAS Security
  • Cell Permissions
  • Dimension Permissions
  • Customizing Cubes and Cube Security
  • Exam Scenarios
  • Module Review

Module 7

  • MultiDimensional eXpressions (MDX)
  • Introduction to MDX
  • Why Use MDX?
  • MDX Syntax
  • MDX Queries and Filters
  • Sets
  • Applying MDX
  • Working with MDX
  • Exam Scenarios
  • Module Review

Module 8

  • Tabular Data Models
  • Introduction to TDM
  • PowerPivot
  • Linked and Non-Linked Tables
  • PowerPivot
  • Server Based Tabular Data Models
  • Creating a Tabular Data Model
  • Workspace Database
  • Tabular Data Model
  • Working with Tabular Data Modeling
  • Exam Scenarios
  • Module Review

Module 9

  • Data Analysis eXpressions (DAX)
  • Introduction to DAX
  • Working with DAX
  • DAX Functions
  • DAX Queries
  • Calculated Columns
  • Measures
  • Multiple Relationships
  • Working with DAX within PowerPivot
  • Exam Scenarios
  • Module Review

Module 10

  • Data Mining
  • Introduction to Data Mining
  • Data Mining Algorithms
  • Data Mining Components
  • Validating Mining Models
  • Presenting Mining Data
  • Creating a Mining Structure
  • Exam Scenarios
  • Module Review
  • Course Review
  1. Module 1
6
Start
Data Warehouse
7
Start
Extract, Transform and Load (ETL)
8
Start
SQL Server Integration Services
9
Start
SQL Server 2012 BI Tools
10
Start
Developer Tools
11
Start
Exam Scenarios
  1. Module 2
12
Start
SQL Server Reporting Services
13
Start
Introduction to SSRS
13
Start
Introduction to SSRS
14
Start
Creation and Delivery
15
Start
SSRS Reports
16
Start
Report Grouping
17
Start
Expressions
18
Start
Drilldown Report
18
Start
Drilldown Report
19
Start
Parameters
20
Start
Visual Components
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
22
Start
Exam Scenarios
23
Start
Module Review
  1. Module 3
24
Start
SSRS Management
25
Start
Deploying Reports
25
Start
Deploying Reports
26
Start
Report Security
26
Start
Report Security

Add New Discussion

How do you rate this product?

Select currency