Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

COURSE: Accelerated SQL Server 2012 Analysis Services

Design, develop, and deploy effective analytical solution that are both scalable and secure using SQL Server 2012 Analytics Services (SSAS).

COURSE DELIVERY OPTIONS

4-DAYS CLASSROOM

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

PRIVATE ONSITE

The course will take place in your company’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity. Request quote here.

Course Benefits

During the Analysis Services 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. The Analysis Services 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.

Who is this course designed for?
IT Professionals responsible for designing, developing, and deploying business intelligence solutions
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.

Pre-requisites: What do you need to know?
Basic experience with data warehouse solutions
A basic understanding of relational design and theory is helpful, as is basic familiarity with Structured Query Language (SQL).
No prior experience with any version of SQL Server Analysis Services is required.

Expert Mentors

Our instructors have faced in previous real case projects, the same problems you are facing now. Learn from experience professionals.

t

Interaction and Q&A

In all of our trainings, you will have the chance to ask individual questions and be capable of solving certain issues.

Course Coverage

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.

l

Design SSAS solutions that are both scalable and secure.

Successfully manage and deploy SSAS solutions in a development/test/production environment.

”Thank you very much, Dr. Tabladillo! It was a pleasure to participate in your workshop!”

COURSE OUTLINE

SECTION A: BI SOLUTION OVERVIEW

Module 00: Logical Query Processing

  • Introductions, course hours, and facilities information

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 data warehouse (RDW)
  • Business Intelligence Semantic Model (BISM) solutions, such as cubes and tabular solutions
  • Delivery and maintenance 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: Undestanding the Process

  • SQL Server Data Tools for BI development
  • The SSAS development process
    • Define data sources
    • Develop the model (multidimensional vs. tabular)
    • Deployment and processing
    • Maintenance

Module 04: Multidimensional Model: Creating Dimensions and Cubes

  • Data source views

Lab 04 A: Working with Data Source Views

  • Dimensions
  • Extended dimensionsLab 04 C: Extending Dimensions

Lab 04 B: Working with Dimensions

  • Building cubes
  • Relationships between measure groups and dimensionsLab 04 E: Working with Measure Groups and Dimensions

Lab 04 D: Building Cubes

Module 05: Multidimensional Model: Advanced Features

  • MDX
  • Calculated members
  • Named sets
  • Scoped assignments
  • Key Performance Indicators (KPIs)

Lab 05 A: Calculations and KPIs

  • Actions
  • Perspectives
  • Translations

Lab 05 B: Actions and Perspectives

Lab 05 C: Translations

Module 06: Tabular Model: Building Models

  • Models
  • Tables
  • Calculated columns
  • Calculated measures

Lab 06: Getting Started with SSAS Tabular Models

Module 07: Tabular Model: Advanced Features

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

Lab 07 A: Hierarchies, Calculations and KPIs

Lab 07 B: Perspectives and Visualization Options

 

SECTION C: COMPLETING THE SSAS SOLUTION TO BE PROPERLY MANAGED

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

  • Storage modes
    • Storage modes for the multidimensional model
    • Storage modes for the tabular model
  • Partitions
  • Aggregation designs
  • Proactive caching

Lab 08 A: Aggregations and Partitions

Lab 08 B: Partitions in the Tabular Model

Module 09: Security

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

Lab 09 A: Security in Multidimensional Models

Lab 09 B: Security in Tabular Models

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

Lab 10: Query Troubleshooting

Module 11: Basic Maintenance and administration

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

Lab 11 A: Backing Up, Restoring, and Deploying SSAS Databases (Multidimensional Model)

Lab 11 B: Deploying SSAS Databases (Tabular Model)

Would you like to register for this course?

Fill out the form at the top of this page