About the Book
Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions
Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
Includes programming examples focused on specific, scenario-based solutions
Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques
Table of Contents:
Foreword. Introduction.
Part I: Getting Started.
Chapter 1: Introducing Reporting Services.
Chapter 2: Business Intelligence Solutions.
Chapter 3: Reporting Services Installation.
Chapter 4: Reporting Services Architecture.
Part II: Report Design.
Chapter 5: Basic Report Design.
Chapter 6: Report Layout and Formatting.
Chapter 7: Designing Data Access.
Chapter 8: Advanced Report Design.
Part III: Business Intelligence Reporting.
Chapter 9: Reporting with Analysis Services.
Chapter 10: Report Solution Patterns and Recipes.
Part IV: Enabling End-User Reporting with Report Builder 1.0.
Chapter 11: Report Models.
Chapter 12: Report Builder 1.0.
Part V: Administering Reporting Services.
Chapter 13: Content Management.
Chapter 14: Report Server Administration.
Part VI: Reporting Services Integration and Custom Programming.
Chapter 15: Integrating Reports into Custom Applications.
Chapter 16: Integrating Reports with SharePoint.
Chapter 17: Extending Reporting Services.
Appendix A: RDL Object Model.
Appendix B: T - SQL Command Syntax Reference.
Appendix C: T - SQL System Variables and Functions.
Appendix D: MDX Reference.
Index.
About the Author :
Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to design architecture for and build BI and reporting solutions. He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike, and Hewlett - Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications, including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner, and IT Project+.
Paul has authored and coauthored several books and courses on database, business intelligence, and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: “ SQL Server 2008 Business Intelligence Solutions ” and “ SQL Server 2008 Reporting Services Solutions. ” His books include Professional SQL Server 2005 Reporting Services , Professional SQL Server Reporting Services (SQL Server 2000) , Beginning Transact - SQL with SQL Server 2000 and 2005 , Beginning SQL Server 2005 Administration , Beginning Access 2002 VBA , Data Warehousing with SQL Server 2000 Analysis Services , and Professional Access 2000 Programming — all from Wrox. He is also a contributing author to SQL Server 2005 Integration Services Step by Step from Microsoft Press. Thiago Silva (Dallas, TX) is a Manager of Specialized Services for Hitachi Consulting. Thiago has also been designing and developing custom .NET, business intelligence, and Reporting Services solutions since the early days of .NET and SQL Server 2000. He is a part of the Microsoft Strategic Alliance leadership group within Hitachi Consulting, where he helps create, manage, and deliver internal training materials and intellectual capital around the Microsoft technology stack. He also teaches the SQL Server Reporting Services course offered by Hitachi Consulting.
Thiago has been a featured guest on the talk show podcast .NET Rocks and is an active member of the .NET development community, frequently writing on his blog Silvaware, at http://silvaware.blogspot.com. Thiago holds a Bachelor of Business Administration degree in Management Information Systems from Texas A & M University, and a MCAD.NET technical certification.
Bryan C. Smith (Irving, TX) is a Manager of Specialized Services for Hitachi Consulting. Bryan has been developing and administering database solutions since 1997 for clients in a variety of industries. These days, he focuses on helping clients build Business Intelligence solutions using the Microsoft SQL Server product suite. Bryan holds MCITP, MCTS, MCDBA, A+, Network+, and Server+ certifications, and serves as an instructor for Hitachi Consulting ’ s SQL Server Analysis Services course.
Ken Withee (Seattle, WA) is a Senior Consultant with Hitachi Consulting. He earned a Master of Science degree in Computer Science studying under Dr. Edward Lank at San Francisco State University. Their work has been published in the LNCS journals and was the focus of a presentation at the IASTED conference in Phoenix. Their work has also been presented at various other Human Computer Interaction conferences throughout the world.
Ken has more than 7 years of professional computer and management experience working with a vast range of technologies.
Ken is a Microsoft Certified Technology Specialist and is certified with Microsoft Office SharePoint Server 2007 and SQL Server 2005, and has passed the certification exam for .NET 2.0.
Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to design architecture for and build BI and reporting solutions. He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike, and Hewlett - Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications, including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner, and IT Project+.
Paul has authored and coauthored several books and courses on database, business intelligence, and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: “ SQL Server 2008 Business Intelligence Solutions ” and “ SQL Server 2008 Reporting Services Solutions. ” His books include Professional SQL Server 2005 Reporting Services , Professional SQL Server Reporting Services (SQL Server 2000) , Beginning Transact - SQL with SQL Server 2000 and 2005 , Beginning SQL Server 2005 Administration , Beginning Access 2002 VBA , Data Warehousing with SQL Server 2000 Analysis Services , and Professional Access 2000 Programming — all from Wrox. He is also a contributing author to SQL Server 2005 Integration Services Step by Step from Microsoft Press. Thiago Silva (Dallas, TX) is a Manager of Specialized Services for Hitachi Consulting. Thiago has also been designing and developing custom .NET, business intelligence, and Reporting Services solutions since the early days of .NET and SQL Server 2000. He is a part of the Microsoft Strategic Alliance leadership group within Hitachi Consulting, where he helps create, manage, and deliver internal training materials and intellectual capital around the Microsoft technology stack. He also teaches the SQL Server Reporting Services course offered by Hitachi Consulting.
Thiago has been a featured guest on the talk show podcast .NET Rocks and is an active member of the .NET development community, frequently writing on his blog Silvaware, at http://silvaware.blogspot.com. Thiago holds a Bachelor of Business Administration degree in Management Information Systems from Texas A & M University, and a MCAD.NET technical certification.
Bryan C. Smith (Irving, TX) is a Manager of Specialized Services for Hitachi Consulting. Bryan has been developing and administering database solutions since 1997 for clients in a variety of industries. These days, he focuses on helping clients build Business Intelligence solutions using the Microsoft SQL Server product suite. Bryan holds MCITP, MCTS, MCDBA, A+, Network+, and Server+ certifications, and serves as an instructor for Hitachi Consulting ’ s SQL Server Analysis Services course.
Ken Withee (Seattle, WA) is a Senior Consultant with Hitachi Consulting. He earned a Master of Science degree in Computer Science studying under Dr. Edward Lank at San Francisco State University. Their work has been published in the LNCS journals and was the focus of a presentation at the IASTED conference in Phoenix. Their work has also been presented at various other Human Computer Interaction conferences throughout the world.
Ken has more than 7 years of professional computer and management experience working with a vast range of technologies.
Ken is a Microsoft Certified Technology Specialist and is certified with Microsoft Office SharePoint Server 2007 and SQL Server 2005, and has passed the certification exam for .NET 2.0.
