Transcript Agenda Short Orientation – Excel and Microsoft’s BI Our goals in designing Excel 2016 What’s new in Excel 2016 for data analysis? Demos, Demos,

Agenda
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 !
Q&A
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
{}
10101
01010
00100
Related Session
Microsoft BI Overview
Tuesday, 09:00AM
S102
Our Goal for Business Analytics in Excel 2016
Streamlined and powerful user experience
for data analysis
The User Journey – From Questions to Published Insights
Get Data
Analyze
Visualize
Publish
Is Excel > In Excel
Consume
The User Journey – From Questions to Published Insights
Get Data
Analyze
Visualize
Publish
Is Excel > In Excel
Consume
Data Acquisition
“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, SAP BO)
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)
Excel 2013
All data should be brought into the worksheet first
Transformation through Excel formulas
Can be automated w/ Macros
Excel 2016
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/o Power Query
data source
w/ Power Query
built-in
Data Acquisition
Support for New Data Sources
Data Source
File
From File (Text, CSV, XML)
Excel 2013
√
Excel workbook, Folder
Database
From Database Access, SQL Server, Analysis Services
√
Oracle, IBM DB2, MySQL, PostgreSQL, Sybase, ODBC
OLEDB Wizard
Other Sources
MS Query
Online Search
√
√
Excel 2016
√
√
√
√
√*
√*
√
Hadoop (HDFS), Azure HDInsight, Azure Blob Storage, Azure
Table Storage
√
SharePoint List,
Active Directory, Microsoft Exchange
√
Facebook
√
√
√
SAP Business Objects
Salesforce Objects & Reports
* Available from the native Excel data ribbon (not thru Power Query)
Related Theatre
Sessions
Empowering your getdata experience
with Power Query
Thursday, 11:35AM
Automating Power
Query in Excel 2016
Preview
Thursday, 01:05PM
Expo:
Office
365
Theater
Data Analysis
“I have my data, now I want to model and analyze it to find insights”
How? A streamlined, in-context, modelling experience, with new analytical capabilities
Usability and quality Improvements
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!
1. Focused on addressing customer feedback for Power Pivot,
Power Query & Power View
2. Deferred Update – Accumulate data model updates and refresh
once when switching focus back to Excel.
http://aka.ms/ExcelUpdate
ulate
Accum s
change
Data Analysis
Usability Improvements in Excel
Coming up 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
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( … )
Read more about it:
http://blogs.msdn.com/b/powerbi/archive/2014/05/08/describing-the-forecasting-models-in-power-view.aspx
Data Visualizations
“I need to visualize my data to make it presentable…”
How? Improvements to native Excel charts and to Power View
Power View OLAP Connectivity
Time Grouping in Pivot Tables and Pivot Charts
New Chart Types
Power Map
Data Visualizations
Charting in Excel – Today
Which visualizations do you use the most? Which ones do you miss?
Related
Session
What’s Next for Visualizations in
Microsoft Excel
Wednesday,
01:30PM
N231
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 for Office 365
Hands On Lab
Create an Excel BI Report and Share on SharePoint 2013
Publishing BI Reports
Embedding Interactive Reports in Blogs
Embed your Excel BI reports from O365 in Blogs and Web Sites
http://blogs.office.com/2014/12/11/power-view-interactive-visualizationspivottables-can-now-embedded-blogs-websites/
How?
http://aka.ms/ExcelEmbedding
Excel Online – BI Consumption
“I want to view and interact with an Excel report online”
How? Improvement in Excel Online consumption experiences (O365 and later on-prem)
Search in filters
Value field settings
Lots of experience improvements
Coming soon to Office 365 and later to on-premises (when Excel Online Server ships)
Get Data
Analyze
Visualize
Publish
Consume
Power Query
Integration
Enhanced Analysis
Experiences
Enhanced
Visualizations
Enterprise Catalog
Power Pivot/ Data Modelling
Usability Improvements
Power View OLAP Support
Publishing to SharePoint
and Office 365
New Chart Types
(Waterfall, Sunburst, Treemaps, …)
Publish models and
dashboard elements to
Power BI from Excel
Time Grouping
Embedding in blogs
Data Transformations
New Data Sources
Programmability using
Excel’s Object Model
Automatic Data Model
Relationship Detection
Smart Rename
Deferred Update Mode
Easy Publishing
Power Map
Native Excel Forecasting
Experiences
Programmability
And we’ve made it easier to find and learn too…
Better Excel Online
Consumption
Search in Filters
Value Field Settings
Slicer Performance
Improvements
…More features coming
regularly to Excel Online
Join The Excel BI Community !
Try Out the Office 2016 Technical Preview:
http://aka.ms/office2016techpreview
Learn more about Excel for Business Analytics:
http://aka.ms/excel/businessanalytics
Like the Excel Facebook Page
https://www.facebook.com/microsoftexcel
Join the Microsoft BI Online Community:
http://aka.ms/office365network/powerbi
Attend Related Excel and BI Sessions at this conference!
Title
Date/Time
Location
Microsoft BI Overview
Tuesday, 09:00AM
S102
Interactive Storytelling with Office
Tuesday, 03:15PM
N227
What’s Next for Visualizations in Microsoft Excel
Wednesday, 01:30PM
N231
End to end Microsoft Business Analytics solution Real world scenario and demo
Wednesday, 03:15PM
S102
Lab: Create an Excel BI Report and Share on SharePoint 2013
Ongoing
HOL2108
Theatre Session: Empowering your get-data experience
with Power Query
Thursday, 11:35AM
Expo: Office 365
Theater
Theatre Session: Automating Power Query in Excel 2016 Preview
Thursday, 01:05PM
Expo: Office 365
Theater
Thank You
Questions?
Yigal Edery
[email protected]
@yigaledery
Eli Schwartz
[email protected]
http://myignite.microsoft.com