Build a Cube using SQL Server Analysis Services (SSAS)

Просмотров 3,9 тыс.

% 43

A multidimensional model is composed of cubes and dimensions that can be annotated and extended to support complex query constructions.
BI developers create cubes to support fast response times, and to provide a single data source for business reporting.
I explained the key concepts of multidimensional models, and the process how to build the model.
Then I demonstrated how to build and use a multidimensional model with SSAS.
You are welcome to provide your comments and subscribe to my RU-vid channel.

Опубликовано:

4 июл 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 7

@user-vt3ym8ih7x Год назад

Very clear explanation. I don't necessarily need to build a cube, but I wanted to understand what one is, and this did that for me.

@statisticsandriskmodeling5477 Год назад

Glad my video is helpful

@rizwanrauf9347 Год назад

Very well explained and detail tutorial.

@hasanmougharbel8030 Год назад

Hey there, god bless your efforts in this channel. As a new sql learner i have only few enquires. I made my mind to work on database systems that are designed to perform data analytics and not merely transactional functions. Is it a good start to start by learning on sql server or i should consider other softwares. Also, is there any ETL tools that i should leverage right from the beginig to ease my learing process. I aim to start with any open source softwares or inexpensive solutions throughout my learning process. Thanks for taking care of this. Looking forward to learn from you.

@statisticsandriskmodeling5477 Год назад

You may start your learning with SQL Server/MySQL database. All different types of relational databases share common features. Just try to design and implement a simple database and you will learn a lot during the process.