Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

courses popup callback

LIVE LAB:

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

Practical exercises in a live environment to help you get real-world, hands-on experience.

Overview

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.

Vendor:   Microsoft
Vendor Id:   70-466
Version:   1
Level:   Intermediate
Learning Time:   320  Minutes

Exercises

  1. Design Dimensions and Measures of a Cube
  2. Total Learning Time is 40  Minutes and module version is 3

    Exercises:
    • Introduction
    • Design Dimensions and Measures
    • Implement and Configure Dimensions in a Cube
    • Summary
  3. Design a Schema to Support Cube Architecture
  4. Total Learning Time is 30  Minutes and module version is 3

    Exercises:
    • Introduction
    • Schema for Cube Architecture
    • Summary
  5. Create and Configure Measures
  6. Total Learning Time is 30  Minutes and module version is 2

    Exercises:
    • Introduction
    • Managing Cube Measures
    • Summary
  7. Implement a Cube
  8. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube
    • Summary
  9. Implement Storage Design in a Multidimensional Model
  10. Total Learning Time is 30  Minutes and module version is 2

    Exercises:
    • Introduction
    • Storage Design for Multidimensional model
    • Summary
  11. Create Multidimensional Expressions (MDX) Queries
  12. Total Learning Time is 40  Minutes and module version is 5

    Exercises:
    • Introduction
    • Managing Multidimensional Expressions (MDX) Queries
    • Define Calculated Members
    • Summary
  13. Deploy SSAS databases
  14. Total Learning Time is 30  Minutes and module version is 2

    Exercises:
    • Introduction
    • Deploy SSAS Databases
    • Summary
  15. Design a Report
  16. Total Learning Time is 90  Minutes and module version is 1

    Exercises:
    • Introduction
    • Create a Report
    • Design Report Templates
    • Customize a Report
    • Select Report Components
    • Design a Grouping Structure
    • Use Expressions for Sophisticated Operations
    • Drilldown Reports
    • Drillthrough Reports
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
  • 320+ Minutes of practical exercises
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top