Microsoft SQL Server 2014: Design and Install Analysis Services and Tools

Business intelligence developers who create reporting and analysis solutions and individual interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisite
None

Expected Duration
117 minutes

Description
Using SQL Server Analysis Services (SSAS), you can build multidimensional and tabular models. These models can be used to analyze large amounts of data for business intelligence (BI) applications. This course will discuss the multidimensional and data mining model, tabular model, and BI with SharePoint, including PowerPivot. It will also demonstrate how to install SSAS and SQL Server Data Tools – Business Intelligence. This course is one in a series of SkillSoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Objective

Preparing for an SSAS Installation

  • start the course
  • explain the functionality that OLAP and data mining provide for business intelligence
  • explain the functionality that tabular mode provides for business intelligence
  • explain the functionality of SQL Server BI features with SharePoint, including PowerPivot
  • identify the different BI features to install based on a scenario
  • identify the appropriate data model to use for data analysis
  • identify the development and production considerations for installing SSAS

Installing SSAS

  • install SSAS in multidimensional mode
  • install SSAS in tabular mode
  • install PowerPivot for SharePoint with use in SSAS
  • upgrade an SSAS instance
  • update an SSAS instance
  • configure server and database level security for an SSAS instance

SQL Server Tools

  • describe the environments available for building, deploying, and managing Analysis Services
  • install SQL Server Data Tools – Business Intelligence
  • describe the SQL Server Data Tools environment
  • deploy SQL Server Management Studio
  • describe the SQL Server Tools environment

Practice: SSAS Design and Installation

  • design and install SQL Server Analysis Services

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.