THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

The Business Intelligence (BI) features of Excel 2007

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:

Microsoft Corporation
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.

About Deepak

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 and click on the link "reserve your seat".


Published Wednesday, August 13, 2008 9:33 AM by AllenMWhite
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement