Explore best practices for scalable SQL Server Analysis Services (SSAS) cube design in this one-hour conference talk. Delve into dimension design, SSAS engine internals, and multidimensional design patterns to optimize SSAS cubes for your organization's needs. Learn about BI application architecture, processing Analysis Services, relational data sources, SSAS surrogate keys, network packet size, dimension design, relationships, measure groups, partitioning strategies, and aggregations. Apply these performance design patterns to new and existing cubes for a better-tuned SSAS cube environment.
Overview
Syllabus
Intro
Analysis Services
BI Application Architecture
Processing Analysis Services
Relational Data Sources
SSAS surrogate keys
Data source design
Network packet size
Connecting sources
Data source
Dimension design
Relationships
Key Columns
Relationship Type
Instance Selection
Attribute Relationships
Queue Design Best Practices
Measure Groups
Partitioning
Partition Strategy
Aggregations
Query Log
Wrapping Up
Taught by
PASS Data Community Summit
