ICC Denali

download report

Transcript ICC Denali

[email protected]

• • • • • • • •

Chris McNulty

SharePoint Strategic Product Manager at Quest Software

10+ years with SharePoint 20 years consulting (led KMA SharePoint practice) and financial services technology (Santander, John Hancock/Manulife, GMO, State Street) MBA in Investment Management from Boston College Write and speak often on Microsoft IW technologies (blogs & books) MCSE MCTS MSA MVTSP MCC Hiking, cooking, playing guitar, colonial history, photography My family: Hayley, three kids (17, 8, 5) and my dog Stan ©2011 Quest Software, Inc. All rights reserved..

3

Agenda

Business Intelligence in SharePoint Today

SQL Server 2012 Overview

SQL Server Reporting Services

Power View – Crescent

Always On

Upgrade paths

©2011 Quest Software, Inc. All rights reserved..

4

Goals for BI Design

• Answering the known questions about our business • Allowing users to self-discover patterns and answers to questions we haven’t yet been asked

Complexity Levels of These Solutions

Time ©2011 Quest Software, Inc. All rights reserved..

6

SharePoint BI Evolution

Chart Web Part Excel Services • Excel Web Access • PowerPivot Enabling technologies • Business Connectivity Services • SQL Reporting Services • Pivot • Azure DataMarket Performance Point • Dashboards • Analysis Services Custom Solutions • Mapping • Web Parts • Etc.

©2011 Quest Software, Inc. All rights reserved..

7

• • • • •

SQL Server Reporting Services (SSRS)

“Code free” integrated solution (with SQL 2008 R2) • (can also use Business Intelligence Developer Studio) SharePoint integrated mode preferred Export contents to Excel, Word, etc.

Reuse in SharePoint and Performance Point Dashboards Use when some reports are printed, multipage, etc.

©2011 Quest Software, Inc. All rights reserved..

8

PowerPivot

• “Project Gemini” – host 1 10MM row datasets • Excel and SharePoint components • Data doesn’t live in spreadsheet • Released with SQL Server 2008 R2 but doesn’t explicitly require the R2 Engine ©2011 Quest Software, Inc. All rights reserved..

9

Recap: Microsoft and SQL 2008 R2

• Invested heavily for Corporate BI  Shared DataSets  Report parts, Report part gallery  New Visualizations: Map, gauge, sparkline, databar, KPI  Ajax Report viewer • Cut scenarios  Adhoc reporting  Alerting ©2011 Quest Software, Inc. All rights reserved..

10

Introducing SQL Server 2012 ©2011 Quest Software, Inc. All rights reserved..

11

SQL Server Provides Rapid Data Exploration

Only 28% of an organization has access to BI tools*

Gartner, “Business Intelligence Purchase Drivers and Adoption Rates, 2009 Survey Results,” Bill Hostmann, Sept. 4, 2009 ©2011 Quest Software, Inc. All rights reserved..

With Managed Self-Service BI ©2011 Quest Software, Inc. All rights reserved..

Provides Required 9s of Availability Without Cost and Complexity ©2011 Quest Software, Inc. All rights reserved..

Summary

Required 9s Blazing Fast Enhanced and Visualization Self Service BI Consistent Data Superior DW Scale Cloud and On Premise Anywhere

©2011 Quest Software, Inc. All rights reserved..

SharePoint/SQL 2012 BI

Chart Web Part Excel Services • Excel Web Access • PowerPivot SSRS • Alerts • Data Feeds Enabling technologies • Business Connectivity Services • SQL Reporting Services • Pivot • Azure DataMarket PowerPivot • Power View Self-Service Performance Point • Dashboards • Analysis Services Custom Solutions • Mapping • Web Parts • Etc.

©2011 Quest Software, Inc. All rights reserved..

16

Self Service Alerting – User Benefits

