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


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

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

  • 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
  • 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
  • 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
  • design and install SQL Server Analysis Services

    • Course Number:
    md_idmr_a01_it_enus

    Expertise Level
    Intermediate