Get in Touch
 Duration 14 hours

Course Outline

Introduction to SQL Server Analysis Services (SSAS)

  • Key concepts in Business Intelligence
  • The function of SSAS within the Microsoft BI landscape
  • Analysis of SSAS architecture and its constituent parts
  • Interactions between SSAS, SSIS, SSRS, and Power BI

Installation and Configuration of SSAS

  • Setting up SQL Server Analysis Services
  • Configuration of SSAS environments
  • Comprehension of deployment modes:
    • Multidimensional models
    • Tabular models
  • Oversight of SSAS databases and instances

Concepts in Business Intelligence and Data Analytics

  • Insight into data warehouses and analytical frameworks
  • Conversion of operational data into business intelligence
  • Architecting analytical solutions for strategic decisions
  • Fundamentals of OLAP and analytical processing

SSAS Data Modeling

  • Foundations of multidimensional data structures
  • Structuring dimensions and measures
  • Construction of cubes and analytical frameworks
  • Establishing connections among data objects
  • Adherence to best practices in BI data modeling

Managing SSAS Tabular Models

  • Understanding the architecture of tabular models
  • Creation and administration of tabular structures
  • Interrogating tabular datasets
  • Utilization of calculations and analytical expressions
  • Enhancement of tabular model efficiency

Querying Multidimensional Data via MDX

  • Basics of MDX (Multidimensional Expressions)
  • Querying cubes and their dimensions
  • Development of calculated members and measures
  • Filtering and analysis of multidimensional datasets

Advanced SSAS Capabilities

  • Utilization of Columnstore Index technology
  • Enhancement of analytical query speed
  • Refined integration with SSIS
  • Overview of Master Data Services (MDS) interoperability

Deploying BI Solutions using SSAS

  • Release of SSAS solutions into production settings
  • Linking SSAS models with client-side applications
  • Integration with reporting and visualization platforms
  • Support for enterprise-level BI use cases

Troubleshooting and Performance Tuning

  • Monitoring of SSAS performance metrics
  • Detection of typical configuration errors
  • Optimization of queries and data models
  • Implementation of SSAS administrative best practices

Practical Workshop and Course Recap

  • Construction of analytical models via SSAS
  • Development and interrogation of BI solutions
  • Examination of real-world SSAS deployment scenarios
  • Recap of core concepts and recommended next steps

Requirements

  • Familiarity with data analysis principles
  • Practical experience using Microsoft SQL Server

Number of participants


Price per participant (excl. VAT)

Testimonials (1)

Upcoming Courses

Related Categories