drab to dynamite! managed self-service bi using real-world data
DESCRIPTION
Drab to Dynamite! Managed Self-Service BI Using Real-World Data. Riccardo Muti, Sandy Rivas. Please silence cell phones. Agenda. What is Power View? What’s new? Power View in Excel and SharePoint Creating reports Features Sneak peek. What is Power View?. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/1.jpg)
April 10-12, Chicago, IL
Drab to Dynamite!Managed Self-Service BI Using Real-World DataRiccardo Muti, Sandy Rivas
![Page 2: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/2.jpg)
April 10-12, Chicago, IL
Please silence cell phones
![Page 3: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/3.jpg)
3
AgendaWhat is Power View?What’s new?Power View in Excel and SharePointCreating reportsFeaturesSneak peek
![Page 4: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/4.jpg)
4
What is Power View?
An interactive data exploration,visualization, and presentation
experience.
![Page 5: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/5.jpg)
5
What is Power View?Managed self-service BI
Visual design experience
Presentation-ready at all times
Metadata-driven
Connect to Excel Data Model
Connect to Analysis Services
![Page 6: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/6.jpg)
6
Traditional reporting
![Page 7: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/7.jpg)
Traditional reporting
Design Preview(Render) Publish
Parameters Render DeliverSchedule
SQL, AS, Oracle, SAP, Essbase, Teradata, OLE DB, ODBC, XML,
…
![Page 8: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/8.jpg)
Power View
Import into Data Model
SQL, AS, Oracle, SAP, Essbase, Teradata, OLE
DB, ODBC, XML, …Explore, Interact
Present, Share
![Page 9: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/9.jpg)
Features in SQL Server 2012 RTMModel explorer and field list for
model navigation and data region structure
Motion charts
Interactivity: cross-filter, highlight, play axis, pop-out, transition animations, bubble
trails…
View and data region level filtering with slicers and
filter pane
Multiple views in a single report
Office-like shell with ribbon and canvas
Table and matrixincluding totals and
blocked layoutTab Strip and Tile Flow for data navigation
Visualization conversionsSharePoint integration (launch from library, manage, preview,
PowerPivot Gallery)
Common chart types, chart titles, axes, legend
Small multiples
Filters area with lists, numeric slider, calendar, and
advanced mode
Sorting
Graceful recovery from model changes
Drag-and-drop to Canvas
Non-measures as measures
Measures as non-measures
Textboxes with rich text formatting
Show all (outer join)
External and database images
Automatic grouping and aggregation
![Page 10: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/10.jpg)
What’s new in SQL Server 2012 SP1Model
features
HierarchiesKPIsGeographic dataHyperlink dataPerspectives
Style and formatting
ThemesBackground colorsBackground imagesEmbedded imagesFont sizeHyperlinks
Visualizations and interactivity
MapsPie chartsDrill-down
![Page 11: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/11.jpg)
Microsoft BI
![Page 12: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/12.jpg)
Types of Power View reports• Power View report
.rdlx fileContains only Power View
sheetsDoesn’t contain a data modelAll sheets connect to same
external model
• Excel workbook.xlsx fileCan contain traditional Excel
sheets and Power View sheetsCan contain a data modelSheets can connect to the
embedded data model or external models
Different sheets can connect to different models
![Page 13: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/13.jpg)
Power View feature comparisonExcel Excel Web App Power View standalone
Design reports Yes No Yes
Interact with reports Yes Yes Yes
Visualizations All All All
Cross-visualization interactivity Yes Yes Yes
Max. workbook size Client limits SharePoint limits(Office 365: 10 MB)
SharePoint limits
Embedded data model Yes Yes No
External data models Yes Yes (Office 365: No) Yes
Multiple models Yes Yes (Office 365: No) No
Multidimensional models (cubes) No No Yes
Reorder Power View sheets No No Yes
Reading and Full-Screen modes No No Yes
Zoom No Browser zoom Browser zoom
External images Yes Yes (Office 365: No) Yes
Export to PowerPoint No No Yes
![Page 14: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/14.jpg)
Power View in ExcelExcel Database
server
SQL AS (Tabular)
Power View
SQL RSADOMD.NE
T
SQL AS (PowerPivo
t)
![Page 15: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/15.jpg)
Power View in SharePointBrowser SharePoint
web serverDatabase server
SharePoint app server
Excel Web App
Excel Web Services
Excel Calculation Services
SQL AS (PowerPivo
t)
SQL AS (Tabular)
SQL RSAdd-In SQL RS
Power View
ADOMD.NET
![Page 16: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/16.jpg)
April 10-12, Chicago, IL
Demo
![Page 17: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/17.jpg)
Roadmap
SQL Server 2008 R2• PowerPivot
SQL Server 2012• Tabular
Models• Power View
Office 2013• PowerPivot
and Power View in Excel
Next…• Power View
against MD models
• …
![Page 18: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/18.jpg)
April 10-12, Chicago, IL
Demo
![Page 19: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/19.jpg)
Key takeawaysExcel: one app for modeling, analytics, visualizationWorkbooks: not just spreadsheets anymoreNext-generation visualizations and interactivityPower View in disconnected scenariosSharePoint: share workbooks and interact in browser
![Page 20: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/20.jpg)
20
Win a Microsoft Surface Pro! Complete an online SESSION EVALUATION to be entered into the draw.
Draw closes April 12, 11:59pm CTWinners will be announced on the PASS BA Conference website and on Twitter.
Go to passbaconference.com/evals or follow the QR code link displayed on session signage throughout the conference venue.
Your feedback is important and valuable. All feedback will be used to improve and select sessions for future events.
![Page 21: Drab to Dynamite! Managed Self-Service BI Using Real-World Data](https://reader038.vdocuments.us/reader038/viewer/2022103102/5681685f550346895ddea4e0/html5/thumbnails/21.jpg)
April 10-12, Chicago, IL
Thank you!Diamond Sponsor Platinum Sponsor