Power View and Reporting Services 2012 Book

  • Article

Several projects kept me very busy over the past year. I will talk more about a few of these in subsequent postings now that some are publicly disclosed in the meantime.

9781118101117 cover.inddIn this posting, I am very happy to announce the availability of “Professional Reporting Services 2012”. After the successful Report Design Recipes book focusing on best practices and report design patterns, it was time to work on a comprehensive book covering the entire Reporting Services 2012 product. For example, the book includes about 100 pages of brand new contents I dedicated solely to Power View and tabular models with PowerPivot (chapters 12 and 13). An extraordinary amount of thanks goes to my co-authors; Paul Turley, Thiago Silva, Ken Withee, and Grant Paisley!

My esteemed colleague Ariel Netz (Partner Group Program Manager for SQL Server Reporting Services) graciously wrote the foreword of our book. I think the following paragraph quoted from Ariel’s foreword summarizes in a great way what to expect from this book:

“What I really like about Professional SQL Server 2012 Reporting Services is that it’s a perfect reflection of the Microsoft BI journey through the eyes of the Reporting Services product line, from the early days of managed and operational to the latest addition of self-service reporting. This book was written by experts who built the product and have implemented it at customers’ sites. Together they have more than 40 years of business intelligence experience.
I call this book the encyclopedia of SQL Server Reporting Services. ”

This book covers a wide range of topics in depth:

  • Demonstrates self-service reporting with Report Builder, using wizards, and simple design tools
  • Helps you design highly visual and attractive business reports with dynamic formatting, drill-down, and drill-through actions
  • Provides the tools to build BI dashboards, scorecards, and performance indicators
  • Demonstrates building BI Semantic Models, interactively exploring data in Power View, and creating compelling presentations
  • Features helpful examples, hands-on code, and resourceful solutions for common problems
  • Demonstrates how to integrate Reporting Services with SharePoint, configure and use Power View, and manage a native mode report server
     

Table of Contents:

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

 

Enjoy!