Atjaunināt sīkdatņu piekrišanu

E-grāmata: Pro Power BI Desktop

5.00/5 (4 ratings by Goodreads)
  • Formāts: PDF+DRM
  • Izdošanas datums: 08-Dec-2017
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484232101
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 42,82 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
Pro Power BI DesktopPalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 08-Dec-2017
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484232101
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features, including combo charts, Cartesian charts, trend lines, use of gauges, and more. Also covered are Top-N features, the ability to bin data into groupings and chart the groupings, and new techniques for detecting and handling outlier data points.

You can take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease and then add metrics and KPIs to project the insights that create your competitive advantage. Make raw data into clear, accurate, and interactive information with Microsoft’s free self-service business intelligence tool.

Pro Power BI Desktop shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You’ll be able to deliver those results on the PC, tablets, and smartphones, as well as share results via the cloud. This book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you.

What You'll Learn
  • Deliver attention-grabbing information, turning data into insight
  • Mash up data from multiple sources into a cleansed and coherent data model
  • Create dashboards that help in monitoring key performance indicators of your business
  • Build interdependent charts, maps, and tables to deliver visually stunning information
  • Share business intelligence in the cloud without involving IT
  • Deliver visually stunning and interactive charts, maps, and tables
  • Find new insights as you chop and tweak your data as never before
  • Adapt delivery to mobile devices such as phones and tablets
Who This Book Is For

Everyone from CEOs and Business Intelligence developers to power users and IT managers



