How to Turn Excel into an
Advanced BI Solution
A detailed whitepaper providing a dozen specific features necessary to ensure that an Excel centric BI Solution fully leverages advanced Excel capabilities thereby providing end-users the reporting flexibility and autonomy necessary to make actionable real-time business decisions. Some of the points covered include:
- Taking advantage of Excel automatic dataset naming
- Empowering end-users by passing constraints to the query using an Excel named cell
- Avoiding manual updates by updating pivot tables & graphics automatically
- Automatically applying Excel functions by embedding them into a query
- Much More!