Data Visualization Choices SQL Saturday Presentation

16 02 2013

Today in Vancouver, British Columbia, at the SQL Saturday #198; I presented a session titled “Data Visualization Choices”.  As promised, my slide deck is available for download here

This is the first draft of the session I’m preparing for the PASS Business Analytics Conference coming up on April 11-12 in Chicago.  I’ll have another update for that conference.









BI Sessions and Report Dashboard Demos at the PASS Global Summit

7 11 2012

Literally, minutes after I began posting my running notes from the keynote presentations and the first session I attended, I received a request to fill a last minute opening on the schedule and prepare a second session.  I’m working on preparing a new version of “Visual Report Design – Bringing Sexy Back”.  I will be presenting that session tomorrow.  Read the rest of this entry »





Ready for SQL PASS 2012 Global Summit

4 11 2012

Well, here I am sitting in a hotel room in Seattle on Sunday night, November 4th; the week of the PASS Global Summit.  This is my favorite week of the year in the SQL Server community.  If you’ve arrived ahead of the conference and have some time, please reach out so we can connect about BI, reporting, architectural design or life in general.  My twitter tag is @paul_turley. Read the rest of this entry »








Professional SQL Server 2012 Reporting Services is available

2 06 2012

I am proud to announce that our Professional SQL Server 2012 Reporting Services book is finally in print and generally available. This 865 page book took about 14 months to write and was completed about six weeks ago. Paperback and electronic editions are available from Wrox.com, Amazon & other resellers.

9781118101117 cover.indd

My esteemed co-authors were Robert Bruckner from the SSRS product team, Grant Paisley, Thiago Silva and Ken Withee; who all did fantastic work. 

Thanks go to Joe Salvatore, Chris Albrektson and Nigel Sammy who did a great job as a technical reviewers.

In addition to covering every significant capability of the new professional reporting platform and the integrated SharePoint  experience; chapters are dedicated to new BI capabilities introduced in SQL Server 2012 including BISM semantic tabular models, PowerPivot for Excel 2012 and SharePoint 2012, and Power View visualizations.

Table of Contents:

FOREWORD xxxv

INTRODUCTION xxxvii

PART I: GETTING STARTED

CHAPTER 1: INTRODUCING REPORTING SERVICES 3

CHAPTER 2: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 23

CHAPTER 3: CONFIGURING SHAREPOINT INTEGRATION 69

PART II: REPORT DESIGN

CHAPTER 4: BASIC REPORT DESIGN 95

CHAPTER 5: REPORT LAYOUT AND FORMATTING 123

CHAPTER 6: DESIGNING DATA ACCESS 143

CHAPTER 7: ADVANCED REPORT DESIGN 189

CHAPTER 8: CHART REPORTS 229

PART III: BUSINESS INTELLIGENCE REPORTING

CHAPTER 9: BI SEMANTIC MODELS 251

CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 263

CHAPTER 11: OLAP REPORTING ADVANCED TECHNIQUES 295

PART IV: ENABLING USER REPORTING

CHAPTER 12: TABULAR MODELS 349

CHAPTER 13: VISUAL ANALYTICS WITH POWER VIEW 373

CHAPTER 14: REPORT BUILDER SOLUTION STRATEGIES 445

PART V: SOLUTION PATTERNS

CHAPTER 15: MANAGING REPORT PROJECTS 463

CHAPTER 16: REPORT SOLUTIONS, PATTERNS, AND RECIPES 483

PART VI: ADMINISTERING REPORTING SERVICES

CHAPTER 17: CONTENT MANAGEMENT 525

CHAPTER 18: INTEGRATING REPORTS WITH SHAREPOINT 559

CHAPTER 19: NATIVE MODE SERVER ADMINISTRATION 581

PART VII: REPORTING SERVICES CUSTOM PROGRAMMING

CHAPTER 20: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 619

CHAPTER 21: USING EMBEDDED AND REFERENCED CODE 681

CHAPTER 22: EXTENDING REPORTING SERVICES 697

PART VIII: APPENDIXES

APPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758

APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779

APPENDIX C: MDX REFERENCE 803

INDEX 829









Follow

Get every new post delivered to your Inbox.

Join 213 other followers