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-467 Designing Business Intelligence Solutions with Microsoft SQL Server

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

Overview

The 70-467 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 in planning for performance and scalability, planning upgrades, maintaining server health, designing a security, partitioning and logging and audit strategies, designing a high availability disaster recovery strategy, planning and managing reporting services configurations, designing a BI reporting solution architecture, designing a data warehouse and cube architecture, designing fact tables and designing and creating MDX calculations. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-467 certification exam.

Vendor:   Microsoft
Vendor Id:   70-467
Version:   1
Level:   Entry
Learning Time:   570  Minutes

Exercises

  1. ETL in SSIS and Processing in Analysis Services
  2. Total Learning Time is 60  Minutes and module version is 5

    Exercises:
    • Introduction
    • Creating a Simple ETL Package
    • Developing and Processing an OLAP Cube
    • Summary
  3. Proactive Caching in SQL Server Analysis Services (SSAS)
  4. Total Learning Time is 60  Minutes and module version is 5

    Exercises:
    • Introduction
    • Implementing Proactive Caching in SSAS
    • Summary
  5. Understanding Performance of Named Queries in Data Source View
  6. Total Learning Time is 60  Minutes and module version is 3

    Exercises:
    • Introduction
    • Creating a Named Query
    • Analysing Performance of Named Query
    • Summary
  7. Analyzing Performance Consequences of MDX and DMX Queries
  8. Total Learning Time is 60  Minutes and module version is 5

    Exercises:
    • Introduction
    • Analyzing Performance Consequences of MDX
    • Analyzing Performance Consequences of DMX
    • Summary
  9. Creation of Multiple Partitions to improve Query and Load Performance
  10. Total Learning Time is 60  Minutes and module version is 9

    Exercises:
    • Introduction
    • Creating Multiple Partitions to Improve Query Performance
    • Creating Multiple Partitions to Improve Load Performance
    • Summary
  11. Implement Appropriate Indexing Strategy on Fact Tables
  12. Total Learning Time is 60  Minutes and module version is 4

    Exercises:
    • Introduction
    • Implementing Clustered Index on Fact Table
    • Implementing Non- Clustered Index
    • Summary
  13. Aggregations in SSAS
  14. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Creating Group of Aggregations
    • Summary
  15. Partitions and Storage Modes in SSAS
  16. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Creating Partitions
    • Configuring Storage Modes in SSAS
    • Summary
  17. Creating Automated Backup of SQL Server
  18. Total Learning Time is 60  Minutes and module version is 3

    Exercises:
    • Introduction
    • Creating Automated Backup
    • Summary
  19. Configure Kerberos Constrained Delegation for Analysis Services
  20. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Configuring Analysis Services for Kerberos Constrained Delegation
    • Summary
  21. Dynamic Dimension Security in SSAS
  22. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Set up Role Based Dynamic Dimension Security
    • Summary
  23. Configure HTTP Access to Analysis Services on IIS
  24. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Configuring HTTP Access to Analysis Services on IIS
    • Summary
  25. Design Roles for Calculated Measures
  26. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Set up Security to Calculated Members through Roles
    • Summary
  27. Parallel Bulk Loading Using Partition Switching
  28. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Partioning Tables
    • Summary
  29. High Availability and Disaster Recovery
  30. Total Learning Time is 60  Minutes and module version is 4

    Exercises:
    • Introduction
    • Backing up and Restoration of an SSAS Database
    • Backing up and Restoration of SSRS Database
    • Backing up and Restoration of SSIS Database
    • Summary
  31. Configure Logging for ETL Package
  32. Total Learning Time is 60  Minutes and module version is 3

    Exercises:
    • Introduction
    • Creating a Simple ETL Package
    • Adding and Configuring Logging for an ETL package
    • Summary
  33. Many to Many Multidimensional Database (SSAS)
  34. Total Learning Time is 60  Minutes and module version is 6

    Exercises:
    • Introduction
    • Create Many to Many Multidimensional Database in SSAS
    • Summary
  35. Designing a Reporting Services Dataset
  36. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Configuring an OLE DB Source to Use Parameterized Queries and Map a Query Parameter to a Variable
    • Creating an SSRS Report on an SSAS OLAP Cube
    • Creating a DAX-Based Dataset to retrieve tabular
    • Creating SSRS reports using Stored Procedures with Parameters
    • Summary
  37. Manage Excel Services and Reporting for SharePoint
  38. Total Learning Time is 60  Minutes and module version is 3

    Exercises:
    • Introduction
    • Add a Reporting Services Report to Your Power Pivot Workbook
    • Deploy PowerPivot Workbook to SharePoint Using BIDS
    • Demonstrate How to Schedule Data Refresh for PowerPivot Workbook Published to a SharePoint Library
    • Deploy a PowerView Report to a SharePoint Library
    • Summary
  39. Plan and Manage Reporting Services Configuration
  40. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Create a Native Mode Report Server Database
    • Create a Reporting Services Service Application using SharePoint Central Administration
    • Summary
  41. Design BI Reporting Solution Architecture
  42. Total Learning Time is 60  Minutes and module version is 4

    Exercises:
    • Introduction
    • Create Drillthrough Reports in SSRS
    • Adding a Subreport
    • Rendering a Report on a Web Page
    • Create a Data Alert in Data Alert Designer
    • Create a Reporting Services Subscription to Deliver a Report to a SharePoint Library
    • Summary
  43. Design the Data Warehouse
  44. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Building an Enterprise Data Warehouse Model Using Snowflake Schema
    • Adding a Data Lineage for a Dimension Table
    • Working with Fact Tables
    • Adding Data Lineage for a Fact Table
    • Working with Column Store Index
    • Partitioning the Fact Table
    • Implement an Incremental Data Load
    • Summary
  45. Design Cube Architecture
  46. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Creating a Data Source View in SSAS
    • Creating Measures, Measure Groups and Aggregate Functions
    • Using Drillthrough Action
    • Define an Index for the View
    • Summary
  47. Design and Create MDX Calculations
  48. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Creating Query-Scoped Calculated Members in MDX Statement
    • Creating Session-Scoped Calculated Member in MDX Statement
    • Summary
  49. Deploy SSIS Solutions
  50. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Creating Integration Services Catalog
    • Creating an SSIS Package with Parameters and Values
    • Adding a Configuration to SSIS Package
    • Deploying SSIS Projects with Project Deployment Model
    • Using Package Configurations in SSIS
    • Executing SSIS Package Using SQL Server Agent
    • Summary
  51. Design Package Configurations for SSIS Packages
  52. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Adding Configurations to SSIS Packages
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
  • 570+ 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