Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com
Phone: +27 10 020 2067

Physical Address:

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

You are here

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

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.
USD 295 USD 120 59% OFF
  • No of hours: 
    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