Intro to BI Semantic Model & Delivering Self-Service Reporting

with Power View (“Crescent”)

Dan English Principal Business Intelligence Consultant

Superior Consulting Services, LLC denglish@teamscs.com

Speaker Background

• Developing with Microsoft technologies for over 14 years

• Over 7 years experience with Data Warehousing and Business Intelligence

• Microsoft SQL Server MVP, Microsoft Certified IT Professional (MCITP), and Microsoft Certified Technology Specialist (MCTS)

• Architect and develop dashboard solutions for enterprise reporting and monitoring

• Experienced in ETL and Analysis Services development, requirements gathering, and data modeling

• PASSMN 2009/2010 – Executive Board Chair (President)

• Microsoft MN BI User Group 2011 – Leadership Board

• Twitter – http://twitter.com/denglishbi

• Vimeo Videos - http://vimeo.com/user3952239/videos

Dan English http://denglishbi.wordpress.com

SCS Background

• Founded in 1997, SCS is a technical consulting firm focused exclusively on Microsoft technologies to provide custom solutions

• Headquartered in Burnsville, MN • Microsoft Gold Certified Partner since 2006 • Microsoft Managed Partner • Provide solutions in the areas of Business Intelligence,

Reporting, Application Development, Networking, SharePoint, and Special Projects

• Industry recognized authorities via books, speaker engagements, and direct assistance to Microsoft

Session Outline

• Microsoft Business Intelligence Overview

• What is the BI Semantic Model

• What’s new in PowerPivot & SSAS

• What is Power View (“Crescent”)

• Demo

• What’s coming (Power View)?

• Questions

Quick Audience Poll

How many are currently using SSAS (UDM) in production?

How many have Excel 2010 deployed?

How many are currently using PowerPivot? In production? With SharePoint?

How many have not seen a Power View (“Crescent”) demo?

Microsoft BI Overview

Microsoft’s BI Vision

Complete and integrated BI and Performance Management offering

Agile products that adapt to how you need the information

Built on a trusted part of your IT backbone

Improving organizations by providing business insights to

all employees leading to better, faster, more relevant decisions

Microsoft Business Intelligence Overview

Business User Experience

•Analysis Services

•Reporting Services

•Integration Services

•Master Data Services

•Data Mining

•Data Warehousing

•Dashboards & Scorecards

•Excel Services

•Web based forms & workflow

•Collaboration

•Search

•Content Management

•LOB data integration

•Self-Service access & insight

•Data exploration & analysis

•Predictive analysis

•Data visualization

•Contextual visualization

Business Collaboration Platform

Data Infrastructure & BI Platform

Seamless Transition Across BI Spectrum

PowerPivot For Excel PowerPivot For SharePoint Analysis Services

Our Context

BI Solution created by

power user. Context is

for a small team & it’s

managed on a server.

My Context

BI solution created by

user. Context is only for

user & exists as

document.

The Org’s Context

BI Solution created by IT,

Established corporate

context & is reusable,

scalable and backed up.

Empowered Aligned

Microsoft Mobile BI Vision Roadmap

BI Semantic Model

BI Semantic Model

One Model for all End User Experiences

Client Tools Analytics, Reports, Scorecards,

Dashboards, Custom Apps

Data Sources Databases, LOB Applications, OData Feeds,

Spreadsheets, Text Files

BI Semantic Model

Team BI PowerPivot for SharePoint

Personal BI PowerPivot for Excel

Organizational BI Analysis Services

Flexibility Richness Scalability

Third-party applications

Reporting Services Excel PowerPivot

Databases LOB Applications Files OData Feeds Cloud Services

SharePoint Insights

BI Semantic Model: Architecture

Feels like

Excel

PowerPivot for Excel BI Development Studio

Information Workers BI Developers

Personal BI Team BI Organizational BI

One file,

Save to

SharePoint

Optimized for Excel power user

Rapid

response to

business

problems Solutions live

for weeks or

months

IW and Pro Model Design Tools

Feels like Visual

Studio

Optimized

for BI Pros

Teams building BI

solutions

Source Control,

TFS

Large data

volumes

It’s a project

(business case,

budget, dates)

Deployment

scripts, versions

What’s New:

Analysis Services & PowerPivot

What’s new PowerPivot?

What’s new Analysis Services?

What’s new DAX?

POWERPIVOT Demo

Power View (Project “Crescent”)

What is Power View?

Power View is an interactive data exploration

and visual presentation experience.

Highly Visual Design Experience

Presentation-ready at all times

Rich metadata-driven interactivity

Power View

• Interactive Presentation turns pervasive information into persuasive information

• Deliver and collaborate through SharePoint • Full screen presentation mode for interactive boardroom session and

ability to export to interactive PowerPoint slidedeck

• Fully integrated with PowerPivot and Tabular SSAS • Drive greater insight through smart and powerful querying • Zero configuration highlighting and filtering • Animated trending and comparisons

• Interactive, web-based authoring, and sharing of information • Familiar Microsoft Office design patterns • Powerful data layout with banding, callout, and small multiples

visualizations

Report Designer Power View Report Builder

Embedded Operational Self-Service

POWER VIEW Demo

Power View Demo Screenshot

What is coming (Power View)?

Sorting

Drag and Drop to Canvas

Multiple pages (views)

Printing support

Database image support

DirectQuery support

Show items with no data

Charts

Multiple measure support

More than 20 series allowed

Color (series) support in scatter charts

Number formatting on tables and matrix

Slicers cross filter

Filters

Measure Filters

Filter Restatement

Data Region Filters

Search

Export to PowerPoint

QUESTIONS

THANK YOU! INFO@TEAMSCS.COM