Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 114 of 212

102 C H A P T E R 6 | More analytics Figure 6-3: Using the sample data view in DirectQuery mode to analyze data in Excel. If you create a sample partition for one table, you should create sample partitions for all tables. Otherwise, when you use the Analyze Table In Excel option, you see null values for columns in tables without a sample partition. For example, in Figure 6-4, CalendarYear is placed in rows but displays null values, and Total Sales is a measure added to the Internet Sales table for which sample data is defined. Figure 6-4: Viewing sample data for multiple tables in Excel in which a sample partition is defined for Internet Sales only. Your sample partition can be a copy of the partition's data, if you prefer that. Simply make a copy of the DirectQuery partition and omit the addition of a WHERE clause. This approach is useful if your table is relatively small, and it also allows you to better confirm that the sample partitions defined for other tables are correct, as shown in Figure 6-5. Figure 6-5: Viewing sample data for multiple tables in Excel after adding a sample partition for the Date table. Working with calculated tables A new feature for tabular models in SQL Server 2016 is the calculated table—as long as you are working with a model that is not in DirectQuery mode. A calculated table is built by using a DAX expression. A model that includes calculated tables might require more memory and more processing time than a model without calculated tables, but it can be useful in situations for which you do not have an existing data warehouse with cleansed and transformed data. This technique is useful in the following situations:

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016