sharepoint 2010: insights into bi

SharePoint 2010: Insights into BI

Presented by:JD Wade, SharePoint Consultant, MCTS

Mail: jd.wade@hrizns.comBlog: http://wadingthrough.comLinkedIn: JD WadeTwitter: http://twitter.com/JDWade

About Me•Consultant with Horizons Consulting. We consult on SharePoint, Exchange and OCS in the Midwest

•Working in IT for over 13 years

•SharePoint Consultant for two years

•Live in St. Louis

•Avid movie watcher and love home theater stuff

Sha

reP

oint

What is BI?•Any information that pertains to the history, current status or future projections of a business organization

•Systems that provide directed background data and reporting tools to support and improve the decision-making process

Sha

reP

oint

Using Business Intelligence to…

Sha

reP

oint

Sha

reP

ointScorecardsScorecards

Slide decksSlide decks

MeetingsMeetings

Analytic applicationsAnalytic applications

PresentationsPresentations

Financial reports Financial reports

DashboardsDashboards

WebcastsWebcasts

Charts and graphsCharts and graphsInternetInternet

Project plansProject plans

DocumentsDocuments

SpreadsheetsSpreadsheets

IntranetIntranet

BlogsBlogs

PortalsPortals

RSS feedsRSS feeds

Business booksBusiness books

Television reportsTelevision reports

MagazinesMagazines

NewspapersNewspapersIM/chatIM/chat

EmailEmail

Relevant Information is Everywhere

Excel and PowerPivot

Sha

reP

oint

Excel •End User Analysis Tool of Choice

•End User BI Begins Here

•Viewing, manipulating, performing analysis on intelligence or for creating reports

•Used for:

• Browser-based access to server-calculated version of spreadsheet

• Interacting with analytic models from multiple sources

Sha

reP

oint

Excel•What‘s New

• Multi-user editing

• Slicers

• New Development Support

Sha

reP

oint

PowerPivot•Extension to Excel that adds support for large-scale data

•Codename was Gemini

•Used to:

• Explore and perform calculations on large data sets for ad-hoc reports and analysis

Sha

reP

oint

Demo

Excel Services

Sha

reP

oint

Excel Services•Server-side browser rendering of Excel spreadsheets

•Used for:

• Sharing Excel content across the organization while maintaining publishing control

• Generate a model to be broadly used(ex: mortgage calculator)

• Protect the intellectual property(formulas, etc.) contained within the spreadsheet S

hare

Poi

nt

Excel Services•What’s New

• Support for more Excel functionality

• Interactive Pivot Tables

• Default Trusted Locations

• Delegate Service Application

• PowerShell

Sha

reP

oint

Visio Services

Sha

reP

oint

Visio Services•Server-side browser rendering of Visio diagrams

•Used to:

• Build a visual representation of your business structures that are bound to data

• Represent processes, systems, and resources

Sha

reP

oint

PerformancePoint

Sha

reP

oint

PerformancePoint•Performance management service with tools to monitor and analyze business data.

•IT easy-to-use tools for building dashboards, scorecards, and KPIs

•Used for:

• Creating dashboard, scorecards, and KPIs

• Providing drill-down analysis

Sha

reP

oint

PerformancePoint•What’s New

• Decomposition Tree

• Improved scorecards

• Time Intelligence filtering improved

• Connectable web parts

• KPI Details report

• Enhanced analytic reports

Sha

reP

oint

Reporting Services

Sha

reP

oint

Reporting Services•Reports, Reports, Reports

•Can be published to SharePoint

•Used to:

• Deliver reports that publish at regular intervals and on-demand

• Deliver reports with well established requirements

Sha

reP

oint

Reporting Services•What’s New (R2)

• Can install add-in before SharePoint 2010 & one step integration

• Local Mode Report Viewing

• SSRS is reporting engine for Access Services reporting

• Native support for Reporting on SharePoint Lists

• Performance improvements

• ULS Logging

Sha

reP

oint

Microsoft’s 2010 Insights Strategy

BI Data Flow

Whiteboard Discussion

Sha

reP

oint

Q & A