Transcript How do we define a dashboard, and how do I get all this stuff on my dashboard? Philosophical changes in 2013 What’s new in Excel.

How do we define a dashboard, and how do I get all this stuff on my
dashboard?
Philosophical
changes in 2013
What’s new in
Excel and Excel
Services?
Apps for Office
What’s new in
PerformancePoint?
The Tool:
Excel Services
Visio Services
PerformancePoint
The Tool:
Excel
Power View
PowerPivot
Sharing
End user exploration
The stack:
Data Analysis with SQL
Analysis Services
SQL Server
Integration Services
On-Premise and Cloud
Personal BI
Self-Service BI
Corporate BI
You create your
own workbook
and use the rich
features of Excel
to interact with
the workbook and
the data it
contains.
You create your
workbook and
publish it to
SharePoint for
wider
consumption.
“Professionally”
authored using
SharePoint, Excel
Services, and
PerformancePoint.
Has lasting power.
“Microsoft
enables
business users
to look no
further than
Excel for selfservice BI”
The Forrester Wave™:
Self-Service Business
Intelligence Platforms,
Q2 2012, Forrester
Research, Inc., June
12, 2012.
How do you pair self-service BI with the needs of IT and smart business?
From PowerPivot . . .
to Analysis Services
Field List/Field
Well
EffectiveUsername
Automatic Target
App Creation
BI Server
NOV2
Also known as Agaves . . .
Content Area
Task Pane
File Shares
Marketplace
Corporate Catalogs
Office Application
Manifes
t
<XML>
Web
Page
(HTLM+JS)
JS
Office
Web
Extension
How do I make one of these things?
And then . . .
How do I deploy it?
2
Azure AD
SharePoint
PowerPivot
Model
3/5
4
1/6
BI Azure
Client
Excel Team Blog
Reporting Services Team Blog
SkyDrive (Beta 2 Workbooks)
Data Visualizations in Power View
What’s new in Power View in Excel 2013 and
Sharepoint 2013
Past
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
Islander Ballroom GB
Wed 10:30am - 11:45am
What's New in Spreadsheet
SPC260
Management for Office and SharePoint
Future
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
MySPC
http://myspc.sharepointconference.com