Pragmatic SSAS (Online)

During this 4-half day SSAS training course, you will learn how to use SSAS in your enterprise. This class takes you from the ground-up, teaching you the fundamental skills you need to develop and deploy SSAS solutions and present this new data to your end users. Some of the topics covered in this class are: How to develop a data warehouse for your company, how to develop a repeatable methodology for a successful SSAS project, how to create and configure a cube and dimensions, how to write MDX (the querying language for cubes), how to define calculations, Key Performance Indicators (KPIs) and perspectives, implementing dynamic security, how to administer and deploy SSAS, defining actions, implementing data mining, how to build office-based BI applications and dashboards, and administering SSAS.

IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionnaire, fill it out, and send it as an attachment to mentor@pragmaticworks.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.

All virtual training students are provided a previously recorded version of the class that are available for 7 days after the end of the class.

Outline

Day 1 - SSAS Introduction

  1. Dimension Modeling
    • Why do I Need Analysis Services?
    • Why do I Need a Data Warehouse?
    • Basics of Data Warehouse Design
  2. SSAS Overview
    • Data Source Views
    • Cubes
    • Dimensions and Measures
  3. Cube Design and Browsing
    • Processing the Cube
    • Exploring the Cube Designer Tabs
    • Browsing the Cube Data

Day 2 - The Cube in Depth

  1. Dimension and Cube Designers
    • Dimension and Attribute Properties
    • Creating Hierarchies
    • Creating Attribute Relationships
    • Formatting Measures
  2. Adding New Facts and Dimensions
    • Adding New Dimensions
    • Adding New Measure Groups and Measures
    • Understanding the Dimension Usage Tab
  3. MDX and Calculations
    • MDX Basics
    • Creating Calculations
    • Using Analysis Services Time Intelligence

Day 3 - Data Mining

  1. Data Mining Basics
    • Understanding the Data Mining Algorithms
    • Creating a Mining Model
    • Training the Mining Model
  2. Actions and KPIs
    • Drilling through to data
    • Creating Key Performance Indicators

Day 4 - User Interfaces and Administration

  1. Reporting Services with SSAS
    • Creating a Report Using MDX
    • Creating a Data Mining Report
  2. Using Excel to Build Cube Interfaces
    • Establishing a Connection to the Cube
    • Building Basic Pivot Tables
  3. Administering SSAS
    • Partitioning your Cube
    • Deploying your Cube
    • Analysis Services Security

Prerequisites

The target of this class is developers, architects or IT professionals who have basic SQL skills already. This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008/2012/2014 and how to query a SQL Server.

SystemRequirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, 2008, 2012, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Analysis Services Multidimensional
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly
  • **Optional** Data Mining Add-ins for Excel (only compatible with 32-bit Excel) http://tinyurl.com/ExcelDataMining
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 database installed on the instance.

Some of our clients