What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: What's new in Excel 2016 - ModelOff GTC 2015
Select a size
Come see the innovations coming in 2016, learn how Excel can better empower you to gather the data around you, get the insights that matter, and share them to make an impact.
What’s New In Excel 2016
Principal Program Manager
Short Orientation – Excel and Microsoft’s BI
Our goals in designing Excel 2016
What’s new in Excel 2016 for data analysis?
Demos, Demos, Demos !
Introduction - Excel in the modern world
The world of data is changing…
Massive amounts of data available, businesses want to make informed business decisions
Excel is the world’s #1 tool for data analysis, with hundred of millions of users using it for BI !
…And it’s available to users on all platforms: Windows, iOS, Android and Web.
Excel 2016 will deliver on two primary business needs:
Business Intelligence for the data analyst, integrated with Power BI for Office 365
Data Loss Prevention, integrated with SharePoint
This session is focused on Business Analytics in Excel 2016
Our Goal for Business Analytics in Excel 2016
Streamlined and powerful user experience
for data analysis
The User Journey – From Questions to Published Insights
Is Excel > In Excel
“I need to bring in the data relevant to the question I’m trying to answer…”
How? Modernizing Excel’s data acquisition experience using Power Query
Find Enterprise data easily
Support New Data Sources (e.g. Salesforce, DynamicsCRM)
Data Shaping & Transformations
Bringing data into the data model or to Excel sheets
Benefits from deep integration:
Discoverable, Natural & Available to all users, Programmable via Object Model.
Data Acquisition One Place To Find The Data You Need
Find Enterprise-managed data sets (Information Catalog)
Share your Queries with other users in your org (Self service and IT blessed queries)
Fetch public data from web sites
Make data easily available for users to consume and analyze
Data Acquisition Data Shaping and Transformations (ETL)
w/o Power Query
All data should be brought into the worksheet first
Transformation through Excel formulas
Can be automated w/ Macros
Easy-to-use UI to transform the data
Transformation Sequence defined in the Query Editor
Automatically repeated during refresh (on new data)
Bring in partial data if needed
Bring data to worksheet or to the data model
Powerful query language (M) for advanced users
Queries can be merged or appended
w/ Power Query
Data Acquisition Support for New Data Sources
From File (Text, CSV, XML)
Excel workbook, Folder
From Database Access, SQL Server, Analysis Services
Oracle, IBM DB2, MySQL, PostgreSQL, Sybase, ODBC
Enterprise Catalog Search
Hadoop (HDFS), Azure HDInsight, Azure Blob Storage, Azure Table Storage
SharePoint List, Active Directory, Microsoft Exchange
Salesforce Objects & Reports
Power Query Demo
“I have my data, now I want to model and analyze it to find insights”
A streamlined, in-context, modelling experience, with new analytical capabilities
Usability and quality Improvements
Automatic relationship detection
In-context editing of data model and measures
Native Excel Forecasting (Formula & Experiences)
Data Analysis Improvements in Excel 2013
Excel 2013 BI December ‘14 Release!
Focused on addressing customer feedback for Power Pivot, Power Query & Power View
Deferred Update – Accumulate data model updates and refresh once when switching focus back to Excel.
Data Analysis Usability Improvements in Excel
Available in Excel 2016:
Search in Field List
Smart Rename of tables, columns & measures
In-context automatic relationships detection
In-context create, edit and delete measures
Power Pivot Demo
Data Analysis Predictive Analytics
New time-series forecasting (using exponential smoothing)
Forecast.ETS(time, time_series, value_series)
Forecast.ETS.Seasonality( … )
Forecast.ETS.Confint( … )
Forecast.ETS.Stat( … )
“I need to visualize my data to make it presentable…”
How? Improvements to native Excel charts and to Power View
Time Grouping in Pivot Tables and Pivot Charts
New Chart Types
3-D maps - Power Map
Data Visualizations Charting in Excel - Today
Which visualizations do you use the most? Which ones do you miss?
Data Visualizations Charting in Excel - What's coming?
Time Grouping and New Chart Types Demo
Publishing BI Reports
“I want to publish my Excel report…”
How? Publishing from within Excel
To SharePoint On-Premises
To Office 365 / Share Point Online
To Power BI
Publishing BI Reports Embedding Interactive Reports in Blogs
Embed your Excel BI reports from O365 in Blogs and Web Sites
“I want to view and interact with an Excel report online”
Improvement in Excel Online consumption experiences (O365 and later on-prem)
Search in filters
Value field settings
Lots of experience improvements (number formatting, viewport,…).
Available at your Office 365 and coming soon to on-premises (when Excel Online Server ships)
Excel Online Demo
In Summary – Business Analytics Value in Excel 2016
Publishing to SharePoint and Office 365
Publish models and dashboard elements to Power BI from Excel
Embedding in blogs
Power Query Integration
New Data Sources
Programmability using Excel’s Object Model
Enhanced Analysis Experiences
Power Pivot/ Data Modelling Usability Improvements
Automatic Data Model Relationship Detection
Deferred Update Mode
Native Excel Forecasting Experiences
New Chart Types (Waterfall, Sunburst, Tree-maps, …)
3-D Maps - Power Map
Better Excel Online Consumption
Search in Filters
Value Field Settings
…More features coming regularly to Excel Online
And we’ve made it easier to find and learn too…
Join The Excel BI Community !
Learn more about Excel for Business Analytics:
Check out the Excel Blog:
Like the Excel Facebook Page
Join the Microsoft BI Online Community:
Pass along customer feedback:
Send your suggestion to Excel's User Voice Suggestion Box!
Thursday Dec 3rd
11:00 12:45 Advanced analysis & Power Pivot
1:30 2:15 End to End report creation using VBA
2:30 3:15 Introduction to Power BI
Friday Dec 4th
9:00 9:45 Excel everywhere
10:00 10:45 Advanced data visualizations
11:00 11:45 Data acquisition in Excel using Power Query and Data cleansing & manipulation
Bring your data to life at the inaugural Microsoft Data Insights Summit,
a two-day event for business analysts to connect with each other and with industry experts.
Discover best practices, new tools, and new ways to get things done.
Visit DataInsightsSummit.com to register.
Questions? More Questions? Eli Schwartz
© 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Cut/Copy/Paste/Delete of query tables/connections/PQ queries
Support Object Model and Macro Recording (VBA, C#, Powershell)
Use ODC files across different envs: dev, staging, production (relative file path) - can we commit?
© 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.'s coming?