Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (1)
personalised to our understanding and data