building stylish power view reports sean boon senior lead program manager microsoft corporation...
TRANSCRIPT
![Page 1: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/1.jpg)
Building Stylish Power View Reports
Sean BoonSenior Lead Program ManagerMicrosoft Corporation
DBI302
Building Stylish & Effective Power View Reports
![Page 3: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/3.jpg)
Objectives
Introduction to Power ViewPower View Feature Deep DiveDemo, Demo, DemoRevealing the magic
Tips and Tricks to Get the Most Out of Power View
![Page 4: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/4.jpg)
Part 1
Breakthrough Insights with Power View
![Page 5: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/5.jpg)
POWER VIEW
Highly visual design experience
Rich metadata-driven interactivity
Presentation-ready at all times
END USER ALERTING
Defined from within operational or
ad-hoc reports
Intuitive Alert rules
Alerts self-managed through SharePoint
ENABLED AS SHAREPOINT SHARED SERVICE
Built-in scale-out for RS Service Apps
SharePoint Cross-farm reporting
Integrated backup & recovery, ULS logging, PowerShell etc.
SSRS INVESTMENTS IN SQL SERVER 2012
Managed Self Service BI – Corporate BI
![Page 6: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/6.jpg)
WHAT IS POWER VIEW?
Easily change data and layout with quick clicks
Collaborate with full interactivity
Share dynamic reports quickly and easily
From Authoring to Presentation in Clicks
Cross Browser & Platform Managed & Discoverable
![Page 7: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/7.jpg)
SQL SERVER 2012 POWER VIEW
Interactive, web-based authoring and sharing of informationFamiliar Microsoft Office design patternsPowerful and flexible data layout with banding, callout and small multiples visualizations
![Page 8: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/8.jpg)
SQL SERVER 2012 POWER VIEW
Fully integrated with PowerPivot and the BI Semantic ModelDrive greater insight through smart and powerful queryingZero configuration highlighting and filteringAnimated trending and comparisons
![Page 9: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/9.jpg)
SQL SERVER 2012 POWER VIEW
Interactive Presentation turns pervasive information into persuasive informationDeliver and collaborate through SharePointFull screen presentation mode for interactive boardroom session
![Page 10: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/10.jpg)
DESIGNED FOR NEW WAVE OF INFORMATION WORKERS
VISUAL EMBELLISHMENTS SUPPORT & ENRICH DATA STORY TELLING
1-way to do things
2 clicks to Return on Investment (ROI)
All tasks done in context
Everything happens on the canvas, with the data
Less is more
Choose the right default, by default
Easy for the user, hard on us
Highly performing and efficient
Power View UI Design Principles
Easily change data and
layout with quick clicks
Collaborate with full
interactivity
Share dynamic reports
quickly and easily
![Page 11: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/11.jpg)
MANY POWER VIEW 2012 FEATURES
Model Explorer and Field list for model navigation and data region structure
Motion charts
Interactivity: highlight, cross filter, play axis, popup,
transition animations, bubble trails…
View and data region level filtering with
slicers and filter paneExport to
PowerPoint
Multiple views in a single report
Canvas, ribbon, application infrastructure
Table & Matrixincluding subtotals,
totals, blockingTab Strip and Cover Flow Tiles for data navigation
Data region conversions
SharePoint integration (launch from doc lib,
manage, preview, Power Pivot gallery)
Common chart types, chart titles, legend, axes,
configure chart, chart series
Small multiples layout
Presentation mode with interactivity
Filter pane supports lists, measure slider, calendar, and
advanced mode
Sorting
Graceful recovery from model changes
Drag and Drop to Canvas
Measures as Non Measures
Non Measures as Measures
Textboxes with rich text formatting
Show All
Embedded image support
Automatic Grouping improvements
![Page 12: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/12.jpg)
demo
Power View
![Page 13: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/13.jpg)
![Page 14: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/14.jpg)
![Page 15: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/15.jpg)
Sophisticated Design Environment
Report Viewer Controls
Rich Design Capabilities
Productive Authoring
Re-use of insights
Flexible layout
Visual data representation
Highly Interactive
Rich Presentation
POWER VIEW FOR ALL USERS
Embedded Operational Business
Report Designer Report Builder Power View
![Page 16: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/16.jpg)
POWER VIEW SHAREPOINT ARCHITECTURE
SharePoint Farm
Web Front End App Server
HeterogeneousData sources
SSDT BISM ModelPower View client
Excel PowerPivot
![Page 17: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/17.jpg)
Part 2
Revealing the Magic
![Page 18: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/18.jpg)
Power Pivot and the BI Semantic Model
Image URLsDefault Field ListSort ByNumber FormattingRelationships
![Page 19: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/19.jpg)
The Value of DAX
Count & Distinct Count
Sum Min & Max Average
Included in Power View by Default
Addition and Subtraction
Ratios
Time Intelligence Rank Inventory
Calculations
Standard Deviation &
Variance
Text Functions
Define Your Own
Context
Power View with DAX
Power View with DAX
![Page 20: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/20.jpg)
demo
DAX and the BI Semantic Model (BISM)
![Page 21: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/21.jpg)
Key Takeaways
Power View is a new Reporting Services offeringPower View is an interactive, ad hoc, query and visualization experience.Power View enables you to go from static to interactive presentationsTo help your users get the most out of Power View you need:
an understanding of Power Pivot, BI Semantic Model settings, andDAX
Power View is fun because it’s smart, simple and flexible.
![Page 22: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/22.jpg)
Call To Action & Resources
Web and WhitepapersPower View TechNet Wiki (Links, Videos, and Training)Learn DAX in 30 Minutes (includes downloadable workbook with DAX)
BlogsReporting Services Team Blog
FAA SampleFAA
Try it today. No install required.Public facing demos
TwitterJoin the discussion #PowerView, #PowerPivot, #msbi
![Page 23: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/23.jpg)
Related Content
DBI52-HOL Exploring Power View in Microsoft SQL Server 2012
Find Me Later in the Breakthrough Insights Booth
DBI330 Killer Real World PowerPivot ExamplesDBI307 Tips and Tricks for Building Rich Reports in Microsoft SQL Server 2012 Reporting ServicesDBI206 Business Intelligence and Data Visualization: Microsoft SQL Server 2012DBI301 Building Self-Service BI Applications Using PowerPivotDBI303 Building the Perfect BI Semantic Tabular Models for Power ViewDBI305 Developing and Managing a BI Semantic Model in Microsoft SQL Server 2012 Analysis ServicesDBI201 What's New in Microsoft SQL Server Reporting ServicesDBI323 Enriching Your BI Semantic Tabular Models with DAXDBI414 Optimizing Your BI Semantic Model for Performance and Scale
![Page 24: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/24.jpg)
Sean Boon
blogs.msdn.com/seanboon
@seanboon
![Page 25: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/25.jpg)
Track Resources
@sqlserver@ms_teched
mvaMicrosoft Virtual Academy
SQL Server 2012 Eval Copy
Get Certified!
Hands-On Labs
![Page 26: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/26.jpg)
Resources
Connect. Share. Discuss.
http://northamerica.msteched.com
Learning
Microsoft Certification & Training Resources
www.microsoft.com/learning
TechNet
Resources for IT Professionals
http://microsoft.com/technet
Resources for Developers
http://microsoft.com/msdn
![Page 27: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/27.jpg)
free $10 gift cardJust take the Microsoft Business
Intelligence Survey
Go to the SQL Server 2012 Breakthrough Insights booth to claim your gift card…while
they last!
![Page 28: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/28.jpg)
Complete an evaluation on CommNet and enter to win!
![Page 29: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/29.jpg)
Please Complete an Evaluation Your feedback is important!
Multipleways to Evaluate Sessions
Scan the Tagto evaluate thissession now on myTechEd Mobile
![Page 30: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/30.jpg)
© 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.
![Page 31: Building Stylish Power View Reports Sean Boon Senior Lead Program Manager Microsoft Corporation DBI302 Building Stylish & Effective Power View Reports](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dd95503460f94acf35c/html5/thumbnails/31.jpg)