There are a number of features coming in Excel 2016 that will be useful for those engaging in Business Intelligence activities.
Power View Connected Directly to OLAP
One of the key new features is the ability to connect directly to OLAP cubes instead of having them refreshed through Power Pivot. Power View can now be used to power live data access to OLAP cubes with Power View’s visualization capabilities such as KPI’s, hierarchies, charts, dashboards, etc.
Power Query Integration
Power Query will be a core part of the product instead of a downloadable add-on. Power Query is a key component to integrating Excel with other big data services and on-premise databases.
New Forecasting Functions
There are a number of new forecasting functions that improve the accuracy of forecast calculations.
Support for Multiple Selections for Slicer Items
In the current version of Excel, the touch experience limits slicers to a single selection. In 2016, you can select multiple items in a slicer.