Create a Tabular Cube with SSAS! // step-by-step

[@KahanDataSolutions]

Looking for help with your team's data strategy? → www.kahandatasolutions.com Looking to improve your data engineering skillset?→ bit.ly/more-kds

[@andreacuellar895]

Hello how can I connect to the same server for practice?

[@edoze_ru]

What version of visual studio do you have? I don't have a point "PostgreSQL database", when I configure Data Sources.. (

[@mayrarosas7107]

Thanks this was so helpful!!

[@michaelpacia7356]

Exactly what I need, thank you mate!

[@KahanDataSolutions]

Glad to help!

[@techproductowner]

Excellent video . . could you please help me understand that . .what is the advantage of a tabluar model here. . I mean to say that we already have the same structure in SQL server dB . .and the same relationship . Why we didn't prefer to use the sql serer DB itself for our analysis . . what is the exact use case need of analysis service here

[@santoshatyam1409]

The advantage of using cube is large calculations are computed so fast . correct me if iam wrong

[@KahanDataSolutions]

A little late on this response here...but in addition to the other comment about performance, one major benefit of a cube is that it is intended to be designed to automatically understand relationships (think SQL joins) across multiple tables. Lets say you have a scenario where you want to show a measure (ex. a sum or count) sliced by a particular attribute (ex. customer, user, location, etc.). Using SQL in a typical relational DB, this may require multiple left/inner joins, where conditions, etc to get the result to display the way you want. However, using tabular cube, you can configure it through analysis services to understand how certain tables should relate (based on keys) and therefore it can automatically return this type of answer for you without any joins. You can simply drag and drop and the underlying engine does the equivalent of those SQL joins for you. Also, business users can connect to an Analysis Services cube through something like Microsoft Excel or Power BI. That means that business users who may not know SQL can easily interact with your data but it will be tightly controlled by you (the cube developer) based on how you manage the relationships, measure logic, visibility, etc. of the cube they are working with. Most of this happens in memory, which is a main reason why the performance is also really good. Hope this helps!

[@navc8550]

Nice video, concise and to the point.

[@KahanDataSolutions]

Glad it was helpful!

[@i.k.986]

Hi Kahan, thank you for the video. May I ask you why you are calling it tabular cube? Tabular and cube are two diffrent technologies... thx for replying

[@venkateshthammisetty7845]

Hi Can u pls let me know if u aware of , what is the use of the annotations in XMLA script, u will find these in XMLA script of Tabular Model?

[@ericmuga]

Wonderful, quite apt

[@KahanDataSolutions]

Thanks for watching!

[@faam-m6z]

Hi! I cant see "new data source" by clicking on data source. Can you help me please?

[@shidharthbammani5751]

can you make a tutorial about dimensional modelling or data warehousing in general that would be great .Thanks in advance

[@KahanDataSolutions]

Noted, thanks!

[@facumontenegro1]

Hello! I had a problem when I imported tables from SQL Server, the error said "Error returned: 'OLE DB or ODBC error: The credentials provided for the SQL source are invalid" Could you tell me How can I solve this? Thanks!!

[@KahanDataSolutions]

Looks like a credentials issue, meaning the username/password you used are not correct. Make sure you do not have any typos.

[@facumontenegro1]

@@KahanDataSolutions Thanks for your answer!! I tried with my database credentials and it worked! I will subscribe to your channel because your videos are really good. Keep it up!

[@KahanDataSolutions]

Awesome! Thank you so much! Glad you find them helpful.

[@maibagiangson4100]

I use SSMS ver 2019, I cant create Analys Service like you, and I cant install analys services from SQL Servcer Installer, how I can do ? plssss

[@KahanDataSolutions]

Have you followed steps similar to what is in this video? kzbin.info/www/bejne/ZnjYnneait6psNE

[@maibagiangson4100]

@@KahanDataSolutions yeah, it's working, tks you !

[@shikurnuriye6551]

Perfect !

[@KahanDataSolutions]

Thanks!

[@MrOnkuba]

Thanks

[@superfreiheit1]

When is SSAS better than SSMS?

[@KahanDataSolutions]

It isn't really an either/or type of thing as they are often used together. SSAS is the underlying services for building tabular/multi-dimensional cubes. SSMS is the user interface program for looking at different objects, which may be Database Services objects (ex. databases, schemas, tables, data rows) and also Analysis Services objects (ex. cubes).

[@CaptainKage]

well... from where do you know sa password?

[@KahanDataSolutions]

This is a user that was created on the sever in a previous video (in this same playlist). You would have to create your own user.

[@ash3rr]

SA is the system admin account on what I pressume is SQL Server. It's created when you install SQL Server and only the DBA should have access to this account in a PRD environment.