Analysing data with Excel

If you have loads of data to analyse then PowerPivot may be of use to you. It is a plugin for Excel 2010 and allows you to analyse very large sets of data, very rapidly, in real-time. The documenation suggests that you think of it as Excel PivotTables on steroids! The main advantage that it has over PivotTables is its ability to pull data from one database and match it against data from elsewhere.

So, if your school has pupil data in lots of different files and formats this may be the tool for you. It’s free, you just need to learn to use it and find its potential!

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.