Professional Microsoft SQL Server 2012 Reporting Services

A must-have guide for the latest updates to the new release of Reporting Services

QL 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.

From the Back Cover
Build your SQL Reporting, Power View, and SharePoint BI skills

Whether 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 server

Table of Contents
Part I: Getting Started
Chapter 1. Introducing Reporting Services
Chapter 2. Reporting Services Installation and Architecture
Chapter 3. Confi guring SharePoint Integration

Part II: Report Design
Chapter 4. Basic Report Design
Chapter 5. Report Layout and Formatting
Chapter 6. Designing Data Access
Chapter 7. Advanced Report Design
Chapter 8. Chart Reports

Part III: Business Intelligence Reporting
Chapter 9. BI Semantic Models
Chapter 10. Reporting with Analysis Services
Chapter 11. OLAP Reporting Advanced Techniques

Part IV: Enabling User Reporting
Chapter 12. Tabular Models
Chapter 13. Visual Analytics with Power View
Chapter 14. Report Builder Solution Strategies

Part V: Solution Patterns
Chapter 15. Managing Report Projects
Chapter 16. Report Solutions, Patterns, and Recipes

Part VI: Administering Reporting Services
Chapter 17. Content Management
Chapter 18. Integrating Reports with SharePoint
Chapter 19. Native Mode Server Administration

Part VII: Reporting Services Custom Programming
Chapter 20. Integrating Reports into Custom Applications
Chapter 21. Using Embedded and Referenced Code
Chapter 22. Extending Reporting Services

Part VIII: Appendixes
Appendix A. T-SQL Commands, Clauses, and Predicates
Appendix B. T-SQL System Variables and Functions
Appendix C. MDX Reference

Book Details

  • Paperback: 912 pages
  • Publisher: Wrox (June 2012)
  • Language: English
  • ISBN-10: 1118101111
  • ISBN-13: 978-1118101117
Download [108.8 MiB]

You may also like...

Leave a Reply