Introduction to Self-Service Reporting and Analysis with SQL Server 2008 R2 No matter how many high quality reports you develop, your users will always want more. They may want to change something on an existing report, do their own analysis on the same data, or create a brand new report altogether. You have two choices: either you can spend all of our time meeting this never ending demand, or you can put great tools and resources in place to enable self-service reporting and analytics. SQL Server 2008 R2 provides comprehensive tools and capabilities to satisfy even the most demanding user. This unit will introduce you to the fundamentals of self-service reporting and analytics with SQL Server 2008 R2, including how to enable great reporting experiences for your users with Report Builder 3.0 and great analytical experiences with PowerPivot for Excel 2010. Hands-On Labs Hands On Lab: Building and Sharing Your First Report Builder 3.0 Report This Hands On Lab will show you how to build your first Report Builder 3.0 report to perform self-service reporting, and how to share it with SQL Server 2008 R2 Reporting Services and SharePoint 2010. Hands On Lab: Building and Sharing Your First SQL Server 2008 R2 PowerPivot for Excel Workbook This Hands On Lab will show you how to build your first SQL Server 2008 R2 PowerPivot for Excel workbook to perform self-service analysis, and how to share it with SQL Server 2008 R2 PowerPivot Server for SharePoint. Videos Presentation: Self-Service Reporting Fundamentals with SQL Server 2008 R2 This presentation introduces the concept of self-service reporting and the business scenarios it addresses, and discussions how SQL Server 2008 R2 can be used to meet these requirements. An architectural overview of SQL Server 2008 R2 self-service reporting components is also provided including Report Builder 3.0 and SQL Server 2008 R2 Reporting Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Self-Service Reporting with Report Builder 3.0 This demo shows how users can create a report with Report Builder 3.0 and SQL Server 2008 R2 Reporting Services using the map wizard that will leverage a shared dataset and report parts. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: Self-Service Analysis Fundamentals with SQL Server 2008 R2 This presentation introduces the concept of self-service analysis and the business scenarios it addresses, and discusses how SQL Server 2008 R2 can be used to meet these requirements. An architectural overview of SQL Server 2008 R2 self-service analysis components is also provided including SQL Server 2008 R2 PowerPivot for Excel and SQL Server 2008 R2 PowerPivot Server for SharePoint 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Self-Service Analysis with SQL Server 2008 R2 PowerPivot for Excel 2010 This demo shows how a user can create an in-memory cube with SQL Server 2008 R2 PowerPivot and Excel 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Sharing and Collaboration with SQL Server 2008 R2 PowerPivot Server for SharePoint 2010 This demo shows how to deliver browser-based access to SQL Server 2008 R2 PowerPivot workbooks using SharePoint 2010 Excel Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.