►► The Starter Guide for Modern Data (Free PDF) → www.kahandatasolutions.com/startermds
@shidharthbammani57512 жыл бұрын
can you make a tutorial about dimensional modelling or data warehousing in general that would be great .Thanks in advance
@KahanDataSolutions2 жыл бұрын
Noted, thanks!
@edoze_ru3 жыл бұрын
What version of visual studio do you have? I don't have a point "PostgreSQL database", when I configure Data Sources.. (
@venkateshthammisetty78452 жыл бұрын
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?
@mayrarosas7107 Жыл бұрын
Thanks this was so helpful!!
@techproductowner3 жыл бұрын
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
@santoshatyam14093 жыл бұрын
The advantage of using cube is large calculations are computed so fast . correct me if iam wrong
@KahanDataSolutions2 жыл бұрын
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!
@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
@michaelpacia7356 Жыл бұрын
Exactly what I need, thank you mate!
@KahanDataSolutions Жыл бұрын
Glad to help!
@ericmuga Жыл бұрын
Wonderful, quite apt
@KahanDataSolutions Жыл бұрын
Thanks for watching!
@andreacuellar8957 ай бұрын
Hello how can I connect to the same server for practice?
@navc8550 Жыл бұрын
Nice video, concise and to the point.
@KahanDataSolutions Жыл бұрын
Glad it was helpful!
@user-wy4sz3gv5r Жыл бұрын
Hi! I cant see "new data source" by clicking on data source. Can you help me please?
@MrOnkuba3 жыл бұрын
Thanks
@shikurnuriye65512 жыл бұрын
Perfect !
@KahanDataSolutions2 жыл бұрын
Thanks!
@facumontenegro13 жыл бұрын
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!!
@KahanDataSolutions3 жыл бұрын
Looks like a credentials issue, meaning the username/password you used are not correct. Make sure you do not have any typos.
@facumontenegro13 жыл бұрын
@@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!
@KahanDataSolutions3 жыл бұрын
Awesome! Thank you so much! Glad you find them helpful.
@maibagiangson41003 жыл бұрын
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
@KahanDataSolutions3 жыл бұрын
Have you followed steps similar to what is in this video? kzbin.info/www/bejne/ZnjYnneait6psNE
@maibagiangson41003 жыл бұрын
@@KahanDataSolutions yeah, it's working, tks you !
@superfreiheit12 жыл бұрын
When is SSAS better than SSMS?
@KahanDataSolutions2 жыл бұрын
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).
@CaptainKage2 жыл бұрын
well... from where do you know sa password?
@KahanDataSolutions2 жыл бұрын
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.
@ash3rr2 жыл бұрын
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.