• Online, Self-Paced
Course 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.

Learning Objectives

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

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration