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
South Africa 1684

You are here

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


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.


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


  1. ETL in SSIS and Processing in Analysis Services
  2. Exercises:
    • Introduction
    • Creating a Simple ETL Package
    • Developing and Processing an OLAP Cube
    • Summary
  3. Proactive Caching in SQL Server Analysis Services (SSAS)
  4. Exercises:
    • Introduction
    • Implementing Proactive Caching in SSAS
    • Summary
  5. Understanding Performance of Named Queries in Data Source View
  6. Exercises:
    • Introduction
    • Creating a Named Query
    • Analysing Performance of Named Query
    • Summary
  7. Analyzing Performance Consequences of MDX and DMX Queries
  8. 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. 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. Exercises:
    • Introduction
    • Implementing Clustered Index on Fact Table
    • Implementing Non- Clustered Index
    • Summary
  13. Aggregations in SSAS
  14. Exercises:
    • Introduction
    • Creating Group of Aggregations
    • Summary
  15. Partitions and Storage Modes in SSAS
  16. Exercises:
    • Introduction
    • Creating Partitions
    • Configuring Storage Modes in SSAS
    • Summary
  17. Creating Automated Backup of SQL Server
  18. Exercises:
    • Introduction
    • Creating Automated Backup
    • Summary
  19. Configure Kerberos Constrained Delegation for Analysis Services
  20. Exercises:
    • Introduction
    • Configuring Analysis Services for Kerberos Constrained Delegation
    • Summary
  21. Dynamic Dimension Security in SSAS
  22. Exercises:
    • Introduction
    • Set up Role Based Dynamic Dimension Security
    • Summary
  23. Configure HTTP Access to Analysis Services on IIS
  24. Exercises:
    • Introduction
    • Configuring HTTP Access to Analysis Services on IIS
    • Summary
  25. Design Roles for Calculated Measures
  26. Exercises:
    • Introduction
    • Set up Security to Calculated Members through Roles
    • Summary
  27. Parallel Bulk Loading Using Partition Switching
  28. Exercises:
    • Introduction
    • Partioning Tables
    • Summary
  29. High Availability and Disaster Recovery
  30. 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. Exercises:
    • Introduction
    • Creating a Simple ETL Package
    • Adding and Configuring Logging for an ETL package
    • Summary
  33. Many to Many Multidimensional Database (SSAS)
  34. Exercises:
    • Introduction
    • Create Many to Many Multidimensional Database in SSAS
    • Summary
  35. Designing a Reporting Services Dataset
  36. 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. 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. 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. 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. 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. 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. Exercises:
    • Introduction
    • Creating Query-Scoped Calculated Members in MDX Statement
    • Creating Session-Scoped Calculated Member in MDX Statement
    • Summary
  49. Deploy SSIS Solutions
  50. 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. 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.
USD 295 USD 120 59% OFF
  • No of hours: 
    + 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 (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top