
Learn the basics of SQL Server 2005 Reporting Services by following the step-by-step tutorials as you work through each stage of the reporting life cycle to author, manage, and deliver reports across your organization. You’ll start by learning how Reporting Services provides a complete reporting solution, how to install and configure Reporting Services, and how to use the Report Wizard to build a simple report. Then you’ll learn how to enhance reports with advanced techniques to meet a variety of reporting requirements and how to build report models to support ad hoc report development for non-technical users. Next you’ll learn how to organize, manage, and secure reports as well as how to monitor and administer the Report Server. You’ll also learn about the options available for accessing reports online, delivering reports to specific destinations, and creating ad hoc reports with Report Builder. Finally, you’ll learn how you can author, manage, and deliver reports programmatically to build your own applications with Reporting Services as the foundation platform.
Sample solution file (120KB)
Sample database (5.2 MB)
Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Use the practical step-by-step exercises in this book to learn how to unify and integrate your business data to support reporting and analysis with SQL Server 2005 Analysis Services. The first part of the book explains the fundamentals of business intelligence and data warehousing, shows how Analysis Services 2005 implements the benefits of OLAP, and introduces you to the development and deployment of an Analysis Services cube. In Part II, you focus on basic dimension and cube design principles by learning how to use specific Analysis Services features to create different types of dimensions, add various types of measures to a cube, and organize dimension attributes into hierarchies for user navigation and aggregation optimization. The third part of the book teaches you how to work with more advanced features, such as MDX calculations, key performance indicators, dimension relationships. You’ll also learn how to implement interactive features like actions, links to reports, drillthrough, and writeback. The final part of the book shows you how to manage an Analysis Services database in production by implementing security, creating partitions, configuring storage options, and managing processing.
Sample solution file (85KB)
Sample database (7.4MB)