Processing your application. Please be patient while we make sure we receive every piece of it.
SQL Server 2012
SQL Server 2012 Analysis Services
4 Days
During this 4-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server 2012 Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution. SQL Server 2012 Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. SSAS enables rapid application development, increases performance and functionality, and reduces the costs and complexity of operation. This course focuses on teaching IT professionals the skills and best practices required to design and develop a well performing and successful analytical solution using SQL Server 2012 Analysis Services.ObjectivesUpon completion of this course, the student will be able to: • Describe the process of building a business intelligence solution and identify where and how SSAS fits into the process.• Create effective SSAS solutions complete with calculations, actions, aggregations, and more.• Design SSAS solutions that are both scalable and secure.• Successfully manage and deploy SSAS solutions in a development/test/production environment.To accomplish that, BISM tabular and multidimensional models will be covered across the whole course.AudienceThis course is intended for IT Professionals that are responsible for designing, developing, and deploying business intelligence solutions. The target audience for this course is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the new capabilities provided by SSAS to build analytical applications.Prerequisites• While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop requires no prior experience with any version of SQL Server Analysis Services.• A basic understanding of relational design and theory is helpful, as is basic familiarity with Structured Query Language (SQL).
Price: $4,145
To find out more available information
about this course, please contact us:

To find out more available information
about this course, please contact us:

To find out more available information
about this course, please contact us:

SQLServer 2012 Analysis Services

SectionA: BI Solutions Overview

Module 01: Introduction to BI Applications

  • The process of creating a BI application
  • The components of a BI application
ü Extraction,transformation, and loading (ETL) processes
ü Relational datawarehouse (RDW)
ü BusinessIntelligence Semantic Model (BISM) solutions, such as cubes and tabularsolutions
ü Delivery andmaintenance processes

Module 02: Dimensional Modeling

  • Terminology review
  • Basic concepts
  • Dimension tables
  • Fact tables
  • Star and snowflake schemas
  • Other considerations
Section B: SSAS Core Design Elements

Module 03: Creating a BISM End-to-End: Understanding the Process

  • SQL Server Data Tools for BI development
  • The SSAS development process
ü Define datasources
ü Develop themodel (multidimensional vs. tabular)
ü Deployment andprocessing
ü Maintenance

Module 04: Multidimensional Model: Creating Dimensions and Cubes

  • Data source views
  • Dimensions
  • Extended dimensions
  • Building cubes
  • Relationships between measure groups and dimensions

Module 05: Multidimensional Model: Advanced Features

  • MDX
  • Calculated members
  • Named sets
  • Scoped assignments
  • Key Performance Indicators (KPIs)
  • Actions
  • Perspectives
  • Translations
Module06: Tabular Model: Building Models
  • Models
  • Tables
  • Calculated columns
  • Calculated measures

Module 07: Tabular Model: Advanced Features

  • Hierarchies
  • DAX and calculated members
  • Key Performance Indicators
  • Perspectives
  • Reporting properties for enhanced end-user experience

Section C: Completing the SSAS solution to be properly managed

Module 08: Storage Modes, Aggregation Designs, and Proactive Caching

  • Storage modes
ü Storage modesfor the multidimensional model
ü Storage modes forthe tabular model
  • Partitions
  • Aggregation designs
  • Proactive caching

Module 9: Security

  • SSAS security architecture
  • Defining administrative access roles
  • Defining user access roles
  • Sections specific to the multidimensional model
ü Custom security

Module 10: Scalability and Performance

  • Optimizing many-to-many dimensions
  • Server properties
  • Tools for monitoring performance
  • Formula engine (FE) vs storage engine (SE)
  • Reading queries in SQL Server Profiler

Module 11: Basic Maintenance and administration

  • SQL Server Management Studio
  • Backup and restore
  • Synchronization
  • Deployment