Create data alerts from within reports • • • Users create alerts directly on the data they see in reports Report authors control which data is available for alerting Supports reports created in Report Builder or BI Development Studio (BIDS) Detect important data changes • • • Intuitive Alert Rules (greater than, before/after) Easy to use scheduling (weekly, daily, monthly) Relevant data included in Alert Message Source: Data.gov - Data.gov and the Federal Government cannot vouch for the data or analyses derived from these data after the data have been retrieved from Data.gov.

©2011 Quest Software, Inc. All rights reserved..

17

Self Service Alerting – IT Benefits

Managed through SharePoint • • • • Per site administration reduces IT burden Fine grained authorization Self-managed through SharePoint IT Visibility & Control of user-defined alerts ©2011 Quest Software, Inc. All rights reserved..

18

• • •

New SSRS SharePoint Integration Benefits

• • SSRS SharePoint 2010 Shared Service Hosted in SharePoint Shared Service App pool SSRS catalog DBs are SharePoint Service App DBs • • • • WCF and Claims based communication PowerShell Cmdlets Central Admin UI for all RS administration ULS Logging integration • • Built-in scale-out and load balancer Report Performance Improvements For reports in AJAX Viewer • • • Parity with Denali Native mode performance Top SharePoint mode pain point Small reports used to be 2-3 times slower: Fixed • Faster than 2008 R2 SharePoint mode ~ 30-60% SQL Setup option for SSRS SharePoint service ©2011 Quest Software, Inc. All rights reserved..

19

SSRS SharePoint Integration Architecture for SQL Server codenamed “Denali”

Alert Designer SharePoint Web Front End SharePoint App Server Alert Manager SSRS in Web Application RS Add-in SSRS Shared Service Application SSRS Shared Service Application SharePoint Config / Content DB Report Server Shared Service DB ©2011 Quest Software, Inc. All rights reserved..

20

Self-Service Alerting – How it works

©2011 Quest Software, Inc. All rights reserved..

21

Receiving alerts

©2011 Quest Software, Inc. All rights reserved..

22

DEMO

Self Service Alerting

©2011 Quest Software, Inc. All rights reserved..

23

SQL Server 2012 Power View • • • Highly Visual Design Experience Interactive, web-based authoring and sharing of information Familiar Microsoft Office design patterns Powerful data layout with banding, callout and small multiples visualizations • • • • Rich metadata-driven interactivity Fully integrated with PowerPivot Drive greater insight through smart and powerful querying Zero configuration highlighting and filtering Animated trending and comparisons • • • Presentation-ready at all times Interactive Presentation turns pervasive information into persuasive information Deliver and collaborate through SharePoint Full screen presentation mode for interactive boardroom session ©2011 Quest Software, Inc. All rights reserved..

PowerPivot for SharePoint

Server, Services, and Components SharePoint Farm

Client User renders a workbook WFE

Excel Web Access Excel Calc Services Application Proxy Excel Web Service PowerPivot Web Service c2wts

App

Excel Calculation Services MSOLAP TCP HTTP Channel PowerPivot Sys Svc Application Proxy PowerPivot System Service Analysis Services in VertiPaq Mode

Content

SQL

Data Sources

©2011 Quest Software, Inc. All rights reserved..

25

• •

DEMO

PowerPivot Power View

©2011 Quest Software, Inc. All rights reserved..

26

SQL Server 2012 RTM

• Multiple views • Export live to PowerPoint • Storyboard view • Chart interactivity • Canvas UI • Print ©2011 Quest Software, Inc. All rights reserved..

27

SQL Server AlwaysOn

• Integrated, flexible, efficient high availability for mission critical business • High availability platform built for the future • On-Premise, Private and Public Cloud • Comprehensive database and instance-level protection  

AlwaysOn Availability Groups

database protection Multi-Database Failover Multiple Secondaries  Active Secondaries  Integrated HA Management

AlwaysOn Failover Cluster Instances

instance level protection     Multisite Clustering Flexible Failover Policy Improved Diagnostics Built for consolidation scenarios ©2011 Quest Software, Inc. All rights reserved..