Tagline: Free interactive data analysis and visualization for the desktop
About the Author xxix
About the Technical Reviewer xxxi
Acknowledgments xxxiii
Introduction xxxv
Chapter 1 Introduction to Power BI Desktop
1(38)
The Microsoft Self-Service Business Intelligence Solution
2(2)
Importing Data from Diverse Sources
2(1)
Modeling Your Data
3(1)
Creating Reports and Dashboards
3(1)
Power BI Desktop Files
3(1)
The Power BI Universe
4(1)
Installing Power BI Desktop
4(6)
Removing Power BI Desktop
9(1)
Running Power BI Desktop
9(1)
A First Power BI Desktop Dashboard
10(4)
Loading the Source Data
11(3)
The Data Load Process
14(1)
The Navigator Window
14(1)
The Navigator Data Preview
14(1)
Modifying Data
15(1)
The Power BI Desktop Window
15(2)
Your First Visualizations
17(9)
Displaying Available Fields
17(1)
Adding a Matrix of Sales per Country by Year
18(2)
Adding a Column Chart of Delivery Charge by Model
20(2)
Adding a Map of Labor Cost by Country
22(1)
Adding a Card Showing the Total Cost of Spare Parts
23(1)
Adding a Slicer by Make
24(1)
Arranging the Dashboard
25(1)
Interactivity in Dashboards
26(2)
Formatting Reports
28(7)
The Format Pane
29(1)
Borders
29(1)
Background Color
30(1)
Titles
31(1)
Table Gridlines
32(1)
Data Colors
33(2)
Creating and Modifying Reports
35(3)
Adding Pages
36(1)
Renaming Pages
36(1)
Deleting Pages
36(1)
Moving Pages
37(1)
Duplicating Pages
37(1)
Scrolling Through Collections of Pages
37(1)
Conclusion
38(1)
Chapter 2 Discovering and Loading File-Based Data with Power BI Desktop
39(26)
The Power BI Desktop Query Editor
40(1)
Data Sources
40(2)
File Sources
41(1)
Loading Data
42(14)
CSV Files
42(4)
Text Files
46(2)
Text and CSV Options
48(1)
XML Files
49(1)
Excel Files
50(1)
Importing Excel and Power View Items
51(3)
Microsoft Access Databases
54(1)
JSON Files
55(1)
Loading Multiple Files from a Directory
56(3)
Loading the Contents of a Folder
59(1)
The Navigator Dialog
59(3)
Searching for Datasets
60(1)
Display Options
61(1)
Refresh
61(1)
Adding Your Own Data
62(1)
Conclusion
63(2)
Chapter 3 Loading Data from Databases and Data Warehouses
65(46)
Relational Databases
65(2)
SQL Server
67(14)
Automatically Loading Related Tables
71(1)
Database Options
71(3)
Searching for Tables
74(7)
Oracle Databases
81(4)
Other Relational Databases
85(1)
Microsoft SQL Server Analysis Services Data Sources
86(5)
Analysis Services Cube Tools
89(2)
SSAS Tabular Data Warehouses
91(2)
Import or Connect Live
93(1)
ODBC Sources
93(7)
OLE DB Data Sources
100(4)
Modifying Connections
104(2)
Changing Permissions
106(2)
Refreshing Data from Databases and Data Warehouses
108(1)
Refreshing the Entire Data in the Power BI Desktop In-Memory Model
108(1)
Refreshing an Individual Table
109(1)
Conclusion
109(2)
Chapter 4 DirectQuery and Connect Live
111(14)
DirectQuery and Connect Live
111(1)
Microsoft SQL Server Data
112(4)
SQL Server Analysis Services Dimensional Data
116(3)
Microsoft SQL Server Analysis Services Tabular Data Sources
119(2)
DirectQuery with Non-Microsoft Databases
121(1)
DirectQuery and In-Memory Tables
122(1)
DirectQuery and Refreshing the Data
123(1)
Conclusion
123(2)
Chapter 5 Loading Data from the Web and the Cloud
125(34)
Web and Cloud Services
125(2)
Web Pages
126(1)
Online Services
126(1)
Microsoft Azure
126(1)
Web Pages
127(5)
Advanced Web Options
130(1)
Table View or Web View
131(1)
Salesforce
132(7)
Loading Data from Salesforce Objects
133(5)
Salesforce Reports
138(1)
Microsoft Dynamics 365
139(3)
Google Analytics
142(4)
OData Feeds
146(2)
OData Options
147(1)
Azure SQL Database
148(3)
Azure SQL Data Warehouse
151(2)
Connecting to SQL Server on an Azure Virtual Machine
153(3)
Azure Blob Storage
156(2)
Azure Security
158(1)
Conclusion
158(1)
Chapter 6 Dealing with Datasets
159(38)
Power BI Desktop Queries
160(3)
Editing Data After a Data Load
160(2)
Transforming Data Before Loading
162(1)
Query or Load?
163(1)
The Power BI Desktop Query Editor
164(7)
The Applied Steps List
165(1)
The Power BI Desktop Query Editor Ribbons
165(6)
Dataset Shaping
171(7)
Renaming Columns
171(1)
Reordering Columns
172(1)
Removing Columns
173(1)
Choosing Columns
173(2)
Merging Columns
175(2)
Going to a Specific Column
177(1)
Removing Records
178(4)
Keeping Rows
179(2)
Removing Duplicate Records
181(1)
Sorting Data
182(2)
Reversing the Row Order
183(1)
Undoing a Sort Operation
183(1)
Filtering Data
184(7)
Selecting Specific Values
184(1)
Finding Elements in the Filter List
185(1)
Filtering Text Ranges
186(1)
Filtering Numeric Ranges
186(1)
Filtering Date and Time Ranges
187(2)
Filtering Data
189(1)
Applying Advanced Filters
190(1)
Grouping Records
191(4)
Simple Groups
191(2)
Complex Groups
193(2)
Saving Changes in the Query Editor
195(1)
Exiting the Query Editor
195(1)
Conclusion
196(1)
Chapter 7 Data Transformation
197(36)
Viewing a Full Record
198(1)
Power BI Desktop Query Editor Context Menus
199(1)
Using the First Row As Headers
200(1)
Changing Data Type
200(5)
Detecting Data Types
202(1)
Data Type Indicators
203(1)
Switching Data Types
204(1)
Data Type Using Locale
204(1)
Replacing Values
205(2)
Transforming Column Contents
207(10)
Text Transformation
207(1)
Adding a Prefix or a Suffix
208(1)
Removing Leading and Trailing Spaces
209(1)
Removing Non-Printing Characters
209(1)
Number Transformations
210(7)
Filling Down Empty Cells
217(2)
Extracting Part of a Column's Contents
219(2)
Advanced Extract Options
220(1)
Duplicating Columns
221(1)
Splitting Columns
222(3)
Splitting Column by a Delimiter
222(2)
Splitting Columns by Number of Characters
224(1)
Merging Columns
225(1)
Custom Columns
226(2)
Creating Columns from Examples
228(2)
Adding Conditional Columns
230(1)
Index Columns
231(1)
Conclusion
232(1)
Chapter 8 Data Mashup
233(30)
The Power BI Desktop Query Editor View Ribbon
234(1)
Merging Data
235(11)
Adding Data
235(3)
Aggregating Data During a Merge Operation
238(2)
Types of Join
240(2)
Joining on Multiple Columns
242(1)
Preparing Datasets for Joins
243(1)
Correct and Incorrect Joins
244(1)
Examining Joined Data
244(2)
The Expand and Aggregate Buttons
246(1)
Appending Data
246(5)
Adding the Contents of One Query to Another
247(1)
Adding Multiple Files from a Source Folder
247(3)
Removing Header Rows After Multiple File Loads
250(1)
Changing the Data Structure
251(3)
Unpivoting Tables
251(2)
Pivoting Tables
253(1)
Transposing Rows and Columns
254(1)
Parsing JSON Files
254(2)
The List Tools Transform Ribbon
256(1)
Convert a Column to a List
257(1)
Parsing XML Data from a Column
258(2)
Parsing JSON Data from a Column
260(2)
Conclusion
262(1)
Chapter 9 Structuring, Managing, and Parameterizing Queries
263(32)
Managing the Transformation Process
263(6)
Modifying a Step
264(1)
Renaming a Step
265(1)
Deleting a Step or a Series of Steps
265(1)
Modifying an Existing Step
266(2)
Adding a Step
268(1)
Altering Process Step Sequencing
268(1)
An Approach to Sequencing
268(1)
Error Records
269(1)
Removing Errors
269(1)
Modifying the Code for a Step
269(2)
Modifying a Single Step
270(1)
Modifying a Query in "M"
270(1)
Modifying Data Source Settings in the Query Editor
271(1)
Managing Queries
272(6)
Organizing Queries
273(1)
Grouping Queries
273(2)
Duplicating Queries
275(1)
Referencing Queries
275(1)
Documenting Queries
276(1)
Adding a Column As a New Query
276(1)
Enabling Data Load
277(1)
Enabling Report Refresh
278(1)
Pending Changes
278(1)
Reusing Data Sources
279(2)
Pinning a Data Source
281(1)
Parameterizing Queries
281(12)
Creating a Simple Parameter
282(1)
Creating a Set of Parameter Values
283(1)
Creating a Query-Based Parameter
284(2)
Modifying a Parameter
286(1)
Applying a Parameter when Filtering Records
287(1)
Modifying the Current Value of a Parameter
288(1)
Applying a Parameter in a Search and Replace
289(1)
Applying a Parameter to a Datasource
290(2)
Other Uses for Parameters
292(1)
Applying a Parameter to a SQL Query
292(1)
Query Icons
293(1)
Power BI Templates
293(1)
Copying Data from Power BI Desktop Query Editor
294(1)
Conclusion
294(1)
Chapter 10 Creating a Data Model
295(36)
Data Modeling in the Power BI Desktop Environment
296(1)
The Power BI Desktop Data View
296(1)
Data Model or Query?
297(1)
The Power BI Desktop Data View Ribbons
297(2)
The Modeling Ribbon
297(2)
Managing Power BI Desktop Data
299(5)
Manipulating Tables
299(2)
Manipulating Columns
301(3)
Power BI Desktop Data Types
304(1)
Formatting Power BI Desktop Data
304(3)
Currency Formats
306(1)
Preparing Data for Dashboards
307(5)
Categorizing Data
307(2)
Applying a Default Summarization
309(1)
Defining Sort By Columns
310(1)
Hiding Tables and Fields from the User
311(1)
Sorting Data in Power BI Desktop Tables
312(1)
Adding Hierarchies
312(1)
Creating and Modifying Groups
313(3)
Creating a Group
314(1)
Modifying a Group
315(1)
Deleting a Group
316(1)
Designing a Power BI Desktop Data Model
316(3)
Data View and Relationship View
317(1)
Relationship View Display Options
318(1)
Creating Relationships
319(6)
Creating Relationships Manually
320(2)
Creating Relationships Automatically
322(1)
Deleting Relationships
323(1)
Managing Relationships
324(1)
Deactivating Relationships
324(1)
Advanced Relationship Options
325(1)
Cardinality
325(1)
Managing Relationships Between Tables
326(3)
Cross Filter Direction
327(1)
Other Relationship Options
328(1)
Reimporting Related Tables
328(1)
Conclusion
329(2)
Chapter 11 Extending the Data Model with Calculated Columns
331(34)
Types of Calculations
332(1)
Adding New Columns
332(2)
Naming Columns
333(1)
Concatenating Column Contents
334(2)
Tweaking Text
336(2)
Simple Calculations
338(4)
Math Operators
340(1)
Rounding Values
340(2)
Calculating Across Tables
342(2)
Choosing the Correct Table for Linked Calculations
344(1)
Cascading Column Calculations
344(1)
Refreshing Data
345(1)
Using Functions in New Columns
345(7)
Safe Division
345(2)
Counting Reference Elements
347(1)
Statistical Functions
348(1)
Applying a Specific Format to a Calculation
349(3)
Simple Logic: The IF() Function
352(10)
Exception Indicators
352(1)
Creating Alerts
353(1)
Flagging Data
354(1)
Nested IFO Functions
355(2)
Creating Custom Groups Using Multiple Nested IFO Statements
357(1)
Multiline Formulas
358(1)
Complex Logic
358(4)
Formatting Logical Results
362(1)
Making Good Use of the Formula Bar
362(1)
Conclusion
363(2)
Chapter 12 Adding Measures to the Data Model
365(28)
A First Measure: Number of Cars Sold
365(2)
Basic Aggregations in Measures
367(1)
Using Multiple Measures
368(3)
Cross-Table Measures
371(2)
More Advanced Aggregations
373(3)
Filter Context
376(1)
Row Context
376(1)
Query Context
376(1)
Filter Context
377(1)
Filtering Data in Measures
377(1)
Simple Filters
377(3)
Text Filters
377(2)
Numeric Filters
379(1)
More Complex Filters
380(3)
Multiple Criteria in Filters
381(1)
Using Multiple Filters
382(1)
Calculating Percentages of Totals
383(5)
A Simple Percentage
383(2)
Removing Multiple Filter Elements
385(1)
Visual Totals
386(1)
The ALLEXCEPTO Function
387(1)
Filtering on Measures
388(2)
Displaying Rank
390(1)
A Few Comments and Notes on Using Measures
391(1)
Calculation Options
391(1)
Conclusion
391(2)
Chapter 13 Analyzing Data over Time
393(32)
Simple Date Calculations
393(6)
Date and Time Formatting
396(2)
Calculating the Age of Cars Sold
398(1)
Adding Time Intelligence to a Data Model
399(1)
Creating and Applying a Date Table
400(6)
Creating the Date Table
400(3)
Adding Sort By Columns to the Date Table
403(1)
Date Table Techniques
404(1)
Adding the Date Table to the Data Model
405(1)
Calculating the Difference Between Two Dates
406(3)
Applying Time Intelligence
409(7)
YearToDate, QuarterToDate, and MonthToDate Calculations
409(2)
Analyzing Data As a Ratio over Time
411(3)
Comparing a Metric with the Result from a Range of Dates
414(2)
Comparisons with Previous Time Periods
416(2)
Calculating Sales for the Previous Year
416(2)
Comparison with a Parallel Period in Time
418(5)
Comparing Data from Previous Years
418(3)
Comparing with the Same Date Period from a Different Quarter, Month, or Year
421(2)
Rolling Aggregations over a Period of Time
423(1)
Conclusion
424(1)
Chapter 14 Table Visuals
425(32)
Power BI Desktop Dashboards
426(1)
Switching to Report View
426(1)
Working with Tables
427(3)
Creating a Basic Table
427(2)
Deleting a Table
429(1)
Copying a Table
430(1)
Changing the Table Size and Position
430(1)
Resizing a Table
431(1)
Moving a Table
431(1)
Changing Column Order
431(1)
Renaming Fields
432(1)
Removing Columns from a Table
432(1)
Table Granularity
433(1)
Types of Data
434(1)
Enhancing Tables
435(6)
Row Totals
435(2)
Formatting Numbers in Reports
437(1)
Font Sizes in Tables
437(1)
Changing Column Widths
438(1)
Sorting by Column
439(2)
Formatting Tables
441(1)
Table Style
441(1)
Adding and Formatting Titles
442(2)
Modifying the Table Background
444(1)
Table Borders
445(1)
Row Formatting
446(1)
Table Grid
447(2)
Column Headers
449(1)
Column Formatting
449(1)
Formatting Totals
450(1)
Conditional Formatting
451(5)
Color Scales
451(2)
Data Bars
453(2)
Conditional Text and Background
455(1)
Conclusion
456(1)
Chapter 15 Matrix and Card Visuals
457(34)
Creating a Matrix
457(7)
Creating a Row Matrix
457(4)
Adding or Removing Subtotals in a Matrix
461(1)
Column Matrix
462(2)
Expanding and Drilling Down and Up
464(6)
The Data/Drill Ribbon
465(1)
Displaying Data at the Previous Level
466(1)
Displaying Data for a Sublevel
467(1)
Drilling Down at Row Level
467(1)
Drill Down Using Click-Through
468(1)
Drilling Down at Column Level
469(1)
Visualize Source Data
470(1)
Viewing Records
471(1)
Including and Excluding Matrix Elements
472(1)
Displaying Multiple Values As Rows
473(2)
Formatting a Matrix
475(5)
Stepped Layout
475(5)
Sorting Data in Matrices
480(1)
Cards
481(3)
Formatting Cards
482(2)
Multirow Cards
484(4)
Formatting Multirow Cards
486(1)
Sorting Multirow Cards
487(1)
Switching Between Table Types
488(1)
Conclusion
489(2)
Chapter 16 Charts in Power BI Desktop
491(36)
A First Chart
492(4)
Creating a First Chart
492(2)
Converting a Table into a Chart
494(1)
Deleting a Chart
495(1)
Basic Chart Modification
495(1)
Basic Chart Types
496(2)
Column Charts
496(1)
Line Charts
497(1)
Pie Charts
497(1)
Essential Chart Adjustments
498(4)
Resizing Charts
499(1)
Repositioning Charts
500(1)
Sorting Chart Elements
500(2)
Donut Charts
502(1)
Funnel Charts
502(1)
Multiple Data Values in Charts
503(4)
100% Stacked Column and Bar Charts
507(1)
Scatter Charts
508(2)
Bubble Charts
510(3)
Waterfall Charts
513(1)
Ribbon Charts
513(2)
Dual-Axis Charts
515(2)
Line and Clustered Column Chart
515(1)
Line and Stacked Column Chart
516(1)
Data Details
517(1)
Drilling into and Expanding Chart Data Hierarchies
518(7)
Drill Down
519(2)
Expand All Down One Level
521(1)
Go to the Next Level
522(3)
Including and Excluding Data Points
525(1)
Conclusion
526(1)
Chapter 17 Formatting Charts in Power BI Desktop
527(26)
Multiple Chart Formatting
527(1)
Chart Legends
527(12)
Legend Display
528(2)
Chart Title
530(1)
Chart Data Labels
531(1)
Chart Background
532(1)
Data Colors
533(1)
Plot Area
533(1)
Axis Modification
534(4)
Chart Borders
538(1)
General Attributes
538(1)
Chart Aspect Ratio
538(1)
Tooltips
539(1)
Specific Chart Formatting
539(7)
Line, Area, and Stacked Area Charts
540(1)
Pie and Donut Charts
541(1)
Ribbon Charts
542(1)
Funnel Charts
543(1)
Scatter and Bubble Charts
544(2)
Bubble Chart Play Axis
546(2)
Chart Analytics
548(2)
Scatter Chart Symmetry Shading and Ratio Line
550(2)
Symmetry Shading
550(1)
Ratio Line
551(1)
Conclusion
552(1)
Chapter 18 Other Types of Visuals
553(30)
Tree Maps
553(4)
Drill Down and Tree Maps
555(1)
Formatting Tree Maps
555(2)
Gauges
557(3)
Formatting Gauges
558(2)
KPIs
560(1)
R Visuals
561(4)
R Options
564(1)
Additional Visuals
565(3)
The Power BI Visuals Gallery
565(3)
Loading Custom Visuals
568(4)
A Rapid Overview of a Selection of Custom Visuals
572(9)
Aster Plots
573(1)
Radar Charts
573(1)
Bullet Charts
574(1)
Word Clouds
574(1)
Sunburst Charts
575(1)
Streamgraphs
575(1)
Tornado Charts
576(1)
Chord Charts
577(1)
Sankey Diagrams
578(1)
Correlation Plots
579(2)
Countdown
581(1)
Custom Slicers
581(1)
Conclusion
581(2)
Chapter 19 Maps in Power BI Desktop
583(28)
Working with Bing Maps
583(1)
Creating Maps in Power BI Desktop
584(2)
Using Geographical Data
586(2)
Geographical Data Types
587(1)
Drilling Down in Maps
588(1)
Adjusting the Map Display in Power BI Desktop
589(4)
Positioning the Map Elements
590(1)
Zooming In or Out
590(1)
Multivalue Series
590(1)
Color Saturation
591(1)
Highlighting Map Data
592(1)
Filled Maps
593(1)
Shape Maps
594(2)
Map Keys
595(1)
Adding Shape Maps
596(1)
Formatting Maps
596(5)
Maps
596(2)
Filled Maps
598(1)
Tooltips
599(1)
Shape Maps
599(2)
ARCGis Maps
601(9)
Creating an ARCGis Map
602(1)
Selecting a Basemap Type
603(1)
Selecting a Location Type
604(1)
Adding a Map Theme
605(1)
Choosing a Symbol Type
605(1)
Adding Pins
606(1)
Adding a Reference Layer
607(2)
Adding Infographics
609(1)
Conclusion
610(1)
Chapter 20 Filtering Data
611(32)
Filters
612(1)
Visual-Level Filters
612(5)
The Filters Well
613(1)
Adding Filters
613(1)
Applying Filters
614(2)
The Select All Filter
616(1)
Clearing Filters
617(1)
Filtering Different Data Types
617(10)
Filtering Numeric Data
618(2)
Filtering Date and Time Data
620(7)
Filtering True or False Data
627(1)
Advanced Text Filters
627(4)
Applying an Advanced Text Filter
628(1)
Clearing an Advanced Filter
629(1)
Reverting to Basic Filtering
629(1)
Text Filter Options
629(2)
Specific Visualization-Level Filters
631(1)
Multiple Filters
632(1)
Page-Level Filters
632(2)
Report-Level Filters
634(2)
Removing Filters
636(1)
Filter Field Reuse
637(2)
Requiring Single Selection
639(1)
Using the Filter Hierarchy
639(1)
Filtering Tips
640(1)
Don't Filter Too Soon
640(1)
Annotate, Annotate, Annotate
640(1)
Avoid Complex Filters
641(1)
Conclusion
641(2)
Chapter 21 Using Slicers
643(30)
Slicers
643(4)
Adding a Slicer
644(1)
Applying Slicers
645(1)
Clearing a Slicer
646(1)
Deleting a Slicer
646(1)
Modifying a Slicer
647(1)
Date Slicers
647(2)
Formatting Slicers
649(6)
Slicer Orientation
649(1)
Modifying the Outline
650(1)
Adjusting Selection Controls
650(1)
Setting the Exact Size and X and Y coordinates of a Slicer
651(1)
Formatting the Slicer Header
652(1)
Formatting Slicer Items
652(1)
Sorting Slicer Elements
653(1)
Switching to Dropdown Slicers
653(1)
Exporting Slicer Data
654(1)
Using Charts As Slicers
655(7)
Charts As Slicers
655(2)
Highlighting Chart Data
657(1)
Cross-Chart Highlighting
658(2)
Highlighting Data in Bubble Charts
660(2)
Charts As Complex Slicers
662(4)
Column and Bar Charts As Filters
664(2)
Specifying Visual Interactions
666(1)
What-lf Slicers
667(3)
Custom Visuals As Slicers
670(2)
Timeline Slicer
670(1)
Timebrush Slicer
671(1)
Chicklet Slicer
671(1)
Choosing the Correct Approach to Interactive Data Selection
672(1)
Conclusion
672(1)
Chapter 22 Enhancing Dashboards
673(32)
Formatting Ribbons
673(2)
The View Ribbon
674(1)
The Format Ribbon
674(1)
Formatting the Page
675(1)
Aligning and Distributing Visuals
676(3)
Aligning Visuals
676(1)
Distributing Visuals
677(1)
Aligning to the Grid
678(1)
Specifying the Exact Position of a Visual
678(1)
Adding Text Boxes to Annotate a Report
679(3)
Adding a Text Box
679(1)
Moving Text Boxes
680(1)
Formatting a Text Box
680(1)
Adding a Hyperlink
681(1)
Removing a Hyperlink
682(1)
Deleting Text Boxes
682(1)
Modifying the Page Background Color
682(1)
Images
683(6)
Image Sources
684(1)
Adding an Image
684(2)
Removing an Image
686(1)
Resizing Images
686(1)
Formatting Images
687(1)
Background Images
687(2)
Some Uses for Independent Images
689(1)
Adding Shapes
689(4)
Formatting Shapes
690(2)
Removing Shapes
692(1)
Standardizing Shapes
693(1)
Organizing Visuals on the Page
693(2)
Layering Visuals
693(2)
Drill-Through
695(4)
The Source Page
695(1)
The Destination Page
696(2)
Applying Drillthrough
698(1)
The Back Button
699(1)
Phone Layout
699(3)
Report Themes
702(1)
Exporting Data from a Visualization
703(1)
Conclusion
704(1)
Chapter 23 PowerBI.com
705(44)
Publishing Reports to PowerBI.com
705(5)
Creating a Power BI Account
706(4)
Using Power BI Desktop Files in PowerBI.com
710(6)
Logging On to PowerBI.com
711(2)
Adding a Power BI Desktop File
713(1)
Publishing a Power BI Desktop File
714(1)
Dashboards, Reports, and Datasets
715(1)
Interacting with a Report on PowerBI.com
716(1)
Printing PowerBI.com Reports
716(1)
Working with PowerBI.com Reports
716(2)
The PowerBI.com Report Menu
717(1)
Report Editing
717(1)
Exiting Edit Mode
718(1)
Adding Datasets to PowerBI.com
718(3)
Creating New Reports in PowerBI.com
721(1)
PowerBI.com Dashboards
722(11)
Adding Tiles to PowerBI.com Dashboards
723(2)
Pinning Entire Reports
725(2)
Editing Dashboard Tiles
727(2)
Modifying Dashboards
729(4)
PowerBI Pro
733(1)
Sharing Dashboards
733(1)
PowerBI.com Gateways
734(7)
Downloading a Gateway
735(6)
Configuring Data Sources
741(1)
Applying Dataset Settings
742(3)
Manual Data Refresh
744(1)
Scheduled Data Refresh
745(1)
PowerBI.com on Tablets and Smartphones
745(2)
Conclusion
747(2)
Appendix A Sample Data
749(4)
Sample Data
749(4)
Downloading the Sample Data
749(1)
Images
749(1)
Sample Databases
750(3)
Index 753
Adam Aspin is an independent business intelligence consultant based in the United Kingdom. He has worked with SQL Server for more than 20 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite.

A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from Access to Oracle and MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe using SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, SharePoint, and Power BI.





Business Intelligence has been Adam's principal focus for the last 15 years. He has applied his skills for a range of clients in industry sectors such as finance, utilities, telecommunications, insurance, manufacturing, and banking.

Adam is a frequent contributor to SQLServerCentral.com and Simple-Talk. 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 speaks regularly at events such as SQLBits, SQL Saturdays, and local SQL Server user groups.

Adam is the author of SQL Server Data Integration Recipes (Apress), High Impact Data Visualization with Power View, Power Map, and Power BI (Apress), and Business Intelligence with SQL Server Reporting Services (Apress).
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97814842321012e.html
Keywords: