model, with a single fact...FIGURE 13-2: Snowflake schemas are less efficient, causing Power Pivot to perfo...FIGURE 13-3: Slicers work together to show relevant data items based on a selec...FIGURE 13-4: Deselecting the Visually Indicate Items option with No Data disabl...14 Chapter 14FIGURE 14-1: Hover the cursor over a query to get quick information, including ...FIGURE 14-2: Queries can be organized into groups.FIGURE 14-3: Use the Choose Columns command to find and select columns faster.FIGURE 14-4: Get in the habit of renaming applied steps.FIGURE 14-5: Create a new query from an existing column.FIGURE 14-6: The Query Dependencies dialog box displays how each of your querie...FIGURE 14-7: Use the Global Data Load options to set a default load behavior.FIGURE 14-8: Power Query automatically adds a step to change data types when da...FIGURE 14-9: Disabling the type detection feature.FIGURE 14-10: Disabling the privacy-level settings.FIGURE 14-11: Disabling relationship detection.
Guide
1 Cover
4 Table of Contents
6 Index
Pages
1 i
2 ii
3 1
4 2
5 3
6 4
7 5
8 6
9 7
10 8
11 9
12 10
13 11
14 12
15 13
16 14
17 15
18 17
19 18
20 19
21 20
22 21
23 22
24 23
25 24
26 25
27 26
28 27
29 28
30 29
31 30
32 31
33 32
34 33
35 34
36 35
37 36
38 37
39 38
40 39
41 40
42 41
43 42
44 43
45 44
46 45
47 46
48 47
49 48
50 49
51 50
52