28

Deployment Scenarios

2 Disaster Recovery Target 1 2 Primary Availability Replica Secondary Availability Replica 1 2 Read-only Environment Backup Stretch Cluster Production Environment ©2011 Quest Software, Inc. All rights reserved..

29

Availability Solutions

AlwaysOn Failover Clustering Geo-clustering or Synchronous Database Mirroring Log Shipping Zero Seconds RPO Minutes Backup/Restore Hours ©2011 Quest Software, Inc. All rights reserved..

Days 30

Limitations

• SharePoint 2010 does not support multi-site, stretch clusters • Intra-farm latency cannot exceed 20ms first byte / 1ms RTT between components/farm members • Asynchronous replication is discouraged to protect data integrity ©2011 Quest Software, Inc. All rights reserved..

31

Climb Denali – You Can Do It! (upgrade, I mean…)

©2011 Quest Software, Inc. All rights reserved..

32

In-Place Upgrade – Overview

• Upgrades existing installation • On same machine and platform • Instance name remains • Old instance is removed • New shared components are installed • User data and configuration is preserved • Mostly automated process through Setup • Existing instance is intact as long as possible • Can upgrade to same edition or higher ©2011 Quest Software, Inc. All rights reserved..

33

In-Place Upgrade – Matrix

©2011 Quest Software, Inc. All rights reserved..

34

• • • • •

Don’t Fall!

• CTP3 <> RTM!!!!

RTM March 7 2012!

• • • Infrastructure Must run SP2010 SP1 Upgrade to PowerPivot v2 Excel Incompatible with Project Server 2010 (for now!) SSAS Cubes • Alerts Not intended for real-time notification • • Structured Data Feeds Power View • Requires PowerPivot v2 Always On Not click-click-OK!

©2011 Quest Software, Inc. All rights reserved..

36

Engineering

Business Connectivity Services (BCS) Performance Point SQL Analysis Services Reporting Services (SSRS) Integrated Secure Store Service Excel Services Excel Services Office Web Apps (OWA) PowerPivot Secure Store Service SQL 2008 R2 Enterprise SQL Server Reporting Services (SSRS) SSRS Alerts SQL 2008 R2 SharePoint Integrated (BIDS for Native Mode) Kerberos [optional] SQL Server 2012 Pivot Silverlight Power View Power Pivot v2 ©2011 Quest Software, Inc. All rights reserved..

37

BI Solutions in SharePoint 2010/SQL 2012

Large Datasets Self Service Visual Navigation PowerPivot Power View Pivot PerformancePoint SSRS Alerts Mapping Printing or exporting SQL Reporting Services SharePoint list KPI / Status Indicator Chart Web Part Excel Services Small Datasets 38 ©2011 Quest Software, Inc. All rights reserved..

Resources - General

• From Microsoft: • SQL 2012: http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

• Business Intelligence: http://www.microsoft.com/bi/ • SharePoint 2010 site: http://sharepoint.microsoft.com

• SharePoint Team Blog: http://blogs.msdn.com/sharepoint/default.aspx

• BI Blog: http://blogs.msdn.com/b/bi/ • From Quest • www.quest.com

• SharePoint Community www.sharepointforall.com

©2011 Quest Software, Inc. All rights reserved..

39

The carousel paradox…

Questions

Contact Me

Evaluations

©2011 Quest Software, Inc. All rights reserved..

41

Thank you…

• Contact • • • • Email [email protected]

Blog http://www.chrismcnulty.net/blog http://www.sharepointforall.com

Twitter: @cmcnulty2000 and • LinkedIn: http://www.linkedin.com/in/cmcnulty Upcoming: • • • March - SharePoint Conference Australia April – SPS Twin Cities, TEC San Diego May – New England SPUG ©2011 Quest Software, Inc. All rights reserved..

42

©2011 Quest Software, Inc. All rights reserved..