About the Book :
This book teaches business analysts and developers how to use Microsoft's reporting platform to create reports and business intelligence (BI) solutions. The book explains Reporting Services architecture and BI fundamentals, as well as the key ingredients to successful report design. The authors also cover advanced report design and filtering techniques, and they categorize common report types and lead the reader through each design, discussing its purpose and the conditions where it could be more efficient.Building on the previous edition, there is more coverage for the professional developer and, of course, coverage of the new features introduced with SQL Server 2012.
INTRODUCTION PART I: GETTING STARTEDINTRODUCING REPORTING SERVICESREPORTING SERVICES INSTALLATION AND ARCHITECTURE CONFIGURING SHAREPOINT INTEGRATION PART II: REPORT DESIGNBASIC REPORT DESIGN REPORT LAYOUT AND FORMATTING DESIGNING DATA ACCESS ADVANCED REPORT DESIGN CHART REPORTS PART III: BUSINESS INTELLIGENCE REPORTINGBI SEMANTIC MODELS REPORTING WITH ANALYSIS SERVICES OLAP REPORTING ADVANCED TECHNIQUES PART IV: ENABLING USER REPORTINGTABULAR MODELS VISUAL ANALYTICS WITH POWER VIEW REPORT BUILDER SOLUTION STRATEGIES PART V: SOLUTION PATTERNSMANAGING REPORT PROJECTS REPORT SOLUTIONS, PATTERNS, AND RECIPES PART VI: ADMINISTERING REPORTING SERVICESCONTENT MANAGEMENT INTEGRATING REPORTS WITH SHAREPOINT NATIVE MODE SERVER ADMINISTRATION PART VII: REPORTING SERVICES CUSTOM PROGRAMMINGINTEGRATING REPORTS INTO CUSTOM APPLICATIONS USING EMBEDDED AND REFERENCED CODE EXTENDING REPORTING SERVICES PART VIII: APPENDIXESAPPENDIX A: T-SQL COMMAND SYNTAX REFERENCE APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS APPENDIX C: MDX REFERENCE INDEX
Interesting Facts :
SQL Server 2012 will be the most significant release of SQL Server since 2005.Reporting Services is part of Microsoft's Business Intelligence toolset, and the key tool for creating reports used by decision makers.The 2012 book is more than 30% revised, plus it adds 200 new pages.The authors are very well-known Reporting Services experts, with a wide following online and at conferences.The previous two editions have sold more than 25,000 copies. Wiley is the leading publisher on data warehousing.
About the Author :
Paul Turley is a manager of Specialized Services for Hitachi Consulting Education Services. He manages the Business Intelligence training team and teaches classes on SQL Server technologies to companies around the world. He is a Microsoft Certified Trainer, with multiple industry certifications. Paul has authored several books and courses on database and BI technologies; he's the lead author of Professional SQL Server 2005/2008 Reporting Services, and other Wrox titles.Co-authors include: Robert M. Bruckner; Thiago Silva, Ken Withee, and Grant Paisley.