The Microsoft Office 2010 suite of products integrates into the Microsoft BI solution stack, and is primarily aimed at disseminating BI to the entire organisation.

Business Intelligence Concepts provided by Office 2010

1.  Visualisation

Microsoft BI solutions make it easy to connect and overlay live business intelligence data in context on diagrams, helping people understand processes and improve performance in a fraction of the time.

For example, Visio diagrams tell the story behind your data in meaningful ways by showing the data in context rather than in static charts, graphics, or tables alone.

2.  Ad-Hoc Analysis

Microsoft Excel and PowerPivot gives employees the power to create timely, ad-hoc reports that deliver answers to critical business questions.

Even without deep technical knowledge or experience, employees can create, customize and run their own reports dynamically.

An example of self-service BI reporting enabled by Microsoft Office and PowerPivot: