PowerPivot for Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel.
You can transform enormous quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. PowerPivot can even help your IT department improve operational efficiencies through SharePoint-based management tools.
Excel-Based In-Memory Analysis: Overcomes existing limitations for massive data analysis on the desktop with efficient compression algorithms to load even the biggest data sets into memory.
Data Analysis Expressions (DAX): Puts powerful relational capabilities into the hands of power users who want to create advanced analytics applications.
SharePoint Integration: Enables users to share data models and analysis, and because the solutions are in SharePoint, you can configure refresh cycles to ensure the data remains current automatically.
Virtually Unlimited Support of Data Sources: Provides the foundation to load and combine source data from any location for massive data analysis on the desktop, including relational databases, multidimensional sources, cloud services, data feeds, Excel files, text files, and data from the Web.
PowerPivot Management Dashboard: Enables IT administrators to monitor and manage your shared applications to ensure security, high availability, and performance.
Hit the ground running: Leverage familiar Excel features you already know, such as the Office Fluent user interface, PivotTables, PivotCharts, and slicers.
Enjoy fast calculations and analysis: Process millions of rows in about the same time as thousands, and make the most of multi-core processors and gigabytes of memory for fastest processing of calculations.
Meet your security and compliance policies: Publish your workbook applications in a managed SharePoint environment and you implicitly observe the security and compliance policies that your IT department sets and enforces
PowerPivot for Excel 2010 is a real game changer, give it a shot now! www.powerpivot.com
