PowerPivot allows business users to take a much more important role in creating ideas that are relevant to making decisions. While traditional BI depends almost entirely on the IT department to create reports, understand the business logic, and convert data into an idea that could be consumed by customers. PowerPivot transforms this into a BI solution, driven by users where the business users can really define what they really want from the IT infrastructure. It is then able to break the barrier of understanding between the IT personnel, and the end user.
If you are one of the thousands of Exel users struggling with the creation of new VBA codes, or trying to reach solutions that are semi-dynamics due to the limitations of traditional Excel, PowerPivot will make your life easier in almost every way.