Atjaunināt sīkdatņu piekrišanu

Business Intelligence with SQL Server Reporting Services 1st ed. [Mīkstie vāki]

3.33/5 (3 ratings by Goodreads)
  • Formāts: Paperback / softback, 428 pages, height x width: 254x178 mm, weight: 7989 g, 152 Illustrations, black and white; XXII, 428 p. 152 illus., 1 Paperback / softback
  • Izdošanas datums: 25-Feb-2015
  • Izdevniecība: APress
  • ISBN-10: 1484205332
  • ISBN-13: 9781484205334
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 55,83 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Standarta cena: 65,69 €
  • Ietaupiet 15%
  • Grāmatu piegādes laiks ir 3-4 nedēļas, ja grāmata ir uz vietas izdevniecības noliktavā. Ja izdevējam nepieciešams publicēt jaunu tirāžu, grāmatas piegāde var aizkavēties.
  • Daudzums:
  • Ielikt grozā
  • Piegādes laiks - 4-6 nedēļas
  • Pievienot vēlmju sarakstam
Business Intelligence with SQL Server Reporting Services 1st ed.Palielināt
  • Formāts: Paperback / softback, 428 pages, height x width: 254x178 mm, weight: 7989 g, 152 Illustrations, black and white; XXII, 428 p. 152 illus., 1 Paperback / softback
  • Izdošanas datums: 25-Feb-2015
  • Izdevniecība: APress
  • ISBN-10: 1484205332
  • ISBN-13: 9781484205334
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9781484205334.html
Keywords:

Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards. Create compelling visualizations that seize your audience’s attention and help business users identify and react swiftly to changing business conditions. Best of all, you'll do all these things by creating new value from software that is already installed and paid for – SQL Server and the included SQL Server Reporting Services.

Businesses run on numbers, and good business intelligence systems make the critical numbers immediately and conveniently accessible. Business users want access to key performance indicators in the office, at the beach, and while riding the subway home after a day's work. Business Intelligence with SQL Server Reporting Services helps you meet these need for anywhere/anytime access by including chapters specifically showing how to deliver on modern devices such as smart phones and tablets. You'll learn to deliver the same information, with similar look-and-feel, across the entire range of devices used in business today.

  • Key performance indicators give fast notification of business unit performance
  • Polished dashboards deliver essential metrics and strategic comparisons

  • Visually arresting output on multiple devices focuses attention
