Home | About Us | Career | Contact
  Upcoming Live Webcasts

Business Intelligence Blogs

SharePoint Blogs

SharePoint 2010 Resources

SharePoint Products Team Blog

SharePoint Well Received

SharePoint Full Feed

SharePoint Miscellaneous

2010 Information Worker Demonstration and Evaluation Virtual Machine (RTM)

Monthly Business Intelligence Review - August 2010

Business Intelligence & Search

Download SharePoint Server 2010 Beta

Microsoft SQL Server Blogs

Microsoft Dynamics Axapta, CRM, & GP

Upcoming Live Webcasts

Upcoming Events

Download Microsoft 2010 Beta Versions

 
 
Microsoft SQL Server Blogs

Microsoft Excel – team blog for Excel & Excel Services
Microsoft OLAP by Mosha Pasumansky – Deep Insights into SSAS & MDX
NickNick Barclay: BI-Lingual –PerformancePoint Server resources
The Microsoft PerformancePoint Team Blog
Patrick Baumgartner’s Unofficial PPS Blog
PerformancePointy – Wade Dorrell’s PerformancePoint & other-stuff blog

Details

Archrived Webcasts Info

Overview

Microsoft SQL Server PowerPivot for Excel 2010

PowerPivot for Excel 2010 (formerly known as "Gemini") is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. It provides users with the ability to analyze mass quantities of data and IT departments with the capability to monitor and manage how users collaborate by integrating seamlessly with Microsoft SharePoint Server 2010 and Microsoft SQL Server 2008 R2.

You can give your users the power to gain deeper insight into any business aspect and compress decision cycles. You can enable your users to share their findings with others effortlessly and securely. You can increase the efficiency of your IT department through the PowerPivot Management Dashboard.


What’s New in BI

Microsoft SQL Server PowerPivot for Excel 2010

                (Click to Expand)

PowerPivot technology redefines how IT departments deliver and succeed with BI:
  • Give users the best data analysis tool available
    Build on the familiarity of Excel to accelerate user adoption. Expand the existing capabilities with column-based compression and in-memory Bi engine, virtually unlimited data sources, and new Data Analysis Expressions (DAX) in familiar formula syntax.
  • Facilitate knowledge sharing and collaboration on user-generated BI solutions.
    Deploy SharePoint 2010 to provide the collaboration foundation with all essential capabilities, including security, workflows, version control, and Excel Services. Install SQL Server 2008 R2 to enable support for ad-hoc BI applications in SharePoint, including automatic data refresh, data processing with the same performance as in Excel, and the PowerPivot Management Dashboard. Your users can then access PowerPivot workbooks in the browser without having to download workbooks and data to every workstation.
  • Increase BI management efficiency.  
    Use the PowerPivot Management Dashboard to manage performance, availability, and quality of service. Discover mission-critical applications and ensure that proper resources are allocated.
  • Provide reliable access to trustworthy data.
    Take advantage of SQL Server Reporting Services data feeds to encapsulate enterprise systems and reuse shared PowerPivot workbooks as data sources in new analyses.

Next Steps

Download the CTP

Connect with the SQL Server development team

Let us know what you think

Attend PASS summit for a deep dive

What's New in R2 Editions

  •  What top companies are doing right with their BI initiatives and what you can learn from them. By Doug Henschen, Intelligent Enterprise
  •  Manufacturers and retailers lead the way in using up-to-the-minute point-of-sale data to avoid stock-outs and overproduction. By Doug Henschen, InformationWeek
  •  This comprehensive data platform is secure, reliable, and scalable for your mission critical applications and provides rich services for any data type.
  •  Learn more about this enterprise class, low-cost, feature-rich and easy-to-use data platform
  •  The Blueprint Poster by Advaiya gives IT managers a comprehensive view of how Business Intelligence & Search technologies work within their IT environment.
  •  In a platform-aligned environment, organizations can easily and inexpensively poll existing data sources and live business processes to get the most recent and accurate picture of the environment.
  •  Find out how Microsoft BI can help you in IT, Finance, Operations, and Sales
  •  Microsoft BI offers a complete, fully integrated set of BI technologies that can help reduce the complexity of organizing and distributing information, enable better business decisions, and improve your bottom line.
  •  Improving business insight and performance with business intelligence.

Previous    1  |  2     Next  
Back to top

 

Home | About Us | Products | Services | Case Studies | Clients | Partners | News | Career | Contact
 
VTL Consulting - Copyright 2009 - All Rights Reserved