Building a

front-end BI

solution based

on SharePoint

2010

What’s on the table?

SharePoint 2010 BI Solutions with SQL Server

2012

• Power Pivot V2

• SSRS Integrated Mode

• Excel Services

• Performance Point

1

More!

• Power View

• SSRS Data Alerts

• We’re going on a picnic!

SQL server 2012

4

Database Services

SQL Server*

SQL Azure*

Replication

SQL Azure Data Sync*

Full Text &

Semantic Search*

Data Integration

Services

Integration

Services*

Master Data

Services*

Data Quality

Services*

StreamInsight*

Project “Austin”*

Analytical Services

Analysis Services*

Data Mining

PowerPivot*

Reporting Services

Reporting

Services*SQL Azure Reporting*

Report Builder

Power View*

* New / improved in SQL Server 2012

2

SharePoint 2010 BI opportunities

Status Indicators

Chart Web Parts

Performance Point Services

Reporting Services

BI Search Visio Services Excel Services PowerPivot

PowerView

It’s not a tool, it’s a toolbox!

SQL Server 2012 BI Novelties

• New BI Semantic Model

• Unified model for reporting, analytics, scorecards and dashboards

• Support for relational and multidimensional APIs

• Model can be cached (VertiPaq) or pass through (DirectQuery)

Rich Modeling Capabilities

• New PowerPivot release

• Usability improvements

• Improved DAX expression and query language

• New Power View thin client in Reporting Services / SharePoint

• Presentation-ready at all times

• Visual, interactive design experience

• Rich metadata-driven interactivity

• New support for Data Alerts in Reporting Services / SharePoint

• Defined directly within reports

• Intuitive Alert rules

• Alerts self-managed through SharePoint

Self-Service Reporting, Analytics and Alerting

3

Where to begin?

Business Intelligence is a collaboration between IT professionals and end users.

Users have the business knowledge. Now user have the tools to implement their vision.

Self Service Business Intelligence

PowerPivot is Microsoft’s self-service BI tool

Qlikview, Tableau, SiSense Prism and Spotfire are competing tools

Allows power users to integrate data from multiple sources and do analysis/reporting

Storing data in a tabular model means:

Query performance is fast

They can handle very large amounts of data

4

DEMO – PowerPivot

We’re going on a picnic!

Who brought an excel sheet?

PowerPivot V2 for SharePoint 2010

• Analysis Services Tabular Engine

• Easy To Deploy

• Easy To Share

5

Excel Services for SharePoint 2010

Bring the power of Excel to the web!

External Data Sources

REST APIExcel Web

Services

Excel Web

Access JSOM

SharePoint Content Database

XLSX / b / m

User-Defined

FunctionsExcel Calculation Service

Excel Proxy

DEMO – Excel Services

Now everyone can go on a picnic!

6

PowerView extraordinaire!

• Based on Silverlight interactive web

experience

• Immediate results

• Highly graphical and intuitive

DEMO – PowerView

See what a wonderful picnic we had!

7

PerformancePoint – where it all comes

together

• Design a dashboard

• Deploy to sharepoint

• Connect your reports

together!

DEMO – PerformancePoint

What can we learn about picnics?

8

Final Touch – Visio Services

Share Diagrams in SharePoint

• Visualize your business intelligence with Visio diagrams

• Diagrams can be viewed without having Visio client installed

• Full Fidelity rendering with Silverlight, or PNG

Connect Diagrams to Data

• Use data graphics to build front ends for your real-time business intelligence solutions

• Diagrams can be connected to various Data sources

Build Dashboards

• Use Web Part Connections to integrate with other SharePoint web parts

• Use the Mashup API to fully customize your dashboards and manipulate data

DEMO - Visio Services

Visualize your data in any form

imaginable

9

Observe and Preserve

• SSRS Data Alerts

• Turn your observations to sustained

achievements for your organization

• Keep track of your business

DEMO - SSRS Data Alerts

10

In Business Evolution,

BI is a winning gene

Thank you for attending!

We presented you with the latest and BEST BI

Solutions for organizations, individuals and

developers.

All the material in this presentation and more can be found

at my blog

Please feel free to contact us at

Asaf and Lior

11

12

13