Transcript Geospatial business intelligence with Power Map, Power View, and SQL Server reporting services Ari Schorr Michael Wilmot.

Geospatial business intelligence
with Power Map, Power View, and
SQL Server reporting services
Ari Schorr
Michael Wilmot
1.
2.
3.
Spreadsheet Jail
Business Insights with Office 365
Discover
• Analyze
• Visualize
•
•
Excel
Share & Get Answers
Power BI
CORPORATE BI
SQL Server Reporting
Services
SELF SERVICE BI
Power View
Power Map
7
SPATIAL
Data Conflation Overlay
TEMPORAL
Pattern & Animation
Reframing
Cartogram Normalization
Source: PowerMaps, Various; ‘World Mapping’ Dorin, Barford & Newman; IPE UX Analysis,
• Collecting the data
• Exploring the data patterns
• Investigating the outliers / patterns
• Visualizing and sharing the results
9
Inspire people to
imagine…

Map Data
• Data in Excel or
Power Pivot Data
Model
• Geo-Code
• 3D and 4 Visuals
Discover Insights
• Play over Time
• Annotate points
• Capture scenes
Share Stories
• Cinematic Effects
• Interactive Tours
• Share Workbook or
Export to Video






Pros
Bubble Maps, Column Maps, Region Maps and HeatMaps
Interactive and time-play axis
Ability to create and share visual tours
Ability to add multiple layers
Storytelling tool, not just visualization





Cons
Unable to filter data
Unable to drill-down (though can switch between layers)
Unable to customize or add custom shapes
Unable to handle hierarchies
 Presentation ready
 Interactive data exploration
 Ease of visualization




Pros
Bubble Maps
Bubble Maps with Pie Charts
Interactive with drill down capabilities in larger dashboard




Cons
Unable to add multiple layers or any other customizations
No other major type of map visualization
No time play or storytelling capabilities







Pros
SQL Geospatial types supported – buffers, intersections…
Leverage underlying SQL & IIS portal scale and collab.
Ability to add nested parameters, filtering, Bing layer, etc….
Full SSRS capabilities to include security, scheduling, config.





Cons
Aging platform.
More sophisticated developer skills required.
More IT involvement for setup and maintenance of servers.
Static visualizations

WHERE Report.[IncidentPoint].STIntersects(Roads.RoadLineString.STBuffer(200)) = 1
http://www.youtube.com/user/10MinCollege
Customer Benefit
Map Data
Discover Insights
Share Stories
Investment
Area
Features added for
GA
Features Requested*
for post-GA
Geospatial
Automatic mapping of
columns
1-Click Add Data to Map
from Power Query
Real-time Data
Analysis &
Visualization
Regions
Flat Map
Filtering
Custom Regions
Platform
Create Video
Power BI Site and App
integration
Interactive tours in Office
(i.e. Power View)
 Power BI add-in download
Microsoft Download Center
Public Preview
 Office 365 ProPlus (Office 365 Enterprise versions)
 Office Professional Plus 2013 (Volume licensing)
 Excel 2013 Standalone (Volume licensing and Retail)
General Availability (Office SP1, 2/25)
 Native to Excel for Office 365 ProPlus (subscription only)
Mission
To transform data into fluid 3D stories, unlocking
new insights for everyone
Excel in
Office 365
ProPlus/E3
BI content creation
Power Query, Power Pivot,
Power View, & Power Map
SharePoint Online P2
Power BI for Office 365

BI sharing & viewing
Viewing (HTML5): <10MB
Viewing (HTML5):
<250MB


BI Sites (organized report homepage)

Query Sharing & Enterprise Data Search

Data Management & Mobility
Data Stewardship & Scheduled Refresh

Q&A (Natural Language Query)

Power BI for Windows & iPad (Mobile BI)

Session Title
Session Code
Session Type
Data modeling and governance with
business intelligence
SPC327
Best Practices
Ashvini Sharma , Sanjay Soni
Deep dive on self-service data retrieval
With Power Query
SPC328
Deep Dive
Matt Masson
Deep Dive on the Data Management
Gateway in Power BI for connectivity to
on premise and hybrid scenarios
SPC397
Deep Dive
Matt Masson
Demystifying Kerberos in SP2013 and
SQL 2012 for business intelligence
SPC422
Best Practices
John Cole, Scott Stewart
Operational reporting and dashboarding SPC370
using Microsoft Business Intelligence
Solutions
Best Practices
John White
SharePoint BI and Power BI - Happy
Together
How to
Dany Hoter , Yigal Edery
SPC2992
Speakers
Get $300 off with discount code:
BACSPC
passbaconference.com
Calling All Data Professionals:
JOIN US to stay ahead of the curve in the changing world of analytics with
more than 70 sessions by the world’s top BI and BA experts.
Sponsored by