End to End Report Creation and Management using Microsoft SQL Server 2008

Audience This session is aimed towards those who are new to using Microsoft SQL Server 2008 Reporting Services and those who wish to learn the features of Reporting Services 2008. It is advantageous if you understand • Experience using Microsoft Windows Operating System • Basic Transact SQL Select statements • An understanding of basic relational database concepts Description With Reporting Services 2008, Microsoft takes a step forward in presenting SQL Server as an enterprise data platform rather than just a database engine. With innovations in data regions, vast improvements in visualisation, and a new Report Designer, Microsoft SQL Server 2008 Reporting Services provides a tool that can be used by all members in the organization. This session will walk through the authoring, management and delivery of reports with a focus on the new features of Reporting Services 2008. At the end of this session you will understand how to create a report in the new report designer. Be aware of the Report management options available and the delivery mechanisms that can be used to deliver reports. This seesion will also finish on the Objectives At the end of this session, students will appreciate how to: • Create and explore report structures in Business Intelligence Development Studio o New Report Designer o Tablix data region o Gauge data region o Improved visualisation through charts • Delivering reports to your User o Report Manager o Report Builder • Managing Report in Report Manager. o Properties o History • Reporting Services 2008 Installation. o Where is IIS? o Sharepoint Integrated mode o Migration issues

Chris Testa-O'Neill

Chris Testa-O'Neill is a Practise Consultant at EMC Consulting. He specialises in SQL Server Business Intelligence Solutions  in the SQL 2005 and 2008 product range. Chris is also a technical author is currently working on E-Learning courses for SQL Server 2008 with Microsoft Learning. He also runs the Manchester SQL Server User Group and is a SQLBits Organiser. Chris is a SQL Server MVP and MCT and has Microsoft qualifications in MCDBA, MCTS and MCITP in SQL Server 2000, 2005 and 2008 as well as an MCSE in Windows Server 2000 and 2003.

Chris Testa-O'Neill's blog http://sqlblogcasts.com/blogs/testas/

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck

<< 1 >>

---

Other sessions from this conference

A Testing Time...

A walk down memory lane

Advanced T-SQL (2005 and 2008)

Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite

Data Vizualisation - Make your reports useful to business - No more "Speed Dials"

Does your cube support your users reporting needs?

Don't try this at work !

Getting more value from your data through data mining.

Head in the Cloud...

How to approach zero downtime database upgrades

Indexes Basically

Microsoft's integrated end-to-end BI offering.

Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse

Small Problem - Simple Solution: Lookup Tables

SQL Server – Under New Management

SQL Server 2008 for Developers

Understanding Query Cache and Query Plans

Useful Sql'y stuff that I've picked up over the years

Where’s my data? An introduction to Spatial Queries in SQL Server 2008