February 22, 2019
Data Analytics in Excel 2016

Data Analytics in Excel 2016

Data Analytics in Excel 2016

Data Analytics in Excel 2016

Data Acquisition

  • Extract Enterprise data easily using PowerQuery built into Excel.
  • Supports New Data Sources like Hadoop, Azure HDInsight, SharePoint List, Relational Databases and much more.
  • Data Shaping, Cleansing & Transformations
  • Bringing data into the data model or to Excel sheets using PowerQuery & PowerPivot

Data Analytics in Excel 2016

Copy/Paste Queries between workbooks and between Power BI Desktop and Excel

See Excel Online Enhancements for SharePoint 2016 and O365

Data connectivity updates:

  1. Support for SharePoint Lists from non-English sites.
  2. Enhanced support for the Exchange connector.
  3. Automatic column type detection when importing .XLS files via the Excel Workbook connector.
  4. A new “Select Related Tables” option when connecting to database sources.
  5. Enhanced Active Directory connector credentials.
  6. An improved function invocation experience.
  7. A new option to delete all entries in the Data Source Settings dialog.
  8. An option to “Enable Relationship Import during Refresh operations.”

Also read “What are Data Analysis Expressions

Data Analysis Improvements in Excel 2016

  • Usability improvements
  • Deferred Refresh
  • Search in Field List
  • Smart Rename of tables, columns & measures
  • In-context automatic relationships detection
  • In-context create, edit and delete measures

See the Microsoft Office 2016 Updates to know more

Forecasting in Excel 2016

New time-series forecasting (using exponential smoothing)

  •   Forecast.ETS(time, time_series, value_series)
  •   Forecast.ETS.Seasonality( … )
  •   Forecast.ETS.Confint( … )
  •   Forecast.ETS.Stat( … )

Know more about forecast in Excel 2016 for Windows

Data VisualizationsData Analytics in Excel 2016

This release introduced new charts across Excel, Word and PowerPoint.

  • Waterfall
  • Histogram
  • Pareto
  • Box & Whisker
  • Treemap
  • Sunburst

Read at Office Blog to know more

Publishing BI Reports

Data Analytics in Excel 2016

  • SharePoint 2013 & 2016 On-Premises
  • To Office 365 & Share Point Online
  • Power BI Service @ PowerBI.com


Related Posts

End of Spec War for Android? With the release of the Samsung Galaxy S4, it became much clearer that Android indeed is looking at the peak of its career in the mobile operati...
How to Fix Airplane mode not turning off in Window... Just as you would expect, the "Airplane mode" in Windows 10 is a system setting that allows you to turn off all wireless communications on your PC. Wi...
How to Embed PowerBI Reports on Websites In order to Embed PowerBI Reports on Websites, you would need to be at the report level. From the file menu, you will now get multiple options to ex...
Resolve and Fix Error “something happened 0x... Resolve and Fix Error "something happened 0x80070002 - 0x20016" All Users of Windows 7, 8 & 8.1 who are eligible for a free upgrade to Windows 10...
Disclosure: We are a professional review website that sometimes receive compensation or free units from the companies whose products we review. We test each product thoroughly and give high marks to only the very best. We are independently owned and the opinions expressed here are our own.