Aspin High Impact Data Visualization with Power View, Power Map, and Power BI

1. Auflage 2014
ISBN: 978-1-4302-6617-4
Verlag: APRESS
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 536 Seiten, eBook

High Impact Data Visualization with Power View, Power Map, and Power BI helps you take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision-making. Learn to harness the power of Microsoft’s flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease. Learn the essential techniques needed to enhance the look and feel of reports and dashboards so that you can seize your audience’s attention and provide them with clear and accurate information. Also learn to integrate data from a variety of sources and create coherent data models displaying clear metrics and attributes. Power View is Microsoft's ground-breaking tool for ad-hoc data visualization and analysis. It's designed to produce elegant and visually arresting output. It's also built to enhance user experience through polished interactivity. Power Map is a similarly powerful mechanism for analyzing data across geographic and political units. Power Query lets you load, shape and streamline data from multiple sources. PowerPivot can extend and develop data into a dynamic model. Power BI allows you to share your findings with colleagues, and present your insights to clients. High Impact Data Visualization with Power View, Power Map, and Power BI helps you master this suite of powerful tools from Microsoft. You'll learn to identify data sources, and to save time by preparing your underlying data correctly. You'll also learn to deliver your powerful visualizations and analyses through the cloud to PCs, tablets and smartphones.Simple techniques take raw data and convert it into information.Slicing and dicing metrics delivers interactive insight.Visually arresting output grabs and focuses attention on key indicators.

Zielgruppe

Popular/general

Autoren/Hrsg.

Aspin, Adam

Inhaltsverzeichnis

