Главная
Study mode:
on
1
Intro
2
Analysis Services
3
BI Application Architecture
4
Processing Analysis Services
5
Relational Data Sources
6
SSAS surrogate keys
7
Data source design
8
Network packet size
9
Connecting sources
10
Data source
11
Dimension design
12
Relationships
13
Key Columns
14
Relationship Type
15
Instance Selection
16
Attribute Relationships
17
Queue Design Best Practices
18
Measure Groups
19
Partitioning
20
Partition Strategy
21
Aggregations
22
Query Log
23
Wrapping Up
Description:
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.

SSAS Design and Performance Best Practices

PASS Data Community Summit
Add to list
0:00 / 0:00