Analyzing your model in Excel
Do you want to see how your model would look in Excel? Before we get to the deployment and other more enterprise or server options related to Tabular Models, you should have a look at your model in a client tool. This capability is built into SSDT.
How to do it…
A good time to analyze your model is before deploying it:
In the Model menu on the ribbon, choose Analyze in Excel.
You will be prompted to choose a few options that we will discuss later. Leave the defaults and click on OK.
In Excel, you can use the Pivot Table to check measures, hierarchies, and KPIs that you have created so far. This is a nice, quick check on how your data will look to an end user.
There's more…
When you first choose to analyze the data in Excel, you are presented with multiple options about how you want to view the data. As you can see, you have the option to choose different users, roles, and perspectives when analyzing the data. This will allow you to verify security settings (users and...
