70-467: Designing Business Intelligence Solutions with Microsoft SQL Server


SKU: LPL-149 Category:

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.

About Practice Labs

In today’s world of complex computer systems and technologies it’s essential that both those new to IT and seasoned professionals alike gain hands on experience. Our state-of-the-art platform brings training theory to life giving the user greater depth of technology ensuring their ability to demonstrate how to use and understand vendor products and software.

Get the hands on learning you need without spending significant amounts of money on your own equipment. We deliver real equipment with the ease and convenience of your web browser, allowing you to develop real world IT skills.


  • Risk free platform to develop practical IT skills in all the latest technologies
  • Real world and exam related practical tasks
  • Real equipment NOT simulations
  • Simply accessed from a web browser, anytime, anywhere – 24/7

Learning Objectives

ETL in SSIS and Processing in Analysis Services
Proactive Caching in SQL Server Analysis Services (SSAS)
Understanding Performance of Named Queries in Data Source View
Analyzing Performance Consequences of MDX and DMX Queries
Creation of Multiple Partitions to improve Query and Load Performance
Implement Appropriate Indexing Strategy on Fact Tables
Aggregations in SSAS
Partitions and Storage Modes in SSAS
Creating Automated Backup of SQL Server
Configure Kerberos Constrained Delegation for Analysis Services
Dynamic Dimension Security in SSAS
Configure HTTP Access to Analysis Services on IIS
Design Roles for Calculated Measures
Parallel Bulk Loading Using Partition Switching
High Availability and Disaster Recovery
Configure Logging for ETL Package
Designing a Reporting Services Dataset
Manage Excel Services and Reporting for SharePoint
Plan and Manage Reporting Services Configuration
Design BI Reporting Solution Architecture_Updated
Design the Data Warehouse
Design Cube Architecture
Many to Many Multidimensional Database (SSAS)
Design and Create MDX Calculations
Deploy SSIS Solutions
Design Package Configurations for SSIS Packages