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.
Course info
Level
Beginner
Updated
Dec 26, 2019
Duration
3h 51m
Table of contents
Course Overview
Creating Tables for a Multidimensional Model
Building a Basic Multidimensional Model
Solving Common Problems in Dimension Design
Solving Common Problems in Measure Group Design
Optimizing the Multidimensional Model
Keeping the Multidimensional Model Up-to-date
Description
Course info
Level
Beginner
Updated
Dec 26, 2019
Duration
3h 51m
Description

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.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Designing SSIS Integration Solutions
Beginner
2h 41m
Jun 18, 2020
Securing SSAS Models
Advanced
1h 40m
Apr 10, 2020
Tuning SSAS Models
Advanced
3h 3m
Mar 10, 2020
More courses by Stacia Misner Varga
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, everyone. My name is Stay Shebaa RGA and welcome to my course building multi dimensional models in as a C s. I work with data all the time. Is a consultant helping my clients use and understand their data. And as an instructor and author, teaching people how to build data solutions and work with data effectively Analysis service is multi dimensional. Models is a very long but official way to refer to cubes on the sequel server platform. On the one hand, cubes are an old technology. I've been building them for over 20 years myself, but on the other hand, they're still around for good reason. Because cubes air much betterthan relational database technology. When it comes to enabling users toe, ask an answer a series of questions in quick succession. This course is going to show you how to think about your data in the context of these types of questions before you start building a cube and then lead you through the basic development steps and management tasks. Some of the major topics that will cover include source state of preparation, key development tasks, important features related to query performance and storage efficiency, and ongoing data management tasks. By the end of this course, you'll be able to use your own data sources to create a multi dimensional model in analysis. Service is before beginning the course. You should be familiar with relation all database technology and how to write and execute sequel queries. Afterwards, you can continue your learning with more advanced courses at Pluralsight on tuning, managing and securing analysis service is multi dimensional models. Come join me on this journey to learn about cube development with the building multi dimensional models in S S S course a Pluralsight.