About the Author xxi
About the Technical Reviewers xxiii
Acknowledgments xxv
Introduction xxvii
Chapter 1 SQL Server Reporting Services as a Business Intelligence Platform
1(18)
Business Intelligence Concepts
2(1)
Key Performance Indicators
2(1)
Scorecards
3(1)
Dashboards
3(1)
SSRS for Business Intelligence, Practically
3(1)
Getting the Data Right
4(3)
Prepare the Data
4(1)
Use Views and Stored Procedures
5(1)
Some Ideas on Source Data Definition
6(1)
Real-World Data
7(1)
Designing SQL Server Reports for Business Intelligence
7(2)
Presentation
8(1)
Design
8(1)
Layout
8(1)
Interface and Interactivity
9(1)
Multi-Purposing
9(1)
The Sample Database
9(1)
Preparing Your Environment
9(4)
Creating an SSDT Project
10(1)
Adding a Shared Datasource
10(1)
Add Shared Datasets
11(1)
Configuring Parameters
12(1)
Code and Stored Procedures
13(1)
Reusability
13(1)
The CarSales_Reports Database
14(1)
Book Audience
14(2)
How Best to Use This Book
16(1)
Conclusion
17(2)
Chapter 2 KPIs and Scorecards
19(48)
What Are Key Performance Indicators?
19(3)
KPI Value
20(1)
KPI Goal
20(1)
KPI Status
20(1)
KPI Trends
21(1)
A Simple KPI
22(8)
The Source Data
22(3)
How the Code Works
25(1)
Building the KPI
25(4)
How It Works
29(1)
A More Complex KPI Using Sparklines
30(8)
The Source Data
30(4)
How the Code Works
34(1)
Building the KPI
35(2)
How It Works
37(1)
Gauge-Based KPIs
38(9)
The Source Data
40(3)
How the Code Works
43(1)
Building the Gauge-Based KPI
43(3)
How It Works
46(1)
Hints and Tips
47(1)
Text-Based KPIs
47(19)
A Simple Text-Based KPI
47(1)
The Source Data
47(6)
How the Code Works
53(1)
Building a Text-Based KPI
53(2)
How It Works
55(1)
A Complex Text-Based KPI
55(1)
The Source Data
56(5)
How the Code Works
61(1)
Building a Complex Text-Based KPI
61(4)
How It Works
65(1)
Conclusion
66(1)
Chapter 3 Gauges for Business Intelligence
67(52)
Gauge Elements
67(1)
Data for Gauges
68(1)
Gauge Development
68(1)
Classic Gauges
69(7)
The Source Data
70(1)
How the Code Works
71(1)
Building the Gauge
72(3)
How It Works
75(1)
Hints and Tips
76(1)
Using Multiple Pointers in Gauges
76(6)
The Source Data
77(3)
How the Code Works
80(1)
Creating the Gauge
80(2)
How It Works
82(1)
Varying the Pointer Types and Assembling Gauges
82(9)
The Source Data
83(5)
How the Code Works
88(1)
Building the Gauge
88(3)
How It Works
91(1)
Hints and Tips
91(1)
Gauges with Multiple Elements
91(5)
The Source Data
92(1)
Creating the Gauge
93(3)
How It Works
96(1)
Hints and Tips
96(1)
Less Traditional Gauges
96(14)
Thermometers
96(1)
The Source Data
97(1)
How the Code Works
98(1)
Building the Thermometer
99(3)
How It Works
102(1)
Hints and Tips
103(1)
Sub-Gauges
103(1)
The Source Data
104(1)
How the Code Works
105(1)
Creating Gauges with Sub-Gauges
105(5)
How It Works
110(1)
Hints and Tips
110(1)
Interesting Tricks with Gauges
110(7)
The Source Data
111(1)
How the Code Works
112(1)
Creating and Assembling the Gauges
112(4)
How It Works
116(1)
Hints and Tips
116(1)
Conclusion
117(2)
Chapter 4 Charts for Business Intelligence
119(42)
Some Chart Presentation Ideas
119(1)
Charts to Compare Metrics with Targets
120(11)
Basic Target Comparison Charts
120(1)
The Source Data
121(1)
How the Code Works
122(1)
Building the Chart
122(3)
An Advanced KPI Chart
125(1)
The Source Data
126(3)
How the Code Works
129(1)
Building the Chart
129(1)
How It Works
130(1)
Ordering Chart Elements
131(3)
The Source Data
131(1)
How the Code Works
132(1)
Building the Chart
132(2)
How It Works
134(1)
Superposed Bar Charts
134(3)
The Source Data
135(1)
Creating the Chart
135(2)
How It Works
137(1)
Hints and Tips
137(1)
Radar Charts
137(3)
The Source Data
138(1)
How the Code Works
139(1)
Building the Chart
139(1)
How It Works
140(1)
Hints and Tips
140(1)
Bubble Charts
141(4)
The Source Data
141(2)
How the Code Works
143(1)
Building the Chart
143(2)
How It Works
145(1)
Waterfall Charts
145(6)
The Source Data
146(2)
How the Code Works
148(1)
Creating a Waterfall Chart
149(1)
How It Works
150(1)
Hints and Tips
150(1)
Trellis Charts
151(3)
The Source Data
152(1)
How the Code Works
152(1)
Building a Trellis Chart
153(1)
How It Works
154(1)
Hints and Tips
154(1)
A Pyramid Chart
154(4)
The Source Data
155(1)
How the Code Works
156(1)
Building a Pyramid Chart
156(2)
How It Works
158(1)
A Few Ideas on Using Charts for Business Intelligence
158(1)
Keep Charts Simple
158(1)
Use Multiple Charts of the Same Type
159(1)
Minimize Titles
159(1)
Avoid Extraneous Elements
159(1)
Vary Chart Types
159(1)
Conclusion
159(2)
Chapter 5 Maps in Business Intelligence
161(24)
Geographical Data
161(2)
Loading Geographical Data into SQL Server from Shapefiles
162(1)
A Simple Map of US States with Sales
163(6)
The Source Data
163(1)
Building the Map
164(5)
How It Works
169(1)
Hints and Tips
169(1)
A Heat Map of European Sales by Country
169(7)
Simplifying the Geographical Data
170(1)
The Source Data
171(2)
How the Code Works
173(1)
Creating the Map
173(3)
How It Works
176(1)
A Bubble Chart Map of English Regions
176(7)
The Source Data
177(1)
How the Code Works
178(1)
Creating the Map
178(5)
How It Works
183(1)
Conclusion
183(2)
Chapter 6 Images in Business Intelligence
185(30)
Image Types
186(1)
Image Editing Software
186(1)
Image Size and Resolution
186(1)
Image Location
187(2)
Exporting Embedded Images from Reports
188(1)
Image Backgrounds for Text Boxes
189(3)
The Source Data
189(1)
How the Code Works
190(1)
Building the Visualization
190(1)
How It Works
191(1)
Report and Table Backgrounds
192(6)
The Source Data
193(3)
How the Code Works
196(1)
Building the Scorecard
196(1)
How It Works
197(1)
Using Background Repeat
198(1)
Rectangle Borders
198(4)
Using Chart Borders for Gauges
199(2)
How It Works
201(1)
Using a Custom Image
202(1)
Borders for Tables
202(5)
Fixed-Size Table Borders
202(2)
How It Works
204(1)
Dynamic Table Borders
204(2)
How It Works
206(1)
Gauge Backgrounds
207(3)
The Source Data
207(1)
How the Code Works
208(1)
Building the Visualization
208(2)
How It Works
210(1)
Chart Columns and Bars
210(3)
The Source Data
211(1)
Building the Chart
212(1)
How It Works
213(1)
Images as Titles
213(1)
Conclusion
214(1)
Chapter 7 Assembling Dashboards and Presentations
215(16)
A First Dashboard
215(3)
How It Works
217(1)
Hints and Tips
218(1)
Grouping Objects
218(3)
How It Works
220(1)
Hints and Tips
220(1)
A More Complex Dashboard
221(8)
Creating the Basic Dashboard
222(1)
Grouping in Tables
222(1)
Grouping Inside a Rectangle
223(2)
Adding Custom Elements
225(2)
Adding the Radar Chart
227(1)
Grouping Two Components
228(1)
Finishing the Dashboard
228(1)
Hints and Tips
229(1)
Creating a Legend
229(1)
Hints and Tips
230(1)
A Few Random Tips
230(1)
Conclusion
230(1)
Chapter 8 Interface Enhancements for Business Intelligence Delivery
231(26)
Report Refresh and Parameter Postback
232(1)
Interactive Parameter Selection
233(8)
The Source Data
233(2)
How the Code Works
235(1)
Building the Report
235(5)
How It Works
240(1)
Hints and Tips
240(1)
Creating a Year and Month Selector Widget
241(1)
Creating Interactive Menus to Select Filter Elements
241(3)
The Source Data
243(1)
Building the Report
243(1)
How It Works
244(1)
Using Slicers
244(5)
Single Slicers
245(1)
The Source Data
245(1)
How the Code Works
246(1)
Building the Report
247(1)
How It Works
248(1)
Multiple Slicers
249(6)
The Source Data
250(1)
How the Code Works
251(1)
Building the Report
251(4)
How It Works
255(1)
Conclusion
255(2)
Chapter 9 Interface Enhancements
257(36)
Highlighting for Data Selection
258(6)
The Source Data
259(1)
How the Code Works
260(1)
Building the Report
261(3)
How It Works
264(1)
Creating Tiles to Subset Data
264(8)
The Source Data
265(3)
How the Code Works
268(1)
Building the Report
268(3)
How It Works
271(1)
Adding a Carousel to Filter Data
272(14)
The Source Data
273(5)
How the Code Works
278(1)
Building the Report
279(5)
How It Works
284(2)
Adding Paged Recordsets
286(5)
The Source Data
287(1)
How the Code Works
288(1)
Building the Report
288(3)
How It Works
291(1)
Conclusion
291(2)
Chapter 10 BI for SSRS on Tablets and Smartphones
293(36)
Designing Mobile Reports
294(1)
Delivering Mobile Reports
294(1)
Tablet Reports
295(1)
Multi-Page Reports
295(5)
The Source Data
298(1)
Building the Report
298(2)
How It Works
300(1)
Creating Tabbed Reports
300(10)
The Source Data
302(2)
How the Code Works
304(1)
Building the Report
305(5)
How It Works
310(1)
Other Techniques for Tablet Reports
310(1)
Smartphone Reports
310(18)
Multiple Gauges
311(1)
The Source Data
312(1)
Building the Gauges
312(1)
How It Works
312(1)
Slider Gauges
313(1)
The Source Data
313(3)
How the Code Works
316(1)
Building the Report
316(4)
How It Works
320(1)
Text-Based Metrics
321(1)
The Source Data
321(2)
How the Code Works
323(1)
Building the Display
323(2)
How It Works
325(1)
Multiple Charts
325(1)
Smartphone and Tablet Report Hierarchy
325(1)
Access to a Report Hierarchy
325(2)
How It Works
327(1)
Structuring the Report Hierarchy
327(1)
Conclusion
328(1)
Chapter 11 Standardizing BI Report Suites
329(16)
Planning for Reuse
329(1)
Shared Datasets
330(1)
Adding Multiple Data Sources, Datasets, or Image Files
330(3)
Copying Images Between Reports
331(1)
Hints and Tips
332(1)
Copying Datasets Between Reports
332(1)
Copying Datasets Between Reports
332(1)
Images in BI Projects
333(6)
Loading and Importing Database Images
333(1)
Using Images from a SQL Server Table
334(1)
Adding a Dataset for Images to a Report
335(2)
Hints and Tips
337(2)
Centralized Style Information
339(4)
Applying Style Information from a Database Table
341(1)
Hints and Tips
342(1)
Conclusion
343(2)
Chapter 12 Optimizing SSRS for Business Intelligence
345(44)
Normalized Data Sources
346(8)
Reporting Tables
346(1)
Aggregated Reporting Tables
347(1)
Indexes
348(2)
Covering Indexes
350(2)
Filtered Indexes
352(1)
Indexed Views
352(2)
Partitioned Data Sources
354(6)
Vertical Partitioning
354(2)
Horizontal Partitioning
356(4)
Columnstore Indexes
360(1)
Dimensional Data Sources
361(1)
Dataset Caching
362(4)
Data Source Credentials
363(2)
Enabling Shared Datasets for Caching
365(1)
Report Caching
366(2)
Using Parameters and Filters when Caching Reports and Datasets
368(5)
The Source Data
370(1)
Building the Report
371(2)
Cache Schedules
373(3)
Creating a Shared Schedule
374(1)
Applying a Shared Schedule
375(1)
Pre-Caching Reports and Data Sets
376(9)
Cache Refreshing
377(1)
Subscriptions to Load the Cache
378(7)
In-Memory Data Warehouses
385(1)
Conclusion
386(3)
Appendix A Sample Data
389(2)
Creating the Sample Data Directory Structure
389(1)
Downloading the Sample Data
390(1)
Sample Database
390(1)
Index 391
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).