Build a Cube using SQL Server Analysis Services (SSAS)

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 KZbin channel.

[@DanielBaker-o6o]

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.

[@tomassarmiento2199]

Thanks. Can u make graphs with this cube?

[@statisticsandriskmodeling5477]

There are some graph-oriented multidimensional models.