Paul Turley is a Mentor with SolidQ, a Microsoft MVP, solution architect, teacher, and presenter.Robert Bruckner is a principal software architect and developer with the Microsoft SQL Server division and is responsible for the technical architecture of SSRS and Power View.Thiago Silva is an MCPD, architect, and consultant for Credera, whose clients include Fortune 1000 companies and emerging industry leaders.Ken Withee is President of Portal Integrators LLC, a software company that develops business applications for the SharePoint platform.Grant Paisley is a SQL Server MVP and founder of Angry Koala, a successful Business Intelligence consulting firm based in Sydney, Australia.
Build your SQL Reporting, Power View, and SharePoint BI skillsWhether you're creating an invoice for a small business or a BI dashboard to help manage a multinational corporation, you need to deliver accurate information. This book shows you how to accomplish this by walking you through Microsoft's reporting platform. You'll dive into SQL Server 2012 Reporting Services' architecture and BI fundamentals, as well as the key ingredients to successful report design. You'll then get up to speed on building business reports with Report Builder and using Power View to make fast, interactive, visual analytics pervasive and accessible to business users.Professional Microsoft SQL Server 2012 Reporting Services:* 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 serverWrox Professional guides are written by working developers to address everyday needs. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.wrox.comProgrammer ForumsJoin our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.Code DownloadsTake advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.Read MoreFind articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
A must-have guide for the latest updates to the new release of Reporting ServicesSQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors.* Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012* Explains Reporting Services architecture and BI fundamentals* Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient* Discusses semantic model design, Report Builder, Crescent, and more* Targets business analysts and report designers as well as BI solution developersProfessional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.
A must-have guide for the latest updates to the new release of Reporting Services SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions.
A must-have guide for the latest updates to the new release of Reporting Services
SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors.
* Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012
* Explains Reporting Services architecture and BI fundamentals
* Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient
* Discusses semantic model design, Report Builder, Crescent, and more
* Targets business analysts and report designers as well as BI solution developers
Professional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.
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
Paul Turley is a Mentor with SolidQ, a Microsoft MVP, solution architect, teacher, and presenter.
Robert Bruckner is a principal software architect and developer with the Microsoft SQL Server division and is responsible for the technical architecture of SSRS and Power View.
Thiago Silva is an MCPD, architect, and consultant for Credera, whose clients include Fortune 1000 companies and emerging industry leaders.
Ken Withee is President of Portal Integrators LLC, a software company that develops business applications for the SharePoint platform.
Grant Paisley is a SQL Server MVP and founder of Angry Koala, a successful Business Intelligence consulting firm based in Sydney, Australia.
Lieferung vom Verlag mit leichten Qualitätsmängeln möglich
Über den Autor
Paul Turley is a Mentor with SolidQ, a Microsoft MVP, solution architect, teacher, and presenter.nnRobert Bruckner is a principal software architect and developer with the Microsoft SQL Server division and is responsible for the technical architecture of SSRS and Power View.nnThiago Silva is an MCPD, architect, and consultant for Credera, whose clients include Fortune 1000 companies and emerging industry leaders.nnKen Withee is President of Portal Integrators LLC, a software company that develops business applications for the SharePoint platform.nnGrant Paisley is a SQL Server MVP and founder of Angry Koala, a successful Business Intelligence consulting firm based in Sydney, Australia.
Inhaltsverzeichnis
FOREWORD xxxvnnINTRODUCTION xxxviinnPART I: GETTING STARTEDnnCHAPTER 1: INTRODUCING REPORTING SERVICES 3nnCHAPTER 2: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 23nnCHAPTER 3: CONFIGURING SHAREPOINT INTEGRATION 69nnPART II: REPORT DESIGNnnCHAPTER 4: BASIC REPORT DESIGN 95nnCHAPTER 5: REPORT LAYOUT AND FORMATTING 123nnCHAPTER 6: DESIGNING DATA ACCESS 143nnCHAPTER 7: ADVANCED REPORT DESIGN 189nnCHAPTER 8: CHART REPORTS 229nnPART III: BUSINESS INTELLIGENCE REPORTINGnnCHAPTER 9: BI SEMANTIC MODELS 251nnCHAPTER 10: REPORTING WITH ANALYSIS SERVICES 263nnCHAPTER 11: OLAP REPORTING ADVANCED TECHNIQUES 295nnPART IV: ENABLING USER REPORTINGnnCHAPTER 12: TABULAR MODELS 349nnCHAPTER 13: VISUAL ANALYTICS WITH POWER VIEW 373nnCHAPTER 14: REPORT BUILDER SOLUTION STRATEGIES 445nnPART V: SOLUTION PATTERNSnnCHAPTER 15: MANAGING REPORT PROJECTS 463nnCHAPTER 16: REPORT SOLUTIONS, PATTERNS, AND RECIPES 483nnPART VI: ADMINISTERING REPORTING SERVICESnnCHAPTER 17: CONTENT MANAGEMENT 525nnCHAPTER 18: INTEGRATING REPORTS WITH SHAREPOINT 559nnCHAPTER 19: NATIVE MODE SERVER ADMINISTRATION 581nnPART VII: REPORTING SERVICES CUSTOM PROGRAMMINGnnCHAPTER 20: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 619nnCHAPTER 21: USING EMBEDDED AND REFERENCED CODE 681nnCHAPTER 22: EXTENDING REPORTING SERVICES 697nnPART VIII: APPENDIXESnnAPPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758nnAPPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779nnAPPENDIX C: MDX REFERENCE 803nnINDEX 829
Klappentext
A must-have guide for the latest updates to the new release of Reporting ServicesnnSQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors.n* Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012n* Explains Reporting Services architecture and BI fundamentalsn* Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficientn* Discusses semantic model design, Report Builder, Crescent, and moren* Targets business analysts and report designers as well as BI solution developersnnProfessional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.
