Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server
Virtual Lab

Time
9 hours 29 minutes
Difficulty
Intermediate

Prove your capabilities as an exceptionally skilled enterprise professional and work hands- on using Microsoft SQL Server 2012 databases. In the Microsoft 70-467 Virtual Lab, learn to effectively plan business intelligence (BI) infrastructure, design BI infrastructure, design a reporting solution, design BI data models, and design an ETL solution.

Join over 2 million IT and cyber professionals advancing their careers

OR REGISTER WITH

Google

Already have an account? Sign In »

Content

Module 1

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

Description

If you are looking to create business intelligence solutions using Microsoft SQL Server 2012 databases and gain faster insights on data, this is the ideal skill enhancement tool for you.

Microsoft SQL Server is a relational database management system with the primary function of storing and retrieving data as requested by other software applications. Being able to tell a story using data is critical for today's evolving businesses who need insight into their customers, products, etc.

Professionals seeking a comprehensive understanding of how to harness Microsoft SQL Server 2012 databases to deliver mission-critical performance will greatly benefit from The Microsoft 70-467 Practice Lab. Not only will this lab allow you to gain hands-on skills needed to design an overall BI infrastructure, but it will also prepare you to confidently ace the Microsoft 70-467 certification exam.

This practice lab and the exam it aligns to are intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

Obtaining your certification signifies that you possess the fundamental knowledge to plan business intelligence (BI) infrastructure, design BI infrastructure, design a reporting solution, design BI data models, and design an ETL solution.

Topics of Emphasis

  • ETL in SSIS and Processing in Analysis Services
  • Proactive Caching in SQL Server Analysis Services (SSAS)
  • Understand Performance of Named Queries in Data Source View
  • Analyze Performance Consequences of MDX and DMX Queries
  • Create Multiple Partitions to improve Query and Load Performance
  • Implement Appropriate Indexing Strategy on Fact Tables Aggregations in SSAS Partitions and Storage Modes in SSAS
  • Create 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
  • Design a Reporting Services Dataset
  • Manage Excel Services and Reporting for SharePoint
  • Plan and Manage Reporting Services
  • Configure 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

Practice Lab Specifications

Practice Labs are pre-configured hardware layouts with accompanying lab guides for fast, convenient access that make studying for an exam or learning new technologies an engaging experience. Develop your comprehensive IT skills in a safe, working environment without the need to invest in your own hardware and software.

  • Practical Training on the Latest Industry Technology
  • Real Equipment, No Simulations
  • 6 Month Unified Access Available on Any Device
  • No Hardware or Licensing Costs

System Requirements

Recommended Hardware:

  • Screen dimensions: 1920px x 1080px or higher (full HD or higher)
  • Processor speed: 2Ghz / multi-core
  • Broadband / Internet access requirements: 5mb download, 1mb upload

Minimum Hardware:

  • Screen dimensions: 1280px x 1024px
  • Processor speed: 1.5Ghz
  • Broadband / Internet access requirements: 2mb download, 256kpbs upload

Operating Systems:

  • Microsoft Windows XP with SP2/Vista/7/8/8.1/10
  • Microsoft Windows Server 2003/2008/2013
  • Linux Red Hat, Fedora, SUSE, Ubuntu
  • Apple Mac OS X

Networking:

  • Internet connection minimum of 512Kbs
  • HTTPS Access (Port 443)
  • HTTP Access (Port 80)

Software:

  • Oracle Java version 1.7+ (If using our Java client)

Browser:

HTML 5 Client

  • Microsoft Edge 13 or later
  • Microsoft Internet Explorer 10 or later
  • Chrome 29 or later
  • Firefox 45 or later
  • Apple Safari 9.1 or later

Java Client

  • Internet Explorer 10 or later

Note: For both client technologies, if you have a Pop up blocker enabled on your computer

you will need to allow popups from *.practice-labs.com as an exception.

Provided By

Practice Labs

Certificate of Completion

Certificate Of Completion

Complete this entire course to earn a Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server Certificate of Completion