Ad-hoc Analysis uses Microsoft’s Pivot Tables and Pivot Charts which leverage the data cubes and dimensions in the data warehouse.

This capability provides strategic decision support and is mostly used by analysts and top managers. The combination of available data cubes and the flexibility in pivot tables supports the dynamic nature of the business and allows for a quick response to unique and unpredictable requests and questions.

One of the values that this approach brings is the ability to quickly create new reports and views, versus relying on technical development and report writers, which usually takes much longer than business needs allow.