About Me

My photo
I'm currently the CTO for Hedgehog Technology a business dedicated to delivering Cloud based productivity solutions in Logistics

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:

No comments: