How to Turn Excel into an Advanced BI Solution
A detailed white paper 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 highlights 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 and graphics automatically
- Automating Excel functions by embedding them into a query