23/04/20
--------
https://www.youtube.com/watch?v=eMDGPHBFzOQ (Tabular model calculations info)
----------
22/04/20
------------
NT Service\MSOLAP$MSSQLSERVER1TAB
20/04/20
----------
https://zoom.us/meeting/register/uJYoceuvpj8svnAc4V2_mblU1ZnycZZADQ/success?
user_id=qdzWEQFhTwKPCLxYIHRYmQ&timezone_id=Asia%2FCalcutta
Please click this URL to join. https://zoom.us/w/525627846?
tk=RVQG7fKh7NTIPBjw1h6TmRn_bzFjlrIXg52AiwPn3Oc.DQEAAAAAH1RxxhZxZHpXRVFGaFR3S1BDTHhZ
SUhSWW1RAA
Meeting ID:
525-627-846
-----------------
11/04/20
-----------------
1) Composite Models:
--> High scale capabilities like direct queries
--> Cube and Tabular Model
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
https://www.nagabiblog.com/powerbi-interviewquestions
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Youtube : Power Bi Interveiw Questions and Answers
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
15/04/20
++++++++++++++++++++++++++++++++++++++++
http://www.learnmsbitutorials.net/install-msbi-step-by-step-for-beginners.php
MSBI Tutorial for beginners
difference between relational and multidimensional database
tabular vs multidimensional ( https://www.youtube.com/watch?v=Y0hWQh7EJME )
olap cube ( https://www.youtube.com/watch?v=yoE6bgJv08E )
ssas interview questions & answers ( https://www.youtube.com/watch?
v=vnAxeq0ysdc&list=PLwJL6NTye3dbCNtPn33wWj2UmlkBy7pz1&index=3 )
msbi tutorial beginners - ssas introduction ( https://www.youtube.com/watch?
v=YfTXtaoLaeI )
ssis ssrs ssas tutorial
Power BI: Data Refresh ad SSAS On-Premises Connectivity
( https://www.youtube.com/watch?v=3ZhqVXOVVzw )
ssrs multi dimensional model power bi
ssas cube design ( https://www.youtube.com/watch?v=CgtCRK9rTGs )
create ssas in visual studio
mdx queries in ssas
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?
view=sql-server-ver15
Server=localhost;Database=master;Trusted_Connection=True;
C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200417_182835
C:\SQL2019\Evaluation_ENU
C:\Program Files\Microsoft SQL Server\150\SSEI\Resources
------------------------------------------------------------
run below commmand from command prompt
-- sqlcmd -S CTSHYDC5098077 -E
--
select @@Version
go
-----------------------------------------------------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------------------------------------------------
---------------------------------------------------
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build
17763: )
(1 rows affected)
1>
-------------------------------------------------------------------
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-
ssms?redirectedfrom=MSDN&view=sql-server-ver15
-----------------------------------------------------
19/04/20:
https://docs.microsoft.com/en-us/analysis-services/comparing-tabular-and-
multidimensional-solutions-ssas?view=asallproducts-
allversions&viewFallbackFrom=sql-server-ver15
---------------------------------------------------------------------
