philosophical changes in 2013 whats new in excel and excel services? apps for office whats new in...
TRANSCRIPT
SharePoint ConferenceKevin DonovanProgram Manager, Office BI
SPC009
• In Nevada, there are more than 209,000 slot machines normally operating 24 hours a day, seven days a week.
• The average annual temperature in Las Vegas is 66 degrees.• It would take 288 years for one person to spend one night in every hotel room in Las Vegas.• More than 110,000 marriage licenses are issued in Las Vegas each year.• The electric bill for the Luxor beam is $51 an hour. The beam of light atop the Luxor is made up of 39
individual lamps. Each xenon lamp costs $1,200 and will last about 2,000 hours.• Las Vegas means "the meadows" in Spanish.
A Little Vegas Trivia
Agenda
Philosophical changes in
2013
What’s new in Excel and Excel
Services?Apps for Office
What’s new in PerformancePoi
nt?
How do we define a dashboard, and how do I get all this stuff on my dashboard?
Office BI Strategy
The stack:Data Analysis with SQL
Analysis ServicesSQL ServerIntegration Services
The Tool:End user exploration
ExcelPower ViewPowerPivot
The Tool:Sharing
Excel ServicesVisio ServicesPerformancePoint
Flavors of BI
On-Premise and Cloud
Personal BI
You create your own workbook
and use the rich features of
Excel to interact with the
workbook and the data it contains.
Self-Service BI
You create your workbook and publish it to
SharePoint for wider
consumption.
Corporate BI
“Professionally” authored using
SharePoint, Excel Services,
and PerformancePoint. Has lasting
power.
The Forrester Wave™: Self-Service Business Intelligence Platforms, Q2 2012, Forrester Research, Inc., June 12, 2012.
“Microsoft enables business users to look no further than Excel for self-service BI”
What’s new in BI for Excel?
Let’s Take a Look . . .
Quick AnalysisRecommended Pivot TablesTimeline SlicerQuick ExplorePower View
Keeping the Data Together
How do you pair self-service BI with the needs of IT and smart business?
Keeping Data Together
Access version history of files stored
Configure custom alerts, notifications and automatic workflows
Audit changes made to spreadsheets and Access databases
Keeping Data Together
From PowerPivot . . .
to Analysis Services
What’s New in Excel Services
Field List/Field Well
EffectiveUsername
BI ServerAutomatic Target App Creation
NOV2
Demo
NOV2Field List / Field WellEffectiveUsernameAutomatic Target App CreationBI Server
Apps for Office
What are Apps for Office?
Content Area
Also known as Agaves . . .
Task Pane
Where do Apps for Office live?
File Shares
Marketplace
Corporate Catalogs
How do Apps for Office Work?
• iFrames within the Office app
• Client JavaScript libraries for Office
• Manifest + JS + Office App = App for Office
• If you can show it in a web site, you can show it in an app.
Office Application
Office Web
Extension
Manifest
<XML>
WebPage
(HTLM+JS) JS
Client Fidelity = Browser Fidelity
Making and App for Office
How do I make one of these things?
And then . . .
How do I deploy it?
Demo
Excel client additionMake a simple AppFile share catalogsSharePoint catalogs
What’s New in PerformancePoint• Themes• BICenter (Dashboard Designer in the ribbon)• Filter Enhancements• Filter Search• EffectiveUsername• Custom Target Applications• Server-side Migration• Dashboard Designer Authentication
DemoFilter SearchNon-PPS Target ApplicationsEffectiveUsernameBISM files as a data sourceServer-side migrationThemes
Dashboards in the Cloud
Client
PowerPivotModel
1 / 6
2
3 / 5
Azure AD
SharePoint
BI Azure
4
Takeaways
ResourcesExcel Team BlogReporting Services Team BlogSkyDrive (Beta 2 Workbooks)Data Visualizations in Power ViewWhat’s new in Power View in Excel 2013 and Sharepoint 2013
Related Sessions
Configuring your SharePoint farm for Business Intelligence
SPC165 Mandalay Bay Ballroom H
Tues 10:30am - 11:45am
What's New in Excel, Excel Services 2013 and Excel Web Apps
SPC257 Lagoon ABGH Tues 5:00pm - 6:15pm
What's New in Spreadsheet Management for Office and SharePoint
SPC260 Islander Ballroom GB Wed 10:30am - 11:45am
Practical Deployment Aspects of Business Intelligence
SPC196 Reef Thur 10:30am - 11:45am
Deep Dive on Implementing Security for your BI Applications
SPC074 Mandalay Bay Ballroom L
Thur 10:30am - 11:45am
Deep Dive on PowerPivot in Office and SharePoint
SPC075 Reef Thur 12:00pm - 1:15pm
Past
Future
Evaluate this session now on MySPC using your laptop or mobile device: http://myspc.sharepointconference.com
MySPC
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.