Excel 2016 provides capabilities that allow users
to further enhance your data analysis experiences and share their data and
analysis more effectively across their company. These features, usually
suitable for professional business analysts, come with all premium plans of
Office 2016, including Office 365 ProPlus, Office Professional Plus, Excel 2016
Standalone, and now also in Office 2016 Professional.
Here is the list of the advanced analytics
Advanced analytics and modelling
capabilities with Power Pivot
the full Power Pivot management UX, users can benefit from advanced modelling
capabilities like Diagram View, KPIs, Hierarchies and DAX Calculated Columns.
options with Power Query
corporate users who require advanced connectivity and importing features, Microsoft
has added the option to connect to corporate, big data and cloud data sources,
such as Oracle, DB2 or MySQL database, a variety of Azure data sources, such as
Azure SQL Database, Salesforce, Hadoop files and many more.
an addition of Power BI license, users will also benefit from a corporate data
search and will be able to share their import and transformation queries with
other analysts within their organization through the means of a Corporate Data