We are pleased to invite you to the August 14th 2008 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below:
6050 Oak Tree Blvd. Suite 300
Cleveland, OH 44131
5:00 - 5:45 PM - Early Arrival/Discussions
Join Bob Coppedge As they discuss the current state of Microsoft certifications for database professionals
5:45 - 6:00 PM - Dinner
6:00 - 7:00 PM - The Business Intelligence (BI) features of Excel 2007 by Deepak Puri
The Excel pivot table has long been one of the most popular BI tools for data analysts, and the most frequently used client tool for SQL Server OLAP cubes. Now, with Excel 2007, its integration with Analysis Services has been revamped to comprehensively support SQL Server 2005-specific features. We will explore how this integration helps to improve the user experience.
Many other enhanced Excel 2007 features, such as charting, filtering and formatting, bring significant benefits to BI usage scenarios as well. In addition, the new Excel Services feature of SharePoint 2007 allows spreadsheets to be published to a SharePoint server, and be viewed by users via web browsers.
We will examine how this new functionality makes Excel 2007 a powerful and flexible BI client tool.
Deepak is a Business Intelligence Consultant at a large insurance company, and has been working with SQL Server Analysis Services since 2000. His interest in OLAP technology arose from working with large volumes of call center telecom data. In addition, Deepak also works with performance data and Key Performance Indicators (KPI's) for new business processes. Recent project work includes SSAS cube design, and dashboard and reporting front-end design for cube data, using Reporting Services, SharePoint and third-party OLAP-aware Web Parts Deepak is also an SQL Server Analysis Services MVP.
7:00 - 7:30 PM - Wrap up / Ongoing discussions
To register, go to www.bennettadelson.com/sql and click on the link "reserve your seat".