Ed on Office

Tuesday, June 23, 2009

Office 2010 Info on SQL pages


Here's some interesting facts on what's coming in Office 2010 and SQL Server 2008 R2


Add-in for Microsoft Office Excel 2010
Build Robust Analytical Applications
Combines native Excel 2010 functionality with an in-memory, column oriented processing engine to allow users to interactively explore and perform calculations on millions of rows of data at lightening speeds
Streamlines the process of integrating data from multiple sources – including corporate databases, spreadsheets and external sources
Access PivotTables, slicers, and other familiar analysis features in Excel to create reports and perform advanced analysis


Add-in for Microsoft Office SharePoint 2010
Share & Collaborate with Confidence
Enables users to publish reports and analyses to SharePoint to make them available to others in the organization
Applications and reports can be refreshed automatically while also maintaining version control and tracking
Central, secure location where users can easily control who has access to sensitive data while also maximizing the number of people who can view the reports


SharePoint 2010 Management Console
Manage User-Generated Analytical Applications
Provides a single, comprehensive management tool through Microsoft Office SharePoint that gives IT administrators the ability to set server policies and monitor Self Service BI activities
IT can manage and secure all BI assets, freeing the original authors to focus on business priorities
Dashboard views to monitor access and utilization of analyses and reports as well as track patterns of hardware usage to help ensure the right security privileges are applied and user generated solutions are continuously available, up-to-date, and secured



Read all about it and look at some screenshots here:



Presenting at Joel Oleson's Seminar tour in Melbourne

You've probably picked up by now that Quest has organised SharePoint Seminars around Australia in July.
Joel Oleson, SharePoint Guru and ex Microsoft SharePoint Team member will present on how to turn your SharePoint deployment project into a success and what you can do to prepare for the next version.

I don't think deployment of SharePoint 2007 is as successful as it can be without considering the added value of Office 2007 and the integrated features it offers users. So I'm presenting a breakout session during the Melbourne event about just that, how and why Office 2007 is a perfect fit to complement your SharePoint environment. I'll go beyond the obligatory Connect to Outlook action and demonstrate the power of Access, Visio, Word and Excel.

Please come and join us at this free seminar, but hurry, spaces are limited.

Click here to register for the Melbourne event on July the 9th.