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

Practice Lab
Online Practice Labs, easily accessed from anywhere at any time, are the foundation to practical hands-on skills development enabling users to access real live equipment in a safe test environment.
€137


The 70-466 Practice-Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012 Databases. By completing the lab tasks you will improve your practical skills on the following: Describe the components, architecture, and nature of a BI solution, create a multidimensional database with Analysis Services, implement dimensions in a cube, implement measures and measure groups in a cube, use MDX Syntax, customize a cube, implement a Tabular Data Model in SQL Server Analysis Services, use DAX to enhance a tabular model, create reports with Reporting Services, enhance reports with charts and parameters, manage report execution and delivery and use Data Mining for Predictive Analysis.


These same tasks will help you understand the objectives and competencies required by the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.


Learning Objectives
Learning Time: 8 hours

  • Design Dimensions and Measures of a Cube
  • Design a Schema to Support Cube Architecture
  • Create and Configure Measures
  • Implement a Cube
  • Create Multidimensional Expressions (MDX) Queries
  • Implement Storage Design in a Multidimensional Model
  • Deploy SSAS databases
  • Design a Report
PlatformOperating SystemBrowser
Chrome 39 Firefox 34 Internet Explorer 10 and 11 Safari 8
PC W7 x86 X X X
W7 x64 X X X
W8.1 x86 X X X
W8.1 x64 X X X
MAC OSX 10.9 X X X
OSX 10.10 X X X
LINUX Linux x86 X X
Linux x64 X X
Surface Pro Windows 8 X X X
PlatformOperating SystemBrowser
Safari 8 Android Chrome 39 Internet Explorer RT Internet Explorer 11
iPad* IOS 8 X X
iPhone 5 or higher* IOS 8 X X
iPhone 4* IOS 7 X X
Android Tablet* 4.0 or higher X X
Android Phone* 4.0 or higher X X
Lumia 920 or higher* Windows Phone 8.1 X
Surface Windows RT X

*Online use only with these devices


Download System Requeriments

  • Win7, Win8.1, Linux 64 bits, MAC OSX 10.9 and 10.10
  • We no longer support XP