welcome

2012 © Trivadis

BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN

Welcome

November 2012Highlights SQL Server 2012: Reporting Services and Power View

1

What's New in Reporting Services and introducing to Power View

November 2012Meinrad Weiss

2012 © Trivadis2

INTRODUCTION

Reporting Services (SSRS) in SQL Server 2012 has been upgraded with new features and capabilities: Empower users with a new visual design experience named

Power View Increase productivity with user-defined data alerts Increase performance and improve administration within

SharePoint Excel renderer for Excel 2007-2010 Word renderer for Word 2007-2010Designers have been upgraded for SQL Server Data Tools (Visual Studio 2010)


2012 © Trivadis

Authoring Reports Many types of visualizations

November 2012

3Highlights SQL Server 2012: Reporting Services and Power View

2012 © Trivadis

Hichert Success Rules


4

2012 © Trivadis5

DATA ALERTS

Data alerts can be defined on report feed(s) Intuitive alert rules based on conditions (AND and OR) Scheduling settings Advanced:

Start/End dates Send message only if results change checkbox

Email address(es), Subject and DescriptionCan only be based on reports that use data sources with stored credentialsAlerts can be managed by users and administratorsView status, Edit, Delete, RunOnly available with SSRS in SharePoint integrated mode Available with SharePoint Foundation or above


2012 © Trivadis6

Data Alerts


2012 © Trivadis

Self-Service Alerting – How it works

November 2012

7Highlights SQL Server 2012: Reporting Services and Power View

2012 © Trivadis8

POWER VIEW


2012 © Trivadis9

INTRODUCTION

Power View is an interactive data exploration, visualization, and presentation experience Highly visual design experience Rich meta-driven interactivity Presentation-ready at all timesProvides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workersOrdinarily, a Power View report needs to be based on a tabular BI Semantic Model that has been optimized for the report authoring tool


2012 © Trivadis10

POWER VIEW


2012 © Trivadis11

POWER VIEW

Server(s): SharePoint Server 2010 SP1 Enterprise Edition SQL Server 2012 Reporting Services Add-in for SharePoint Client: Supported browsers:

Windows Vista: IE7 32-bit, FireFox 4 Windows 7: IE8 32-bit, IE9 32-bit, FireFox 4, Safari Note the InPrivate browsing feature of IE is not supported

Silverlight 5


2012 © Trivadis12

POWER VIEW

A Power View report must be based on a deployed tabular BI Semantic Model: Published PowerPivot workbook in a SharePoint library Tabular databaseDAX Query is used to query the modelOrdinarily, the model needs to be optimized for the Power View experience


2012 © Trivadis13

POWER VIEW

Users create a new Power View report (.rdlx) from: A BISM Connection File (.bism) A PowerPivot workbook (.xlsx) in the PowerPivot Gallery (in Gallery view) An SSRS shared data source (.rsds) based on a tabular BI Semantic ModelReports can consist of multiple views and each view can be filteredReports may be: Printed Saved to SharePoint libraries Exported to PowerPointClicking the report will open it in Preview modeIf the user has permission, they can switch to Edit mode


2012 © Trivadis14

Tabular BI Semantic Model Optimization

Reporting properties can also be configuredThe properties apply to tables and columns


2012 © Trivadis

BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN

Let‘s go.


15

Wettbewerb

welcome

Documents