Building Multidimensional Models in SSAS
This course leads you through the necessary steps to create a multidimensional model, explains essential concepts unique to online analytical processing, and shows you how to manage data storage and model updates on an ongoing basis.
What you'll learn
An SQL Server Analysis Services (SSAS) multidimensional model provides a much better data structure for analysis than a traditional relational model, but you need a completely different set of skills. In this course, Building Multidimensional Models in SSAS, you will learn the foundational knowledge needed to build a complete multidimensional model from a simplified data warehouse stored in SQL Server relational tables. First, you will discover how to properly prepare your data for use in a multidimensional model and will be introduced to key terms and concepts applicable to generic dimensional modeling. Next, you will learn how to build out the core components of a multidimensional model with an emphasis on practical application. Finally, you will explore the Analysis Services features that help you optimize the query performance, management operations, and data storage efficiency of the multidimensional model. When you are finished with this course, you will have the skills and knowledge of SSAS multidimensional modeling needed to load your own data into dimensions and cubes for reporting and analysis.
Table of contents
- Building a Basic Multidimensional Model 2m
- SQL Server Data Tools 3m
- Data Source 4m
- Data Source View 3m
- Demo: Creating a Data Source View 5m
- Dimension Development 3m
- Demo: Creating Your First Dimension 7m
- Demo: Creating the Remaining Dimensions 4m
- Optional Dimension Development Tasks 5m
- Cube Development 3m
- Demo: Using the Cube Wizard 6m
- Deployment and Processing 7m
- Summary 3m
- Keeping a Multidimensional Model Up-to-date 2m
- Deployment in SSDT 3m
- Demo: Using the Build, Deploy, and Process Commands 7m
- Deployment Wizard 2m
- Demo: Using the Deployment Wizard 7m
- Process Command 3m
- Demo: Processing a Dimension and a Cube 6m
- Processing Options 6m
- Demo: Executing Process Update, Process Full, Process Data, and Process Index 8m
- Summary 2m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.