Session 1: Introduction to SQL Server 2008 R2 Reporting Services and SharePoint 2010 Integration
Speaker: David E. Myers
Ever since business applications were introduced, there was a need for great data reporting tools. With the release of SQL Server Reporting Services 2008 R2, Microsoft has made a stronger case than ever for investing in their reporting solution. In this session David will provide an overview of SQL Server 2008 R2 Reporting Services with a focus on the key value proposition, core architecture, development tools, and integration with SharePoint 2010.
David is an IT professional and developer at the Upper Canada District School Board (Brockville, ON). He primarily works with SQL Server, SharePoint and Windows Client / Server infrastructure, but like many Canadian IT professionals he wears many hats. As a SQL Server MVP and a member of Microsoft’s Springboard Technical Experts Panel (STEP) he is constantly looking to connect with people that share his passion for technology. In his spare time David works as a Microsoft Certified Trainer in the Kingston and Ottawa areas.
Session 2: Excel Has Never Been the Same with Self-Service Analytics on SQL Server 2008 R2
Speaker: Edwin Sarmiento
We have to admit that Excel is the most popular data visualization tool there is. In this session, we’ll look at using Excel to gather data, cleanse and model that data, and then use it as a source for pivot-table and pivot-chart analysis – all in the context of self-service analytics in SQL Server 2008 R2. We’ll also look at some of the new analysis features available in Excel 2010, including slicers, improved charting, and improved pivot-table functionality.
Edwin Sarmiento works as a SQL Server DBA/Systems Engineer for The Pythian Group in Ottawa, ON in Canada. Prior to joining Pythian, he was a senior systems engineer/DBA for Fujitsu Asia Pte Ltd in Singapore. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – “To help people grow and develop their full potential as God has planned for them.”
Location:
Kingston Frontenac Public Library
Calvin Park Branch – Community Room
88 Wright Cres
Kingston, Ontario K7L 4T9
Agenda:
6:00 – Registration
6:15 – Session 1: Introduction to SQL Server 2008 R2 Reporting Services and SharePoint 2010 Integration
7:15 – Intermission / Q & A
7:30 – Session 2: Excel Has Never Been the Same with Self-Service Analytics on SQL Server 2008 R2
8:30 – Wrap Up & Door Prizes
Registration:
http://kitpro-062810.eventbrite.com
Notes:
Pizza and Pop will be served, Please RSVP to help us order enough of both.