Microsoft Power Pivot for Excel is a powerful data analysis tool, which allows the user to transform enormous quantities of data into meaningful information.
Key features include:
Excel is limited in the amount of data it can work (maximum of just over 1 million rows) with which can be restrictive when dealing with multiple sources of data. Power Pivot for Excel seeks to solve these issues, allowing the user to:
Data from multiple sources including web resources, SQL databases, Excel spreadsheets or from Access databases and can be imported into a Data Model. The image above shows data imported from Access into Power Pivot for Excel which was performed during a recent training session we delivered for Lincoln University. Multiple tables have been imported, the largest one containing over 2.5 million rows of data. Analysis is then performed on the imported data using Excel and Access type functions (and in some cases Excel functions which work in a similar fashion to their Excel equivalents e.g. Concatenate) to produce the information in the format required.
William Hamilton of Lincoln University commented “I came with a specific problem which was preventing the completion of a task involving Excel; by the end of the training, not only had the problem been solved but the task had been completed as well. The techniques taught will help in the future as well.”
For further information on Power Pivot for Excel, please call 0114 4040 160 or Contact Us.