PowerPivot

What is PowerPivot for Excel?

Microsoft Excel is the most popular tool IT professionals use to analyze data and the groundbreaking PowerPivot for Excel is changing the world of data analysis.

A Microsoft Excel add-in, PowerPivot adds to the already exceptional power of Microsoft's award-winning analysis engine, bringing the full features of a columnar database to Excel. PowerPivot for Excel arms business users and IT professionals with the revolutionary power to perform complex data analysis without the intervention of Business Intelligence (BI) technicians.

Why Choose PowerPivot for Data Analysis?

PowerPivot is the first tool available from Microsoft to handle self-service Business Intelligence. The amazing new PowerPoint technology implements a powerful in-memory database that gives IT professionals and business users a quick and easy way to browse information. The PowerPivot tool can organize data, detect interesting relationships and perform an entourage of fascinating features and functions including:

• The ability to analyze millions of rows of data, build complex simulation patterns and integrate databases, Excel worksheets, Internet sources and almost any kind of data.


• The ability to define surprisingly rich expressions through DAX (a powerful programming language) compared to those standard in Microsoft Excel. DAX defines complex expressions on top of the relational database.


• Incredibly fast in-memory processing of complex queries over the whole database.


• The availability of a fast, space-saving columnar database. The PowerPivot database can handle huge amounts of data without the limitations of Excel worksheets.


• Ability to organize tables for the PivotTable in a relational way. PowerPivot also frees the analyst from the need to import data as Excel worksheets before analyzing the data.

Learn from the PowerPivot Pros

The PowerPivot Pros at Light Speed Solutions are here to help business users become more proficient in this incredible new technology and to acquire the skills necessary to implement PowerPivot applications, perform data analysis and share these applications with other users. Call Light Speed Solutions today at (631) 752-2000 to inquire about our PowerPivot Training and PowerPivot Consulting services.