Azure Data Engineering

 8.SSAS tabular model ?

Ans:

This is the most popular and interesting question which every interviewer will ask.

The tabular model era started form visual studio 2012 version on words and its keep on adding features to each 

version(2015,2017 till 2019).

1.Tabular Model:

a.This model is very faster compared to the multidimensional model.

b.The customized columns and measures can be added using DAX language.

c.Data can be export into a excel file and its useful to create Power Bi dashboard.

d.But in tabular only limitation is data if the data is more then the model get slow down.

Below are the steps to create tabular model:

Step1:

Step2:

Step3: Select data source

Step4: Select sql server 

Step5: Select the server name and the database where the tables exist

Step6:Select the option to get the data

Step7:We can use based on our requirement like,table select or qury writing

Step8:Select the dimension or facts which required for your model