1;Contents at a Glance;3
2;Contents;518
3;About the Author;534
4;About the Technical Reviewer;535
5;Acknowledgments;536
6;Introduction;5
7;Chapter 1: Self-Service Business Intelligence;7
7.1;The Microsoft Self-Service Business Intelligence Solution;7
7.1.1;The Excel BI Toolkit;8
7.1.2;Power BI;8
7.2;The Excel BI Toolkit and Power BI;8
7.2.1;Power Query;9
7.2.2;PowerPivot;9
7.3;Power View;10
7.3.1;Power Map;10
7.3.2;Power BI;10
7.4;Preparing the Self-Service BI Environment;11
7.4.1;PowerPivot;11
7.4.2;Power View;12
7.4.3;Power Query;13
7.4.4;Power Map;17
7.5;Power BI;17
7.5.1;Adding a Power BI Site;17
7.6;The Windows Power BI App;19
7.7;Corporate BI or Self-Service BI ?;19
7.8;The Excel Data Model;20
7.9;How This Book Is Designed to Be Read;21
7.9.1;Discovering Data;22
7.9.2;Creating a Data Model;22
7.9.3;Taking Data and Preparing It for Output;22
7.9.4;Taking Existing Excel BI and Sharing It;22
7.9.5;Delivering Geodata;22
7.9.6;Delivering Excel BI to Mobile Devices;22
7.9.7;To Learn the Product Suite Following a Real-World Path;23
7.10;The Self-Service Business Intelligence Universe;23
7.11;Conclusion;24
8;Chapter 2: Power View and Tables;25
8.1;The Power View Experience;26
8.1.1;Adding a Power View Sheet to an Excel Workbook;26
8.1.2;The Power View Interface;26
8.1.3;The Power View Ribbon;27
8.1.4;The Field List;29
8.1.5;Using the Field List;29
8.1.6;Renaming or Deleting a Power View Report;31
8.2;Tables in Power View;31
8.2.1;Adding a Table;31
8.2.2;Deleting a Table;34
8.2.3;Changing the Table Size and Position;34
8.2.4;Changing Column Order;34
8.2.5;Removing Columns from a Table;35
8.3;Types of Data;36
8.4;Data and Aggregations;37
8.5;Enhancing Tables;38
8.5.1;The Design Ribbon;38
8.5.2;Row Totals;40
8.5.3;Formatting Columns of Numbers;41
8.5.4;Default Formatting;42
8.5.5;Changing Column Widths;42
8.5.6;Font Sizes in Tables;43
8.5.7;Copying a Table;44
8.5.8;Sorting by Column;44
8.6;Table Granularity;45
8.7;Matrix Tables;46
8.7.1;Row Matrix;46
8.7.2;Column Matrix;48
8.7.3;Sorting Data in Matrix Tables;50
8.8;Drilling Through with Matrix Tables;52
8.8.1;Drilling Down;52
8.8.2;Drilling Up;54
8.8.3;Reapplying Matrix Visualization;54
8.8.4;Drilling Through with Column Hierarchies;54
8.9;Card Visualizations;56
8.9.1;Card Visualization Styles;58
8.9.2;Sorting Data in Card-View Tables;59
8.10;Switching Between Table Types;60
8.11;Key Performance Indicators (KPIs);60
8.12;Conclusion;61
9;Chapter 3: Filtering Data in Power View;62
9.1;Filters;62
9.1.1;Hiding and Displaying the Filters Area;63
9.2;View Filters;63
9.2.1;Adding Filters;64
9.2.2;The (All) Filter;65
9.2.3;Clearing Filters;66
9.2.4;Deleting Filters;66
9.2.5;Expanding and Collapsing Filters;67
9.2.6;Subsetting Large Filter Lists;67
9.2.6.1;Searching for Specific Elements in a Filter;68
9.2.6.2;Clearing a Filter Subset;68
9.2.6.3;Filtering with Wildcards;69
9.2.6.4;Clearing a Filter Element Search;70
9.3;Filtering Different Data Types;70
9.3.1;Numeric Data;70
9.3.1.1;Range Filter Mode;70
9.3.1.2;List Filter Mode;71
9.3.1.3;Quickly Excluding Outliers;73
9.3.2;Date and Time Data;73
9.3.3;Other Data Types;75
9.3.4;Multiple Filters;75
9.4;Advanced Filters;75
9.4.1;Applying an Advanced Filter;76
9.4.2;Clearing an Advanced Filter;77
9.4.3;Advanced Wildcard Filters;78
9.4.4;Numeric Filters;79
9.4.5;Date and Time Filters;80
9.4.6;Complex Filters;81
9.4.7;Advanced Text Filter Options;82
9.4.8;Advanced Numeric Filter Options;83
9.4.9;Advanced Date Filter Options;83
9.5;Visualization-Level Filters;84
9.5.1;Filter Hierarchy;85
9.6;Filtering Tips;87
9.6.1;Don’t Filter Too Soon;87
9.6.2;Drill-Down and Filters;87
9.6.3;Annotate, Annotate, Annotate;88
9.7;Conclusion;88
10;Chapter 4: Charts in Power View;89
10.1;A First Chart;89
10.1.1;Creating a First Chart;90
10.1.2;Deleting a Chart;93
10.1.3;Basic Chart Modification;93
10.1.4;Basic Chart Types;94
10.1.4.1;Column Charts;95
10.1.4.2;Line Charts;95
10.1.4.3;Pie Charts;96
10.2;Essential Chart Adjustments;97
10.2.1;Resizing Charts;98
10.2.2;Repositioning Charts;99
10.2.3;Sorting Chart Elements;99
10.2.4;Font Size;102
10.2.5;Applying Color to Bar and Column Charts;103
10.3;Multiple Data Values in Charts;103
10.3.1;Data Details;106
10.4;The Layout Ribbon;107
10.5;Enhancing Charts;108
10.5.1;Chart Legends;108
10.5.2;Chart Title;109
10.5.3;Chart Data Labels;109
10.6;Drilling Down;111
10.7;Popping Charts Out and In;115
10.8;Chart Filters;117
10.9;Conclusion;121
11;Chapter 5: Advanced Charting with Power View;122
11.1;Multiple Charts;122
11.1.1;Multiple Bar or Column Charts;122
11.1.2;Specifying Vertical and Horizontal Selections;124
11.2;Specifying the Layout of Multiple Chart Visualizations;125
11.2.1;Creating Horizontal Multiples;125
11.2.2;Defining the Multiples Grid;125
11.2.3;Multiple Line Charts;127
11.2.4;Multiple Pie Charts;129
11.2.5;Drilling Down with Multiple Charts;130
11.3;Scatter Charts;131
11.3.1;Drilling Down with Scatter Charts;133
11.3.2;Scatter Charts to Display Flattened Hierarchies;134
11.3.3;Scatter Chart Multiple s;135
11.4;Bubble Charts;136
11.4.1;Bubble Chart Data Labels and Legend;137
11.4.2;Multiple Bubble Elements;138
11.4.3;Bubble Chart Multiple s;140
11.5;Play Axis;141
11.5.1;Tiles with Charts;143
11.6;Conclusion;143
12;Chapter 6: Interactive Data Selection;144
12.1;Tiles;144
12.1.1;Creating a Tiled Visualization from Scratch;145
12.1.2;Adjusting Tile Display;146
12.2;Some Variations on Ways of Creating Tiled Visualizations;146
12.2.1;Creating a Tiled Visualization from Scratch—Another Variant;147
12.2.2;Adding Tiles to an Existing Visualization;147
12.2.3;Adding Tiles to an Existing Visualization—Another Variant;148
12.2.4;Modifying an Existing Visualization Inside a Tile Container;148
12.2.5;Re-creating a Visualization Using Existing Tiles;148
12.2.6;Re-creating a Visualization Using Existing Tiles—A Simple Variant;149
12.2.7;Removing Tiles from a Visualization;150
12.2.8;Deleting a Tile Visualization;151
12.2.9;Tile Types;151
12.2.10;Using Tiles;152
12.2.11;Filtering Tiles;152
12.2.12;Tiles with No Data;153
12.2.13;Changing the Inner Visualization;154
12.2.14;Tiles and Multiple Charts;155
12.3;Slicers;155
12.3.1;Adding a Slicer;155
12.3.2;Applying a Slicer;156
12.3.3;Clearing a Slicer;157
12.3.4;Deleting a Slicer;158
12.3.5;Modifying a Slicer;158
12.4;Using Charts as Slicers;158
12.4.1;Charts as Slicers;159
12.5;Highlighting Chart Data;160
12.5.1;Cross-Chart Highlighting;161
12.5.2;Highlighting Data in Bubble Charts;163
12.6;Charts as Filters;164
12.6.1;Scatter Chart Filtering;166
12.6.2;Column and Bar Charts as Filters;167
12.7;Choosing the Correct Approach to Interactive Data Selection;171
12.8;Filter Granularity;171
12.9;Conclusion;174
13;Chapter 7: Images and Presentation;175
13.1;Titles;175
13.1.1;Adding a Title;176
13.1.2;Moving and Resizing Titles;176
13.1.3;Formatting a Title;177
13.2;The Text Ribbon;177
13.3;Adding Text Boxes to Annotate a Report;178
13.3.1;Deleting Text Boxes;179
13.4;The Context Menu;179
13.5;Altering the Font Used in a Report;181
13.5.1;Font Family;181
13.5.2;Text Size;181
13.6;Altering the Theme of a Report;182
13.6.1;Deciphering Themes;184
13.7;Applying a Report Background;185
13.8;Images;188
13.8.1;Image Sources;188
13.8.2;Background Images;189
13.8.2.1;Adding a Background Image;189
13.8.2.2;Fitting a Background Image;190
13.8.2.3;Removing a Background Image;192
13.8.2.4;Setting an Image’s Transparency;192
13.8.3;Images in Tables;194
13.8.3.1;Resizing Images Used in Tables;194
13.8.4;Images in Slicers;195
13.8.5;Images in Tiles;196
13.8.6;Independent Images;197
13.9;Layering Visualizations;198
13.10;Some Uses for Independent Images;200
13.10.1;Image File Format;201
13.11;Preparing Images;201
13.12;Conclusion;202
14;Chapter 8: Mapping Data in Power View;203
14.1;Bing Maps;203
14.2;Maps in Power View;204
14.3;Adjusting Map Display in Power View;206
14.3.1;Positioning the Map Elements;206
14.3.2;Zooming In or Out;207
14.3.3;Removing or Adding a Map Title;207
14.3.4;Modifying the Map Background;208
14.3.5;Filtering Map Data;209
14.4;Multi-Value Series;210
14.4.1;Highlighting Map Data;212
14.4.2;Adjusting a Legend;214
14.5;Adding Tiles to Maps;216
14.6;Multiple Maps;217
14.6.1;Multiple Maps by Region;218
14.7;Drilling Down in Maps;219
14.8;Conclusion;221
15;Chapter 9: PowerPivot Basics;222
15.1;The PowerPivot Environment;222
15.1.1;Using PowerPivot;223
15.1.2;The PowerPivot Ribbons;224
15.1.2.1;The Home Ribbon;224
15.1.2.2;The Design Ribbon;226
15.1.2.3;The Advanced Ribbon;227
15.2;Loading Data into PowerPivot;227
15.2.1;Loading Data from SQL Server;228
15.2.2;Preview and Filter Tables;233
15.2.2.1;Preview and Filter Options;235
15.2.2.2;Writing Queries to Select Data;236
15.2.2.3;Filtering Data Using the Table Import Wizard Design Dialog;237
15.2.2.4;List of Tables or Write a Query?;240
15.3;Importing Other Tables from an Existing Source;241
15.4;Modifying Existing Imports;242
15.5;Loading Data from Excel;243
15.5.1;Copying and Pasting Data from an Excel Workbook;243
15.5.2;Appending Data from Excel;244
15.5.3;Updating a Copied Table;245
15.5.4;Importing Data from an Excel Workbook;246
15.5.5;PowerPivot Data Sources;247
15.6;Refreshing Data;248
15.6.1;Refreshing Data from External Data Sources;249
15.6.1.1;Refreshing a Single Table Connected to an External Data Source;249
15.6.1.2;Refreshing All the Tables in the Data Set Connected to an External Data Source;250
15.6.1.3;Refreshing All the Tables in the Data Set Connected to an External Data Source;251
15.6.2;Refreshing Data from Linked Excel Worksheets;251
15.6.2.1;Refreshing a Single Table Connected to an Excel Worksheet;251
15.6.2.2;Refreshing All the Tables in the Data Set Connected to Excel Worksheets;251
15.7;Deleting a Connection;252
15.8;PowerPivot Data Types;252
15.9;Managing PowerPivot Data;253
15.9.1;Manipulating Tables;253
15.9.1.1;Renaming Tables;253
15.9.1.2;Deleting a Table;253
15.9.1.3;Moving a Table;253
15.9.2;Moving Around a Table;254
15.9.2.1;Selecting a Column from the List of Available Column Names;255
15.9.2.2;Searching for Metadata;255
15.9.3;Manipulating Columns;256
15.9.3.1;Renaming a Column;256
15.9.3.2;Deleting Columns;257
15.9.3.3;Moving Columns;258
15.9.3.4;Setting Column Widths;259
15.9.3.5;Freezing Columns;259
15.9.3.6;Other Currency Formats;261
15.10;Formatting PowerPivot Tables;260
15.11;Manipulating Data in PowerPivot;262
15.11.1;Sorting Data in PowerPivot Tables;262
15.11.2;Filtering Data in PowerPivot Tables;263
15.11.2.1;Clearing Filters;265
15.11.2.2;Custom Filters—Text;265
15.11.2.3;Custom Filters—Numeric;266
15.11.2.4;Custom Filters—Date;267
15.12;Conclusion;268
16;Chapter 10: Extending the Excel Data Model Using PowerPivot;269
16.1;Designing a PowerPivot Data Repository;269
16.1.1;Data View and Diagram View;270
16.1.1.1;Diagram View Display Options;271
16.1.1.2;Maximizing a Table;272
16.1.2;Creating Relationships;272
16.1.3;Creating Relationships Manually;273
16.1.4;Creating Relationships Automatically;274
16.1.5;Deleting Relationships;275
16.1.6;Managing Relationships;275
16.2;Preparing a Date Table;276
16.2.1;Marking a Table as a Date Table;278
16.3;Calculations;279
16.4;Calculated Columns;279
16.4.1;Simple Calculations;280
16.4.2;Using Formulas in Calculated Columns;282
16.4.3;Looking Up Related Data;285
16.5;Making Good Use of the Formula Bar;286
16.5.1;Multiline Formulas;286
16.6;Calculated Fields;287
16.6.1;A First Calculated Field: Number of Cars Sold;287
16.6.2;Basic Aggregations in Calculated Fields;288
16.6.3;More Advanced Aggregations;290
16.6.3.1;How It Works;291
16.6.4;Time-Dependent Calculations;292
16.6.4.1;YearToDate, QuarterToDate, and MonthToDate Calculations;292
16.6.4.2;Comparisons with Previous Years, Quarters, or Months;293
16.6.4.3;How It Works;294
16.6.4.4;Rolling Aggregations over a Period of Time;294
16.6.4.5;How It Works;295
16.6.4.6;Comparison with a Parallel Period in Time;295
16.6.4.7;How It Works;296
16.6.5;Other Possibilities;297
16.6.5.1;How It Works;298
16.6.6;Putting It All Together;298
16.6.7;A Few Comments and Notes on Using Calculated Fields;298
16.7;Calculation Options;298
16.8;Creating Pivot Tables from PowerPivot;299
16.8.1;Creating a Pivot Table;300
16.8.2;The PowerPivot Ribbon;301
16.9;Copying Data from PowerPivot;302
16.10;Conclusion;303
17;Chapter 11: PowerPivot for Self-Service BI;304
17.1;Default Field Set;305
17.2;Table Behavior;305
17.2.1;Sort Column;306
17.2.2;Row Identifier;307
17.2.3;Keep Unique Rows;308
17.2.4;Default Label;308
17.2.5;Set a Default Aggregation (Summarize By);309
17.3;Preparing Images for Power View;310
17.3.1;Binary Images;311
17.3.2;Image URLs;311
17.3.3;Default Image;312
17.4;Preparing Hyperlinks for Power View;312
17.5;Creating Hierarchies;312
17.5.1;Modifying Hierarchies;313
17.5.1.1;Adding a Level to a Hierarchy;314
17.5.1.2;Removing a Level from a Hierarchy;314
17.5.1.3;Altering the Levels in a Hierarchy;314
17.5.2;Deleting a Hierarchy;315
17.5.3;Hiding the Original Field;315
17.5.4;Hiding Hierarchies from the Diagram View;315
17.6;Key Performance Indicators (KPIs);315
17.6.1;Creating a KPI;316
17.6.2;KPI Options;317
17.6.3;KPI Descriptions;319
17.6.4;Calculated KPI Targets;320
17.6.5;Modifying a KPI;320
17.6.6;Deleting a KPI;321
17.7;Perspectives;321
17.7.1;Creating a Perspective;321
17.7.2;Applying a Perspective;323
17.8;Data Categories;323
17.9;Hiding Columns from Client Tools;324
17.10;Preparing Data for Natural Language Querying;326
17.11;Optimizing File Size;326
17.12;Conclusion;327
18;Chapter 12: Discovering and Loading Data with Power Query;328
18.1;The Power Query Interface;329
18.1.1;The Power Query Ribbon;329
18.1.2;Data Sources;330
18.1.2.1;File Sources;331
18.1.2.2;Databases;331
18.1.2.3;Other Sources;332
18.2;Loading Data;333
18.2.1;Web Pages;333
18.2.1.1;The Navigator Window;336
18.2.1.2;The Peek Popup;337
18.2.1.3;The WorkBook Queries Window;337
18.2.2;CSV Files;339
18.2.2.1;What Is a CSV File ?;340
18.2.3;Text Files;340
18.2.4;XML Files;341
18.2.5;Excel;342
18.2.5.1;Excel Data from the Current Workbook;343
18.2.6;Microsoft Access Databases;344
18.2.6.1;Loading Multiple Tables;344
18.2.6.2;Loading the List of Tables;345
18.3;Relational Databases;345
18.4;Database Metadata;348
18.5;Data Discovery or Data Load?;349
18.5.1;Peeking at Data;350
18.5.2;Searching for Data;350
18.6;Conclusion;353
19;Chapter 13: Transforming Data with Power Query;354
19.1;Modifying Data;354
19.1.1;The Power Query Window;355
19.1.2;The Power Query Ribbons;356
19.1.2.1;The Home Ribbon;356
19.1.2.2;The Insert Ribbon;358
19.2;Dataset Shaping;359
19.2.1;Using First Row as Headers;359
19.2.1.1;Renaming Columns;360
19.2.1.2;Reordering Columns;360
19.2.1.3;Removing Columns;361
19.2.1.4;Removing Records;361
19.2.1.5;Removing Duplicate Records;363
19.2.1.6;Removing Errors;364
19.2.2;Filtering Data;364
19.2.2.1;Selecting Specific Values;364
19.2.2.2;Finding Elements in the Filter List;365
19.2.2.3;Filtering Text Ranges;366
19.2.2.4;Filtering Numeric Ranges;366
19.2.2.5;Filtering Date and Time Ranges;367
19.3;Extending Data;368
19.3.1;Duplicating Column;368
19.3.2;Splitting Columns;368
19.3.2.1;Splitting Column by a Delimiter;369
19.3.2.2;Splitting Columns by Number of Characters;370
19.3.2.3;Custom Columns;371
19.3.2.4;Index Column;373
19.4;Data Cleansing and Modification;374
19.4.1;Changing Datatype;374
19.4.2;Replacing Values;375
19.4.3;Transforming Column Contents;376
19.4.4;Filling Down;378
19.4.5;Sorting Data;379
19.5;Managing the Transformation Process;379
19.5.1;Modifying a Step;380
19.5.2;Renaming a Step;380
19.5.3;Deleting a Step or a Series of Steps;381
19.5.4;Adding a Step;382
19.5.5;Altering Process Step Sequencing;382
19.5.6;An Approach to Sequencing;382
19.6;Changing the Data Structure;383
19.6.1;Unpivoting Tables;383
19.6.2;Grouping Records;384
19.6.3;Merging Data;386
19.6.3.1;Adding Reference Data;386
19.6.3.2;Aggregating Data During a Merge Operation;388
19.7;Appending Data;390
19.7.1;Adding the Contents of One Query to Another;390
19.7.2;Adding Multiple Files from a Source Folder;391
19.8;Data Destinations;392
19.9;The Power Query View Ribbon;393
19.10;Effective Use of the Formula Bar;393
19.10.1;Replacing Value s;393
19.10.2;Transforming;394
19.10.3;Grouping;394
19.10.4;Extending a Filter;394
19.11;Conclusion;395
20;Chapter 14: Power Map;396
20.1;Bing Maps;396
20.2;Running Power Map;397
20.3;The Power Map Window;397
20.4;The Power Map Ribbon;398
20.5;Region Maps;399
20.6;Power Map Source Data;400
20.6.1;Refreshing Data;401
20.6.2;Geographical Data Types;401
20.6.2.1;Define the Data Category in the Data Model;401
20.6.2.2;Add Multiple Levels of Geographical Information;401
20.6.2.3;Select the Correct Geographical Data Type in Power Map;402
20.7;Using the Task Panel;402
20.7.1;Showing and Hiding the Task Panel;402
20.7.2;Task Panel Panes;402
20.7.3;The Task Panel Data Views;404
20.7.4;Removing a Field;404
20.8;Moving Around in Power Map;405
20.8.1;Moving Around a Map;405
20.8.2;Zooming In or Out;406
20.8.3;Changing the Pitch of a Map;406
20.8.4;Flat Map and 3-D Globe;406
20.8.5;Going to a Specific Location;406
20.9;Power Map Aggregations;407
20.10;Map Types;408
20.11;The Various Map Types, by Example;409
20.11.1;Bubble Maps;409
20.11.2;Column Maps;412
20.11.2.1;Clustered Columns;413
20.11.2.2;Stacked Columns;414
20.11.3;Heat Maps;415
20.11.4;Region Maps;416
20.12;Presentation Options;417
20.12.1;The Settings View;417
20.12.1.1;Bubble Map Settings;419
20.12.1.2;Column Map Settings;419
20.12.1.3;Column Shapes;420
20.12.1.4;Region Map Settings;420
20.12.1.5;Heat Map Settings;420
20.13;Power Map Themes;421
20.13.1;Text Boxes;422
20.14;Timelines;424
20.14.1;Adding a Timeline;424
20.14.2;Using a Timeline;426
20.14.2.1;Playing the Timeline;426
20.14.2.2;Pausing the Timeline;426
20.14.2.3;Selecting Points along the Timeline;426
20.14.2.4;Setting Timeline Duration;427
20.14.2.5;Hiding the Time Decorator;428
20.14.2.6;Hiding the Timeline;428
20.14.2.7;Setting the Date Range for Playback;429
20.14.2.8;Date and Time Formats in the Time Decorator;429
20.15;Using Layers;430
20.15.1;2-D Charts;432
20.15.2;2-D Chart Types;433
20.15.3;Hiding the Map Data;433
20.16;Power Map Tours;434
20.16.1;Creating Power Map Tours;435
20.16.2;Deleting a Power Map Tour;436
20.17;Power Map Movies;437
20.17.1;Transitions;438
20.17.2;Exporting a Movie;438
20.18;Conclusion;440
21;Chapter 15: Self-Service Business Intelligence with Power BI;441
21.1;Using Excel Workbooks in Power BI;442
21.1.1;Adding a Workbook;442
21.1.2;Enabling Team Site Excel Files;444
21.1.3;Adding a Workbook to Featured Reports;445
21.1.4;Marking a Workbook as a Favorite;446
21.1.5;Interacting with a Workbook;447
21.1.5.1;Interacting with Power View in the Excel Web App;447
21.1.5.2;Editing Excel in the Excel Web App;448
21.1.5.3;Editing a BI Workbook in Excel;451
21.1.6;Downloading a Copy of an Excel Workbook;452
21.1.7;Removing a Workbook from Power BI;455
21.2;The Power BI App on Tablet Devices;455
21.2.1;Running the Power BI App;456
21.2.2;Adding Reports to the Power BI App from the Power BI Site;457
21.2.3;Removing Reports from the Power BI App;460
21.2.4;Using Reports in the Power BI App;460
21.2.4.1;Opening a Report in the Power BI App;461
21.2.4.2;Filtering a Report in the Power BI App;461
21.2.4.3;Highlighting or Slicing Data in a Report in the Power BI App;462
21.2.4.4;Switching Reports in the Power BI App;463
21.2.5;Synchronizing the Power BI App with the Power BI Site;464
21.3;Power BI on Other Mobile Devices;464
21.4;Keeping Power BI Data Up to Date;465
21.5;Data Management Gateway;466
21.5.1;Download a Data Management Gateway to a Workstation or Server on the Corporate Network;466
21.5.2;Installing and Configuring a Data Management Gateway from the Power BI Admin Page;475
21.5.3;The Data Management Gateway Application;477
21.5.3.1;Reregistering a Data Management Gateway Key with the Data Management Gateway Application;477
21.5.3.2;Changing Data Management Gateway Parameters;478
21.5.3.3;Stopping and (Re)Starting a Gateway;480
21.5.4;Deleting a Gateway;480
21.6;Data Sources;480
21.6.1;Using a Connection String to Determine Connection Settings;486
21.6.2;Deleting a Data Source;488
21.7;Data Refresh;489
21.7.1;Scheduled Data Refresh;489
21.7.2;Ad-Hoc Data Refresh;490
21.8;Using Data Sources;491
21.8.1;Shared Queries;491
21.8.1.1;Sign In to Power Bi from Power Query;491
21.8.1.2;Sharing Queries;492
21.8.1.3;Using a Shared Query;494
21.8.1.4;Searching for Shared Queries;494
21.8.1.5;Deleting a Shared Query;495
21.8.1.6;Editing Shared Query Settings;495
21.8.2;OData Feeds;495
21.9;My Power BI;496
21.10;Power BI Admin;497
21.10.1;Role Management;497
21.10.2;The Data Steward Group;498
21.10.3;Checking System Health;499
21.10.4;Exporting System Health Logs;500
21.11;Natural Language Querying;500
21.12;Conclusion;502
22;Chapter 16:Sample Data;503
22.1;Downloading the Sample Data;503
22.2;The Sample Data;503
22.3;Sample Files;504
22.4;Sample Database;504
23;Index;506

Über Autor(innen)

Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for seventeen years, and Business Intelligence has been his principal focus for the last ten years. He has applied his skills for a range of clients, including J.P. Morgan, The Organisation for Economic Co-operation and Development (OECD), Tesco, Centrica, Harrods, Vodafone, Crédit Agricole, Cartier, Alfred Dunhill, The RAC and EMC Conchango.Adam is a graduate of Oxford University. He is a frequent contributor to SQLServerCentral.com. He has written numerous articles for various French IT publications. A fluent French speaker, Adam has worked in France and Switzerland for many years. He is the author of SQL Server 2012 Data Integration Recipes (Apress, 2012), and of High Impact Data Visualization with Power View Power Map, and Power BI (Apress, 2014).