Connecting Technology and Business.

Advanced analytics functionality in Excel 2016

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 features:

Advanced analytics and modelling capabilities with Power Pivot

With the full Power Pivot management UX, users can benefit from advanced modelling capabilities like Diagram View, KPIs, Hierarchies and DAX Calculated Columns.

New ways to get the Excel business analytics features  1

Advanced connectivity options with Power Query

For 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.

New ways to get the Excel business analytics features  2

Advanced collaboration

With 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 Catalog.

New ways to get the Excel business analytics features  3

-Microsoft Excel Team